Formula Errors

Why Excel Adds the @ Operator to Formulas and How to Fix It

Maira Mehtab Sep 20, 2026 869 views

Question details

Users notice that Excel automatically inserts the @ operator into certain formulas, preventing them from spilling dynamic arrays as originally intended.

Product: Microsoft Excel
Device & OS: not provided
Scenario: Opening a workbook containing dynamic-array formulas in older Excel versions or using formulas that naturally return an array.
Observed behavior: Excel automatically prefixes certain formulas or cell references with the @ symbol, forcing an implicit intersection instead of a dynamic array spill.

Before you start

Verify which version of Excel you are currently using, as dynamic array formulas behave differently in Excel 2019 and older compared to Microsoft 365.

Solution 1Recommended

Remove the @ Operator to Enable Array Spilling

Manually remove the implicit intersection operator (@) to allow dynamic arrays to spill across multiple cells.

The @ symbol acts as Excel's implicit intersection operator. It reduces an array or range to a single value. Excel automatically inserts it to preserve formula compatibility when a workbook is opened in older versions that do not support dynamic arrays.

Select the Formula Cell

Click on the cell containing the formula with the unexpected @ symbol.

Edit the Formula

Click into the formula bar at the top of the screen or press F2 to edit the cell directly.

Remove the @ Symbol

Delete the @ symbol from the formula references and press Enter. The formula should now spill the array results into adjacent cells as intended.

Version Compatibility: If you share this file with users on older versions of Excel, they may see the @ symbol reappear to ensure the formula continues to work as a single-value return on their end.

Solution 2

Upgrade to a Version Supporting Dynamic Arrays

Ensure you are opening the file in a spreadsheet application that natively supports dynamic arrays without forcing implicit intersection.

Free Microsoft Office alternative

Edit and Manage Array Formulas Seamlessly with WPS Office

If you frequently encounter formula compatibility or versioning issues in Microsoft Excel, consider using WPS Office. It provides a highly compatible, free alternative for standard and advanced spreadsheet formulas.

1. Download the Software: Visit the official WPS Office website and click 'Download WPS Office Free'.
2. Install and Launch: Run the installer and open the WPS Spreadsheet application.
3. Open Your Spreadsheet: Open your existing Excel workbook to edit your formulas with full compatibility and ease.

Fully compatible with Microsoft Excel (.xlsx) formats, ensuring your formulas and data remain intact.Free, lightweight, and features an intuitive interface similar to Microsoft Office.Seamlessly migrate your existing spreadsheets without losing data or dealing with complex formula downgrades.

microsoft office alternative - wps office

Frequently Asked Questions

What does the @ symbol mean in Excel formulas?

The @ symbol represents the implicit intersection operator. It restricts a formula that could return multiple values (an array) to return only a single value, ensuring compatibility with older spreadsheet behaviors.

Can I stop Excel from automatically adding the @ symbol?

You cannot entirely disable this feature in older versions of Excel. However, if you are using a modern version like Microsoft 365, you can manually remove the @ symbol, and it will not return unless the file is opened again in a legacy version.

Will removing the @ symbol break my formula?

If your current spreadsheet software supports dynamic arrays, removing the @ symbol will not break the formula. Instead, it will unlock the formula, allowing it to spill its results across multiple adjacent cells.

Why do some users see the @ symbol in my shared workbook while others don't?

This occurs when users are on different versions of Excel. Those on older versions (like Excel 2016 or 2019) will see the @ symbol because their software doesn't support dynamic arrays, whereas Microsoft 365 users will see the normal spilling array.

Excel & Data Problems