How to jump to end of text only?

Tricky question to ask this one!

I have a shhet with data in it, I press CTRL+END and it goes to empty cells
way down the bottom of the sheet (there was text in these cells once but not
any more).

When I press CTRL+END I want it to go to the last cell with text it it and
not further. Is there a way of totally clearing empty cells?

Thanks

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

Joe Bloggs wrote:
>
> Tricky question to ask this one!
>
> I have a shhet with data in it, I press CTRL+END and it goes to empty cells
> way down the bottom of the sheet (there was text in these cells once but not
> any more).
>
> When I press CTRL+END I want it to go to the last cell with text it it and
> not further. Is there a way of totally clearing empty cells?
>
> Thanks

--

Dave Peterson

Thanks for the reply, would not work for me.

I have copied the cells into new sheet and got what I wanted that way.

Thanks for help.



"Dave Peterson" <[email protected]> wrote in message
news:[email protected]...
> Debra Dalgleish shows techniques to reset that last used cell:
> http://contextures.com/xlfaqApp.html#Unused
>
> Joe Bloggs wrote:
>>
>> Tricky question to ask this one!
>>
>> I have a shhet with data in it, I press CTRL+END and it goes to empty
>> cells
>> way down the bottom of the sheet (there was text in these cells once but
>> not
>> any more).
>>
>> When I press CTRL+END I want it to go to the last cell with text it it
>> and
>> not further. Is there a way of totally clearing empty cells?
>>
>> Thanks
>
> --
>
> Dave Peterson

Might this help:
You can go to the last cell of *contiguous* data by hovering the cursor over
the bottom border of a cell until it changes to an arrow, and then *double*
click!
?
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

"Joe Bloggs" <[email protected]> wrote in message
news:[email protected]...
Thanks for the reply, would not work for me.

I have copied the cells into new sheet and got what I wanted that way.

Thanks for help.



"Dave Peterson" <[email protected]> wrote in message
news:[email protected]...
> Debra Dalgleish shows techniques to reset that last used cell:
> http://contextures.com/xlfaqApp.html#Unused
>
> Joe Bloggs wrote:
>>
>> Tricky question to ask this one!
>>
>> I have a shhet with data in it, I press CTRL+END and it goes to empty
>> cells
>> way down the bottom of the sheet (there was text in these cells once but
>> not
>> any more).
>>
>> When I press CTRL+END I want it to go to the last cell with text it it
>> and
>> not further. Is there a way of totally clearing empty cells?
>>
>> Thanks
>
> --
>
> Dave Peterson