📞 01223 214177 ✉️ karen@roem.co.uk
Hello and welcome to April... time for another Clever Clogs tip. Yes, I know I usually send these on the first Tuesday of the month (after nearly weekly emails from 2003 to 2023) but hey - today's as good a day as any. Unless, of course, you think this tip is an April Fool's joke? (Spoiler alert: it isn't.) This month's tip: how to ditch those (in my opinion) confusing Table Formulas.
Somebody who attended a recent Excel training session recently told me this tip alone made the course worth attending (he had avoided using Tables altogether) so I figured it was about time to share it with you too.
So, where do you stand? Are you on Team Table Formulas (technically called "Structured References", but let's skip the jargon)...
... or do you (like me) prefer good old-fashioned regular formulas?
Here's how to disable the Table Formulas:
This setting only affects new or edited formulas, so existing formulas will remain unchanged.
By the way, the client who hired me to deliver the training shared the feedback from that session (in a spreadsheet, of course ;) and I normally simply save this in my "happy" folder. But last week I took it a step further following Rosie Wareham's brilliant trick on LinkedIn for giving yourself a well-deserved confidence boost. Here's what she suggested:
Intrigued, I decided to test it out on the feedback spreadsheet from the session. Here's what happened...
Thanks for the tip, Rosie! So much better than blowing your own trumpet! ;)
Related tips
Last month's CleverClogsTipTime on LinkedIn (newest posts first)
K.
Sharing for free since 2003
Copyright © 2025 Roem Ltd
*
Unless stated otherwise this tip is written for Microsoft 365 desktop apps and Windows 11 users, but might also be useful in Office 2010, 2013, 2016 and 2019.
I'm committed to sharing the best of what I know with others so please don't keep me a secret. If you enjoyed today's tip, please forward it to anyone you feel may benefit. Alternatively, feel free to reprint it (with full copyright and subscription information) in your newsletters and message boards.