Thanks for the suggestion! If the formula is incomplete, hitting enter causes excel to issue an error message.
I'm looking for a specific keyboard shortcut. For example, let's say the goal is to sum a 1000 row column of numbers and place the sum result at the top of the column. Typing "=sum(" then using the arrow keys to highlight the first cell, then pressing ctrl-shift down-arrow selects the entire column moves the view such that the cell with the formula in is off the screen and not visible, but then typing ")" and pressing enter brings the view back to the cell with the sum formula in it.
Now let's say an if-function is used with a 1000 row column as an input. After selecting the column via ctrl-shift down-arrow, then typing a "," the view does not go back to the cell with the if-function in it. Pressing ctrl-backspace brings the view back to the cell with the formula in it. Ctrl-backspace brings the view back to the cell with the formula as long as the formula variable are located within the same sheet.
Ctrl-backspace doesn't bring the view back to the cell with the formula in it when writing a formula on one sheet that requires cell-references from other sheets. In other words, starting the formula in a cell, navigating to another sheet and selecting a cell, ctrl-backspace doesn't bring the view back to the cell with the formula in it.
I'm looking for a keyboard shortcut that brings the view back to the cell with the formula after entering a cell-reference on a different sheet. Hope that makes sense.