Ah, yes that joyful scenario. You have a list – a great big juicy list and you want to scroll down that list but oh no my headings have disappeared…WHAT DO I DOOOOO? Well I *have* heard of people who have sellotaped the headings onto their monitor…..and that is indeed one option. However why don’t we see what Excel has actually already got?
- Reflecting on 2022 – Failures & Disappointments, what went well and lessons learned.
- How to check for duplicates across worksheets – using Power Query Append
- How to use removed unwanted spaces with Power Query – AKA Trim
- What I learned from the 2022 Tour de France
- Meet Aggregate – the function that helps you wrangle hidden rows and subtotals in your formulas..