TheExcelAddict.com
Need to go to a particular cell in a hurry? Just press the F5 key
(the GoTo dialog appears), type in the cell address and hit
Enter. Then when you want to get back to the cell you just came
from, press F5 (notice that Excel remembers the last cell you
came from), and hit Enter.
Just try it. This is a trick you could use every day.
If you use Named Ranges, as I told you about a couple of weeks ago, you can quickly jump between sheets by pressing F5, entering
a Named Range and hitting Enter.
Microsoft Excel "Quick Tips"
Make Lightning-Quick Jumps with F5
share it with your friends and associates?
|
Get more time-saving tips just like this one delivered to you by email every week in my FREE newsletter "Spreadsheet Tips From An Excel Addict".
|