last cell query

IrvineP

New Member
Joined
Jan 19, 2003
Messages
16
I have quite a large spreadsheet - This morning it was about 6,000 KB

I've deleted a few lines here and there and have ended up with the file being 10,000 KB (I honestly was expecting it to get smaller)

Anyway I've noticed that on a number of sheets when I goto last cell its taking me to the IV65536 cell, I'm pretty sure that this wasn't the case this morning.

Does anyone know if this will effect the file size, and also how to change the last-cell where-abouts to something that is a little more correct probably around AM6000??

Cheers

Pete
 

Some videos you may like

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.

texasalynn

Well-known Member
Joined
May 19, 2002
Messages
8,458
Yes if the last cell is IV65536 it will increase the file size. Most times this is because either all cells have been given a format. Or if data was placed in the last cell and not deleted correctly. Also whenever you go in and delete rows/columns be sure to save so that the last cell gets reset by Excel.

texasalynn
 

IrvineP

New Member
Joined
Jan 19, 2003
Messages
16
Cheers texas,

Worked a treat. Didn't realise you had to save the workbook on that particular worksheet to re-build last cell.

Anyway the file's down to 4,500 KB's now

Again thanks very much. :biggrin:
 

Watch MrExcel Video

Forum statistics

Threads
1,122,469
Messages
5,596,329
Members
414,055
Latest member
mcarduner

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top