How to freeze more than 5 column in google spreadsheet?

Question

KyleMit · Answer 1 · 2016-06-13T20:18:16.080

13

The freeze menu item now lists the first two rows/columns or all the way up to the currently selected cell:

screen shot

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

screen capture

edited Jun 13 '16 at 20:18

answered Jul 15 '14 at 13:52

KyleMit

6,345

Great answer. It looks like Google has changed the interface now since you posted - in the menu it now allows you to freeze one or two columns, or all up to the row/column you are currently on. – mwfearnley Jun 13 '16 at 19:59
1

This should now be Best Answer. – Hashim Aziz May 18 '17 at 21:07

score 4 · Accepted Answer · answered Dec 29 '09 at 05:41

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.

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 06:05

score 1 · Answer 3 · edited Jun 13 '16 at 19:55

1

On a mac, you can now drag the frozen column handle past the 5th column.

edited Jun 13 '16 at 19:55

Pierre.Vriens

1,425
38
16
20

answered Nov 07 '13 at 23:35

Trevor

11
1

This is not a Mac thing, works also on Linux and Windows. Look @KyleMit answer. – Pablo A May 09 '17 at 12:33

How to freeze more than 5 column in google spreadsheet?

3 Answers3