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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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