{"id":1300,"date":"2018-07-04T10:18:05","date_gmt":"2018-07-04T10:18:05","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=1300"},"modified":"2024-03-28T14:06:43","modified_gmt":"2024-03-28T14:06:43","slug":"text-wrapping","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/examples\/text-wrapping\/","title":{"rendered":"Text Wrapping in Excel"},"content":{"rendered":"\n<p>When you have a large amount of data in your spreadsheet, you will notice that often the cell is too narrow to make all that information visible.<\/p>\n\n\n\n<p>There are a few ways you can deal with this problem. One of them is text wrapping.<\/p>\n\n\n\n<p>If you want to read about other ways to deal with this problem, read the lesson:&nbsp;<a href=\"https:\/\/officetuts.net\/excel\/en\/training\/adjusting-text-in-a-cell\">adjust text in a cell<\/a>.<\/p>\n\n\n\n<p>Take a look at the following example:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"482\" height=\"119\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/07\/example-text-wrapping.png\" alt=\"\" class=\"wp-image-1301\" srcset=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/07\/example-text-wrapping.png 482w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/07\/example-text-wrapping-300x74.png 300w\" sizes=\"(max-width: 482px) 100vw, 482px\" \/><\/figure>\n\n\n\n<p>As you can see, the text in the \u201cOccupation\u201d column is too wide. Let\u2019s fix it.<\/p>\n\n\n\n<p>First, choose cells for which you want to wrap text. Now, you have two options to do it.<\/p>\n\n\n\n<p><strong>1. Click HOME &gt;&gt; Alignment &gt;&gt; Wrap Text.<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"265\" height=\"92\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/07\/wrap-text-button.png\" alt=\"\" class=\"wp-image-1302\"\/><\/figure>\n\n\n\n<p><strong>2. Right-click to open a contextual menu.&nbsp;<\/strong><\/p>\n\n\n\n<p>From the &#8220;Format Cells&#8221; window click the &#8220;Alignment&#8221; tab. In the &#8220;Text control&#8221; group check &#8220;Wrap text&#8221;.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"529\" height=\"465\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/07\/format-cells-window-1.png\" alt=\"\" class=\"wp-image-1303\" srcset=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/07\/format-cells-window-1.png 529w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/07\/format-cells-window-1-300x264.png 300w\" sizes=\"(max-width: 529px) 100vw, 529px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Wrap text automatically<\/h3>\n\n\n\n<p>Instead of using the \u201cWrap Text\u201d button on each cell, you can select empty cells and apply text wrapping. Now, each time you enter some text, it automatically wraps it inside those cells.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Unwrapping<\/h2>\n\n\n\n<p>To unwrap text, click the cells you want to unwrap and then uncheck the &#8220;Wrap Text&#8221;.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>When you have a large amount of data in your spreadsheet, you will notice that often the cell is too narrow to make&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[21],"tags":[190],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Text Wrapping in Excel<\/title>\n<meta name=\"description\" content=\"Learn how to adjust text in a cell when there&#039;s too much data to display. Wrap text in Excel spreadsheets or even do it automatically.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/officetuts.net\/excel\/examples\/text-wrapping\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Text Wrapping in Excel\" \/>\n<meta property=\"og:description\" content=\"Learn how to adjust text in a cell when there&#039;s too much data to display. Wrap text in Excel spreadsheets or even do it automatically.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/officetuts.net\/excel\/examples\/text-wrapping\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-07-04T10:18:05+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-28T14:06:43+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/07\/example-text-wrapping.png\" \/>\n<meta name=\"author\" content=\"Tomasz Decker\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Tomasz Decker\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/text-wrapping\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/text-wrapping\/\"},\"author\":{\"name\":\"Tomasz Decker\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"headline\":\"Text Wrapping in Excel\",\"datePublished\":\"2018-07-04T10:18:05+00:00\",\"dateModified\":\"2024-03-28T14:06:43+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/text-wrapping\/\"},\"wordCount\":198,\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/text-wrapping\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/07\/example-text-wrapping.png\",\"keywords\":[\"pinterest\"],\"articleSection\":[\"examples\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/text-wrapping\/\",\"url\":\"https:\/\/officetuts.net\/excel\/examples\/text-wrapping\/\",\"name\":\"Text Wrapping in Excel\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/text-wrapping\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/text-wrapping\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/07\/example-text-wrapping.png\",\"datePublished\":\"2018-07-04T10:18:05+00:00\",\"dateModified\":\"2024-03-28T14:06:43+00:00\",\"description\":\"Learn how to adjust text in a cell when there's too much data to display. Wrap text in Excel spreadsheets or even do it automatically.\",\"breadcrumb\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/text-wrapping\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/officetuts.net\/excel\/examples\/text-wrapping\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/text-wrapping\/#primaryimage\",\"url\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/07\/example-text-wrapping.png\",\"contentUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/07\/example-text-wrapping.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/text-wrapping\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/officetuts.net\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Text Wrapping in Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/officetuts.net\/excel\/#website\",\"url\":\"https:\/\/officetuts.net\/excel\/\",\"name\":\"\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/officetuts.net\/excel\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\",\"name\":\"Tomasz Decker\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"caption\":\"Tomasz Decker\"},\"logo\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\"},\"description\":\"Spreadsheet and Python enthusiast.\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Text Wrapping in Excel","description":"Learn how to adjust text in a cell when there's too much data to display. Wrap text in Excel spreadsheets or even do it automatically.","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:\/\/officetuts.net\/excel\/examples\/text-wrapping\/","og_locale":"en_US","og_type":"article","og_title":"Text Wrapping in Excel","og_description":"Learn how to adjust text in a cell when there's too much data to display. Wrap text in Excel spreadsheets or even do it automatically.","og_url":"https:\/\/officetuts.net\/excel\/examples\/text-wrapping\/","article_published_time":"2018-07-04T10:18:05+00:00","article_modified_time":"2024-03-28T14:06:43+00:00","og_image":[{"url":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/07\/example-text-wrapping.png"}],"author":"Tomasz Decker","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Tomasz Decker","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/officetuts.net\/excel\/examples\/text-wrapping\/#article","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/examples\/text-wrapping\/"},"author":{"name":"Tomasz Decker","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"headline":"Text Wrapping in Excel","datePublished":"2018-07-04T10:18:05+00:00","dateModified":"2024-03-28T14:06:43+00:00","mainEntityOfPage":{"@id":"https:\/\/officetuts.net\/excel\/examples\/text-wrapping\/"},"wordCount":198,"publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"image":{"@id":"https:\/\/officetuts.net\/excel\/examples\/text-wrapping\/#primaryimage"},"thumbnailUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/07\/example-text-wrapping.png","keywords":["pinterest"],"articleSection":["examples"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/officetuts.net\/excel\/examples\/text-wrapping\/","url":"https:\/\/officetuts.net\/excel\/examples\/text-wrapping\/","name":"Text Wrapping in Excel","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/officetuts.net\/excel\/examples\/text-wrapping\/#primaryimage"},"image":{"@id":"https:\/\/officetuts.net\/excel\/examples\/text-wrapping\/#primaryimage"},"thumbnailUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/07\/example-text-wrapping.png","datePublished":"2018-07-04T10:18:05+00:00","dateModified":"2024-03-28T14:06:43+00:00","description":"Learn how to adjust text in a cell when there's too much data to display. Wrap text in Excel spreadsheets or even do it automatically.","breadcrumb":{"@id":"https:\/\/officetuts.net\/excel\/examples\/text-wrapping\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/officetuts.net\/excel\/examples\/text-wrapping\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/examples\/text-wrapping\/#primaryimage","url":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/07\/example-text-wrapping.png","contentUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/07\/example-text-wrapping.png"},{"@type":"BreadcrumbList","@id":"https:\/\/officetuts.net\/excel\/examples\/text-wrapping\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/officetuts.net\/excel\/"},{"@type":"ListItem","position":2,"name":"Text Wrapping in Excel"}]},{"@type":"WebSite","@id":"https:\/\/officetuts.net\/excel\/#website","url":"https:\/\/officetuts.net\/excel\/","name":"","description":"","publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/officetuts.net\/excel\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42","name":"Tomasz Decker","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","caption":"Tomasz Decker"},"logo":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/"},"description":"Spreadsheet and Python enthusiast."}]}},"_links":{"self":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/1300"}],"collection":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/comments?post=1300"}],"version-history":[{"count":5,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/1300\/revisions"}],"predecessor-version":[{"id":17379,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/1300\/revisions\/17379"}],"wp:attachment":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/media?parent=1300"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/categories?post=1300"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/tags?post=1300"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}