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 ...

From now on, when you update the Excel file, the table in Word will also be updated. Be aware, however, that you will need to repeat the previous steps if you change the location or name of the ...