How do I unhide row 1?

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
Select the whole worksheet, Ctrl-A, Format>Row>Unhide.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
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
 
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

Problem with hidden rows automatically unhiding 2
Unhide rows 1 - 9 3
Hide and Unhide Function 4
Cannot unhide the hidden rows in my spreadsheet 3
Unhiding rows in Excel 2007 5
Unhide a row 1
Unhide row formula 1
I am unable to unhide rows through the format menu. 7

Back
Top