Excel can be a lot easier to use once you get comfortable using keyboard shortcuts to perform common actions. Copying and pasting, for example, is one action that can be made much quicker by using a keyboard instead of a mouse.
But there are keyboard shortcuts for many more Excel functions, including the AutoFit Column Width and AutoFit Column Height commands. Our guide below will show you how to get to them without needing to use your mouse.
Autofitting Rows and Columns in Excel 2013 Without Using Your Mouse
The steps in this article are going to show you a series of keyboard shortcuts that will allow you to use the AutoFit commands to automatically resize all of the columns and rows in your worksheet. The result of following these steps will be a worksheet where all of the row heights and column widths have been adjusted to fit the largest piece of data in that row or column.
Here is how to use keyboard shortcuts to AutoFit rows and columns in Excel 2013 –
- Open the worksheet in Excel 2013.
- Press Ctrl + a to select the entire worksheet.
- Press Alt + h to specify the Home tab.
- Press Alt + o to open the Format menu.
- Press Alt + i to use the AutoFit Column Width command.
- Repeat steps 2, 3, and 4 to get back to the Format menu, then press Alt + a to use the AutoFit Row Height command.
These steps are also shown below with pictures –
Step 1: Open your worksheet in Excel 2013.
Step 2: Press Ctrl + A on your keyboard to select the entire worksheet.
Step 3: Press Alt + h to select the Home tab.
Step 4: Press Alt + o to open the Format menu.
Step 5: Press Alt + i to use the AutoFit Column Width function.
Step 6: Repeat steps 2 – 4, then press Alt + a to use the AutoFit Row Height function.
If your Excel spreadsheet is difficult to print, then consider adjusting the scale. Learn how to fit a worksheet to one page in Excel 2013 without needing to manually adjust the size of your rows or columns at all.
Matthew Burleigh has been writing tech tutorials since 2008. His writing has appeared on dozens of different websites and been read over 50 million times.
After receiving his Bachelor’s and Master’s degrees in Computer Science he spent several years working in IT management for small businesses. However, he now works full time writing content online and creating websites.
His main writing topics include iPhones, Microsoft Office, Google Apps, Android, and Photoshop, but he has also written about many other tech topics as well.
Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.