HIDDEN ROWS

W

William

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?
 
D

Dave Peterson

Maybe the window is frozen.

Window|Unfreeze (in xl2003 menus)
then try scrolling left.
 
M

Minty Fresh

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

William

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 said:
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 said:
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?
 
D

Daryl S

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 said:
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 said:
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 said:
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?
 
W

William

YES! Thanks so much.
--
William


Daryl S said:
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 said:
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 said:
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].

:

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top