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:
Other People Are Reading
Launch Excel by double-clicking on its icon. Open the spreadsheet that needs column headers.
Enter each column header, one after another, on the first row.
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.
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for