{"id":174735,"date":"2021-02-09T13:24:52","date_gmt":"2021-02-09T10:24:52","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/how-to-resize-columns-and-rows-in-google-sheets\/"},"modified":"2021-02-09T13:24:52","modified_gmt":"2021-02-09T10:24:52","slug":"how-to-resize-columns-and-rows-in-google-sheets","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/how-to-resize-columns-and-rows-in-google-sheets\/","title":{"rendered":"#How to Resize Columns and Rows in Google Sheets"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_88 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-6acf14db76bd1\" 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-6acf14db76bd1\" 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-resize-columns-and-rows-in-google-sheets\/#Manually_Resizing_a_Column_or_Row_in_Google_Sheets\" >Manually Resizing a Column or Row in Google Sheets<\/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-resize-columns-and-rows-in-google-sheets\/#Resizing_Rows_or_Columns_Automatically_in_Google_Sheets\" >Resizing Rows or Columns Automatically in Google Sheets<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-resize-columns-and-rows-in-google-sheets\/#Using_the_Resize_Column_or_Row_Tool_in_Google_Sheets\" >Using the Resize Column or Row Tool in Google Sheets<\/a><\/li><\/ul><\/nav><\/div>\n<p><strong>&#8220;#How to Resize Columns and Rows in Google Sheets&#8221;<\/strong><\/p>\n<div>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-395627\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2018\/11\/SheetsHeader.png\" alt=\"Google Sheets\" width=\"650\" height=\"300\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>When you open a new Google Sheets spreadsheet, the columns, rows, and individual cells you see will all be a certain size. If you want to see more data in each cell, you\u2019ll need to resize them. Here\u2019s how.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Manually_Resizing_a_Column_or_Row_in_Google_Sheets\"><\/span>Manually Resizing a Column or Row in Google Sheets<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>One of the quickest ways to resize a column or row in Google Sheets is to use your mouse or trackpad to resize it manually. This involves dragging the column or row border to a new position, resizing it in the process.<\/p>\n<p>To do this, <a rel=\"nofollow noopener\" target=\"_blank\" href=\"http:\/\/sheets.google.com\/\">open a Google Sheets spreadsheet<\/a> containing your data. Below the formula bar, you\u2019ll see your column headers, initially ranging from A to Z. Likewise, row headers are seen on the left-hand side, initially ranging from 1 to 100.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>The Beginner&#8217;s Guide to Google Sheets<\/em><\/strong><\/p>\n<p>To resize either a row or column, hover over the column (A, B, etc.) or row (1, 2, etc.) header and move your mouse to the border. Your cursor should turn to an arrowhead, pointing in either direction.<\/p>\n<p>Using your mouse or trackpad, drag the border to a new position, releasing it once the border is in place. A blue line will <a href=\"https:\/\/buradabiliyorum.com\/en\/category\/download-scripts-themes-apps\/\" data-internallinksmanager029f6b8e52c=\"9\" title=\"Download Scripts &amp; Themes &amp; Apps\" target=\"_blank\" rel=\"noopener\">app<\/a>ear as the border is being moved, giving you a visual indication of the size of the new column or row.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-708760\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/01\/Google-Sheets-Manual-Resize-Column.png\" alt=\"To resize a column, hover over a column border. Using your mouse, hold down and move the border to a new position, letting go once the new border is in place.\" width=\"457\" height=\"363\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You can also complete this step for multiple columns or rows at once by first selecting them, then using your mouse or trackpad to resize the border on one of the columns or rows.<\/p>\n<p>Google Sheets will treat the selected cells together, resizing them all to the same size.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-708761\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/01\/Google-Sheets-Manual-Resize-Multiple-Rows.png\" alt=\"To resize multiple rows and columns, select the rows or columns, then hover over one of the selected header borders. Using your mouse, drag the border into a new position, letting go once in place.\" width=\"457\" height=\"367\" 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=\"Resizing_Rows_or_Columns_Automatically_in_Google_Sheets\"><\/span>Resizing Rows or Columns Automatically in Google Sheets<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>If the cells in your chosen row or column contain too much data, some of the information may be hidden from review (unless you wrap the text first).<\/p>\n<p>To quickly resize these columns or rows to display this data without wrapping the cell text, you can use your mouse to resize it to fit. This will display all hidden text, resizing the column or row to match the size of the largest cell containing the most data.<\/p>\n<p>To do this, open your spreadsheet and hover over the column (starting with A, B, etc.) or row (starting with 1, 2, etc.) header labels. Move your cursor to hover over the border until the cursor changes to an arrowhead.<\/p>\n<p>Once the arrowhead cursor is visible, double-click the border. This will force Google Sheets to resize it automatically to fit the content of the largest cell.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-708762\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/01\/Google-Sheets-Auomatic-Resize-Column.png\" alt=\"To automatically resize a column or row to fit the largest cell's data, double-click the header border.\" width=\"457\" height=\"367\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>As with the manual method above, you can select multiple rows or columns to resize them at once. This will automatically resize each row or column to fit the largest cell\u2019s data.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Using_the_Resize_Column_or_Row_Tool_in_Google_Sheets\"><\/span>Using the Resize Column or Row Tool in Google Sheets<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>The steps above allow you to resize columns and rows using your mouse or trackpad, but these methods don\u2019t offer a way to resize them to a set size. To do this, you\u2019ll need to use Google Sheets\u2019 column and row resizing tool.<\/p>\n<p>To start, open your spreadsheet and select the header for your row (starting with 1, 2, etc.) or column (starting with A, B, etc.) to select it. You can also do this for multiple rows and columns at once by selecting them first.<\/p>\n<p>With the row or column you wish to resize selected, right-click the header label itself (eg. 1 or A). From the pop-up menu, click the \u201cResize The Column\u201d or \u201cResize The Row\u201d option.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-708763\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/01\/Google-Sheets-Resize-Row-Option.png\" alt=\"To resize a row or column to a set size, right-click a column or row header label and select &quot;Resize the Row&quot; or &quot;Resize the Column&quot; from the pop-up menu.\" width=\"457\" height=\"447\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>In the \u201cResize\u201d box for your row or column, enter a new size (in pixels) in the box provided to resize it. Alternatively, select the \u201cFix To Data\u201d option to automatically resize the column or row to fit the largest cell\u2019s data.<\/p>\n<p>Press \u201cOK\u201d to make the change once you\u2019re happy with the new sizing.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-708764 size-full\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/01\/Google-Sheets-Set-Row-Size.png\" alt=\"In the &quot;Resize&quot; box, provide a custom size, or select &quot;Fit To Data&quot; to resize the column or row to fit the largest cell's data. Click &quot;OK&quot; to save the setting.\" width=\"416\" height=\"347\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Once confirmed, the column or row will resize to match the size you selected. You can repeat this step for additional rows or columns.<\/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\/708758\/how-to-resize-column-and-rows-in-google-sheets\/\" target=\"_blank\" rel=\"noopener\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;#How to Resize Columns and Rows in Google Sheets&#8221; When you open a new Google Sheets spreadsheet, the columns, rows, and individual cells you see will all be a certain size. If you want to see more data in each cell, you\u2019ll need to resize them. Here\u2019s how. Manually Resizing a Column or Row in&#8230;<\/p>\n","protected":false},"author":1,"featured_media":174736,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2018\/11\/SheetsHeader.png?height=200p&trim=2,2,2,2","fifu_image_alt":"","footnotes":""},"categories":[18],"tags":[],"class_list":["post-174735","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\/174735","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=174735"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/174735\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/174736"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=174735"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=174735"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=174735"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}