Problem: You have a multi-tab spreadsheet, and it is taking you too long to get from one sheet to another.
Let’s say you are in cell B27 on the Assumptions tab, which reports the Investor IRR as of the last month in the model, and that this value flows into B27 from cell BH185 in the Waterfall tab (the last tab in your spreadsheet). Thus, the formula in Assumptions cell B27 reads =’Waterfall’!BH185.
If you want to go to that cell, one option is to write down the cell coordinates and the tab and then click over to the tab and navigate down to the cell with your mouse or the arrow keys. That is so 1985, though.
REFM 60-Second Skills Solution: While in Assumptions B27, simply hold down the Ctrl key and, while keeping it held down, hit the [ key (the key to the right of the letter P).
You’ve now been transported to that exact cell on the Waterfall tab.
That’s a great tip, Bruce. I love the 60-second Excel tips, these shortcuts save time and aggravation. Keep them coming!
Great tip, thanks!
After checking out the cell by using Ctrl + Bracket, is there a quick way to go back to the cell you were just in (Assumptions cell B27)?
If you’re using it to jump around within the same sheet, Ctrl + [ (open bracket) will jump you to the referenced cell and Ctrl + ] (closed bracket) will take you back.
When jumping between multiple sheets, the closed bracket won’t take you back.
Doesn’t seem to work on a Mac…