Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question

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.

share|improve this answer

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.

share|improve this answer
Good tip! However, this only appears to work as long as the dependent cell is on the same worksheet. – Andi Mohr Jan 16 '14 at 10:16

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.

share|improve this answer

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.

share|improve this answer

You must log in to answer this question.

protected by Community Jan 11 at 12:38

Thank you for your interest in this question. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).

Would you like to answer one of these unanswered questions instead?

Not the answer you're looking for? Browse other questions tagged .