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.