How to resize all columns and rows in Microsoft Excel

0
22


You may need to resize a column to fit the width of your data or a row for a better look. But what if you want to resize all the columns and rows in an Excel spreadsheet?

We’ll show you some easy ways to change your column and row sizes at the same time. Also, we will explain how to adjust the default size of all new columns in a sheet.

Resize all columns and rows in a sheet

Whether you want to resize all columns, all rows, or both, you can do it in just a few clicks.

Start by selecting the entire sheet. You can do this by clicking the Select All triangle in the upper left corner of the spreadsheet.

Select All button in Excel

Drag a header to adjust sizes

To view column or row sizes instead of entering exact measurements, simply click and drag. For columns, drag the letter header to any column on the sheet. For rows, drag the number header from any row.

Resize The Excel Formula Bar

Drag to resize a column

You will immediately see all the columns or rows update to the new size.

Right click for exact sizes

Another way to change all column and row sizes is to enter a precise measurement. The default sizes are 8.43 points wide for columns and 15 points high for rows. You can fit columns up to 255 points and rows up to 409 points.

With the entire sheet selected, right-click a column and choose “Column Width.”

Column width in context menu

Enter the measurement in points and click “OK”.

Column width checkbox

For a row, right-click and choose “Row Height”, enter the measurement and click “OK”.

Row height in context menu

You will then see all the columns and/or rows configured with the new point measure.

Use the format button for exact sizes

One more way to resize all columns and rows to the exact size is to use the Format option on the Home tab. In the Cells section of the ribbon, select the Format drop-down arrow and choose “Column Width” or “Row Height.”

Column and row sizes in the Format menu

Enter the measure in points for the columns or rows and click “OK”.

Row height checkbox

Use the Format button to AutoFit

If you don’t necessarily want all columns or rows to be a particular size, but would rather have them fit your data, this is one more option.

RELATED: How to AutoFit in Microsoft Excel

With the sheet selected, use the Format button on the Home tab. Choose “AutoFit Column Width”, “AutoFit Row Height”, or both.

AutoFit in the Format menu

You will see your sheet update the columns and/or rows to accommodate the sizes of the data in the cells. Just note that if you have blank columns or rows, those sizes will stay at the default sizes.

Column sizes for AutoFit

Set default size for all columns in a sheet

Another option to change the width of all columns on a sheet is to set the default width. This is only an option for columns because the height of the row depends on the font size you use.

Select the entire sheet as described above and go to the Home tab. Click the Format dropdown arrow and choose “Default Width.”

Default column width in the Format menu

Enter the measurement in points and click “OK”.

Default Column Width box

All existing and new columns you add to your sheet will fit this size.

Column and row sizes for new workbooks

When you resize columns and rows in an Excel sheet, the changes only apply to the current sheet. It does not affect other sheets in the workbook or any new workbooks and sheets you create.

If you want to resize the columns and rows of all your new workbooks and sheets, consider creating a template. You can set the sizes for the sheet(s) using any of the above methods, save the workbook as a template, and then open that template for each new workbook you create.

Another option when you create the template is to have it open every time you start Excel. Follow our procedure to always open a specific workbook in Excel if you are interested in this option.

Resizing all the columns and rows in your Excel sheet allows you to avoid the ##### error, ensure your data fits well, and provides a consistent look and feel.