How to make a header row in Excel
You can watch a video tutorial here.
![](https://spreadcheaters.com/wp-content/uploads/Final-Image-–-How-to-make-a-header-row-in-Excel.png)
Excel has the provision to convert a set of data into a table. When converting the data into a table, you have the option of making the top row the header for the table. Creating a header makes the table more presentable and easier to understand.
Step 1 – Choose the menu option
![](https://spreadcheaters.com/wp-content/uploads/Step-1-–-How-to-make-a-header-row-in-Excel.png)
– Go to the Insert menu option and choose Table
Step 2 – Define the table
![](https://spreadcheaters.com/wp-content/uploads/Step-2-–-How-to-make-a-header-row-in-Excel.png)
– In the pop-up window, change the range, if needed
– Tick the My table has headers box
– Click OK
Step 3 – Check the result
![](https://spreadcheaters.com/wp-content/uploads/Step-3-–-How-to-make-a-header-row-in-Excel.png)
– The data will be converted into a table with a header row