Excel end of range question

Soldato
Joined
26 Feb 2004
Posts
4,800
Location
Hampshire, England.
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?
 
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
 
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...
 
Back
Top Bottom