Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

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

share|improve this question

migrated from superuser.com Dec 2 '11 at 9:53

This question came from our site for computer enthusiasts and power users.

2 Answers 2

up vote 64 down vote accepted

Up to ten rows of each sheet can be designated as the column header. This is called freezing rows. Every sheet has a horizontal guideline which separates header rows from the rest of the sheet. This guideline has a gray handle. The gray handle initially appears above row “1” on the left hand side of the sheet. To set the number of rows in the column header, drag the handle up or down using the mouse – or you can set the number of rows using the menu option View, Freeze Rows.

There is also a vertical guideline which works in a very similar manner, and lets you freeze as many as five columns as row labels.

When you create a blank document, it comes with an initial sheet. This sheet does not have a column header.¹ Additional sheets, if you create them, are the same: they do not have column headers to begin with.

The Android app imposes a limitation on this feature. While it does show frozen row and column headers properly, it does not let you control which rows or columns are frozen. You need to use a PC based browser to change your row and column headers.

Notes

  1. When the question was originally asked, the first sheet in a new untitled spreadsheet had one header row: row 1. This is no longer so. But it is why the question was asked the way it was.
share|improve this answer
5  
Hover over the blue (dashed) line ....at the top left corner..wait for the hand shaped cursor ..then drag it down. –  so_mv Feb 4 '13 at 6:36
    
UPDATE: the dashed line may appear gray now, but turns blue when hovering. –  Nilloc May 8 '13 at 17:43
    
When I create a new spreadsheet it doesn't default to one header row, so I'm assuming that's a change from before. But, otherwise, this and the comments are still correct. I.e. There's a horizontal/vertical dashed gray line at the top-left corner, and when you hover over one it turns blue and the cursor changes to a hand. The other answer about "Freeze rows" is an alternative way to do this through the menu. –  Michael Krebs Nov 17 '13 at 22:55
    
@MichaelKrebs Thanks for the update. I have changed the answer to reflect changes in the app, and added information about the Android app as well. –  MετάEd Feb 24 at 16:39
  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.

enter image description here

share|improve this answer
1  
Please add the instructions to your answer instead of linking to your own site. Thanks! –  Alex Feb 7 '12 at 6:10
2  
Thanks a lot for the Screenshots....:) –  Sangram Anand Oct 4 '12 at 15:20

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.