If we make the first row as header in Excel, it will help to organize data and make the document easier to read. Excel provides several methods for creating the first row as a header. In this article, we will discuss four simple methods to make the first row as header in Excel with the explanation.
Download Practice Workbook
Download the practice workbook from here.
4 Simple Methods to Make First Row as Header in Excel
1. Create First Row as Header by Freezing in Excel
Assuming, we have a dataset B1:C5, containing some Items with their product IDs. Here, we need to make the first row a header. Now, we are going to use the ‘Freeze Panes’ option to make it happen. ‘Freeze Panes’ option keeps an area of a worksheet visible while scrolling to another section of the worksheet.
- First, click on the View tab from the ribbon.
- After that, click on the Freeze Panes.
- Then, a dropdown menu will appear.
- Now, select Freeze Top Row from the dropdown menu.
- Clicking Freeze Top Row, it locks the first row finally. That means if we scroll down, the top row stays at the top of the document.
2. Apply Format as Table Option to Show First Row as Header
Suppose, we need to make the first row as header of the dataset (B1:C5) below in Excel which includes some items and product IDs. We can use the Format as Table option in the Home tab to do so. Excel automatically converts the data range to a table after selecting the ‘Format as Table’ option.
- Firstly, go to the Home tab and click the Format as Table dropdown menu.
- After clicking the dropdown menu, you can select a style for your table.
- Then, the Create Table window will appear.
- Now, check if our selected cells are correct.
- After that, give a tick mark on the My table has headers.
- Lastly, click on OK.
- In the end, a table will be created that contains the header in the first row.
- [Fixed!] My Column Headings Are Labeled with Numbers Instead of Letters
- Promote a Row to a Column Header in Excel (2 Ways)
- How to Make Multiple Sortable Headings in Excel
- Keep Row Headings in Excel When Scrolling Without Freeze
3. Make First Row as Header Using Excel Print Titles Option
Here, we have the same dataset (B1:C5) in Excel just like the above methods. Now we need to make the first row as header. We can do this easily by using the Print Titles option in Excel. It specifies rows and columns in Excel that will be printed on each page. This makes printed copy easier to read.
- In the beginning, select the Page Layout tab and click on the Print Titles.
- Then, the Page Setup window will appear.
- Click on the Rows to repeat at top.
- Now, select the first row.
- After selecting the first row, click on the Print Preview button to make sure the header row is correct.
- Finally, click on the Print button to see the result.
4. Use of Power Query Editor to Select First Row as Header
In our last method, we are using the same dataset (B1:C5) of product items with their IDs. We can easily make the first row as the header of the dataset by using Power Query Editor in Excel. It helps to import or connect to external data, and then shape that data, such as removing a column, changing a data type, or merging tables. The steps for this method are given below.
- In the first place, choose the Data tab and click on From Table/Range.
- Secondly, a Create Table window will appear.
- Now, click on the box to enter data.
- After that, select the dataset and click on OK.
- Then, go to the Transform.
- At this time, select Use First Row as Headers (see the screenshot).
- In turn, the Power Query will convert the first row of data to a header row.
- Finally, select Home > Close & Load
- Now, you will return to the transformed data where the first row is converted to header.
I hope these four methods will be helpful for you to make the first row as header in excel. Download the practice workbook and give it a try. Let us know your feedback in the comment section. Follow our website ExcelDemy to get more articles like this.