To add column headings in Excel for the web, type a label into the top cell of each column, such as “Date” or “Amount.” To make the headings behave like a filterable Excel table, select your data and choose Insert > Table, then confirm that your table has headers. If you mean a header printed at the top of each page, Excel for the web cannot add or edit one; use the desktop Excel app instead.
What You’ll Need
- A workbook you can edit in Excel for the web, saved in OneDrive, SharePoint, or another location you can access in your browser.
- A clear idea of which kind of header you need: column headings inside the worksheet, or a page header that appears on printed pages.
- If you are creating a table, a data range with one intended heading row and no merged cells in the range.
Step-by-Step
- Open the workbook and select the right worksheet. Go to Microsoft 365 or your OneDrive or SharePoint library, open the workbook, and choose the sheet where you want headings. If the file opens in view-only mode, choose Edit Workbook or ask the owner for editing access before making changes.
- Decide whether you need column headings or a printed page header. Column headings label fields in the worksheet, usually in the first row above the data. For example, a sales list might have headings such as Order Date, Customer, Region, and Total. These are the usual meaning of “headers” when organizing worksheet data. A page header is separate: it is text, a date, or another item placed in the top margin of a printed page. Follow the column-heading steps below for worksheet data; see the note in step 7 for page headers.
- Make room for a heading row if needed. If your data already starts in row 1 and has no labels, right-click the row number 1 and choose Insert Rows Above. If the right-click menu does not show that command, use the row controls available on the Home tab. Inserting a row shifts the existing data down without overwriting it. If row 1 already contains the correct labels, do not insert another row just to repeat them.
- Enter a heading in each column. Click the first cell in the heading row, commonly A1, type a short, descriptive label, and press Enter. Continue across the row, entering one label per data column. For instance, if names are in column A and email addresses are in column B, use headings such as Name and Email. Keep each label in its own cell; do not combine several headings in one cell or leave an unexplained blank between headings.
- Check that the headings match the data below them. A heading should describe the values in its column, not the whole worksheet. Use “Invoice Date” for dates and “Invoice Total” for amounts rather than a vague label such as “Info.” Make labels distinct when two fields could be confused, such as “Billing Address” and “Shipping Address.” Avoid putting notes or a report title in the same row as the column labels.
- Optionally turn the range into an Excel table. Click a cell in the data, then choose Insert > Table. Check the range shown in the dialog and make sure it includes the heading row and all the intended data. Select the option labeled “My table has headers” if it is not already selected, then confirm by choosing OK. Excel treats the first row as the table’s field names, adds filter controls to the headings, and applies a table style. If you leave the option unchecked, Excel may create generic labels such as Column1, so check the setting before confirming.
- Review the result and choose the right display option. Confirm that each table heading is correct and that the filter arrows appear in the heading row if you made a table. If you want headings to stay visible while you scroll, choose View > Freeze Panes > Freeze Top Row. This freezes worksheet row 1; it does not add a printed page header. If your heading row is lower down, select the row immediately below the rows you want to keep visible, then use View > Freeze Panes > Freeze Panes. Check the result by scrolling down.
- For a printed page header, open the workbook in desktop Excel. Excel for the web does not provide the controls to insert or edit worksheet page headers and footers. In Excel for Microsoft 365 on Windows, open the file in the desktop app, choose Insert > Text > Header & Footer, then click a header section in the worksheet’s Page Layout view and type the desired text. Excel for the web may display page setup features differently and does not offer this editing workflow. Save changes in the desktop app and reopen or refresh the workbook in the browser to see the saved workbook.
Common Mistakes
- Confusing a column heading with a page header. Typing “Monthly Sales” into A1 creates worksheet content; it does not print automatically at the top of every page. If the requirement is a repeating print header, use desktop Excel’s Header & Footer feature.
- Including a title row in the table’s heading row. A large report title across several columns is not a set of field names. Keep the table’s first row to one distinct label per column. Put a report title above the table, outside its data range, if you need one.
- Forgetting the “My table has headers” setting. When Excel treats your labels as data, it may add generic names and include your labels as the first record. Undo the table creation if appropriate, then create it again with the header option selected, or correct the table headings and remove the unintended row.
- Using blank, duplicate, or unclear labels. Blank cells can make a table confusing, and repeated labels make it harder to identify fields when filtering. Give each column a concise, distinct name, even if two columns contain similar kinds of information.
- Expecting Freeze Top Row to follow a heading below row 1. That command keeps the first worksheet row visible, not whichever row contains your headings. Use Freeze Panes with the active cell or row positioned below the rows you need to keep on screen.
Tips
- Use consistent, readable wording. Choose labels that make sense to someone who did not build the workbook. “Units Sold” is more useful than “Units” if the sheet also tracks units returned.
- Keep one record per row and one field per column. This layout makes sorting, filtering, and table features work more predictably. Avoid merged cells in a data range, especially in its heading row.
- Use a table when you need to work with the data. Table headings provide filter controls, and the table can expand as you add entries beneath it. A table is usually more practical than manually formatting a row if you plan to sort or filter the records.
- Freeze the row for long worksheets. Freezing row 1 helps keep column labels in view while you scroll through records. Remember that freezing is a screen-view setting, not a print setting, and it does not change the workbook’s data.
- Keep visual styling restrained. A bold font or a table style can distinguish headings from the data, but color alone should not carry meaning. Check that the text remains easy to read on different screens.
- Save and confirm edits. Excel for the web generally saves workbook changes automatically, but wait for the save status to finish before closing the browser tab. If other people are editing the file, verify that your headings appear as expected after their changes.
Troubleshooting
The Table command created Column1 or similar labels. The header option may have been off, or Excel may not have recognized the heading row. Check the table’s first row. You can replace generic names with meaningful labels, or undo the creation and repeat Insert > Table with “My table has headers” selected. Make sure the range starts at the actual heading row, not at a title or blank row.
Your heading text is cut off. The cell may be narrower than the label. Widen the column by dragging the boundary between its lettered column headings, or shorten the wording. Text may also look cut off because the cell to its right contains content. Widening the column or wrapping the heading text can make it visible; use the Home tab’s text-wrapping control if it is available in your ribbon layout.
The headings disappear when you scroll. If they are in row 1, choose View > Freeze Panes > Freeze Top Row. If they are farther down, select the row immediately beneath the rows to keep visible and choose View > Freeze Panes > Freeze Panes. If the wrong rows remain frozen, use the Freeze Panes menu’s Unfreeze Panes command and set it again.
You cannot edit the workbook or the heading row. Check whether the workbook is open in view-only mode, whether the worksheet is protected, or whether you have permission to edit the file. Ask the owner to grant access or remove the relevant restriction. If another person is editing at the same time, wait for their change to finish and check whether your cell has been updated.
You cannot find Header & Footer in Excel for the web. That is expected for page headers: the browser version does not offer the desktop command to insert or edit them. Open the workbook in the Excel desktop app and use Insert > Text > Header & Footer. If you only need worksheet column labels, enter them in cells instead; you do not need the page-header feature.
Frequently Asked Questions
Can I add a repeating print header in Excel for the web?
No. Excel for the web does not let you insert or edit page headers and footers. Open the workbook in desktop Excel and use Insert > Text > Header & Footer to add one.
How do I make column headings stay visible as I scroll?
For headings in row 1, choose View > Freeze Panes > Freeze Top Row. For headings below row 1, freeze the rows above them using Freeze Panes. This keeps rows visible on screen but does not repeat them on printed pages.
Do I need to format my headings as a table?
No. You can type headings into worksheet cells without creating a table. Convert the range to a table when you want features such as filter controls and a consistent table style.
Can I use more than one row of column headings?
For an Excel table, use a single row of field names. You can put a title or explanatory text above the table, outside its range. Multiple header rows can make sorting and filtering less predictable.
Can I change a table heading after creating the table?
Yes. Click the heading cell and type the replacement label. Use a clear, unique name; the table’s filter controls remain associated with the heading row.
Will freezing the top row make it repeat when I print?
No. Freeze Panes affects what stays visible while you work in the worksheet. To repeat rows or add a page header for printing, use the relevant page setup features in desktop Excel.
Related
- How to Lock Cells in Excel So You Can Scroll
- How to Lock Cells in Excel So No One Can Edit Them
- How to Lock Cells in Excel and Protect a Worksheet
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Shortcut to Go to a Referenced CellIn Excel for Microsoft 365 on Windows, select a formula cell and press Ctrl+[ to select the cells…
- SUMIF Negative Values in Google Sheets: Formula HelpTo total negative numbers in Google Sheets, use SUMIF with the criterion "<0". If the values are in…
- Excel Data Table Relationships and How to Create ThemIn Excel, table relationships link separate tables through matching key columns, letting PivotTables and the Data Model analyze…
- Why Is Excel Not Letting Me Transpose Data?Excel usually will not transpose data because the source was not copied as a normal cell range, or…
- Power Query Union Tables: How to Append QueriesTo union tables in Power Query, use Append Queries: it stacks the rows from one query beneath the…
- Delete a Blank Page in Word: A Simple Step-by-Step GuideTo delete a blank page in Word, show formatting marks with Ctrl+Shift+8 on Windows or Command+8 on Mac,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.