Reset Worksheet Size

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Wade - 16 Jun 2006 19:16 GMT

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

Reply to this Message

tim m - 16 Jun 2006 19:27 GMT

What is after G700, just blanks? If your meangingful data ends at G700 and
there is nothing after that you could delete all the rows between G700 and
G1001, this should get rid of cells with blank spaces in them and then the
end of your sheet should be at G700.

> How can I reset the size of a spreadsheet?
>
[quoted text clipped - 3 lines]
>
> thanks

Reply to this Message

Elkar - 16 Jun 2006 19:37 GMT

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

> How can I reset the size of a spreadsheet?
>
[quoted text clipped - 3 lines]
>
> thanks

Reply to this Message