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
QR Codes
When to use them and how to create a QR Code for your Website - it's quick and easy and an efficient way to share information.
365 Productivity
How to Format Slicers in Excel
Slicers are a winning feature in Excel - Slice and Dice data in a simple and user-friendly interface
Copilot
Excel Tables: The Secret to Unlocking Copilot’s Full Potential
If you’re looking to harness the power of Copilot for data insights, starting with Excel Tables is your best bet. Tables make data management a breeze by automatically expanding as you add new information, and they come with built-in features like sorting, filtering, and easy calculations. This structured format not only keeps your data organised but also enhances Copilot’s ability to analyse and provide meaningful insights.