How to use Power Query to make First Row into Headers
It's simple with Power Query - make sure your data is a Table to start with, use the Shortcut Ctrl + T. Then click into Data> Get Data from Table to open up Power Query.
Power Query has all sorts of tools and the more you familiarise yourself with them, the quicker you can work to clean and transform any data problem you may be facing.
Inside Power Query go to the Transform Ribbon. There is an icon on the left to ‘Use first row as headers’.
Now close and load back into Excel - Easy!
Keen to stay up to date on anything 365?
Sign up for tips and updates
You may also like
Teams
Polls for your next Teams meeting
Liven up your next Teams meeting wth a poll - make it interactive and even fun!
Copilot
Managing PDFs easily!
Did you know Copilot can compile your PDF files into one document!
Follow us for more M365 and Copilot tips and tricks.
Copilot
Your Early Adopters Have Copilot… So Why Has Usage Dropped Off?
You’ve invested in Microsoft Copilot. You’ve selected a group of Early Adopters. Licenses are assigned, enthusiasm is high… and then, a few weeks later, something changes. Usage slows down. Energy fades. People revert to old ways of working!
If this sounds familiar, you’re not alone. Many organisations experience this exact pattern during their Copilot rollout. The good news? It’s not a failure of the tool.
It’s a gap in how adoption is supported.