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.

Skibee wrote:

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.

--

Dave Peterson

Click the Gray button between 1 and A to highlight entire worksheet. then
from menu do the following

Format - Rows - Unhide

"Skibee" wrote:

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.

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.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire

"Skibee" wrote in message
...
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.

"Skibee" wrote:

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.

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.


"Skibee" wrote:

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.