How to Set Excel Height & Width Using Your Keyboard

Those of you like me, who love to use their keyboard to save time will love this information and those of you who didn’t know you could accomplish this task with your keyboard will be very happy to learn that you can!

Unfortunately, this is not terribly easy, but it can be accomplished. Follow the steps below to learn how:

Versions 2007 – 2010 (Still clunky) Row Height:

1. Click Alt which will make Excel display its “shortcut mode.” You should now see shortcut keys above each tab of your Ribbon.
2. Click H to indicate you would like to use the Home tab and new shortcut keys display above each tool in the tab.
3. Click O to indicate you want to use the Format tool in the Cells Group. Excel will display a drop-down list of options.
4. Click H to select the Row Height option and the Row Height dialog will display.
5. Key in the value you want for your row height.
6. Click Enter.

To specify row width, simply use the steps above and substitute W in step 4.

Another method that can be used in any version of Excel:

1. Click Shift + Spacebar to select the entire row.
2. Click Shift + F10 to display a Context menu.
3. Click R to indicate you want to change the row height.
4. Key in the value you want for your row height.
5. Click Enter.

For Column width:

1. Click Ctrl + Spacebar.
2. Click Shift + F1- to display a Context menu.
3. Click C two times to choose the second C command in the Context menu.
4. Click Enter and Excel displays the Column Width dialog.
5. Key in the value you want for your column width.
6. Click Enter.