Excel Tables - Absolute Column and Cell References

In this video, we look at how to make Excel table cell and column references absolute. It surprises many that the structured references used by Excel tables are relative. Many you copy a formula, the table references change. But you can lock table column and cell references. This video will show you the technique to make table references absolute with two examples. You can download the Excel workbook used in the tutorial here - https://bit.ly/3vHdUer Timings for the video are: 00:00 - Introduction 00:32 - Table columns references changing - and we want it 01:54 - Table columns changing - this is wrong 03:25 - Interesting table reference behaviour 04:17 - Make an absolute table column reference 05:21 - Make an absolute table cell reference absolute Find more great free tutorials at; https://www.computergaga.com *** Online Excel Courses *** The Ultimate Excel Course – Learn Everything ► https://bit.ly/UltimateExcel Excel VBA for Beginners ► http://bit.ly/37XSKfZ Advanced Excel Tricks ► https://bit.ly/3CGCm3M Excel Formulas Made Easy ► http://bit.ly/2ujtOAN Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2Siivkm Connect with us! LinkedIn ► https://www.linkedin.com/company/18737946/ Instagram ► https://www.instagram.com/computergaga1/ Twitter ► http://www.twitter.com/computergaga1