You can see that B5 (the last cell I was in) is already populated as the destination. And in this case, Excel guessed right, thus saving you the hassle of typing in your destination again.īelow is the pop-up I get after I go from B5 to C200 using Ctrl+G. Why? Because once you hit Ctrl+G again, it automatically assumes you want to go back to the last cell you were in. Kind of slow.īut the good news is that Ctrl+G is arguably the fastest way to get back.
Hit Ctrl+G (or F5), and then type C200 (and then Enter) to go to C200. What’s a fast way to get to C200 and then back to B5?
You forget what’s in C200, what the formula is there, but you need to know. Let’s say you have a simple formula in B5.