How can I create a fixed column header in Google Spreadsheet like the first sheet?
migrated from superuser.com Dec 2 '11 at 9:53
This question came from our site for computer enthusiasts and power users.
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.
Frozen row(s) will stay at the top of the sheet when viewing other portions of it.