Lesson 14


Customizing a Table – Edit Names Using Name Manager; Practice Exercise 13

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


Back to: Intermediate Excel 2016 > Module 2 – Intermediate Excel 2016

Leave a Reply