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

365 Productivity
How to use Viva to Protect your Time
Microsoft Viva can help you get your work done - Use Viva from your navigation bar in Teams to schedule time to do the doing!

365 Productivity
How to add percentage labels to a pie chart
Your Pie Chart in Excel comes ready with percentage labels - you just need to know where to find them!

Copilot
Copilot vs Chat GPT
Why use Copilot instead of Chat GPT - Let's explore the security to help you understand the difference.