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

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?

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

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

Already tried that!

"[email protected]" 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
>
>

That didn't work either, thanks anyway.

"VBA Noob" wrote:

>
> 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
>
>
> --
> VBA Noob
> ------------------------------------------------------------------------
> VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
> View this thread: http://www.excelforum.com/showthread...hreadid=565913
>
>

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

LisaH wrote:
> That didn't work either, thanks anyway.
>
Copy only your used range into a new sheet and delete the original.

Regards

Steve

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

"[email protected]" wrote:

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

You might have to close excel down but does work

VBA Noob

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

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?

--

Dave Peterson