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
Auf dieser Seite können Sie das Online-Video Excel Linking Cells - Table Name vs Sheet Reference Explained mit der Dauer stunde minuten sekunde in guter Qualität ansehen, das der Benutzer Data For Knowledge 29 Juni 2026 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 100 Mal angesehen und es wurde von 3 den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!
