How do I unhide row 1?

G

Guest

I have bee delivered a worksheet with Rows 1-9 hidden. How do I unhide these
rows when I cannot select the rows on both side of the hidden area.

Thanx.
 
B

Bob Phillips

Select the whole worksheet, Ctrl-A, Format>Row>Unhide.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
A

Andy Pope

Hi Bob,

If you use the mouse to select the top row, 10 in the OP's case, and the
whilst holding left button move up to the actual column headers you can
then via the menus use Format > Row > Unhide.
This way if any other rows are hidden they will remain hidden.

Cheers
Andy
 
D

Dave Peterson

I'd type A1:A9 in the namebox -- to the left of the formulabar.

Then format|row|unhide.

If the rows still don't appear when you scroll up, I'd remove the freeze panes.
Window|Unfreeze panes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unhide rows 1 - 9 3
Problem with hidden rows automatically unhiding 2
Unhide row formula 1
Unhide a row 1
Hide and Unhide Function 4
Cannot unhide the hidden rows in my spreadsheet 3
I'm unable to unhide rows 1-3 in Excel 2
Need help with Macro 2

Top