Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
HIDDEN ROWS
Columns A and B on a worksheet are hidden and I can't unhide them. Here's
what I've tried: 1. Select the entire wksheet/Window/Unhide (it's grayed out). 2. Select the entire wksheet/Format/column/width/25. All the columns change their width but A and B still are hidden. I've tried the above selecting only selected columns instead of the entire wksheet. Same result - nada. Ideas? -- William |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
HIDDEN ROWS
The subject for this post should have been Hidden COLUMNS, not rows.
-- William "William" wrote: Columns A and B on a worksheet are hidden and I can't unhide them. Here's what I've tried: 1. Select the entire wksheet/Window/Unhide (it's grayed out). 2. Select the entire wksheet/Format/column/width/25. All the columns change their width but A and B still are hidden. I've tried the above selecting only selected columns instead of the entire wksheet. Same result - nada. Ideas? -- William |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
HIDDEN ROWS
Maybe the window is frozen.
Window|Unfreeze (in xl2003 menus) then try scrolling left. William wrote: Columns A and B on a worksheet are hidden and I can't unhide them. Here's what I've tried: 1. Select the entire wksheet/Window/Unhide (it's grayed out). 2. Select the entire wksheet/Format/column/width/25. All the columns change their width but A and B still are hidden. I've tried the above selecting only selected columns instead of the entire wksheet. Same result - nada. Ideas? -- William -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
HIDDEN ROWS
Hi William
This is done under the [Format] menu, not [Windows] Select the entire worksheet. Click on the [Format] menu. Select [Column] and then [Unhide]* *I think its Unhide. My Excel is in Japanese where the option translates to [Show Again]. "William" wrote: Columns A and B on a worksheet are hidden and I can't unhide them. Here's what I've tried: 1. Select the entire wksheet/Window/Unhide (it's grayed out). 2. Select the entire wksheet/Format/column/width/25. All the columns change their width but A and B still are hidden. I've tried the above selecting only selected columns instead of the entire wksheet. Same result - nada. Ideas? -- William |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
HIDDEN ROWS
Thanks, Minty. Unfortunately when I follow that path (Format/Column/Unhide),
the Unhide link is grayed out. I have tried this selecting all or parts of the worksheet. -- William "Minty Fresh" wrote: Hi William This is done under the [Format] menu, not [Windows] Select the entire worksheet. Click on the [Format] menu. Select [Column] and then [Unhide]* *I think its Unhide. My Excel is in Japanese where the option translates to [Show Again]. "William" wrote: Columns A and B on a worksheet are hidden and I can't unhide them. Here's what I've tried: 1. Select the entire wksheet/Window/Unhide (it's grayed out). 2. Select the entire wksheet/Format/column/width/25. All the columns change their width but A and B still are hidden. I've tried the above selecting only selected columns instead of the entire wksheet. Same result - nada. Ideas? -- William |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
HIDDEN ROWS
William -
Maybe they are not hidden. Could you have freeze panes on? If so, turn that off and see if you can scroll left then. -- Daryl S "William" wrote: Thanks, Minty. Unfortunately when I follow that path (Format/Column/Unhide), the Unhide link is grayed out. I have tried this selecting all or parts of the worksheet. -- William "Minty Fresh" wrote: Hi William This is done under the [Format] menu, not [Windows] Select the entire worksheet. Click on the [Format] menu. Select [Column] and then [Unhide]* *I think its Unhide. My Excel is in Japanese where the option translates to [Show Again]. "William" wrote: Columns A and B on a worksheet are hidden and I can't unhide them. Here's what I've tried: 1. Select the entire wksheet/Window/Unhide (it's grayed out). 2. Select the entire wksheet/Format/column/width/25. All the columns change their width but A and B still are hidden. I've tried the above selecting only selected columns instead of the entire wksheet. Same result - nada. Ideas? -- William |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
HIDDEN ROWS
YES! Thanks so much.
-- William "Daryl S" wrote: William - Maybe they are not hidden. Could you have freeze panes on? If so, turn that off and see if you can scroll left then. -- Daryl S "William" wrote: Thanks, Minty. Unfortunately when I follow that path (Format/Column/Unhide), the Unhide link is grayed out. I have tried this selecting all or parts of the worksheet. -- William "Minty Fresh" wrote: Hi William This is done under the [Format] menu, not [Windows] Select the entire worksheet. Click on the [Format] menu. Select [Column] and then [Unhide]* *I think its Unhide. My Excel is in Japanese where the option translates to [Show Again]. "William" wrote: Columns A and B on a worksheet are hidden and I can't unhide them. Here's what I've tried: 1. Select the entire wksheet/Window/Unhide (it's grayed out). 2. Select the entire wksheet/Format/column/width/25. All the columns change their width but A and B still are hidden. I've tried the above selecting only selected columns instead of the entire wksheet. Same result - nada. Ideas? -- William |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
opening a group but keep hidden rows hidden | Excel Discussion (Misc queries) | |||
Hidden rows columns won't stay hidden | Excel Worksheet Functions | |||
Formula or Code to keep Hidden Rows Hidden | Excel Worksheet Functions | |||
I need my Hidden Rows to stay hidden when I print the sheet. | Excel Discussion (Misc queries) | |||
Excel 2003 -Rows hidden. Scrolling unhides rows ! How do I stop th | Excel Discussion (Misc queries) |