If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Unhiding rows in Excel 2007
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. |
#2
|
|||
|
|||
Unhiding rows in Excel 2007
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 |
#3
|
|||
|
|||
Unhiding rows in Excel 2007
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. |
#4
|
|||
|
|||
Unhiding rows in Excel 2007
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. |
#5
|
|||
|
|||
Unhiding rows in Excel 2007
"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. |
#6
|
|||
|
|||
Unhiding rows in Excel 2007
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. |
Thread Tools | |
Display Modes | |
|
|