How does Excel define a name for a cell?

How do you want to define a cell name for a range in an Excel table? Some friends may never think of this problem, then come together to learn how to operate it! The following is an action tutorial.

Excel tutorial Excel How to define a name for a cell

First, the method of naming.

Select a cell or range of cells, enter a name in the upper-left address bar, and press ENTER to end the entry. Name complete. Of course, you can also use the name manager to complete the naming.

Second, the use of the name

1, in the formula can be used directly to replace the area. Such as

=vlookup ("S1", wage scale, 2,0)

2, to overcome the conditional format, data validation can not be different table reference data restrictions.

3, the definition of the name can be seen in the address bar to see the name of the definition, then, whether in the workbook in any one of the worksheets, you only need to select "wage" in the address bar, you can immediately jump to the "pay scale" area of the worksheet and select the area.

When you need to delete a name, the formula-name Manager-Deletes the name.