Microsoft Excel logo on a green background

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

We’ll show you a few easy ways to change the sizes of your columns and rows at one time. Plus, we’ll 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 change the size of all columns, all rows, or both, you can do so in just a few clicks.

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

Select All button in Excel

Drag a Header to Adjust the Sizes

To eyeball the sizes of the columns or rows rather than enter exact measurements, just click and drag. For columns, drag the letter header for any column in the sheet. For rows, drag the number header for any row.

Dragging to resize a column

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

Perform a 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 15 points high for rows. You can adjust 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 the shortcut menu

Enter the measurement in points and click “OK.”

Box for the column width

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

Row Height in the shortcut menu

You’ll then see all columns and/or rows set to the new points measurement.

Use the Format Button for Exact Sizes

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

Column and row sizes in the Format menu

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

Box for the row height

Use the Format Button for AutoFit

If you don’t necessarily want all columns or rows to be a particular size, but prefer they adjust to 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’ll see your sheet update the columns and/or rows to accommodate the sizes of the data in the cells. Just keep in mind that if you have blank columns or rows, those sizes remain at the default sizes.

Column sizes to AutoFit

Set the Default Size for All Columns in a Sheet

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

Select the entire sheet as described above and head to the Home tab. Click the Format drop-down arrow and pick “Default Width.”

Default Column Width in the Format menu

Enter the measurement in points and click “OK.”

Default Column Width box

All existing columns and new ones you add to your sheet will conform to 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 new workbooks and sheets you create.

If you want to change the sizes of columns and rows for all new books 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 each time you launch Excel. Follow our how-to for always opening a specific workbook in Excel if you’re interested in this option.

Resizing all columns and rows in your Excel sheet lets you avoid the ##### error, ensure that your data fits nicely, and provides a consistent appearance.

Profile Photo for Sandy Writtenhouse Sandy Writtenhouse
With her B.S. in Information Technology, Sandy worked for many years in the IT industry as a Project Manager, Department Manager, and PMO Lead. She learned how technology can enrich both professional and personal lives by using the right tools. And, she has shared those suggestions and how-tos on many websites over time. With thousands of articles under her belt, Sandy strives to help others use technology to their advantage.
Read Full Bio »