Here's our Microsoft Office Tip for.. September 10, 2001
Click Here to see a complete list of all of our previously released Tips!
Quickly Assigning a Name
Naming ranges is a powerful feature. To name a range, you select the range and choose Insert, Name. Or you can take a shortcut by using the Name control on the Formula bar. Select the range you want to name and click the Name control (all the way to the left on the Formula bar) to highlight the current entry. Type in the Name control the name you want to give the range of cells you just selected.

This process of assigning a name to a range is much quicker and easier than going through the menus.