In Excel, headers describe the content that is found in the column. In most cases, the header rows are usually the top rows of the worksheet. Have you ever tried adding two header rows to your dataset? In some cases, your dataset may require two or more header rows. This article will guide the steps and ways of adding two header rows in your dataset.
Using the Table Tool
Table Tool is a built-in feature in Excel that allows users to convert the dataset into table format. The table format allows the user to have two or more header rows. Below are steps to follow while using this method:
1. Open the Excel application.
2. Enter your dataset in the empty cell and include the two header rows.
3. Select the dataset from the top Row containing header 1.
4. Click on the Insert tab on the Ribbon, and locate the Tables section.
5. Click the Table button to open a Create a Table dialogue box. In the dialogue box, check the “My table has headers” checkbox. Then, click the OK button.
Now, you have a dataset with two header rows.
Using the Page Setup Tool
Steps to follow:
1. Open the Excel application.
2. Enter your dataset in the empty cell and include the two header rows.
3. Click on the Page Layout tab on the Ribbon, and locate the Page Setup section.
4. Click on the dialogue box launcher. A Page Setup dialogue box will open.
5. On the dialogue box, click the Sheet tab and locate the Print Titles section. Click on the Row to repeat at top textbox, and then select the top Row of your dataset. Finally, hit the OK button.
How to Freeze two header Rows
Steps:
1. Open the Excel application.
2. Enter your dataset in the empty cell and include the two header rows.
3. Place the cursor on the third Row (Immediately below the two headers).
4. Click on the View tab on the Ribbon, and locate the Window section.
5. Click on the Freeze Panes drop-down button. From the menu, choose the Freeze panes button.
How to customize the column width to fit your headers
A] Using the Format Tool
Steps:
1. Open the Excel application.
2. Open the Workbook you want to resize its column.
3. Click on the column you want to resize. Then, click on the Home tab on the Ribbon.
4. From the Cells section, click the Format drop-down button.
5. Click the Column Width button to open the Column Width dialogue box. Add the width you want to apply to the selected column in the text box. Then, hit the OK button.
C] Using the Right-Click Tool
Below are the steps and workarounds to follow:
1. Open the Excel application.
2. Open the Workbook you want to resize its column.
3. Right-click on the column you want to resize. Click the Column Width button from the menu to open the Column Width dialogue box.
4. Add the width you want to apply to the selected column in the text box. Then, hit the OK button.
