Hi all, I was looking for an explanation to understand Excel's behaviour of the active cell of any given sheet.
E.g.:
- When I switch to any sheet the active cell is wherever I was last time when I left the sheet; that cell name/position is also indiciated in the Name Box
- However, when I start to enter a formula and want to pull an argument from a different sheet - using the keyboard - this seems to work differently:
1. As soon as I start typing an equal-sign the Name Box gets populated with "SUM".
2. If I open the brackets of the formula to enter its arguments and then change the sheet and start moving around with the arrow keys, the starting cell seems to be always A1; unless the sheet has its panes frozen in which case the active cell is the top left corner of the frozen panes (similar to pressing Ctrl+Home with/without panes frozen).
So I'm trying to understand whether this is always the case/why this is or if the behaviour can be changed in any way; e.g. that the starting point for any cell to be used as the formula argument, is the cell where I left the sheet last time.
I hope it's clear what I am trying to get at.
Thanks and Regards
Bookmarks