Name that ranges in Microsoft excel

 

Name that range!

1. Select all the cells in the range that you intend to name. You can use any of the cell selection techniques that you prefer. When selecting the cells for the named range, be sure to include all the cells that you want selected each time you select its range name.

 2. Click the Name box on the Formula bar. Excel automatically highlights the address of the active cell in the selected range.

3. Type the range name in the Name box and then press Enter. As soon as you start typing, Excel replaces the address of the active cell with the range name that you’re assigning. As soon as you press the Enter key, the name appears in the Name box instead of the cell address of the active cell in the range.