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

Either of the following sets of keystrokes will take you back to the original cell:

• F5, Enter
• Ctrl+G, Enter

F5 and Ctrl+G are shortcuts to bring up the "Go To" dialogue box. The dialogue box will be pre-populated with the address of the original cell, and you can press Enter to go there.

Answer 2

Press F5

In the new window, click Special.

From here, click on Last Cell and then press enter.

Or, if you want keyboard then it's F5 ALT+ S and then another S and then Enter

The above could easily be assigned to a keyboard mapping tool like AUTOHOTKEY so it would be a single instruction.

Answer 3

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.

Answer 4

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.