Excel Linking Cells - Table Name vs Sheet Reference Explained
Why does Excel sometimes show a table name in your formula and other times a sheet name — even when you're linking to the exact same cell? If that's ever left you confused, this video explains exactly what's happening and how to control it.
📩 Free Newsletter: Practical tips on Data, Tools, & Workflow - https://data-for-knowledge.kit.com/si...
⏱️ Timestamps
00:00 – The Excel formula mystery explained
00:27 – The hidden rule behind table references
00:46 – Why the @ symbol matters in Excel
01:16 – When Excel uses table names vs. sheet names
01:37 – Row mismatch: why you get a sheet reference instead
02:07 – Tip: quickly find where a formula is linked
02:37 – How to turn off table names in Excel options
🔗 Resources
📝 Organising my work with Clickup – https://try.web.clickup.com/8emh4z1sj9w6
Disclosure: I am a participant in the ClickUp Affiliate Program, and I may earn a commission if you click on my referral links and make a purchase.
✍️ My articles on Medium - / paulinecairns
🔔 New to Excel? Subscribe to the channel for more Excel tips, tricks, and tutorials!
/ @dfk_data
💥 For more Excel tutorials:
• Excel Tips And Tricks | Excel Hints for Ev...
🔥Popular Excel tutorials:
• Linking cells in excel - link within tab, ...
• Excel - Calculate Duration - number of day...
☕ If this tutorial saved you a headache today, you can support the channel via a 'Thanks' or a coffee : https://buymeacoffee.com/dataforknowl...
👉 Follow me on LinkedIn: www.linkedin.com/in/pauline-cairns-data
#Excel #ExcelTips #MicrosoftExcel #ExcelFormulas #SpreadsheetTips #ExcelTutorial #TableReferences #ExcelHelp #ProductivityTips #LearnExcel
In questa pagina del sito puoi guardare il video online Excel Linking Cells - Table Name vs Sheet Reference Explained della durata di ore minuti seconda in buona qualità , che l'utente ha caricato Data For Knowledge 29 giugno 2026, condividi il link con amici e conoscenti, su youtube questo video è già stato visto 100 volte e gli è piaciuto 3 spettatori. Buona visione!
