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 |
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 |
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 |
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 |
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 |
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 |
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 |
All times are GMT +1. The time now is 08:30 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com