How to Make a Headline in Excel

By Jason Artman

Spreadsheets and charts created with Microsoft Excel are rarely self-explanatory; adding a title headline to a spreadsheet helps viewers quickly understand its data, without requiring you to type lengthy explanations at the top of each column. Add a headline to an Excel spreadsheet using the program's "Header and Footer" function, which adds a text box to the top and bottom of each page in the workbook.

Step 1

Launch Excel and open the spreadsheet that you want to add a headline to.

Step 2

Click the "Insert" tab at the top of the window, then click the "Header & Footer" button in the "Text" area of the menu bar. This displays a new field at the top of the spreadsheet labeled "Header."

Step 3

Click the "Click to add header" area at the top of the spreadsheet. A blinking cursor appears.

Step 4

Type the headline that you want to appear at the top of the spreadsheet. If the default font is too small, click and drag the mouse pointer to highlight the headline, and continue.

Step 5

Click the "Home" tab at the top of the window.

Step 6

Click the drop-down menu next to the font name in the "Font" area of the menu bar, then select a larger number to increase the size of the headline.

Tips & Warnings

  • You can also use the "Text Box" button -- next to the "Header & Footer" button -- to add a headline to an Excel spreadsheet. While the "Header & Footer" button creates a text area outside the cells of the spreadsheet, the "Text Box" button creates a box within the cells. After clicking "Text Box," click and drag with the mouse pointer to indicate the desired size of the headline area.