How to Change Excel 2007 Column Headings

Save

The Microsoft Excel 2007 spreadsheet application provides users with powerful data management, analysis and display capabilities. When you're editing large Excel worksheets, it is often useful to set up column headings that always appear at the top of the worksheet so you can easily organize the information that you enter into lower rows. You can create column headings by typing the headings into row 1 of your worksheet and using the application's "Freeze Panes" function.

  • Navigate to the folder that contains the Microsoft Excel workbook that you want to edit. Double-click the file to open the workbook in the Microsoft Excel 2007 application.

  • Highlight row 1 in the worksheet to which you wish to add column headers. Right-click the row and choose "Insert" to add a column header row. Skip this step if there are already column headers typed in row 1 of the worksheet.

  • Type the heading for each column.

  • Click on cell A2 if your worksheet contains only column headings. Click on cell B2 if your worksheet contains both column and row headings.

  • Click the "Window" tab and choose "Freeze Panes." The column and/or row headings that you have typed in will always be displayed at the margins of the worksheet. If you later need to eliminate column headings simply click "Window" and choose "Unfreeze Panes."

References

Promoted By Zergnet

Comments

You May Also Like

Related Searches

Check It Out

Geek Vs Geek: Robot battles, hoverboard drag race, and more

M
Is DIY in your DNA? Become part of our maker community.
Submit Your Work!