View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
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!