What Is a Structured Reference? Direct cell references in Excel link one cell to another using the column and row header labels. For example, cell A1 is in the first column and first row, while ...

Referencing can become difficult, especially if you’re using structured referencing. Instead, reference a spill range so you can use the hashtag shortcut.