Sometimes in an Excel document the column sizes need to be adjusted so you can see the data clearly. Rather than trying to change all the column and row sizes manually, we show you how to do it in just a few clicks.
If you work with large spreadsheets, manually adjusting column widths and row heights can quickly become frustrating. Fortunately, Excel offers a fast and easy way to automatically resize your entire worksheet so everything fits neatly on the screen. Whether you prefer using your mouse or keyboard shortcuts, you can auto-fit your data in just a few seconds.
Method 1: Auto-Fit Using the Mouse
One of the quickest ways to resize your Excel sheet is with a simple double-click.
- Select the entire worksheet by clicking the Select All button in the top-left corner of the spreadsheet — the small triangle where the row numbers and column letters intersect.
- To auto-fit columns, move your cursor over the boundary line between any two column headers, such as A and B.
- When the cursor changes into a double-headed arrow, double-click the boundary line.
Excel will instantly adjust all column widths to fit the content perfectly.
Method 2: Auto-Fit Using Keyboard Shortcuts
If you enjoy working faster with shortcuts, Excel has a built-in sequence for auto-fitting columns.
- Press Ctrl + A twice to select the entire worksheet.
- Press Alt + H + O + I in sequence.
This command automatically resizes every column based on the data inside the cells.
Bonus Tips for Better Spreadsheet Formatting
Auto-Fit Row Heights – Sometimes text gets cut off because the row height is too small. To fix this:
- Select the entire worksheet.
- Hover over the boundary between any two row numbers.
- Double-click to automatically adjust all row heights.
You can also use the keyboard shortcut: Alt + H + O + A
Use Wrap Text for Cleaner Layouts – If your columns become too wide after auto-fitting, consider using Excel’s Wrap Text feature instead. This keeps columns narrow while displaying all the text within a cell.
To enable it:
- Select the cells you want to format.
- Go to the Home tab.
- Click Wrap Text.
Final Thoughts
Auto-fitting rows and columns is one of the simplest ways to make your Excel spreadsheets cleaner, easier to read, and more professional. Whether you use the mouse method or keyboard shortcuts, these quick formatting tricks can save you valuable time and improve your workflow instantly.
We regularly update the Tech Tips with new articles and advice from the IT West team so be sure to check back for the latest technical tips, tricks and guidance from our team of business IT experts.