Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

How to freeze more than 5 column in google spreadsheet?

share|improve this question
up vote 4 down vote accepted

You can't as of yet. According to Google's support page, Rows and columns: Freezing columns and rows:

Freezing Columns

There are also two methods to freeze columns in a spreadsheet:

  • The Column Bar is a vertical bar that separates active columns from frozen ones. Using its handle (found at top, by the column headers), you can drag the Column Bar left or right to the last column you'd like to freeze, 5 columns maximum.

  • Click the Tools tab and then click the "Freeze columns" drop-down menu. From the menu, select the number of columns you want to freeze, 5 columns maximum.

share|improve this answer
and we canonly freeze first 5 column and row what if i want to free column 8 only – metal gear solid Dec 30 '09 at 6:05

This can now be done by dragging the frozen column handle at the top of the column:

screen capture

Even though the pull down options still only list 5 columns avaialable:

screen shot

share|improve this answer

On a mac, you can now drag the frozen column handle past the 5th column. I tried to post image but not enough reputation I am afraid.

share|improve this answer

Your Answer


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

Not the answer you're looking for? Browse other questions tagged or ask your own question.