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.

7 comments
ahmed19imran
ahmed19imran

Just go to the control panel click ----> Region and Language ----> Keyboards and Languages ----> Change Keyboards -----> Add keyboards -----> United States - International. Don't forget to move up and make it your default keyboard. I tried it on Microsoft Excel 2007 I think it will work in Excel 2010 as well. - Imran Ahmed .

anupamtiwari05
anupamtiwari05

The shortcut combination Ctrl+Shift+0 to unhide columns is not working in Excel 2007 however when I am Ctrl, Shift and 0 from Number Pad in keyboard, the combination is performing Copy function and when I am not using 0 from number pad then the combination is not doing anything. I don't know what's wrong with the combination in Excel 2007. Regards, Anupam

scrivensa
scrivensa

Ctrl+Shift+0 to unhide columns works for me in both 2007 and 2010. Could it be regional keyboards? I am using a British keyboard.

aksalaymeh
aksalaymeh

shortcuts worked fine with me in 2010 (((( BUT NUMBERS OF THE KEYBOARD ))))

gitmo
gitmo

All the others work, but in Excel 2010 [Ctrl]+[Shift]+0 shortcut doesn't work. Odd.

ahmed19imran
ahmed19imran

Just go to the control panel click ----> Region and Language ----> Keyboards and Languages ----> Change Keyboards -----> Add keyboards -----> United States - International. Don't forget to move up and make it your default keyboard. I tried it on Microsoft Excel 2007 I think it will work in Excel 2010 as well. - Imran Ahmed

Full Tao-er
Full Tao-er

Another thing I noted is the other shortcuts only work with the keyboard numbers, not the keypad to the right.

Editor's Picks