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 'copy as a pdf' from OneDrive in a simple step
Once your Word doc is finalised, you'll probably want to 'copy as a pdf' before you forward it on to your client or team. Now it's easy from within OneDrive. Click the three dots next to the File name for more options, go to Automate, and select 'Copy as a PDF' to run the automated flow - it's all set and ready to go, you don't need to do a thing!
365 Productivity
How to use Sparklines in Excel
Go to the Insert Ribbon and select the Sparkline you wish to use - Microcharts contained in one cell can help give you a quick visual to analyse data.
365 Productivity
How to Remove a Background from an Image
Jump into PowerPoint, go to the Picture tools Ribbon and here you'll find the tools available when you select the 'Remove Background' icon.