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

Using Structured References Within a Table To use structured references within your table, as in the example above, you first need to add some data to your Excel worksheet, with column names ...