PDA

View Full Version : Clearing and resetting CTRL+END



ukdane
08-17-2009, 10:52 AM
Excel 2003.

If I press CTRL+END, I am taken to the last "used" column and the last "used" row.

In one of my worksheets, this happens to be T65516.
T is correct I have some data in column T
However, 65516 is wrong, as the last cell containing any information is row 62.

For some reason, this is causing the file size of my document to increase vastly.

I've tried deleting and using clear contents to remove the rows (and cells from A63 to T65516) but I continue to be informed that the last used row is 65516.

Any ideas:
1) why?
2) how I remove the data in the rows, so that the last cell is T63?

I need to do this in order to reduce the file size, as it's currently way to big (just under 40Mb).

Thanks in advance.

Bob Phillips
08-17-2009, 11:25 AM
See http://www.contextures.com/xlfaqApp.html#Unused