How to Make Column Titles in Excel 2007

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.

Step

Open an Excel worksheet.

Step

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.

Step

Enter the column title.

Step

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.

Step

Save the worksheet.