Office Settings & Configuration

Add Mathematical Operators to the Excel for Mac Quick Access Toolbar

Phi Hung VoPhi Hung Vo Nov 14, 2026 868 views

Question details

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

Add Mathematical Operators to the Excel for Mac Quick Access Toolbar
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.
Before you start

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.

Solution 1Recommended

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.

1
Open the Visual Basic Editor

In Excel, open the Developer tab and select Visual Basic. If Developer is hidden, enable it under Excel > Preferences > Ribbon & Toolbar.

2
Create the macro

In the Visual Basic Editor, select your workbook, choose Insert > Module, and paste: Sub InsertEquals() With ActiveCell .NumberFormat = "@" .Value2 = "=" End With End Sub

3
Save the workbook

Choose File > Save As and select Excel Macro-Enabled Workbook (.xlsm). Allow macros for the workbook if prompted and you trust its contents.

4
Add the macro to the toolbar

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.

5
Insert the symbol

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 "-".

Create a macro to insert an operator
Toolbar availability varies: If macros cannot be selected in your version's Quick Access Toolbar settings, use the Macros dialog on the Developer tab or enter the symbols directly instead. The workbook containing the macro must be open to use it.
Free Microsoft Office alternative

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.

Enter mathematical operators and formulas in spreadsheet cellsOpen and edit Microsoft Excel formats, including .xlsxUse a familiar interface for an easier transition from Microsoft OfficeWork with a free, lightweight office suite
microsoft office alternative - wps office

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.