2.6 Customizing a Table – Edit Names Using Name Manager – Practice Exercise 13 – Intermediate Excel 2016

Practice Exercise 13: Learn how to edit names using the Name Manager
STEP 1: To change the name of the recently created name PREVIOUS_QTR_SALES, select the Formula tab.

STEP 2: Select Name Manger from the Defined Names section of the ribbon.

STEP 3: On the Name Manger dialog box, select the Edit button (FIGURE 1). 

FIGURE 1
STEP 4: ​In the Edit Name dialog box, in the Name window, change the name to QTR_SALES_2015. Select OK button (FIGURE 2).

Tip: If you wish to enter any amplifying information about what the name does, enter it in the Comments window. This is often a good idea since it will help you remember what the name does.

                                  FIGURE 2
This is the end of this section. To continue, go to Module 2 Section 2.7 Customizing a Table – Using the Name Manager; Practice Exercise 14