Help With CRTL+END

J

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
 
P

Patricia Shannon

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