How to Make Column Titles in Excel 2007by 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.