CTRL+SHIFT+END

[RichardG]

Greetings All,

When a sheet has been cleared of all of its text, using the
keystrokes, CTRL+SHIFT+END, still performs the action of extending to
the last used cell. How does one reset this action and thereby no
action is performed in trying to go to the last so-called used cell?

Many thanks.

RichardG

 

[Jan Kronsell]

You can Delete all formely used rows and then save thespread sheet. That'll
do the trick.

Jan

 

[Paul B]

Richard, have a look here also

http://www.mvps.org/dmcritchie/excel/lastcell.htm

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 2003
** remove news from my email address to reply by email **

 

[RichardG]

Thanks for the responses.
I tried both and they worked fine. The website also had alot of other
nice ideas that I did not think of having.

Regards,

RichardG