CTRL+SHIFT+END extends selection of cells to last - how reset?
Already tried that!
" wrote:
LisaH wrote:
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
|