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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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?
Click to expand...

Hi LisaH

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

Regards

Steve
 
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
 

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

Similar Threads

Select range of cells from A1 to last cell with data? 8
Changing position of last used cell 4
Error message "cannot shift nonblank cells off the worksheet" 2
Shift-Ctrl-DownArrow 2
Excel-how do I reset the cell to which I go with a Control End? 1
How do you reset the position that pressing CTRL-END moves you to? 2
Ctrl shift end 2
Re-setting lat row or end of data 1

Back
Top