To add column headers to an Excel workbook stored in SharePoint, open the workbook for editing, enter a label in the first row of each data column, and—if you want filters and table styling—select the data and choose Insert > Table with My table has headers checked. You need edit permission and a clear idea of what each column contains. These are worksheet column headings, not the page headers that appear on printed sheets.
What You’ll Need
- An Excel workbook saved in a SharePoint document library.
- Permission to edit the workbook. If you can only view it, ask the file owner or a SharePoint administrator for edit access.
- A plan for the column names, such as Date, Product, Owner, and Status. Use one heading for each column.
- A current browser for Excel for the web, or Microsoft Excel for Microsoft 365 on Windows if you prefer to edit in the desktop app.
Step-by-Step
-
Open the workbook in an editing mode. In the SharePoint document library, select the Excel file. It may open directly in Excel for the web; if it opens in a preview, choose the option to edit in the browser. To work in desktop Excel, use the option to open the file in the desktop app. The exact wording of these buttons can vary with the SharePoint layout and organization settings.
If you do not see an edit option, check that you have edit permission and that the workbook is not locked by a restriction. Opening a file from SharePoint does not automatically grant permission to change it.
-
Choose the worksheet and inspect the top row. Select the worksheet tab that contains the data. Look at the first row of the data range before typing. If the first row already contains labels, edit those cells rather than adding a second header row. If the data starts in row 1 with no labels, you can use that row for headings only if doing so will not replace real data.
For example, if A1 contains the first date in your records, do not type Date over it. Insert a new worksheet row above row 1 first, then put the headings in the new row. In desktop Excel, right-click the row number 1 and choose Insert. You can also use Home > Insert > Insert Sheet Rows. In Excel for the web, right-click the row number and choose the insert-rows option shown in the menu.
-
Enter one heading at the top of each column. Select the first header cell, usually A1, type a short label, and press Tab to move across the row. For a simple inventory, you might enter Item, Category, Quantity, and Reorder Date in A1:D1. Keep each label in its own cell; do not put several column names into one cell or merge the header cells.
Choose names that tell a reader what values belong below them. Use Customer ID rather than just ID if there are several kinds of identifiers in the workbook. A clear heading helps people scan the sheet and makes sorting, filtering, and table features easier to understand.
-
Check that every data column has a heading. Compare the headings with the data beneath them. If column C contains email addresses, label it Email or Email Address. Avoid blank header cells, because Excel may assign a generic name when you turn the range into a table. Also avoid duplicate headings such as two columns both named Date; use more specific labels such as Order Date and Delivery Date.
Headings should be a single row of text. Avoid putting explanatory notes, totals, or a report title in the same row as the column names. Put a report title above the table if needed, and keep notes outside the data range.
-
Optionally convert the range to an Excel table. A table makes headers easier to recognize and adds filter controls to the header row. Select any cell in the data or select the full range, including the header row, then choose Insert > Table. In the dialog, confirm that the range includes all the intended rows and columns. Check My table has headers, then confirm the dialog.
If that checkbox is left clear, Excel treats the first row as ordinary data and creates generic labels such as Column1. If you already made a table, select a cell in it and edit the text directly in the header cell. Excel tables require a name for each column, so fill any blank header before continuing.
-
Format the headings for readability. If you made a table, Excel applies a table style and usually displays filter arrows in the header cells. In desktop Excel, select a table cell to reveal the Table Design tab, where you can choose a style and check the Header Row option if it is available. In Excel for the web, select the table and use the contextual Table controls to choose a style or header-row setting. The labels remain editable regardless of the style.
If you do not want a table, select the header cells and use Home to apply bold text, a fill color, or alignment. Keep sufficient contrast between text and background. Avoid using color alone to convey meaning, since some readers may not distinguish the colors and the labels should remain understandable without formatting.
-
Check the result in the worksheet. Confirm that each heading sits above the correct column and that no data was overwritten. If you created a table, check that its filter buttons appear on the intended header row and that the table includes the full data range. Try opening a filter menu to make sure it offers the values from that column. Close it without changing the data if you are only checking.
Also inspect long headings. Widen a column by dragging the boundary between its letters at the top of the sheet, or use Home formatting controls to wrap text if available. A heading that is clipped may still be stored correctly, but it is harder to read.
-
Let the changes save to SharePoint. Excel for the web saves changes automatically; wait for its save status to indicate that the workbook is up to date before closing the tab. In desktop Excel, check the AutoSave status when the workbook is opened from SharePoint, and wait for synchronization to finish. If you see a prompt about uploading or resolving changes, follow it and confirm the version you want to keep.
For a quick check, return to the SharePoint library and reopen the workbook, or ask a colleague with access to confirm the headings are visible. Avoid making separate edits in the browser and desktop versions at the same time, because concurrent changes can produce a conflict.
Common Mistakes
- Replacing the first record: Typing a heading into a cell that already contains data overwrites that value. Inspect row 1 first and insert a row above the data when necessary.
- Leaving the table-header setting off: If you create a table without checking My table has headers, Excel may treat your labels as data and add generic column names. Recreate the table with the correct setting or rename the generated header cells.
- Using blank or repeated labels: Blank headings can result in generic names, and duplicates make filtering or analysis confusing. Use a unique, descriptive name for every column.
- Merging header cells across columns: A merged title may look tidy, but it is not a useful column-by-column header row and can interfere with sorting and table creation. Keep each heading in a separate cell.
- Confusing worksheet headers with print headers: Column labels belong in cells at the top of the data. A page header is repeated text in the top margin of printed pages and is configured separately.
Tips
- Use concise names that explain the contents, such as Invoice Date, Region, or Units Sold. Avoid vague headings such as Info or Misc.
- Keep headings consistent in spelling and style. For example, decide whether you will use singular labels such as Product or plural labels such as Products, then apply that choice across the sheet.
- Use an Excel table when people need to filter or sort a list regularly. Table headers stay associated with their columns as the table grows, and table styles make the header row easier to identify.
- Freeze the top row if the data extends far down the sheet and readers need to keep seeing the headings while scrolling. In Excel for Microsoft 365 on Windows, choose View > Freeze Panes > Freeze Top Row. Excel for the web also provides Freeze Panes controls on the View tab; menu labels may vary slightly.
- Use descriptive text rather than relying only on colors or icons. This helps colleagues understand the workbook and makes the sheet more accessible.
- If the workbook is shared, tell collaborators when you add or rename headings. A changed label can affect someone else’s instructions, reports, or processes that depend on the existing layout.
Troubleshooting
I cannot type into the worksheet. Confirm that you opened the workbook in edit mode rather than preview mode. Check whether the file or worksheet is protected, and whether your SharePoint access is view-only. If you cannot change the protection or permissions, contact the workbook owner rather than making a separate copy that others may not use.
The headings disappeared or replaced data. Use Undo immediately if the change just happened and the workbook is still open. If the change has already been saved, check the workbook’s version history in SharePoint or ask the owner to restore an earlier version. Before trying again, identify the first actual data row and insert a worksheet row above it if needed.
Excel shows Column1 or similar labels. This usually means the range was converted to a table without treating the first row as headers. Select each generated header cell and replace it with the intended label. If the original labels are now included in the table as a data row, correct the table range or recreate the table so the labels occupy its header row.
The filter arrows are missing. Check whether the range is an Excel table or whether filtering is enabled for the selected data. When creating a table, include the header row and confirm My table has headers. If you only typed labels into cells, that does not by itself create a table or add filter buttons.
The workbook does not show the latest changes. Wait for the save or upload indicator to finish, then refresh or reopen the SharePoint file. If Excel reports a conflict, compare the versions before choosing one; do not assume the newest-looking browser tab contains every person’s edits. If the file remains out of date, check your internet connection and ask the file owner whether the workbook is checked out or restricted.
The headings are cut off. Widen the columns, wrap the text, or use shorter labels. If the sheet looks correct on screen but not on paper, check print preview and adjust the page layout separately. Column headings in worksheet cells do not automatically repeat at the top of every printed page.
Frequently Asked Questions
Do I need to use Excel for the web to edit a workbook in SharePoint?
No. You can edit in Excel for the web or open the workbook in the desktop Excel app, provided you have permission. Changes made in either place need to finish saving or syncing to SharePoint before you close the workbook.
Can I add headers without turning the data into a table?
Yes. Type the labels into the row above the data and format them if you want. A table is optional, but converting the range to one adds table features such as filter controls and consistent styling.
How do I add a header row without deleting the first record?
Insert a worksheet row above the record before entering labels. In desktop Excel, right-click row number 1 and choose Insert, or use Home > Insert > Insert Sheet Rows. Then place one heading in each column of the new row.
How do I repeat column headings on printed pages?
That is different from adding labels to worksheet cells. In desktop Excel for Microsoft 365 on Windows, use Page Layout > Print Titles and set the row to repeat at the top of each printed page. Excel for the web has limited print-layout controls, so open the workbook in desktop Excel if you do not see the Print Titles option.
How do I add text in the top margin of a printed sheet?
Use a page header rather than a worksheet header row. In desktop Excel for Windows, choose Insert > Text > Header & Footer, then click a header area and enter the text. This page-header feature is separate from column labels and may not be available for editing in Excel for the web.
Can I rename a header after sharing the workbook?
Yes. Edit the header cell and allow the file to save. If the column is in a table, rename its header cell directly. Tell collaborators about the change if they rely on the old name, especially when the workbook feeds a report or a recurring workflow.
Related
- Excel Conditional Formatting Question Mark Explained
- Excel Conditional Formatting Greyed Out? Fixes to Try
- How to Add a Dropdown List in Excel for Data Entry
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Page Break in Excel Shortcut: Insert and Adjust BreaksIn Excel for Microsoft 365 on Windows, select the row, column, or cell where the printed page should…
- Finance Spreadsheet in Google Sheets: Setup and FormulasA finance spreadsheet in Google Sheets can help you track income, spending, budgets, savings, and debt in one…
- Google Sheets Checkbox X Symbol: Show an X InsteadGoogle Sheets’ built-in checkbox cannot be changed to draw an X instead of its usual check mark. To…
- Excel Conditional Formatting Across Sheets ExplainedYes, Excel can use values from another sheet to control conditional formatting, but a rule usually cannot refer…
- Excel Shortcut Keys: Essential Commands and How to Use ThemIn Microsoft Excel for Microsoft 365 on Windows, shortcut keys let you edit cells, move around a worksheet,…
- Google Sheets IF Statements: Syntax and Examples ExplainedIn Google Sheets, an IF statement uses the IF function to test a condition and return one result…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.