Whenever you save an Excel file, it will re-determinethe the "last" cell
used. Excel will continually expand your range of used cells as you add more
data, but will not retract that range if data is deleted, until the file is
saved.

HTH,
Elkar


"Wade" wrote:

How can I reset the size of a spreadsheet?

If if hit 'end' 'home' it goes to g1000.

The data I need is a1 to g700.

thanks