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).
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.
END OF LESSON
Leave a Reply