Add Mathematical Operators to the Excel for Mac Quick Access Toolbar
Question details
Add mathematical operators such as equals, plus, and minus to the Quick Access Toolbar in Excel for Mac.

- Product
- Microsoft Excel for Mac
- Device & OS
- macOS
- Scenario
- The user wants quick access to mathematical symbols while working in a spreadsheet.
- Observed behavior
- Individual mathematical symbols are not built-in commands in the Quick Access Toolbar customization list.
Open Excel and check which commands your version offers under Excel > Preferences > Ribbon & Toolbar > Quick Access Toolbar. If you plan to use a macro, make sure your workbook can be saved in the macro-enabled .xlsm format.
Create a macro to insert an operator
Use a macro as a toolbar shortcut if your Excel version allows macros to be added to the Quick Access Toolbar.
The example inserts an equals sign as text into the active cell. It replaces the cell's existing value and changes its number format to Text; it does not insert a character into a formula currently being edited.
In Excel, open the Developer tab and select Visual Basic. If Developer is hidden, enable it under Excel > Preferences > Ribbon & Toolbar.
In the Visual Basic Editor, select your workbook, choose Insert > Module, and paste: Sub InsertEquals() With ActiveCell .NumberFormat = "@" .Value2 = "=" End With End Sub
Choose File > Save As and select Excel Macro-Enabled Workbook (.xlsm). Allow macros for the workbook if prompted and you trust its contents.
Open Excel > Preferences > Ribbon & Toolbar > Quick Access Toolbar. If your version lists Macros under the available commands, select InsertEquals, add it to the toolbar, and save the changes.
Select an empty cell and click the new toolbar button. To make separate plus or minus shortcuts, create additional macros with distinct names and replace "=" in each macro with "+" or "-".

Check the available Quick Access Toolbar commands
Use this option to see whether your Excel version offers a suitable built-in command.
Enter operators directly in a cell
Use the keyboard when you need a symbol without creating a toolbar shortcut.
Work with spreadsheet operators in WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for editing spreadsheets. Open compatible Excel files and enter operators or formulas as you move your work to WPS Spreadsheets.

Frequently Asked Questions
Can I add an equals sign directly to the Excel for Mac Quick Access Toolbar?
An equals sign is not normally available as an individual toolbar command. Check Excel > Preferences > Ribbon & Toolbar > Quick Access Toolbar; if your version supports adding macros there, you can add a macro that inserts the sign.
How do I display an equals sign without starting a formula?
Select a cell, type an apostrophe followed by an equals sign, and press Return. Excel displays the equals sign as text.
Why is my macro missing from the toolbar command list?
Make sure the workbook containing the macro is open and saved as an .xlsm file. Check the Macros category in Quick Access Toolbar settings if it is available; some Excel versions may not support adding macros there.
Can the sample macro insert a symbol into a formula I am editing?
No. The sample macro writes a literal symbol to the active cell, replacing its contents. To build a formula, type the operator directly in the cell or formula bar.




