Excel shortcut to go back to previous cell (last position)

Question

There is a cool shortcut to go to a precedent cell: ctrl+[
This takes you to the source of your data in a cell that is linked from another worksheet for example.

I'm trying to find a shortcut that will take me back to the original cell that I was viewing. Doesn't seem to exist. Anyone?

Answer 1

You could make a macro to do this.

First you would want to create a macro that runs when "ctrl+[" is run that remembers your current worksheet and cell, and then runs the usual command that jumps you to the source (to find this out, try recording a macro when you push the ctrl+[ and see what command is used). Now that you're position is saved, you can create a second macro with hotkey of your choosing that will grab the saved worksheet and position and jump to that spot.

Answer 2

I think Ctrl + ] works, but only if you have the target cell still selected and it will select all dependants of that cell, not just the one you got there from.