How Can Ctrl+[ and Ctrl+G Save Me Time?
Let’s say you have a simple formula in B5. The formula is C200*5. You forget what’s in C200, what the formula is there, but you need to know.
What’s a fast way to get to C200 and then back to B5?
Method 1 (very slow):
Scroll to C200 and then scroll back. Fugedaboutit. Too damned slow.
Method 2 (faster, but not the fastest):
Hit Ctrl+G (or F5), and then type C200 (and then Enter) to go to C200. Kind of slow. [Read more…]