ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel 2007 - Hide & Unhide Columns/Rows (https://www.excelbanter.com/excel-discussion-misc-queries/209104-excel-2007-hide-unhide-columns-rows.html)

leahl

Excel 2007 - Hide & Unhide Columns/Rows
 
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?
--
Leah L. Hinds
Project Manager, Training & Support

Bob I

Excel 2007 - Hide & Unhide Columns/Rows
 
Is this in the QAT? Works just fine here. Try remove and re-add?

leahl wrote:

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?



GILBERT

Excel 2007 - Hide & Unhide Columns/Rows
 
Try Ctrl+Shift+9 and Ctrl+Shift+0.

"leahl" wrote:

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?
--
Leah L. Hinds
Project Manager, Training & Support


leahl

Excel 2007 - Hide & Unhide Columns/Rows
 
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.

--
Leah L. Hinds
Project Manager, Training & Support


"Gilbert" wrote:

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

"leahl" wrote:

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?
--
Leah L. Hinds
Project Manager, Training & Support


leahl

Excel 2007 - Hide & Unhide Columns/Rows
 
I am sorry, Bob, but I don't know what QAT is...??? Remove and re-add what?
Sorry to sound so clueless...
--
Leah L. Hinds
Project Manager, Training & Support


"Bob I" wrote:

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

leahl wrote:

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

Excel 2007 - Hide & Unhide Columns/Rows
 
Sure it does.

leahl wrote:

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

Excel 2007 - Hide & Unhide Columns/Rows
 
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...
--
Leah L. Hinds
Project Manager, Training & Support


"Bob I" wrote:

Sure it does.

leahl wrote:

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.




Bob I

Excel 2007 - Hide & Unhide Columns/Rows
 
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

leahl wrote:

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



Bob I

Excel 2007 - Hide & Unhide Columns/Rows
 
See other reply Shift key

leahl wrote:

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...




All times are GMT +1. The time now is 06:18 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com