Reverse Ctrl + Open bracket?

[erniepoe]

Hi all,

Weird question, but i love the ctrl + open bracket trick to take you to where the formula is happening, but is there a way to get back to the original cell? It can get tedious to have to trudge through several sheets or rows, especially if you are working with large file.

Thanks so much!

 

[Scott Huish]

CTRL right bracket

 

[erniepoe]

CTRL right bracket

that doesn't work for me, sadly. just shows the cells that use the cell that ctrl+ open bracket brought me to. I'm on Excel 2013 if that makes a difference.

 

[Scott Huish]

Sorry, I don't know. I was just trying stuff in Excel 2010 and it worked for me.

I put this formula in K1
=A1+A3

I hit CTRL [ and it highlighted cells A1 and A3

I then hit CTRL ] and it took me back to K1

 

[erniepoe]

weird that it didnt work for me

But i appreciate the effort, Scott, thanks so much!

 

[Fluff]

Whilst Ctrl ] will highlight all the dependent cells, I don't think there is anyway to go back to the cell you started from.

 

[gadiyabhushan]

You can use F5 and enter to go to the original location again from where you pressed the Ctrl+[
Although there are a few limitations to this but it works mostly for me