{"id":366477,"date":"2021-11-12T19:00:51","date_gmt":"2021-11-12T16:00:51","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/how-to-shrink-or-expand-cells-to-fit-text-in-microsoft-excel\/"},"modified":"2021-11-12T19:00:51","modified_gmt":"2021-11-12T16:00:51","slug":"how-to-shrink-or-expand-cells-to-fit-text-in-microsoft-excel","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/how-to-shrink-or-expand-cells-to-fit-text-in-microsoft-excel\/","title":{"rendered":"#How to Shrink or Expand Cells to Fit Text in Microsoft Excel"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_90 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-6b004b7f66968\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #dd3333;color:#dd3333\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #dd3333;color:#dd3333\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-6b004b7f66968\" checked aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-shrink-or-expand-cells-to-fit-text-in-microsoft-excel\/#Automatically_Resize_Cells_Using_AutoFit\" >Automatically Resize Cells Using AutoFit<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-shrink-or-expand-cells-to-fit-text-in-microsoft-excel\/#Automatically_Resize_Cells_Using_Your_Cursor\" >Automatically Resize Cells Using Your Cursor<\/a><\/li><\/ul><\/nav><\/div>\n<p><strong>&#8220;#How to Shrink or Expand Cells to Fit Text in Microsoft Excel&#8221;<\/strong><\/p>\n<div>\n<img loading=\"lazy\" decoding=\"async\" class=\"type:primaryImage alignnone size-full wp-image-757715\" srcset=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/microsoft_excel_hero_1200x675.jpg?width=398&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1 400w, https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/microsoft_excel_hero_1200x675.jpg?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1 1200w\" sizes=\"auto, 400w, 1200w\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/microsoft_excel_hero_1200x675.jpg?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Microsoft Excel logo on a green background\" width=\"1200\" height=\"675\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>When entering data in Excel, you\u2019ll notice cells have limited space for displaying their contents. This can cause data to display cut off. Whether text or numbers, you can automatically resize cells to fit the contents.<\/p>\n<p>You can certainly adjust the sizes of cells in columns and rows manually in Microsoft Excel. But for a quick way to shrink or expand cells to fit the text or numbers, you can use one of these easy automatic methods.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Automatically_Resize_Cells_Using_AutoFit\"><\/span>Automatically Resize Cells Using AutoFit<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Microsoft Excel provides a feature called AutoFit that you can use to format cells in both columns and rows. We\u2019ll show you how this works using an example.<\/p>\n<p>Here, you can see our data is squished and unreadable for both our column headers and dollar amounts. So, we\u2019ll expand the cells in these columns.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Convert Currency in Microsoft Excel<\/em><\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-759785\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/10\/ColumnsToWiden-ExcelResizeCells.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Columns to widen in Excel\" width=\"475\" height=\"311\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Select the columns you want to resize. You can drag through them with your cursor or hold Ctrl as you select each one. Then, head to the Home tab and Cells section of the ribbon.<\/p>\n<p>Click the Format drop-down arrow and choose \u201cAutoFit Column Width.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-759786\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/10\/AutoFitColumnWidth-ExcelResizeCells.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Select AutoFit Column Width\" width=\"650\" height=\"365\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>And there we go! As you can see, those columns were expanded just enough to display the contents clearly for the headers and currencies.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-759788\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/10\/AutoFitColumnsWiden-ExcelResizeCells.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Columns widened with AutoFit\" width=\"580\" height=\"310\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>The AutoFit feature works the same way for shrinking the sizes of cells. Maybe you have a column of single characters, as in our example below. We can gain some space in our sheet by making the cells smaller to fit the text.<\/p>\n<p>Select the column(s), click the Format drop-down arrow on the Home tab, and pick \u201cAutoFit Column Width\u201d as described above.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-759789\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/10\/AutoFitColumnWidthShrink-ExcelResizeCells.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Select AutoFit Column Width\" width=\"447\" height=\"406\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>And this time, you can see our column width decreased to accommodate the contents.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-759790\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/10\/ShrinkColumn-ExcelResizeCells.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Decreased column width with AutoFit\" width=\"196\" height=\"215\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You can use the AutoFit feature to shrink or expand cells in rows the same way. Simply select your row(s) and choose \u201cAutoFit Row Height\u201d in the Format drop-down list.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-759791\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/10\/AutoFitRowHeight-ExcelResizeCells.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Select AutoFit Row Height\" width=\"265\" height=\"314\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Automatically_Resize_Cells_Using_Your_Cursor\"><\/span>Automatically Resize Cells Using Your Cursor<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Another quick and easy way to automatically resize cells in columns and rows is using your cursor.<\/p>\n<p>Select the column(s) or row(s) that you want to shrink or expand to fit the contents. Place your cursor on the right side of a column or the bottom of a row. When you see the double-sided arrow display, double-click.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-759792\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/10\/CursorResizeColumn-ExcelResizeCells.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Double-click the double-sided arrow\" width=\"475\" height=\"378\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Just like with the AutoFit feature, you\u2019ll see your column(s) or rows(s) adjust to fit the contents. Whether the cells shrink or expand depends on how wide the text or numbers are.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-759793\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/10\/CursorResizedColumn-ExcelResizeCells.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Widened column with double-click\" width=\"470\" height=\"337\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>If you want to resize the cells for your entire sheet, this trick works just as easily. Select the sheet by clicking the triangle on the top left between column A and row 1. Then double-click when you see the double-sided arrows between both the columns and the rows.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-759794\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/10\/SelectAdjustSheet-ExcelResizeCells.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Resize cells in a sheet\" width=\"584\" height=\"311\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Manually resizing cells in Excel to fit your contents is helpful in many situations. But to see the data that\u2019s cut off, quickly and with minimal effort, try one of these automatic resizing options.<\/p>\n<p>For another way to see your cell contents clearly, learn how to add space between text and cell borders in Excel.<\/p>\n<\/div>\n<p><script>\n setTimeout(function(){\n  !function(f,b,e,v,n,t,s)\n  {if(f.fbq)return;n=f.fbq=function(){n.callMethod?\n  n.callMethod.apply(n,arguments):n.queue.push(arguments)};\n  if(!f._fbq)f._fbq=n;n.push=n;n.loaded=!0;n.version='2.0';\n  n.queue=[];t=b.createElement(e);t.async=!0;\n  t.src=v;s=b.getElementsByTagName(e)[0];\n  s.parentNode.insertBefore(t,s) } (window, document,'script',\n  'https:\/\/connect.facebook.net\/en_US\/fbevents.js');\n   fbq('init', '335401813750447');\n   fbq('track', 'PageView');\n  },3000);\n<\/script><\/p>\n<blockquote><p><strong><span style=\"color: #ff6600;\">If you liked the article, do not forget to share it with your friends. Follow us on\u00a0<span style=\"color: #ff0000;\"><a style=\"color: #ff0000;\" href=\"https:\/\/news.google.com\/publications\/CAAqBwgKMLG0nwswvr63Aw\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">Google News<\/a><\/span>\u00a0too, click on the star and choose us from your favorites.<\/span><\/strong><\/p><\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\">For forums sites go to <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/forum.buradabiliyorum.com\/\" target=\"_blank\" rel=\"noopener\">Forum.BuradaBiliyorum.Com<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\"><strong>If you want to read more like this article, you can visit our <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/en.buradabiliyorum.com\/technology\/\" target=\"_blank\" rel=\"noopener\">Technology category.<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<p><span style=\"color: black;\"><a style=\"color: #ff9900;\" href=\"https:\/\/www.howtogeek.com\/759780\/how-to-shrink-or-expand-cells-to-fit-text-in-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;#How to Shrink or Expand Cells to Fit Text in Microsoft Excel&#8221; When entering data in Excel, you\u2019ll notice cells have limited space for displaying their contents. This can cause data to display cut off. Whether text or numbers, you can automatically resize cells to fit the contents. You can certainly adjust the sizes of&#8230;<\/p>\n","protected":false},"author":1,"featured_media":366478,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/microsoft_excel_hero_1200x675.jpg?height=200p&trim=2,2,2,2","fifu_image_alt":"","footnotes":""},"categories":[18],"tags":[],"class_list":["post-366477","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology"],"_links":{"self":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/366477","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/comments?post=366477"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/366477\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/366478"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=366477"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=366477"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=366477"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}