Shortcut keys, functions, and data validation for Excel names

Shortcut keys, functions, and data validation for Excel names

1, the definition of the name directly using CTRL+F3, so you do not have to go to the menu to look for. Insert, name, definition. Sick of it.

2, paste the name of all, direct use of F3, we do not need to use the insertion, name, paste.

3, the batch definition name, direct use CTRL+SHIFT+F3 directly to the batch name definition, to the computer work we save not only time.

4, the use of the name box, what is the use of the name box?

One is checked, the other is jump. For example, where you fill in the A500,excel will select the A500 cell, and the carriage will jump to that cell.

Second, he also has special cell definitions, such as the subject of special love for small knitting. Economic law and tax Law 2, small weave then select these two cells, and in the Name box enter special Love carriage return, from then on, the name box under the small series will show the name of the special love.