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.