How to shorten references using the hashtag symbol in Microsoft Excel Your email has been sent Referencing can become difficult, especially if you’re using structured referencing. Instead, reference a ...

Double square brackets appear in structured references in Excel when column headers contain spaces or special characters. They're also inserted into formulas when you reference header and total rows ...