By default, references in Excel use the A1 reference style, which means that it refers to the column first, and then the row number. However, the INDIRECT function enables you to switch these around.

Image: Aleksei/Adobe Stock. If you’re using Microsoft Excel in Microsoft 365, you might have noticed the hashtag symbol (#), or the pound sign, in references.It’s a relatively new feature that ...

By default, Excel names the first sheet in the workbook "Sheet1." Append the cell's address to its sheet's name, separated by an exclamation mark. Continuing the example, the extended reference ...