Fast Way to Adjust Height and Width of Cells in Excel


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).


Year-end tax planning and what’s new for 2016

Practitioners need to consider several tax planning opportunities to review with their clients before the end of the year. This report offers strategies for individuals and businesses, as well as recent federal tax law changes affecting this year’s tax returns.


News quiz: Retirement planning, tax practice, and fraud risk

Recent reports focused on a survey that gauges the worries about retirement among CPA financial planners’ clients, a suit that affects tax practitioners, and a guide that offers advice on fraud risk. See how much you know with this short quiz.


Bolster your data defenses

As you weather the dog days of summer, it’s a good time to make sure your cybersecurity structure can stand up to the heat of external and internal threats. Here are six steps to help shore up your systems.