| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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... |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| One-click hide or unhide rows & columns | Excel Worksheet Functions | |||
| Hide / Unhide columns and rows | Excel Discussion (Misc queries) | |||
| How do I hide and unhide worksheets in Excel 2007? | Excel Discussion (Misc queries) | |||
| How to hide and unhide Rows & Columns | Excel Worksheet Functions | |||
| How do I hide or unhide zero value columns/rows USING A MACRO? | Excel Discussion (Misc queries) | |||
Linear Mode
