If your header row is in row 1, you don’t have to click any cells. Just continue to the next step. If your header row is down further, such as in row 2 or 3, click a cell below the header row. For example, if the row that contains your column labels is row 5, you will need to click a cell in row 6.
For example, if the row that contains your column labels is row 5, you will need to click a cell in row 6.
If your header row is in row 1 (the first row on your sheet), select Freeze Top Row. This ensures that the top row of your sheet remains locked into position, even as you scroll through your data. If your header row is in a different row, such as row 3, select Freeze Panes. This freezes the row above the cell you selected in Step 1. For example, if you selected A6 in Step 1, selecting Freeze Panes will freeze row 5, making it your header row. This row will always stay visible as you scroll through your data. The Freeze Panes option works as a toggle. That is, if you already have panes frozen, clicking the option again will unfreeze your current setup. Clicking it a second time will refreeze the panes in the new position.
For example, if you selected A6 in Step 1, selecting Freeze Panes will freeze row 5, making it your header row. This row will always stay visible as you scroll through your data.
Click the Header/Footer tab Click the Header or Footer drop down menus to select a preset header. Alternatively, click Custom Header or Custom Footer to create your own.
Click Print to start the printing process. Check the print preview in the preview section. Click Print (the printer icon) to print the spreadsheet.
Click Print to start the printing process. Check the print preview in the preview section. Click Print (the printer icon) to print the spreadsheet.
For example, if you’re using Excel to track your bills, you might have headers like Date, Expense Type, and Amount.
If you’re looking for Pivot Table information, check out our intro guide here.
If you don’t select “My table has headers,” a header row will be created using default names. You can edit these names by selecting the cell.
Click the Design tab Check or uncheck the “Header Row” box to toggle the header row on and off. You can find this option in the Table Style Options section of the Design tab. Note that turning the header off will also remove any applied filters from the table.
Note that this method requires the first row of your dataset to contain column header names.
Click Use First Row as Headers. Select Use First Row as Headers in the drop down menu. This will make row 1 into the headers for the table.
Double-click the column header name. Type in a new name for the header. Press ↵ Enter to confirm the name.
