Fast Way to Adjust Height and Width of Cells in Excel

BY STANLEY ZAROWIN

When I’m working in Excel, I frequently need to adjust the height and width of a cell. I can do it with a mouse, but that means I have to shift my hand from the keyboard to the mouse. I’m beginning to realize I can be more efficient if I keep both hands on the keyboard. So, is there a keyboard sequence for that?

I like the way you think. While the mouse is handy, keystrokes are far more efficient. Here’s how to adjust the size of cells using the keyboard:

For pre-2007 Excel, press Alt+O (that’s the letter, not a zero) and the regular formatting screen will appear (see screenshot below).

Then click on just the letter R (for the Row option) and the Row submenu appears. Press E and the Height option opens. Enter your choices and press Enter.

To change the column width, press Alt+O and then press C (for Column) and then W (for width). Type your values and press Enter.

In Excel 2007, press Alt, which puts Excel into a shortcut key mode (see the January 2009 column, page 74, for more on the use of KeyTips) and press H for the Home tab of the Ribbon. Press O (capital letter O) to open the Format tool in the Cells group with a dropdown list. Press H for Row Height. For Width, press W.

Another way to adjust the height of an entire row in any version of Excel is topress Shift+Spacebar, and then press Shift+F10, which displays the Context menu (see screenshot at right).

To change the Row Height, press R. To reset a Column Width, press Ctrl+Spacebar, then Shift+F10, then press C twice to choose Column Width, which is the second command that starts with the letter C (see screenshot at left).

SPONSORED REPORT

How the election may affect taxation of business income

This report summarizes recent proposals to reform the U.S. business income tax system and considers the path to enactment of any such legislation.

VIDEO

How to Excel pivot a general ledger

The general ledger is a vast historical data archive of your company's financial activities, including revenue, expenses, adjustments, and account balances. J. Carlton Collins, CPA, shows how to prepare data for, and mine data with, PivotTables.

QUIZ

Did you follow 2016’s biggest accounting news?

CPAs will remember 2016 as a year of new standards and new faces. How well did you follow the biggest accounting events? The 7 questions in this quiz will help you find out