{"id":798,"date":"2018-06-30T17:54:00","date_gmt":"2018-06-30T17:54:00","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=798"},"modified":"2024-03-30T00:38:45","modified_gmt":"2024-03-30T00:38:45","slug":"adjusting-text-in-a-cell","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/training\/adjusting-text-in-a-cell\/","title":{"rendered":"Fit Text in a Cell"},"content":{"rendered":"\n

If the text you entered in the cell is too long to display it in its entirety, Excel will display only a part of it. When you click the cell, you can see much more in the formula bar.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

There are a few different ways in Excel to display the entire text. Depending on the situation or certain restrictions (for example those imposed by the company you work in), you can choose one of the three methods to achieve this goal.<\/p>\n\n\n\n

Changing the width of a column<\/h2>\n\n\n\n

Example 1:<\/h3>\n\n\n\n

Widening a column is the easiest and probably the first method that comes to mind. Move the border between cell D<\/strong> and E<\/strong>, so that the cursor will change its shape, as shown in the following picture.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Click the border between cells D<\/strong> and E<\/strong> and drag it to the right, so it is wide enough to contain the entire contents of the cell.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

You can also use double-click on the border. When you do it, the column will be widened exactly to contain the widest text in the column.<\/p>\n\n\n\n

Text wrapping<\/h2>\n\n\n\n

When the text is too long, widening columns doesn’t seem to be the best idea because the column would be too wide to scroll the worksheet comfortably. Besides, it would take many pages to print<\/a> such a document.<\/p>\n\n\n\n

The next method is called Text Wrapping<\/a><\/strong>. It will wrap the text and display it in multiple lines, increasing the row height.<\/p>\n\n\n\n

Example 2:<\/h3>\n\n\n\n

Select column D5<\/strong>, then go to HOME >> Alignment >> Wrap Text<\/strong>. In our example, the row becomes twice as high to display the entire text.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Text shrinking<\/h2>\n\n\n\n

There is another method that allows you to fit the whole text into the cell<\/a>. In this one you don\u2019t need to change the row height or column width, just adjust the font size<\/a>.<\/p>\n\n\n\n

To use this method, select the cell, then go to HOME >> Alignment<\/strong> and click the little square in the lower right corner. In the new window, select Shrink to fit<\/strong> and press the OK<\/strong> button.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

The disadvantage of this method is that it makes sense only when the text is only slightly larger than the column width. Otherwise, the font will be too small and, therefore, impossible to read.<\/p>\n","protected":false},"excerpt":{"rendered":"

If the text you entered in the cell is too long to display it in its entirety, Excel will display only a part…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[14],"tags":[190],"yoast_head":"\nFit Text in a Cell<\/title>\n<meta name=\"description\" content=\"Learn how to display entire text in Excel using column width adjustment, text wrapping, or text shrinking. Click the cell to see more in the formula bar.\" \/>\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\/training\/adjusting-text-in-a-cell\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fit Text in a Cell\" \/>\n<meta property=\"og:description\" content=\"Learn how to display entire text in Excel using column width adjustment, text wrapping, or text shrinking. Click the cell to see more in the formula bar.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/officetuts.net\/excel\/training\/adjusting-text-in-a-cell\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-06-30T17:54:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-30T00:38:45+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/adjusting-text-in-a-cell-example.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\/training\/adjusting-text-in-a-cell\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/training\/adjusting-text-in-a-cell\/\"},\"author\":{\"name\":\"Tomasz Decker\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"headline\":\"Fit Text in a Cell\",\"datePublished\":\"2018-06-30T17:54:00+00:00\",\"dateModified\":\"2024-03-30T00:38:45+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/training\/adjusting-text-in-a-cell\/\"},\"wordCount\":398,\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/training\/adjusting-text-in-a-cell\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/adjusting-text-in-a-cell-example.png\",\"keywords\":[\"pinterest\"],\"articleSection\":[\"training\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/officetuts.net\/excel\/training\/adjusting-text-in-a-cell\/\",\"url\":\"https:\/\/officetuts.net\/excel\/training\/adjusting-text-in-a-cell\/\",\"name\":\"Fit Text in a Cell\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/training\/adjusting-text-in-a-cell\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/training\/adjusting-text-in-a-cell\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/adjusting-text-in-a-cell-example.png\",\"datePublished\":\"2018-06-30T17:54:00+00:00\",\"dateModified\":\"2024-03-30T00:38:45+00:00\",\"description\":\"Learn how to display entire text in Excel using column width adjustment, text wrapping, or text shrinking. Click the cell to see more in the formula bar.\",\"breadcrumb\":{\"@id\":\"https:\/\/officetuts.net\/excel\/training\/adjusting-text-in-a-cell\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/officetuts.net\/excel\/training\/adjusting-text-in-a-cell\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/training\/adjusting-text-in-a-cell\/#primaryimage\",\"url\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/adjusting-text-in-a-cell-example.png\",\"contentUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/adjusting-text-in-a-cell-example.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/officetuts.net\/excel\/training\/adjusting-text-in-a-cell\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/officetuts.net\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Fit Text in a Cell\"}]},{\"@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":"Fit Text in a Cell","description":"Learn how to display entire text in Excel using column width adjustment, text wrapping, or text shrinking. Click the cell to see more in the formula bar.","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\/training\/adjusting-text-in-a-cell\/","og_locale":"en_US","og_type":"article","og_title":"Fit Text in a Cell","og_description":"Learn how to display entire text in Excel using column width adjustment, text wrapping, or text shrinking. Click the cell to see more in the formula bar.","og_url":"https:\/\/officetuts.net\/excel\/training\/adjusting-text-in-a-cell\/","article_published_time":"2018-06-30T17:54:00+00:00","article_modified_time":"2024-03-30T00:38:45+00:00","og_image":[{"url":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/adjusting-text-in-a-cell-example.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\/training\/adjusting-text-in-a-cell\/#article","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/training\/adjusting-text-in-a-cell\/"},"author":{"name":"Tomasz Decker","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"headline":"Fit Text in a Cell","datePublished":"2018-06-30T17:54:00+00:00","dateModified":"2024-03-30T00:38:45+00:00","mainEntityOfPage":{"@id":"https:\/\/officetuts.net\/excel\/training\/adjusting-text-in-a-cell\/"},"wordCount":398,"publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"image":{"@id":"https:\/\/officetuts.net\/excel\/training\/adjusting-text-in-a-cell\/#primaryimage"},"thumbnailUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/adjusting-text-in-a-cell-example.png","keywords":["pinterest"],"articleSection":["training"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/officetuts.net\/excel\/training\/adjusting-text-in-a-cell\/","url":"https:\/\/officetuts.net\/excel\/training\/adjusting-text-in-a-cell\/","name":"Fit Text in a Cell","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/officetuts.net\/excel\/training\/adjusting-text-in-a-cell\/#primaryimage"},"image":{"@id":"https:\/\/officetuts.net\/excel\/training\/adjusting-text-in-a-cell\/#primaryimage"},"thumbnailUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/adjusting-text-in-a-cell-example.png","datePublished":"2018-06-30T17:54:00+00:00","dateModified":"2024-03-30T00:38:45+00:00","description":"Learn how to display entire text in Excel using column width adjustment, text wrapping, or text shrinking. Click the cell to see more in the formula bar.","breadcrumb":{"@id":"https:\/\/officetuts.net\/excel\/training\/adjusting-text-in-a-cell\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/officetuts.net\/excel\/training\/adjusting-text-in-a-cell\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/training\/adjusting-text-in-a-cell\/#primaryimage","url":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/adjusting-text-in-a-cell-example.png","contentUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/adjusting-text-in-a-cell-example.png"},{"@type":"BreadcrumbList","@id":"https:\/\/officetuts.net\/excel\/training\/adjusting-text-in-a-cell\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/officetuts.net\/excel\/"},{"@type":"ListItem","position":2,"name":"Fit Text in a Cell"}]},{"@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\/798"}],"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=798"}],"version-history":[{"count":9,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/798\/revisions"}],"predecessor-version":[{"id":13118,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/798\/revisions\/13118"}],"wp:attachment":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/media?parent=798"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/categories?post=798"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/tags?post=798"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}