How to make the Professional Symbols toolbar in Excel tables

1, the implementation of "tools → macros → record new macros" command, open the Record New Macro dialog box, enter the macro name? such as "Fuhao1"? and save the macro in the Personal Macro Workbook, and then OK to start recording. Select the Relative Reference button on the Record Macro toolbar, and then enter the special symbol you want into a cell, and then click the Stop button on the Record Macro toolbar to complete the recording of the macro.

Follow the above operation, recording the other special symbols of the input "macro".

2, open the Customize dialog box, in the Toolbars tab, click the New button, pop-up the new Toolbar dialog box, enter the name-"professional symbol", after the confirmation, that is, a toolbar in the workspace.

Switch to the Commands tab, select Macros under Categories, and then drag the custom button item under commands to the professional symbols bar (how many buttons to drag with the number of special symbols).

3, select one of the "custom button", modeled after the 2nd secret secret of the 1th to name them.

4, right click on a named button, in the following pop-up shortcut menu, select the "Specify Macros" option, open the "Specify Macros" dialog box, select the appropriate macros (such as FUHAO1, etc.), to determine the exit.

Repeat this action to link the button to the corresponding macro.

5. Close the Customize dialog box, and then use the Professional Symbols toolbar to quickly enter professional symbols in a cell, just as you would with a normal toolbar.