Reverse Ctrl + Open bracket?

erniepoe

Active Member
Joined
Oct 23, 2006
Messages
328
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!
 

Some videos you may like

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.

Scott Huish

MrExcel MVP
Joined
Mar 17, 2004
Messages
19,952
Office Version
365, 2010
Platform
Windows
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

Active Member
Joined
Oct 23, 2006
Messages
328
weird that it didnt work for me :(

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

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
40,675
Office Version
365
Platform
Windows
Whilst Ctrl ] will highlight all the dependent cells, I don't think there is anyway to go back to the cell you started from.
 

Watch MrExcel Video

Forum statistics

Threads
1,099,082
Messages
5,466,531
Members
406,484
Latest member
kaksolver

This Week's Hot Topics

Top