How to get to lower right corner

[nsv]

If you press END followed by HOME you should have the cursor moved t
the lowest row and the rightmost column of the spreadsheet, but it doe
not work properly. You end in the lowest row and rightmost column tha
until now HAS BEEN in use. If you have had data in row 6734 and othe
data in column DT, then END followed by HOME takes you to DT6734 eve
though you already have erased everything but a small block from A12 t
F35.

The counter is reset only when not used rows and columns are delete
with "delete entire row" and "delte entire column" (CTRL + the minu
sign in the numerical keyboard) and even then you also have to save th
sheet. That can hardly be the idea of having a function that should b
able to take you to the current limits of your sheet.

Is there another function than END HOME that can show you the actua
limits of your current sheet?

Need I say, that Lotus123 had this feature working perfectly more tha
10 years ago? I wonder sometimes if Microsoft read these pages. The
ought to, but they probably don't care

NS

 

[Max]

"nsv"

... Is there another function than END HOME that can show you t
he actual limits of your current sheet?

Just some thoughts. I use CTRL+End to get to the "lower right corner". And
if I clear previously used bottom rows / cols to the right, I just need to
save the book, and CTRL+End would then work again to get to the new "lower
right corner".

 

[Dave Peterson]

You could try resetting that used range by using techniques at Debra Dalgleish's
site:
http://www.contextures.com/xlfaqApp.html#Unused