My beloved old Excel 2003 decided to go weird yesterday. Somehow all rows 1 thru 51 in a particular spreadsheet got hidden (not by me - must have been an alien flyby), and the usual method of unhiding them don’t seem to work. I can select and drag the cursor over the area, and it won’t bring up the usual options of “hide” and “unhide”. As this method is the only way I know of unhiding something, this has got me somewhat stymied.
Columns A and B also got hidden, but I can unhide those OK.
CTRL+9 Hides the selected Rows.
CTRL+0 Hides the selected Columns.
CTRL+SHIFT+9 Unhides the hidden rows within the selection.
CTRL+SHIFT+0 Unhides the hidden columns within the selection.
To JeffB: There are no “before” rows. The first numbered row shown is 51. I tried your suggestion by selecting from the very top (where the Column designations are), to no avail.
To bob++: Nothing happens when I use the CTRL etc approach.
Thanks for your efforts, but no luck so far.
I’m beginning to think that the problem is EVIL SPIRITS. Any priests available for an exorcism?
Did you try selecting the entire worksheet (clicking the corner above the first row and to the left of first column) and then unhiding and/or set row height?
BLUNT is the winner - “Unfreeze Panes” did the trick!!! Never had tried that one before. Now I just have to find out how they got frozen in the first place. Probably due to my habit of seeing how fast I can type in commands (called the “flying fingers syndrome”).