If your dataset contains formulas that reference other columns within the range, you'll need to recreate these using structured references once you've formatted the data as an Excel table.

Have you ever carefully crafted a formula in Excel, only to watch it unravel into chaos the moment you copy it across columns? It’s a maddening quirk of Excel tables—structured references that ...

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

First, rather than using cell references, you need to use structured references. This means that you can use the column headers in your table. Second, if you use the same formula as in regular ...