Use the Keyboard to Change Row Height and Column Width in Excel 2007

If you prefer using the keyboard rather than the mouse, there is a way in Excel to change the row height and column width using the keyboard; however, it is not very intuitive.

To set the row height, press Alt to put Excel into a “shortcut key mode.” You will see shortcut keys displays on each tab of the ribbon.

Pressing Alt to see shortcut keys

Press “H” to indicate you want to use the Home tab. New shortcut keys display on each tool in the tab. Press “O” to indicate you want to use the Format tool in the Cells group.

Shortcut keys on tools

A drop-down menu displays with shortcut keys next to the options. Press “H” to select the Row Height option under the Cell Size heading on the menu.

NOTE: To change the column width, press “W” instead of “H.”

Format drop-down menu

The Row Height dialog box displays. Enter the desired height in the edit box and press Enter.

Row Height dialog box

There is another method for changing the row height. Select any cell in the row you want to change and press Shift + Spacebar to select the entire row.

  1. Press R to indicate you want to change the row height. Excel displays the Row Height dialog box.
  2. Type the value you want for the row height.
  3. Press Enter.

Entire row selected

Press Shift + F10 to display the context menu, which is the same menu you see if you were to right-click on the selected row. Press “R” to select the row height option.

Row context menu

The Row Height dialog box displays. Enter the desired height in the edit box and press Enter.

Row Height dialog box

Changing the column width using the method is similar to changing the row height. To select the entire column, press Ctrl + Spacebar. Then, press Shift + F10 to access the context menu. Press “C” twice to select the second “C” command on the menu and press Enter.

Column context menu

The Column Width dialog box displays. Enter the desired column width and press Enter.

Column Width dialog box

The shortcut keys that display using the Alt key on the tabs and on the tools and options allow you to access many options using the keyboard.

by Lori Kaufman

More posts from the Office Tips Category

outlook memory hog

How to Reduce Outlook Memory Usage

Always Paste Text into Word 2010 from an Outside Source without Formatting

How to Trace Dependents in Excel 2010

Popup Spell Number for Word installation file

Quickly Spell Out Numbers in Word and Excel

Popular Posts This Month

event id

Fix Windows 8 App Opens Then Closes

runas command

5 Windows Alternatives to the Linux sudo Command

5 Utilities for Changing DNS Servers in Windows Reviewed

windows defender

Windows Defender vs. Security Essentials vs Safety Scanner

Leave a Reply