View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Ken Johnson Ken Johnson is offline
external usenet poster
 
Posts: 1,073
Default How do you unhide the first three rows of a worksheet?


Has the sheet's scroll area property been altered?

The first three rows will remain hidden if they are not part of the
sheet's scroll area.

Right click that sheet's tab then select "View Code" from the popup
menu. This takes you to the VBA Editor. In the VBA Editor go
View|Properties window. If the ScrollArea value is not blank then you
will have to delete the address to reveal the top three rows.

Ken Johnson