Excel end of range question

[slipd]

Hi guys,

I'm using quite a large spreadsheet that used to, the last time I used it, take me to the last used cell when I pressed Ctrl+End. I've just opened up the same sheet again (nothing's changed) but now when I hit Ctrl+End I get taken to 655xx... isn't there a feature in Excel to actually reset the range that's being used, resetting to the last cell that's being used?

Any ideas?

 

[izzop]

Hi,

Do you mean the last cell used regardless of where it is on the sheet, as I've never heard of this?

Or a you refering to the last cell in a column (Shift - End - Down)?

Regards

 

[slipd]

Yeah, that's what used to work but suddenly it stopped? I found a MS add-on on the Office site that sorted me out - it clears the contents of cells and 'resets' a few other things. I didn't take much notice of the specifics if I'm honest but it worked

Trouble is, its changed a 6mb file into a 90 file? Not sure what could have happened there...