![\"Message](\"https:\/\/i2.wp.com\/dsconsultant.net\/blog\/wp-content\/Excel-Insertion-colonne-impossible.jpg?resize=405%2C165&ssl=1\" "\\"Excel-Insertion-colonne-impossible\\"")
<\/a><\/p>\nLe conseil semble judicieux : \u00ab\u00a0essayez de supprimer…\u00a0\u00bb et pourtant idem…<\/p>\n
Une des raisons possibles peut-\u00eatre\u00a0la mise en forme (par exemple une bordure) ajout\u00e9\u00e9 \u00e0 une colonne ou ligne enti\u00e8re.<\/p>\n
La solution :<\/p>\n
supprimez la mise en forme des cellules \u00e0 droite ou en dessous de votre tableau en faisant\u00a0CTRL + SHIFT fl\u00e8che \u00a0DROITE \u00a0(pour s\u00e9lectionner toutes les colonnes \u00e0 droite de la colonne o\u00f9 vous \u00eates) et choisissez : EFFACER FORMAT ou EFFACER TOUT suivant vos besoins et votre probl\u00e8me, et tout devrait rentrer dans l’ordre.<\/p>\n","protected":false},"excerpt":{"rendered":"
Vous souhaitez ins\u00e9rez une colonne (ou une ligne) et Excel vous dit :<\/p>\n
\u00ab\u00a0Pour \u00e9viter la perte possible de donn\u00e9es, Microsoft Excel ne peut pas d\u00e9placer les cellules non vides hors de la feuille de calcul.\u00a0\u00bb<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"spay_email":""},"categories":[3,4,35],"tags":[],"yoast_head":"\n
Excel, insertion colonnes ou lignes impossible - Mes Notes, Astuces & Conseils informatiques<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dsconsultant.net\/blog\/apple\/excel-insertion-colonnes-ou-lignes-impossible\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel, insertion colonnes ou lignes impossible - Mes Notes, Astuces & Conseils informatiques\" \/>\n<meta property=\"og:description\" content=\"Vous souhaitez ins\u00e9rez une colonne (ou une ligne) et Excel vous dit : "Pour \u00e9viter la perte possible de donn\u00e9es, Microsoft Excel ne peut pas d\u00e9placer les cellules non vides hors de la feuille de calcul."\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dsconsultant.net\/blog\/apple\/excel-insertion-colonnes-ou-lignes-impossible\" \/>\n<meta property=\"og:site_name\" content=\"Mes Notes, Astuces & Conseils informatiques\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/dsconsultant.net\/\" \/>\n<meta property=\"article:published_time\" content=\"2010-03-28T13:29:29+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2013-12-03T22:06:21+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dsconsultant.net\/blog\/wp-content\/Excel-Insertion-colonne-impossible.jpg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"Dominique Schos\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dsconsultant.net\/blog\/#website\",\"url\":\"https:\/\/dsconsultant.net\/blog\/\",\"name\":\"Mes Notes, Astuces & Conseils informatiques\",\"description\":\"Dominique Schos Consultant Conseil informatique Maroc\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dsconsultant.net\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/dsconsultant.net\/blog\/apple\/excel-insertion-colonnes-ou-lignes-impossible#primaryimage\",\"url\":\"https:\/\/dsconsultant.net\/blog\/wp-content\/Excel-Insertion-colonne-impossible.jpg\",\"contentUrl\":\"https:\/\/dsconsultant.net\/blog\/wp-content\/Excel-Insertion-colonne-impossible.jpg\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dsconsultant.net\/blog\/apple\/excel-insertion-colonnes-ou-lignes-impossible#webpage\",\"url\":\"https:\/\/dsconsultant.net\/blog\/apple\/excel-insertion-colonnes-ou-lignes-impossible\",\"name\":\"Excel, insertion colonnes ou lignes impossible - Mes Notes, Astuces & Conseils informatiques\",\"isPartOf\":{\"@id\":\"https:\/\/dsconsultant.net\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dsconsultant.net\/blog\/apple\/excel-insertion-colonnes-ou-lignes-impossible#primaryimage\"},\"datePublished\":\"2010-03-28T13:29:29+00:00\",\"dateModified\":\"2013-12-03T22:06:21+00:00\",\"author\":{\"@id\":\"https:\/\/dsconsultant.net\/blog\/#\/schema\/person\/09f4f57c32b2145fdea40e17b1ea7e92\"},\"breadcrumb\":{\"@id\":\"https:\/\/dsconsultant.net\/blog\/apple\/excel-insertion-colonnes-ou-lignes-impossible#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dsconsultant.net\/blog\/apple\/excel-insertion-colonnes-ou-lignes-impossible\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dsconsultant.net\/blog\/apple\/excel-insertion-colonnes-ou-lignes-impossible#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/dsconsultant.net\/blog\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel, insertion colonnes ou lignes impossible\"}]},{\"@type\":\"Person\",\"@id\":\"https:\/\/dsconsultant.net\/blog\/#\/schema\/person\/09f4f57c32b2145fdea40e17b1ea7e92\",\"name\":\"Dominique Schos\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/dsconsultant.net\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/5df6b5e6cea471da661f13bc21e3e889?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/5df6b5e6cea471da661f13bc21e3e889?s=96&d=mm&r=g\",\"caption\":\"Dominique Schos\"},\"description\":\"De MacOS 1.0 en 1984 \u00e0 OSX12 Monteray en passant par le mythique OSX, de MS-DOS 1 \u00e0 Windows11, de IOS Apple \u00e0 Android, des premiers \\\"Tchat\\\" sur ICQ \u00e0 Facebook Live, je ne me lasse pas de \\\"flirter\\\" avec ces technologies et moyens de communications que j'aime mettre \u00e0 votre service...\",\"sameAs\":[\"https:\/\/www.dsconsultant.net\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel, insertion colonnes ou lignes impossible - Mes Notes, Astuces & Conseils informatiques","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/dsconsultant.net\/blog\/apple\/excel-insertion-colonnes-ou-lignes-impossible","og_locale":"fr_FR","og_type":"article","og_title":"Excel, insertion colonnes ou lignes impossible - Mes Notes, Astuces & Conseils informatiques","og_description":"Vous souhaitez ins\u00e9rez une colonne (ou une ligne) et Excel vous dit : \"Pour \u00e9viter la perte possible de donn\u00e9es, Microsoft Excel ne peut pas d\u00e9placer les cellules non vides hors de la feuille de calcul.\"","og_url":"https:\/\/dsconsultant.net\/blog\/apple\/excel-insertion-colonnes-ou-lignes-impossible","og_site_name":"Mes Notes, Astuces & Conseils informatiques","article_publisher":"https:\/\/www.facebook.com\/dsconsultant.net\/","article_published_time":"2010-03-28T13:29:29+00:00","article_modified_time":"2013-12-03T22:06:21+00:00","og_image":[{"url":"https:\/\/dsconsultant.net\/blog\/wp-content\/Excel-Insertion-colonne-impossible.jpg"}],"twitter_card":"summary_large_image","twitter_misc":{"\u00c9crit par":"Dominique Schos","Dur\u00e9e de lecture estim\u00e9e":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebSite","@id":"https:\/\/dsconsultant.net\/blog\/#website","url":"https:\/\/dsconsultant.net\/blog\/","name":"Mes Notes, Astuces & Conseils informatiques","description":"Dominique Schos Consultant Conseil informatique Maroc","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dsconsultant.net\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"fr-FR"},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/dsconsultant.net\/blog\/apple\/excel-insertion-colonnes-ou-lignes-impossible#primaryimage","url":"https:\/\/dsconsultant.net\/blog\/wp-content\/Excel-Insertion-colonne-impossible.jpg","contentUrl":"https:\/\/dsconsultant.net\/blog\/wp-content\/Excel-Insertion-colonne-impossible.jpg"},{"@type":"WebPage","@id":"https:\/\/dsconsultant.net\/blog\/apple\/excel-insertion-colonnes-ou-lignes-impossible#webpage","url":"https:\/\/dsconsultant.net\/blog\/apple\/excel-insertion-colonnes-ou-lignes-impossible","name":"Excel, insertion colonnes ou lignes impossible - Mes Notes, Astuces & Conseils informatiques","isPartOf":{"@id":"https:\/\/dsconsultant.net\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dsconsultant.net\/blog\/apple\/excel-insertion-colonnes-ou-lignes-impossible#primaryimage"},"datePublished":"2010-03-28T13:29:29+00:00","dateModified":"2013-12-03T22:06:21+00:00","author":{"@id":"https:\/\/dsconsultant.net\/blog\/#\/schema\/person\/09f4f57c32b2145fdea40e17b1ea7e92"},"breadcrumb":{"@id":"https:\/\/dsconsultant.net\/blog\/apple\/excel-insertion-colonnes-ou-lignes-impossible#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dsconsultant.net\/blog\/apple\/excel-insertion-colonnes-ou-lignes-impossible"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/dsconsultant.net\/blog\/apple\/excel-insertion-colonnes-ou-lignes-impossible#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/dsconsultant.net\/blog"},{"@type":"ListItem","position":2,"name":"Excel, insertion colonnes ou lignes impossible"}]},{"@type":"Person","@id":"https:\/\/dsconsultant.net\/blog\/#\/schema\/person\/09f4f57c32b2145fdea40e17b1ea7e92","name":"Dominique Schos","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/dsconsultant.net\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/5df6b5e6cea471da661f13bc21e3e889?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/5df6b5e6cea471da661f13bc21e3e889?s=96&d=mm&r=g","caption":"Dominique Schos"},"description":"De MacOS 1.0 en 1984 \u00e0 OSX12 Monteray en passant par le mythique OSX, de MS-DOS 1 \u00e0 Windows11, de IOS Apple \u00e0 Android, des premiers \"Tchat\" sur ICQ \u00e0 Facebook Live, je ne me lasse pas de \"flirter\" avec ces technologies et moyens de communications que j'aime mettre \u00e0 votre service...","sameAs":["https:\/\/www.dsconsultant.net"]}]}},"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/dsconsultant.net\/blog\/wp-json\/wp\/v2\/posts\/104"}],"collection":[{"href":"https:\/\/dsconsultant.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dsconsultant.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dsconsultant.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dsconsultant.net\/blog\/wp-json\/wp\/v2\/comments?post=104"}],"version-history":[{"count":0,"href":"https:\/\/dsconsultant.net\/blog\/wp-json\/wp\/v2\/posts\/104\/revisions"}],"wp:attachment":[{"href":"https:\/\/dsconsultant.net\/blog\/wp-json\/wp\/v2\/media?parent=104"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dsconsultant.net\/blog\/wp-json\/wp\/v2\/categories?post=104"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dsconsultant.net\/blog\/wp-json\/wp\/v2\/tags?post=104"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}![\"Message](\"https:\/\/i2.wp.com\/dsconsultant.net\/blog\/wp-content\/Excel-Insertion-colonne-impossible.jpg?ssl=1\" "\\"Excel-Insertion-colonne-impossible\\"")
<\/a><\/p>\n