CTRL+SHIFT+) is not working in Excel 2007

[Nagender Rathi]

Hi,

I am using Office 2007 on Vista machine.

When i am using CTRL+0, the excel columns are getting hide. But when i am
using CTRL+SHIFT+), my hided columns are not showing up.

If there is any workaround, please let em know

 

[Mike H]

Hi,

This hasn't changed in E2007. To Hide as you correctly say hold CTRL and tap 0
To unhide you have to select the columns either side of the hidden column(s)
then CTRL+Shift +0

Mike

 

[Nagender Rathi]

Hi Mike,

Thanks for replying

But my CTRL+Shift +0 is not working to unhide the hidden column(s).

Any workaround?

 

[Gord Dibben]

Does your SHIFT key work for other functions or shortcuts?


Gord Dibben MS Excel MVP

 

[Nagender Rathi]

yes my SHIFT key works for other functions or shortcuts

 

[Gord Dibben]

I cannot replicate the problem.

C + S + 0 works for me.

Out of guesses assuming you do select columns before and after as Mike
suggested.


Gord