Assume that I create a worksheet that goes to, for example, cell F500. Okay,
now do "File/Save As" to rename & save it. I then delete Rows 101-500.
Now, if I select Ctrl + End in the new worksheet, it will go to F500 €“ even
though the new worksheet ends at F100 (remember: I deleted rows 101-500).
Some questions:
1) What is this feature called that causes Excel to remember the last cell
(seems like the "last cell that was ever used")?
2) How do you control that feature?
3) In the above example, how can I configure the new worksheet so that Excel
recognizes F100 as the last cell (rather than F500)?
THANKS!