Vertical Scroll Includes Empty Cells

[Diana]

On one of my Excel spreadsheets, all of the empty cells
are being included in the vertical scroll (which
increases the document size immensely, making opening,
closing and saving an extremely tedious process).

How can I change the view so that only the cells
containing information was included in the vertical
scroll?

 

[Andy B]

Hi

You need to reset your used range. Have a look here for info:
http://www.contextures.com/xlfaqApp.html#Unused