Make Excel table references absolute

Part 3 of our series on improving the automation of Excel spreadsheets through the use of Tables has just been posted to the Excel Community site. As well as covering quick ways to create references to Table contents, it shows how Table structured references can be made absolute so that they can be copied across columns without the column to which they refer changing.

This blog is brought to you by the Excel Community where you can find additional blogs, extended articles and webinar recordings on a variety of Excel related topics. In addition to live training events, Excel Community members have access to a full suite of online training modules from Excel with Business. There is also an online forum where you can ask questions and share ideas with other community members.

Anonymous