Excel 2007: remove extra rows

LCMSdev
LCMSdev used Ask the Experts™
on
I have an Excel 2007 spreadsheet with roughly 300 rows. For whatever reason, Excel has decided that this document has many thousands of rows of meaningful data, rendering the vertical scrollbar useless as scrolling a single pixel takes me to row 41263.

"Remove" probably isn't quite the word for what I want to do, but I don't want Excel to recognize these empty rows for purposes of scrolling. I tried selecting the empty rows and deleting them, with no effect. Copying the data into a new spreadsheet isn't an option either; this sheet has a large number of very finicky formatting and tweaks that don't copy over even when "Keep source formatting" is selected.

Is there a way I can force Excel to re-evaluate the size of my document? Any advice is appreciated.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Try highlighting the first row without data and pressing Ctl+Shift+Down Arrow, then right click mouse and DELETE.
Highlight the first column without data and press Ctl+Shift+Right Arrow, right click mouse, DELETE.
Now, save your workbook. Close the workbook.  Open the workbook and see if that fixed the scroll area.
 

Author

Commented:
Thanks for the suggestion, but this was the first thing I tried. No luck :(
Any chance there's an object on the sheet?  
Press F5, special, objects.
Similarly, F5, special, last cell might help.

Author

Commented:
This got it. Sorry for taking so long to accept; forgot to close the question out when I got finished.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial