Function Problems

What Do Brackets and the @ Symbol Mean in Excel Formulas?

Natalie Taylor Oct 21, 2026 869 views

Question details

The user wants to understand the meaning and usage of brackets and the @ symbol in Excel formulas, commonly found in Microsoft templates.

What Do Brackets and the @ Symbol Mean in Excel References?

Product: Excel
Device & OS: not provided
Scenario: Analyzing formulas in downloaded Excel templates or working with formatted Excel tables.
Observed behavior: The formulas contain brackets and the @ symbol, which function differently than standard named ranges and cause formula errors if typed manually in standard cells.

Before you start

Familiarize yourself with basic Excel formulas and ensure your data is formatted as an Excel Table (Insert > Table), as structured references only apply to Tables.

Solution 1Recommended

Understand Structured References in Excel Tables

Learn how the @ symbol and brackets operate within Excel Table formulas to reference columns and rows efficiently.

Brackets and the @ symbol are part of 'structured references' used exclusively for Excel Tables. They are not standard named ranges.

The brackets enclose the name of a table column. The @ symbol specifically refers to the data in the current row of that specified column.

Identify the Excel Table

Select any cell in your data range and check the ribbon for the 'Table Design' tab. Here you can see the table's name (e.g., CheckRegister) on the far left.

Read the Column Reference

Look for brackets in the formula, such as [WITHDRAWAL]. This tells Excel to look at the entire 'WITHDRAWAL' column within the table.

Understand the @ Symbol

When you see an @ symbol, like [@WITHDRAWAL], it instructs Excel to fetch the value from the 'WITHDRAWAL' column on the exact same row where the formula is located.

Reference Outside the Table

If you use this formula in a cell outside of the table, the formula will automatically include the table name for context, looking like CheckRegister[@WITHDRAWAL].

Understand Structured References in Excel Tables

Compatibility Note: If you try to manually type brackets or the @ symbol into formulas using standard cell ranges (without formatting them as a Table first), Excel will return a syntax error.

Solution 2

Convert Tables to Standard Ranges

If structured references are confusing, you can convert the table back to a normal range, which automatically reverts the formulas to standard cell coordinates.

Spreadsheet Solutions

Master Excel Tables and Formulas with WPS Spreadsheet

WPS Spreadsheet fully supports Excel tables and structured references, allowing you to seamlessly open, edit, and understand complex Microsoft templates featuring brackets and @ symbols.

1. Open your Template: Launch WPS Spreadsheet and open your existing Excel template (.xlsx).
2. Format Data as Table: Select your data range, navigate to the 'Home' tab on the ribbon, and click 'Format as Table'.
3. Use Structured Formulas: Type '=' in a cell and click on any table column header to automatically generate precise references with brackets and @ symbols.

Fully compatible with Microsoft Excel formulas and Table formats.Intuitive Table Design tools to manage structured references effortlessly.Free, lightweight, and user-friendly alternative for your daily spreadsheet tasks.

microsoft office alternative - wps office

Frequently Asked Questions

Can I use the @ symbol in normal Excel ranges?

No, the @ symbol in this context is specific to structured references within formatted Excel Tables. If you try to use it in a standard cell range, Excel will usually return a syntax error.

Why did older Excel versions use [#This Row] instead of the @ symbol?

In Excel 2010 and earlier versions, structured references used the [#This Row] specifier to indicate the current row. Starting with Excel 2013, Microsoft shortened this specifier to the @ symbol to make formulas cleaner and easier to read.

How do I stop Excel from using brackets when I click cells?

To prevent Excel from automatically creating structured references when you click cells inside a table, go to File > Options > Formulas, and uncheck the box for 'Use table names in formulas'.

Excel & Data Problems