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
Copilot
How to Explain Microsoft Copilot in Plain English?
Years ago, when I worked in marketing, we had a simple rule: "Does it pass the Grandmother Test?" In other words, could you explain the idea in plain English to someone not involved in the project? If not, it probably needed more work.
I still think about that now, especially when I see how many people are trying to work out what AI actually means for them in their day-to-day work.
So, how would you explain Microsoft Copilot to your grandmother?
365 Productivity
How do you know if your SharePoint site has a Team site?
Go to SharePoint, click into one of your Sites and if you see a 'Teams icon' in the SharePoint site name then a Team site has already been created!
Teams
How to Create a Quick Poll on Teams
Use a Poll in a Conversation to find out answers for quick survey questions on Teams.