Share this content

Excel question - can't unhide rows

This is probably really easy for all you Excel whizz-kids out there - HELP.

I have hidden rows 1-65 in an excel sheet.

I need access to these rows, but when I highlight the whole area or sheet, the HIDE/UNHIDE options do not appear and therefore I cannot unhide my hidden rows.

Please can anyone suggest a solution?

Many thanks in advance!



Please login or register to join the discussion.

03rd Jul 2007 17:52

Here is how I do it
Left click and hold on row 66 (ie on the number 66 itself) then move the mouse pointer up, so it goes up to the letters. Then release the mouse. Next right click row 66, chose unhide, and rows 1-65 will reappear.

Thanks (0)
By Anonymous
02nd Jul 2007 17:34

Excel query
When you say you have highlighted the whole area or sheet, have you done this by clicking in the border above row 1 and left of column A? When I do that, the Unhide option is not greyed out and achieves what you are trying to do.

Thanks (0)
01st Jul 2007 18:45

Try this!

First, is your data filtered? If so, first remove your filter (Data/filter/autofilter)

If you type A1 in the box in the top left that contains a cell reference, press enter, then hold the shift key and select row 66, you should now be able to unhide your rows.


Thanks (0)
01st Jul 2007 12:21

Protected sheet?
Have you 'protected' the sheet after you hid the rows?

Thanks (0)
13th Jul 2007 12:29

Try this
Did you freeze panes after you hid the rows? Try Windows unfreeze panes.


Thanks (0)
13th Jul 2007 19:59

Use the F5 to go to a cell in the hidden area (eg A1) then Format, Row, Unhide

Thanks (0)