ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   HIDDEN ROWS (https://www.excelbanter.com/excel-discussion-misc-queries/250342-hidden-rows.html)

William

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

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


Dave Peterson

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

Minty Fresh

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


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


Daryl S

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


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