Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default unhide row does not unhide the hidden rows

hi, I run into this problem where I have hidden rows 1 - 3 and now I can't
seem to unhide them.

I found the below in online help. however, it still does not unhide the
hidden rows.
If the first row or column of a worksheet is hidden, click Go To on the Edit
menu. In the Reference box, type A1, and then click OK. On the Format menu,
point to Row or Column. and then click Unhide.
Instead of being hidden, the height or width of the first row or column of a
worksheet may have been set to zero. In this case, point to the border of the
Select All button until the cursor changes to or , and then drag to widen
the row or column.

Any ideas are highly appreciated! thanks!
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 11,501
Default unhide row does not unhide the hidden rows

Two thoughts,

If your rows are hidden by a filter then you can't simply unhide them you
must remove the filter.

Or Tap F5 and type A1 in the dialogbox and click OK. Then
Format|Row|Height set the height to 12.75.


Mike

"nikita" wrote:

hi, I run into this problem where I have hidden rows 1 - 3 and now I can't
seem to unhide them.

I found the below in online help. however, it still does not unhide the
hidden rows.
If the first row or column of a worksheet is hidden, click Go To on the Edit
menu. In the Reference box, type A1, and then click OK. On the Format menu,
point to Row or Column. and then click Unhide.
Instead of being hidden, the height or width of the first row or column of a
worksheet may have been set to zero. In this case, point to the border of the
Select All button until the cursor changes to or , and then drag to widen
the row or column.

Any ideas are highly appreciated! thanks!

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default unhide row does not unhide the hidden rows

Mike, thanks for your input.

I have no filters I am aware of and show all appears greyed out.
Your second thought is what I tried from online help and it did not unhide
either.
(I have tried again anyhow with the same result)

In fact I do not see the somewhat thicker line indicating hidden rows, but
my sheet starts with row 4 and with "go to" I can edit content in the hidden
rows.
However, I still can not unhide the hidden rows.
thanks!



"Mike H" wrote:

Two thoughts,

If your rows are hidden by a filter then you can't simply unhide them you
must remove the filter.

Or Tap F5 and type A1 in the dialogbox and click OK. Then
Format|Row|Height set the height to 12.75.


Mike

"nikita" wrote:

hi, I run into this problem where I have hidden rows 1 - 3 and now I can't
seem to unhide them.

I found the below in online help. however, it still does not unhide the
hidden rows.
If the first row or column of a worksheet is hidden, click Go To on the Edit
menu. In the Reference box, type A1, and then click OK. On the Format menu,
point to Row or Column. and then click Unhide.
Instead of being hidden, the height or width of the first row or column of a
worksheet may have been set to zero. In this case, point to the border of the
Select All button until the cursor changes to or , and then drag to widen
the row or column.

Any ideas are highly appreciated! thanks!

  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default unhide row does not unhide the hidden rows

Try going to Window/Unfreeze Panes, I had a similar problem, which led me to
find this thread, and in reading it, I thought of that solution.

Jim

"nikita" wrote:

Mike, thanks for your input.

I have no filters I am aware of and show all appears greyed out.
Your second thought is what I tried from online help and it did not unhide
either.
(I have tried again anyhow with the same result)

In fact I do not see the somewhat thicker line indicating hidden rows, but
my sheet starts with row 4 and with "go to" I can edit content in the hidden
rows.
However, I still can not unhide the hidden rows.
thanks!



"Mike H" wrote:

Two thoughts,

If your rows are hidden by a filter then you can't simply unhide them you
must remove the filter.

Or Tap F5 and type A1 in the dialogbox and click OK. Then
Format|Row|Height set the height to 12.75.


Mike

"nikita" wrote:

hi, I run into this problem where I have hidden rows 1 - 3 and now I can't
seem to unhide them.

I found the below in online help. however, it still does not unhide the
hidden rows.
If the first row or column of a worksheet is hidden, click Go To on the Edit
menu. In the Reference box, type A1, and then click OK. On the Format menu,
point to Row or Column. and then click Unhide.
Instead of being hidden, the height or width of the first row or column of a
worksheet may have been set to zero. In this case, point to the border of the
Select All button until the cursor changes to or , and then drag to widen
the row or column.

Any ideas are highly appreciated! thanks!

  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default unhide row does not unhide the hidden rows

Jim, thanks for the tip. However, I unfreeze also does not let me unhide the
rows.
same problem as before. thanks.

"Jim Evers" wrote:

Try going to Window/Unfreeze Panes, I had a similar problem, which led me to
find this thread, and in reading it, I thought of that solution.

Jim

"nikita" wrote:

Mike, thanks for your input.

I have no filters I am aware of and show all appears greyed out.
Your second thought is what I tried from online help and it did not unhide
either.
(I have tried again anyhow with the same result)

In fact I do not see the somewhat thicker line indicating hidden rows, but
my sheet starts with row 4 and with "go to" I can edit content in the hidden
rows.
However, I still can not unhide the hidden rows.
thanks!



"Mike H" wrote:

Two thoughts,

If your rows are hidden by a filter then you can't simply unhide them you
must remove the filter.

Or Tap F5 and type A1 in the dialogbox and click OK. Then
Format|Row|Height set the height to 12.75.


Mike

"nikita" wrote:

hi, I run into this problem where I have hidden rows 1 - 3 and now I can't
seem to unhide them.

I found the below in online help. however, it still does not unhide the
hidden rows.
If the first row or column of a worksheet is hidden, click Go To on the Edit
menu. In the Reference box, type A1, and then click OK. On the Format menu,
point to Row or Column. and then click Unhide.
Instead of being hidden, the height or width of the first row or column of a
worksheet may have been set to zero. In this case, point to the border of the
Select All button until the cursor changes to or , and then drag to widen
the row or column.

Any ideas are highly appreciated! thanks!

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to unhide Excel rows after they are automatily hidden Chuck New Users to Excel 1 March 24th 08 10:31 PM
Why do hidden columns/rows unhide automatically? WHY Excel Discussion (Misc queries) 1 December 11th 07 02:51 AM
all hidden rows automatically unhide WHY Setting up and Configuration of Excel 1 October 20th 07 01:46 PM
Hidden rows unhide themselves when formulas are written Hongch Excel Discussion (Misc queries) 3 January 19th 06 07:33 PM
Why cannot I unhide the hidden rows ? Jim Edwards Excel Discussion (Misc queries) 2 December 4th 04 05:38 PM


All times are GMT +1. The time now is 05:00 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"