How to Fix Extremely Small Cells in Excel 2019
Question details
Users are experiencing an issue where new Excel workbooks open with unusually small rows and columns, displaying too many columns on screen even at 100% zoom.
- Product
- Microsoft Excel 2019
- Device & OS
- not provided
- Scenario
- Creating or opening new Excel workbooks.
- Observed behavior
- Cells appear extremely small, showing an excessive number of rows and columns despite standard zoom, display scaling, and default font settings.
Ensure your computer's Windows display resolution and scaling settings are set to their recommended defaults, as operating system scaling conflicts can sometimes interfere with Excel's visual rendering.
Reset the Default Excel Template (Book.xltx)
Replacing or resetting the default template resolves formatting issues that persistently occur every time you create a new workbook.
Excel uses a default template for every new workbook created. If this template file becomes corrupted or accidentally modified, it forces unusually small column widths and row heights on all new files.
Press the Windows Key + R on your keyboard to open the Run dialog box.
Type %appdata%\Microsoft\Excel\XLSTART and press Enter. This folder stores your startup files and templates.
Look for a file named Book.xltx or Sheet.xltx. Delete these files or move them to another folder (like your Desktop) as a backup.
Open Excel 2019 again and create a blank workbook. Excel will automatically generate a fresh, factory-default layout.
Verify Normal Style and Default Font Settings
Incorrect default font sizes within Excel's Normal style can forcefully shrink row heights and column widths.
Test Excel in Safe Mode
Running Excel in Safe Mode helps determine if a third-party add-in or hidden startup program is causing the small cells rendering issue.
Use WPS Office to Avoid Template Glitches
If Microsoft Excel continues to display unusually small cells or gives you persistent template errors, consider switching to WPS Office. It provides a lightweight, highly compatible spreadsheet experience without the hassle of corrupted startup templates or rendering bugs.
- 1. Download the Installer: Visit the official WPS Office website and download the free installer package.
- 2. Install WPS Office: Run the downloaded file and follow the quick on-screen instructions to install the software suite.
- 3. Open Spreadsheets: Launch WPS Spreadsheets, seamlessly open your existing Excel workbooks, or start fresh with stable cell dimensions.
Frequently Asked Questions
Why are my Excel cells suddenly so small?
This layout issue typically occurs due to a corrupted default workbook template (Book.xltx), accidental changes to the 'Normal' cell style font size, or conflicting Windows display scaling configurations.
How do I change the default column width in Excel?
You can change the default width for your current workbook by navigating to the Home tab, clicking 'Format' in the Cells group, selecting 'Default Width', entering a standard value (like 8.43), and clicking OK.
Does zooming in permanently change the cell size in Excel?
No, adjusting the zoom slider only changes how the cells are displayed on your computer screen. It does not alter the actual printed size or the inherent default dimensions of the rows and columns in the file.
