Ensure Excel goes to last used cell upon startup
Everything else being equal, Excel should open very close to the last screen-view on that sheet
prior to final save unless an event macro is working behind the scenes or if you hit PageUp or
PageDown etc.
Plan B Do Alt-GAdvancedLastCellReturn
Eagleone
Stephen wrote:
I have a condition when starting Excel (2002), instead of going to the last
used cell (when I saved and shutdown Excel), the sheet goes a cell halfway up
(it's the same cell every time). As the sheet grows, this becomes a nuisance.
Does anyone have an idea how to force Excel to go to last entered cell? I
tried a suggestion sometime ago, which involved entering a line of code into
an active cell, but this has not worked. Any suggestions would be greatly
appreciated :) (Excel novice BTW)
Thanks in advance.
|