Lock Structured References in Excel Tables (No More Formula Errors)

How to lock table column and row references in Excel formulas. 👩‍🏫 Improve your Excel skills with my courses: https://bit.ly/references25courses ⬇️ Download the free cheatsheet and example file here: https://bit.ly/references25file The problem with Excel Tables is there’s no easy way to lock the references to the columns so when you copy the formula across to other columns, it ends up in a mess. In this video I’ll show you how to lock table references and a shortcut to apply them. LEARN MORE =========== 📰 EXCEL NEWSLETTER - join 450K+ subscribers here: https://www.myonlinetraininghub.com/excel-newsletter-sign-up 🎯 FOLLOW me on LinkedIn: https://www.linkedin.com/in/myndatreacy/ 💬 EXCEL QUESTIONS: Get help on our Excel Forum: https://www.myonlinetraininghub.com/excel-forum ⏲ TIMESTAMPS ============== 0:00 The problem with Excel Tables 0:14 Locking single columns 2:56 Locking multiple columns 4:41 Locking rows 6:56 Excel fixes for the most common problems #Excel #ExcelTables #ExcelTips