How to Make Column Titles in Excel 2007

By Kathryn Hatashita-Lee

Updated February 10, 2017

Excel 2007 allows you to format cells to give spreadsheets a custom look. A column title helps label the column’s data. A column title you create is different from Excel’s column header that tracks data. The “Home” tab includes formatting commands such as font and alignment. You can change the title's style and format to help make your spreadsheet more organized and readable.

Open an Excel worksheet.

Click on a cell above a column. The selected cell will show a heavy black outline. The column and row headers will change to a different color.

Enter the column title.

Edit or format the title for a custom look. For example, you can change the font, font color, size and alignment. Click on the “Home” tab and use the commands in the "Font" and "Alignment" groups to change the format of your column title.

Save the worksheet.


If there is no space above the column, insert a new row for your column title. Click the cell holding the column's first entry. Select the "Home" tab and click "Insert" in the "Cells" group. A new row appears above the column. The data will move down one row. Enter the title on the new row.

You can create a merged cell that allows you to enter one title that extends across the top of two or more columns. Click the "Home" tab, then click and drag to select two or more cells. Click the “Merge & Center” button on the “Alignment” group on the command Ribbon. The cells will merge to form a larger cell. Enter the title in this merged cell. You can change the font and alignment by clicking “Font” and “Alignment” commands on the "Home" tab.