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
The Quickest Way Possible To Format Text in Microsoft Word
Microsoft Word is turning 40 and here is our favourite trick to celebrate! Here is how to quickly format text in Microsoft Word. Selecting the Text with Similar Formatting can be made easy, especially handy when you want to change all the headings in a document to a different style, switch a certain font size or even change a footer or header. This can be done by selecting the text in your document that has the formatting you want to change. On the Home tab, click the Editing Group button, Select and Select All with Similar Formatting. Apply a different style or change the formatting for the selected text.
Teams
How to share an email from Outlook to Microsoft Teams
Select the email you wish to share with Teams. on the right-hand side of the email, click onto the Teams icon and then select the channel you want to share the email with.
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!