Help With CRTL+END

[Jim Mac Millan]

Hello,

Whenever I delete some rows or columns at the end of a sheet CTRL+END
takes me to where the old data was. Instead I want it to take me to the end
of any visible data. The only way I have found to get around this is to
paste the visible data into a new sheet. The CTRL+END will then stop at the
end of the visible data.

Is there any way to eliminate this added step?

TIA
Jim Mac Millan

 

[Jim Mac Millan]

Ooops. I meant to type CTRL

 

[Dave Peterson]

Sometimes saving and reopening will fix it.

You may want to skim Debra Dalgleish's instructions:
http://contextures.com/xlfaqApp.html#Unused

 

[Guest]

I was having this problem. Several things I tried worked some of the time,
but not consistently. I finally found that if you do a "Save-as", to w/o
changing the name of the file, just "Save-as" the file to itself, it fixes
the problem!