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/Photos.com/Getty 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:
Easy

Other People Are Reading

Instructions

  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

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

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