View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
GS[_6_] GS[_6_] is offline
external usenet poster
 
Posts: 1,182
Default Clean/delete all cells outside of a range

After I deleted the rows and columns in the original spreadsheet, I saved the
file.

I then opened that file again.

Then I used the "Go to Special" and clicked "Last Cell" and the cursor went
to a cell outside of the range.


Ok, this has been the process I've been using since Excel5.0 and it hasn't been
replaced yet with some other process! I use Ctrl+End (keyboard equivalent to
'Go to Special:Last Cell') It works as I'm describing it EVERY TIME! Go ahead
and try it; -duplicate the scenario and see what happens...

Not saying the behavior you got is not possible since Excel (MS Office in
general) has had a tendancy to 'misbehave' more than ever with the newer
releases. Just try the exercise for your own benefit so you can see *how it
should behave* normally.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion