Tuesday, May 26, 2009

F3: The Magic Key

Well, “Magic Key” might overstating it a bit, but you work with Named Ranges and a lot of Formulas, the F3 key can save you a great deal of work. Here is what it can do for you:

Let’s say that you have named several ranges (an Excel Enthusiasts best practice) in your workbook. When creating a formula, (in this example, we will find the average of a field named, “Sales”), do the following:

1. Type “ =Average( "
2. The hit the F3 key and
3. Choose your Named Range from the dropdown
4. Note that you can use your Down Arrow on your keyboard to select

This shortcut will save you little bits of time that will add up to many hours of work. (Wow! “Magic” …)

No comments: