How to Use Column Headers in Excel

Written by jonah quant
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Use Column Headers in Excel
Add column headers to your spreadsheets. (Jupiterimages/ Images)

Excel is a spreadsheet manager that runs on the Microsoft Windows operating system. Spreadsheets often contain one or more rows of column headers that explain the meaning of the data stored in the columns beneath them; that is a useful technique to communicate data more effectively. However, if you just enter all column headers into a row, they will scroll out of sight as you scroll down the spreadsheet. You can make column headers stay visible in Excel, no matter how deep down the spreadsheet you scroll.

Skill level:


  1. 1

    Launch Excel by double-clicking on its icon. Open the spreadsheet that needs column headers.

  2. 2

    Enter each column header, one after another, on the first row.

  3. 3

    Move the cell pointer to the column immediately after the last column that has a header, and on the second row. Select "Window" on the main menu, then click on "Freeze panes." Everything above and to the left of the cell pointer -- that is, the header row -- will remain in place at the top of the spreadsheet even if you scroll down more than one screen's worth of rows.

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.