TheExcelAddict.com
Microsoft Excel "Quick Tips"

Make Lightning-Quick Jumps with F5

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.



Why not print (CTRL+P) this tip and
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".
Subscribe at the TheExcelAddict.com/Newsletter.htm and you could win a really cool t-shirt.
You'll be amazed how much time you'll save just by learning a few of these tips.
Copyright 2002 All Rights Reserved by FJH Marketing

Close this window