Excel 2007 - Hide & Unhide Columns/Rows

[leahl]

The tool tip that appears when you cursor over the Unhide Rows and Unhide
Columns doesn't work --- rows - Ctrl+( and Columns - Ctrl+). The Hide Tool
tip does work (Hide Rows - Ctrl+9 and Hide Columns - Ctrl+0) but the unhide
does not... Any suggestions?

 

[Bob I]

Is this in the QAT? Works just fine here. Try remove and re-add?

 

[Gilbert]

Try Ctrl+Shift+9 and Ctrl+Shift+0.

 

[leahl]

oooooops... I mistyped the commands... Sorry

It is Ctrl+Shift+) which is Ctrl+Shift+0 and Ctrl+Shift+( which is
Ctr+Shift+9.

Also, Ctrl+Shift+9 or ( works for Rows but the Ctrl+Shift+0 or ) does not
work for Columns.

 

[leahl]

I am sorry, Bob, but I don't know what QAT is...??? Remove and re-add what?
Sorry to sound so clueless...

 

[Bob I]

Sure it does.

 

[leahl]

I cannot get mine to work to unhide columns... I have tried selecting cells
on either side of the hidden column, selecting the entire column... nothing
seems to work...

 

[Bob I]

Quick Access Toolbar. I thought you meant the Tooltip didn't appear.

But it sounds like you are having trouble with the Shift key

Ctrl+ 9 or 0 to Hide
Ctrl+Shift+ 9 or 0 to UNHide

 

[Bob I]

See other reply Re: Shift key