How to Add a Title to Your Excel Spreadsheet

The fastest way to add a title

The simplest way to add a title to an Excel spreadsheet is to type it into a cell at the top, usually in row 1, and format it to stand out. Most people merge cells across the width of their data, increase the font size, and apply bold formatting or a background color. Excel does not have a built-in "title" feature — you create one by using cells and formatting.

If you want the title to appear on every printed page, you can also add it through the Page Layout settings so it prints as a header above your data each time. This is separate from the title that appears on screen in the spreadsheet itself.

Key Takeaways

Type your title into the first row of your spreadsheet, then merge cells across your data columns to center it.
Use the Home tab to increase font size, apply bold formatting, and add background color to make the title visually distinct.
To print a title on every page, go to Page Layout, click Print Titles, and specify which rows should repeat at the top of each printed page.
You can add a header or footer through Insert > Header & Footer if you want text to appear in the margins of printed pages instead of in the spreadsheet itself.

Adding a title in cells and formatting it

Start by clicking on cell A1 (or the leftmost cell in your first row). Type your title text. Press Enter to confirm the entry.

Next, select the range of cells you want the title to span. Click on A1 and drag to the right to the last column that contains your data, or click A1 and then Shift+Click on the final column in row 1. With those cells selected, go to the Home tab and click the Merge & Center button in the Alignment group. This combines the selected cells into one and centers your title text across them.

To make the title stand out, select the merged cell again. On the Home tab, increase the font size using the Font Size dropdown (14 or 16 points is common for titles). Click the Bold button to apply bold formatting. If you want a background color, click the Fill Color dropdown (the paint bucket icon) and choose a color. These steps are all in the Home tab.

Printing a title on every page

If your spreadsheet is long and prints across multiple pages, you can make your title repeat at the top of each printed page. Go to the Page Layout tab (or Sheet menu on Mac). Click Print Titles in the Page Setup group.

A dialog box opens. Under "Rows to repeat at top," click in the field and then click on the row number (or row numbers) you want to repeat. If your title is in row 1 only, click the row 1 header on the left side of the spreadsheet. If your title spans rows 1 and 2, select both. Click OK. Now when you print, your title will appear at the top of every page.

Adding headers and footers for printed pages

A header or footer is text that prints in the margins of your pages, separate from the spreadsheet data itself. This is different from a title in a cell. To add a header or footer, go to the Insert tab and click Header & Footer in the Text group.

The spreadsheet switches to Page Layout view. You will see three sections at the top of the page: Left Header, Center Header, and Right Header. Click in the Center Header section and type your title or other text. You can also click in the Left Header or Right Header to add text there. When you are done, click anywhere in the spreadsheet to exit header editing mode. The header will print at the top of every page in the margins.

To add a footer instead (text that prints at the bottom of each page), scroll down to the bottom of the page in Page Layout view and click in the footer sections there. The process is the same as for headers.

Formatting options for titles

Beyond basic bold and color, you can make your title more visually distinct. Select the merged title cell and right-click to open the context menu. Choose Format Cells. In the Format Cells dialog, the Font tab lets you change the font family, apply italic or underline, and adjust the font color. The Fill tab lets you choose a background color or pattern. The Alignment tab lets you adjust how the text sits within the cell (top, middle, or bottom).

You can also add a border around your title cell. With the title selected, go to the Home tab, click the Borders dropdown (next to the Fill Color button), and choose a border style. A border can help separate the title visually from the data below it.

Titles that span multiple rows

Some spreadsheets use more than one row for a title — for example, a main title in row 1 and a subtitle or date in row 2. To format these together, select both rows (click row 1 header, then Shift+Click row 2 header), then merge and center them as described above. You can type both lines of text in the merged cell, pressing Alt+Enter between lines to create a line break within the cell.

Alternatively, keep the rows separate and format each one individually. Type the main title in row 1, merge and center it, and apply formatting. Then type the subtitle in row 2, merge and center it, and apply different formatting (perhaps a smaller font size or lighter color) to distinguish it from the main title.

Removing or editing a title

To edit a title, click on the merged cell containing it and type new text. Press Enter to confirm. To remove the title entirely, select the merged cell, press Delete to clear the text, then right-click and choose Unmerge Cells to separate the cells again.

If you added a title through Print Titles (so it repeats on every printed page), you can remove that setting by going to Page Layout, clicking Print Titles, clearing the "Rows to repeat at top" field, and clicking OK. The title will still appear in the spreadsheet itself, but it will no longer repeat on printed pages.

Frequently Asked Questions

Can I add a title without merging cells?

Yes. Type your title in a single cell and format it with a larger font, bold, and background color. It will not be centered across multiple columns, but it will still stand out as a title. Merging cells is optional — it just makes the title span the width of your data.

What if I want the title to print but not appear on screen?

Use a header or footer instead of a title in a cell. Go to Insert > Header & Footer, type your text in the Center Header section, and click away. The header will print at the top of every page but will not show in the spreadsheet itself when you are working on it.

Can I add a title to only some pages when I print?

No. Print Titles repeats on every page. If you want a title on only the first page, type it in a cell at the top of your data and do not use the Print Titles feature. When you print, it will appear only on the first page because it is part of the spreadsheet data.

How do I center a title across columns without merging?

Select the cell containing your title and the empty cells to its right (spanning the width of your data). Go to Home > Alignment > Merge & Center. This centers the text across the selected range without permanently merging the cells into one, which can be useful if you want to unmerge them later.

Can I add a title to a specific worksheet only?

Yes. Each worksheet in an Excel file is separate. A title you add to one sheet appears only on that sheet. If you have multiple sheets and want each to have its own title, add the title to each sheet individually. Print Titles settings also apply to one sheet at a time.

This guide is for general information only and is not medical, financial, legal, or other professional advice. For decisions specific to your situation, consult a qualified professional. See our Editorial Policy.