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

L

LisaH

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?
 
B

britwiz

LisaH said:
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
 
V

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
 
B

britwiz

LisaH said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top