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:
- 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).
- Click the Home tab.
- From the Format dropdown in the Cells group, choose Hide & Unhide.
- Select Unhide Columns.