Unable to unhide any Rows beyond Row 1022 in excel

[Guest]

I have a very large workbook and when I try to unhide the rows it does not
work. When I click on row 1022 with the mouse and scrowl down, the # of rows
it tells me is only 64516? What is happening? I'm hoping to make the
template smaller by making sure that there is no formula's and formatting in
the rows below a particular row. Once I do this to 15 worksheet in the
template I would like to again hide the "unneeded rows".

 

[Guest]

If the rows are truly hidden, go to the vary last row. Then put your mouse
pointer just below the last ROW NUMBER (in gray) untl you see the pointer
change to a doulble arrow pointing up and down. Right click and select
unhide from the menu. [It's a little tricky to get the arrows to stay while
clicking, so you don't accidently click row 64516. You may have to try a
couple of times.]

Hope this helps.