Unhiding rows in Excel 2007

  • Thread starter Thread starter Skibee
  • Start date Start date
S

Skibee

I've taken over a worksheet of an employee who has left the company.

Rows 1-7 are set as Print Title areas and rows 1-3 are hidden. I need to
edit rows 1-3 but I cannot get them to unhide.

Have tried Ctrl+A (to select whole sheet) and then right clicking and
selecting unhide but no luck. Have also checked to make sure no filters are
on.

Any help would be much appreciated.
Thanks.
 
Try unfreezing the panes. Maybe you showed them ok, but you just can't scroll
up.
 
Click the Gray button between 1 and A to highlight entire worksheet. then
from menu do the following

Format - Rows - Unhide
 
Hi,

First try just scrolling up, when you unhide rows they don't automatically
come back into view depending on your position on screen.

Second, the rows may not be hidden, instead Freeze panes could be on.
Choose View, Freeze Panes, Unfreeze Panes.
 
Skibee said:
I've taken over a worksheet of an employee who has left the company.

Rows 1-7 are set as Print Title areas and rows 1-3 are hidden. I need to
edit rows 1-3 but I cannot get them to unhide.

Have tried Ctrl+A (to select whole sheet) and then right clicking and
selecting unhide but no luck. Have also checked to make sure no filters are
on.

Any help would be much appreciated.
Thanks.
Click to expand...
 
I am having the same problem. None of the suggested solutions work or apply
to the situation.
I have multiple locations within multiple worksheets in this workbook with
blocks of rows that have been hidden. I can hide and unhide columns. If I
hide additional rows, I cannot unhide them except with the undo button at the
top.
I've never seen anything like this. So far it is only occurring in this
wookbook.
 
Back
Top