The simplest way to add a title

To add a title to an Excel spreadsheet, type your title text into a cell at the top of the sheet — usually cell A1 — then format it to stand out. Select the cell, increase the font size (18 to 28 points works well), make it bold, and center it across the columns your data will use. That's the complete process.

If you want the title to span across multiple columns instead of sitting in just one cell, select the range of cells you want it to cover (for example, A1 through E1), then click the "Merge & Center" button in the Home tab. This combines the cells into one and centers your title across all of them at once.

Key Takeaways

  • Type your title into cell A1, then use the font size and bold buttons in the Home tab to make it visually distinct from your data.
  • Merge & Center (in the Home tab) combines multiple cells and centers your title across them, which looks more polished than a title in a single cell.
  • Add a blank row between your title and your actual data so the title doesn't get confused with column headers.
  • You can add a background color to your title row using the Fill Color button to make it even more visually separate from the data below.

Merging cells to span your title across columns

When you merge cells, Excel combines them into one larger cell. This is useful because it lets your title stretch across the width of your data instead of sitting cramped in a single column.

To merge cells: first select the range you want to combine (click cell A1, hold Shift, and click the last column of your data in row 1). Then go to the Home tab, find the Merge & Center button (it looks like two boxes joining together), and click it. Excel will center your text automatically across the merged area.

If you later need to unmerge the cells — for example, to go back to using row 1 for column headers — select the merged cell and click Merge & Center again. Excel will split it back into separate cells.

Adding space and color to separate your title from data

A title looks more professional when it's visually separated from the actual data. The easiest way is to leave a blank row between them. Type your title in row 1, leave row 2 empty, and start your column headers in row 3.

You can also add a background color to make the title row stand out. Select your title cell or merged range, go to the Home tab, click the arrow next to Fill Color (the paint bucket icon), and choose a color. Light colors like pale blue or light gray work well because they don't make the text hard to read.

Formatting text to make your title readable

The three formatting changes that matter most are font size, bold, and alignment. Start with font size: select your title cell and change the size from the default 11 points to at least 18. You can do this from the font size dropdown in the Home tab.

Then make it bold by clicking the Bold button (the B icon) in the Home tab, or by pressing Ctrl+B. Finally, center the text horizontally. If you used Merge & Center, this happened automatically. If you didn't merge, select the cell and click the Center button in the Home tab.

You can also change the font itself — Arial, Calibri, and Times New Roman are all readable choices — but size and bold matter more than the specific font.

Keeping your title from printing on every page

If your spreadsheet is long and will print across multiple pages, you might want your title to appear only on the first page, not on every page. To do this, go to the Page Layout tab, click Print Titles, and in the dialog that opens, leave the "Rows to repeat at top" field empty (or clear it if it has something in it). This tells Excel not to repeat your title row on subsequent pages.

If instead you want your title to repeat on every page — which is useful for very long spreadsheets where readers might lose track of what the columns mean — click Print Titles, then click in the "Rows to repeat at top" field and select row 1 (or whichever row holds your title). Now the title will print at the top of every page.

Using a subtitle or additional information below your title

Many spreadsheets benefit from a subtitle that explains what the data shows or when it was last updated. Add this in row 2 (or row 3 if you left row 2 blank). Use a smaller font size than your main title — 12 to 14 points — and you can leave it in regular weight instead of bold.

For example, your main title might be "Sales by Region" and your subtitle might be "Q4 2024 — Updated January 15". This gives readers context without cluttering the title itself. You can format the subtitle row the same color as the title row to keep them visually grouped together.

Frequently Asked Questions

Can I add a title without merging cells?

Yes. Type your title in cell A1, format it with a larger font and bold, and leave it there. It will sit in that single cell. The title won't span across your columns, but it will still be visible and readable. Merging is optional — it just makes the title look more polished.

What happens to my title if I add or delete rows?

If your title is in row 1 and you insert a new row above it, the title moves down to row 2. If you delete row 1, the title is deleted too. To avoid accidents, keep your title in row 1 and don't insert rows above it. If you need to add content above the title later, it's easier to add it in a new sheet instead.

Can I use a picture or logo as a title instead of text?

Yes. Go to the Insert tab, click Pictures, and select an image from your computer. Resize it to fit at the top of your sheet. You can position it over merged cells in row 1, or place it to the left of a text title. Keep the image small enough that it doesn't push your data far down the page.

How do I center a title across my data if I don't know how many columns I'll use?

Merge from column A to a column that's wider than your data will ever be — for example, A1 through H1. This gives you room to add more columns later without having to re-merge. Alternatively, use Merge & Center now, and if you add columns later, select the merged cell and unmerge it, then re-merge across the new range.