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
Introducing Chat GPT - What, Why and Where!
Open AI and backed by Microsoft soft - this new AI will be the new Google. Find out more here.

Teams
How to Expand a Screen in Teams
Ever wanted to get a bigger view of your Planner board - just click the Expand Screen button!

365 Productivity
How to use 'If Error' with a V-Lookup
If you get errors in your results in Excel, edit your formula so it starts with the 'IfError' formula. You can 'nest' an If Error formula and another formula to remove the error messages and it will look so much better