How to jump to end of text only?

[Joe Bloggs]

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]

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

 

[Joe Bloggs]

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.

 

[RagDyeR]

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!
=====================================================

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.