How can I create a fixed column header in Google Spreadsheet like the first sheet?

Question

How can I create a fixed column header in Google Spreadsheet like the first sheet?

Answer 1

The first sheet in a new untitled Google Docs spreadsheet has one header row, row 1. A horizontal guideline below row 1 separates the header row from the rest of the sheet. This guideline has a blue handle which appears between the numbers "1" and "2" on the left hand side of the sheet. The handle can be dragged up or down using the mouse to include more (or fewer) rows in the column header.

Other sheets have no header rows to begin with. The guideline with the blue handle is located above row "1". Simply drag the blue handle down the left hand side of the sheet to create one (or more) header rows.

Currently you are limited to ten header rows.

Note that there is also a vertical guideline which works in a very similar manner, and lets you use as many as five columns as row labels.

Answer 2

1. Open Spreadsheet
2. Click on View from the menu
3. Click on Freeze rows from the dropdown menu
4. Choose how many rows you want to freeze.

Frozen row(s) will stay at the top of the sheet when viewing other portions of it.