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 move an object within an image and create images just as you want them
Use this when you want to reposition the subject in a photo; for example, moving a person or product to one side to make room for headings or callouts.
Teams
How to Colour Code Folders in Microsoft Teams
If you're a colour coding sort of person, you'll love the new ability to colour code your folders in Microsoft Teams. Just right click, go to Colour and select from the options available.
Teams
Did you know Microsoft Teams can recognise who is speaking in a meeting?
If you use meeting transcripts or recordings, this is a simple but often overlooked setting that can make a real difference.