Software

Office solution: Keyboard shortcuts for hiding and unhiding columns and rows

This week, learn one solution to last week's Office challenge: What's the shortcut for unhiding columns and rows in Excel 2007?
A couple of weeks ago, we asked for the keyboard shortcut that unhides columns and rows in Excel 2007. Reader Paul Blaser initiated this challenge after upgrading to Excel 2007. As you can see in Table A, the [Ctrl]+[Shift]+0 shortcut for unhiding columns doesn't work in Excel 2007 - at least, for some of us. Help files for Excel 2007 list the keystroke, so it should work, right?

Table A

Combo

Description

2003

2007

2010

[Ctrl]+0 Hides columns

Y

Y

Y

[Ctrl]+[Shift]+0 Unhides columns

Y

N

Y

[Ctrl]+9 Hides rows

Y

Y

Y

[Ctrl]+[Shift]+9 Unhides rows

Y

Y

Y

Another way to unhide a column follows:

  1. Select the adjacent columns. Or, enter a cell reference to any cell in the hidden column into the Name box (to the left of the Formula bar).
  2. Click the Home tab.
  3. From the Format dropdown in the Cells group, choose Hide & Unhide.
  4. Select Unhide Columns.

The keystroke equivalent to the above process is [Alt]+H+O+U+L. Unfortunately, this keystorke method isn't as efficient as [Ctrl]+[Shift]+0; why it doesn't work in Excel 2007 is still a mystery to me. If any of you figure it out, let us know!

About

Susan Sales Harkins is an IT consultant, specializing in desktop solutions. Previously, she was editor in chief for The Cobb Group, the world's largest publisher of technical journals.

Editor's Picks