How to make a row a header in Excel
You can watch a video tutorial here.
![](https://spreadcheaters.com/wp-content/uploads/Final-Image-1-1.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-1-1.png)
– Go to the Insert menu option and choose Table
Step 2 – Define the table
![](https://spreadcheaters.com/wp-content/uploads/Step-2-1-1.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-1.png)
– The data will be converted into a table with the top row as a header