CTRL+SHIFT+END extends selection of cells to last - how reset?

[Guest]

I have been working on spreadheets with large amounts of data, that I have
manipulated and some of which I have deleted, when I want to select it all,
and press CTRL+SHIFT+END is goes row 14000 where the data originally ended
instead of 6000 where it ends now.
I wondered if there was anyway to reset what excel considers the last used
cell to be?

 

[britwiz]

I have been working on spreadheets with large amounts of data, that I have
manipulated and some of which I have deleted, when I want to select it all,
and press CTRL+SHIFT+END is goes row 14000 where the data originally ended
instead of 6000 where it ends now.
I wondered if there was anyway to reset what excel considers the last used
cell to be?

Hi LisaH

Save the workbook, the used range will be re-calculated.

Regards

Steve

 

[VBA Noob]

Select blanks cells. Go to Edit Clear all. Save workbook and should
clear area.

or select cells press F5. select blanks and then Edit clear all.

VBA Noob

 

[Guest]

Already tried that!

Hi LisaH

Save the workbook, the used range will be re-calculated.

Regards

Steve

 

[Guest]

That didn't work either, thanks anyway.

 

[britwiz]

Already tried that!

Then I suspect that you haven't actually got rid of all your data
and/or formatting, see VBANoob's suggestion.

Regards

Steve

 

[britwiz]

That didn't work either, thanks anyway.

Copy only your used range into a new sheet and delete the original.

Regards

Steve

 

[Guest]

I have tried that now, and it still isn't working. Thanks

 

[VBA Noob]

You might have to close excel down but does work

VBA Noob

 

[Dave Peterson]

Debra Dalgleish shows techniques to reset that last used cell:
http://contextures.com/xlfaqApp.html#Unused