How to make the Professional Symbols toolbar in Excel tables

Source: Internet
Author: User

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.

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.