How to Fix Excel Not Adding Plus Signs When Selecting Cells on Mac
Question details
The user wants to restore the behavior where Excel for Mac automatically inserts plus signs between cell references when creating a formula.
- Product
- Microsoft Excel
- Device & OS
- Mac
- Scenario
- Creating a formula by clicking multiple cells after typing an equals sign.
- Observed behavior
- Excel replaces the selected cell reference instead of inserting a plus sign between the selected cells.
Ensure your Excel for Mac is updated to at least version 16.37, as the required setting for this feature was introduced in this release.
Enable Click to Add Mode in Excel Preferences
Activating this preference restores the automatic insertion of mathematical operators when selecting multiple cells during formula creation.
In older versions of Excel for Mac, or if preferences were accidentally reset, clicking a new cell while building a formula might overwrite your previous selection. Enabling 'Click to Add Mode' forces Excel to insert a plus sign automatically.
Launch Excel on your Mac. In the Apple menu bar at the top of your screen, click on 'Excel' and select 'Preferences' from the dropdown menu.
In the Excel Preferences window, locate and click on the 'Edit' icon to view your editing options.
Find the checkbox labeled 'Click to Add Mode' and check it. Now, when you type an equals sign and click multiple cells, Excel will automatically add operators between them.
Try WPS Office for Seamless Formula Creation on Mac
If Excel for Mac's settings are causing trouble, WPS Office offers a free, lightweight, and highly compatible alternative. Its intuitive spreadsheet interface handles formula inputs effortlessly, fully supporting Microsoft Excel file formats.
- 1. Download WPS Office: Get the free WPS Office installer for Mac directly from the official website.
- 2. Open your Spreadsheet: Launch WPS Spreadsheet and open your existing Excel (.xlsx) files without losing any formatting or data.
- 3. Create Formulas Easily: Type an equals sign and select your cells to build formulas intuitively without worrying about hidden preference toggles.
Frequently Asked Questions
Why does Excel replace my cell reference instead of adding it?
This happens if the 'Click to Add Mode' is disabled in your Excel preferences. Without this setting, clicking a new cell simply overwrites the previously selected cell reference in your active formula.
Where do I find my Excel for Mac version?
Open Excel, go to the Apple menu bar at the top, and click 'Excel' > 'About Microsoft Excel'. A dialog box will appear displaying your current version number and license details.
Does holding Control or Shift help insert operators automatically?
No, holding modifier keys like Control or Shift usually changes your selection behavior (such as highlighting a range of cells) but does not automatically insert mathematical operators like plus signs.
