[ad_1]
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.
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.
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.”
Enter the measurement in points and click “OK”.
For a row, right-click and choose “Row Height”, enter the measurement and click “OK”.
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.”
Enter the measure in points for the columns or rows and click “OK”.
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.
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.
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.”
Enter the measurement in points and click “OK”.
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.
[ad_2]
