Welcome to Lesson 2 of the Basic Microsoft Excel Tutorial. In this lesson we will cover Names. I hope you enjoy the lesson.

Names

Step 1: Select Data to Name

Enter some data on your worksheet. Then select the cell that you want to name.

Step 2: New Workbook

Select Insert, then Name, then Define. In the Define Name dialog box enter in the name that you want to use. At the bottom of the dialog box you will see the cell that is being referred to by this name.

Step 3: The Toolbar and Menu

You can now use this name in formulas, or anywhere else where you would refer to the named cell.