Re: I am unable to unhide rows through the format menu.

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

If you freeze the screen so that row 2 is visible and row 1 is off the screen
(hidden or visible), you won't be able to scroll up to see row 1.

As soon as you unfreeze the panes, you could scroll up to see if row 1 was
visible. If it isn't, you can use the other techniques to show that row.

Victoriamarie wrote:

Thank you. Thank you. Thank you. I did have everything below Row 6 frozen. I
unfroze the sheet and then went to Format Row Unhide and my Row 1 showed up.
Any suggestions as to why freezing panes would cause this situation?

"Dave Peterson" wrote:

Maybe the row is off the visible screen.

Window|unfreeze panes (xl2003 menus)
and then scroll up

Victoriamarie wrote:

Mike,

I tried your suggestions, but I am still not able to unhide my Row 1. I'm
unsure of the filtering. As far as I can tell this row is not filtered. Any
other suggestions?

"Mike H" wrote:

Hi,

If the sheet isn't protected select everything by clicking the box in the
upper left corner at the intersection of the row and column headings then
click
Format|Row|Unhide

If that doesn't work check if the rows are hidden with a Filter. If they are
you can't simply unhide then you must remove the filter.

Mike

"Pistol" wrote:

I have tried unhiding rows and my worksheet is not protected and the panes
are not frozen. I have also tried selecting the entire worksheet to unhide,
but I wasn't able to see all of my hidden rows.

--

Dave Peterson


--

Dave Peterson
.

Relevant Pages

  • Re: printing
    ... use the scroll bar to to the right to scroll to the bottom of the page it ... "Dave Peterson" wrote: ... I have used that range to create an auto filter. ...
    (microsoft.public.excel.programming)
  • Re: printing
    ... "Larry" wrote: ... use the scroll bar to to the right to scroll to the bottom of the page it ... "Dave Peterson" wrote: ... I have used that range to create an auto filter. ...
    (microsoft.public.excel.programming)
  • Re: Unhiding Rows
    ... Check to see if you can use Window|Unfreeze panes. ... Then scroll to the left ... "Dave Peterson" wrote: ... When I opened it I found that I couldn't unhide them by right clicking ...
    (microsoft.public.excel.misc)
  • Re: How do I unhide collom a?
    ... Make sure that you haven't frozen the panes so that you can't scroll to column ... I hid collom A and now can't unhide it! ... Dave Peterson ...
    (microsoft.public.excel.worksheet.functions)
  • RE: method select of object range failed
    ... an applied data filter the program crashes. ... Sub Test() ... I am writing code that creates a user form used to scroll through a filtered ...
    (microsoft.public.excel.programming)