How to Reset Excel New Workbooks to the Default Cell Size
Question details
The user wants to restore standard cell dimensions in newly created workbooks because they currently appear abnormally large.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Creating a new workbook or attempting to revert formatting by copying content from a normally formatted workbook.
- Observed behavior
- New workbooks display unusually large cells and row numbers, and pasting content from other workbooks does not restore the expected default sheet view.
Before resetting cell sizes globally, check if your zoom level in the lower-right corner is set to a high percentage, as this can mimic the appearance of large cells without altering the actual default dimensions.
Use AutoFit to Restore Cell Sizes
Quickly adjust all cells to fit their content naturally using the built-in AutoFit feature.
Click the triangle icon in the top-left corner of the worksheet (between column A and row 1) or press Ctrl+A to select all cells.
Go to the Home tab on the top ribbon and locate the Cells group, then click on Format.
Click 'AutoFit Row Height' and then click 'AutoFit Column Width' from the dropdown menu to adjust the cells back to normal.
Set Standard Dimensions Manually
Manually enter the default values if AutoFit does not provide the standard visual layout you prefer.
Reset the Default Excel Template
If every new workbook opens with incorrect cell sizes, your default template file may be corrupted or incorrectly modified and needs to be removed.
Manage Cell Sizes and Templates Easily in WPS Office
WPS Spreadsheet offers a clean, highly compatible interface for managing cell dimensions, creating customized workbooks, and restoring default settings effortlessly.
- 1. Open WPS Spreadsheet: Launch WPS Office and open a blank workbook.
- 2. Select the worksheet: Click the top-left corner triangle above Row 1 to highlight all cells.
- 3. Adjust cell dimensions: Navigate to the Home tab, click on the Rows & Columns icon, and select AutoFit or manually input standard dimensions.
Frequently Asked Questions
What is the standard default cell size in Microsoft Excel?
By default, Excel sets the column width to 8.43 characters (64 pixels) and the row height to 15 points (20 pixels) when viewed at 100% zoom with the standard Calibri 11-point font.
Why do my cells suddenly look huge when I open Excel?
This can happen if your zoom slider (bottom right corner) is accidentally increased, or if the default blank workbook template (Book.xltx) was overwritten with custom, enlarged formatting.
Does copying data fix the cell size issue in a corrupted workbook?
Not always. If you copy data without bringing over the source formatting, the destination sheet will retain its original large cell dimensions. You must paste with source formatting or manually reset the dimensions.
