In case you’re don’t like the double-click method, there is another way to quickly auto-fit column width in Google Sheets. Autofit Column Width with ‘Fit to Data’ Option Once selected, you can autofit columns by double-clicking for any of the columns. In case you want to do this for the entire sheets, you can select all the cells by clicking on the gray box at the top-left of the worksheet. This would adjust the column width of all the selected columns at one go. You would notice that the cursor changes to a double-pointed arrow Place the cursor at the right edge of any of the selected column titles.Select the columns that you want to autofit (these could be contiguous or non-contiguous columns).In case you want to autofit column width for multiple columns at once, follow the below steps: So if you have a cell that has a lot of text, autofit may widen the column a lot. Note that auto-fit adjusts to accommodate the cell with the maximum text. The above steps would instantly auto-fit the column based on the text in the cells. Place the cursor at the right edge of the column title.Select the column that you want to autofit.Suppose you have the dataset as shown below and you want to autofit column A (which has the company names). The easiest way to autofit the width of the columns in Google Sheets is to select all the columns for which you want to adjust the width and use a simple double click. So let’s get started! Autofit Column Width with Double Click Autofit Column Width with ‘Fit to Data’ Option.The default width of a column is 8.43 units and the default height of a row is 15.00 units. Note: you can also use this technique to set a row height or a column width (see screenshot at step 3). On the Home tab, in the Cells group, click Format. First, select multiple rows by clicking and dragging over the row headers.Ģ. There’s one more way to autofit columns or rows.ġ. Instead of clicking the right border of a column header, simply click the bottom border of a row header. The techniques described above can also be used to change the height of a row. To change the width of all columns, first select all columns by clicking the Select All button. Next, double click the right border of one of the column headers.ĥ. Note: to select non-adjacent columns, hold CTRL while clicking the column headers.Ĥ. To autofit multiple columns, first select multiple columns by clicking and dragging over the column headers. To automatically fit the widest entry in a column, double click the right border of a column header.ģ. You can change the width of a column by clicking and dragging the right border of the column header.Ģ. The default width of a column is 64 pixels.ġ. When a column width or row height is set to 0, such column/row is not visible on a sheet (hidden). The default height of an Excel row varies from 15 points on a 100% dpi to 14.3 points on a 200% dpi. Rows can have a maximum height of 409 points, with 1 point equal to approximately 1/72 inch or 0.035 cm. The default size of columns in Excel is 8.43. Using a bigger font size or applying additional font characteristics such as italics or bold may significantly reduce the maximum column width. When resizing cells in Excel, either automatically or manually, please bear in mind the following limits to how big columns and rows can be made.Ĭolumns can have a maximum width of 255, which is the maximum number of characters in the standard font size that a column can hold. However, when exporting or copying data from another source, row heights may not auto adjust, and in these situations the AutoFit Row Height opting comes in helpful. Unlike column width, Microsoft Excel changes the row height automatically based on the height of the text you type in a cell, therefore you won’t really need to auto fit rows as often as columns. This option expands the row vertically to hold multi-line or extra-tall text. Excel AutoFitĪutoFit Column Width - changes the column width to hold the largest value in the column.ĪutoFit Row Height - adjusts the column width to match the largest value in the row. Depending on your preferred work style, you can auto fit columns and rows by using the mouse, ribbon or keyboard. What I particularly like about Excel is that it provides more than one way to do most things. No need for cells that get cut off!Īnd if you learn to quickly use AutoFit, you can get perfectly sized cells in no time.Įxcel’s AutoFit feature is designed to automatically resize cells in a worksheet to accommodate different sized data without having to manually change the column width and row height. Adjusting column widths and row heights in Excel can make for a much nicer looking spreadsheet.