How to freeze more than 5 column in google spreadsheet?

How to freeze more than 5 column in google spreadsheet?

3 Answers

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.

1

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

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

2

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

1

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password Submit

Post as a guest

Post Your Answer Discard

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy