How to use cells as worksheet names in excel?

Select a cell or range of cells, enter a name in the address bar in the upper left corner, and then press Enter to end the entry. The naming is complete. Of course, naming can also be done through the name manager.

Second, the purpose of naming

1. You can directly replace this area with a name in the formula. Such as =vlookup("S 1 ",salary level, 2,0)

2. Overcome the limitation that conditional format and data validity cannot refer to data in different tables.

3. After defining the name, you can see the defined name in the address bar. At this time, no matter in any worksheet in this workbook, you only need to select Salary Level in the address bar, and you can immediately jump to the worksheet where the Salary Level area is located and select this area.