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
Two Pivot Tables - One Slicer
Create a simple Pivot Table, then create a second one in the same sheet. Then add in a Slicer or two - and run them both!
365 Productivity
How to Manually Group Data in Excel
It's so quick to group data in Excel if you select your columns and go to Outline and then select Group. That's it!
365 Productivity
Dictation in Outlook
With just a simple tap, your spoken words are converted into text, making email creation on both desktop and mobile devices faster and more accessible than ever.