Freezing Multiple Columns and Rows In Google Sheets

Freezing Multiple Columns and Rows In Google Sheets
Spreadsheets can get a little complicated and cumbersome. To get a better view of information across a spreadsheet we often need to scroll through lots of information. The headings for information may not always be at the top of the sheet in the first or second row. That happens to be the case in this example.

We have some data collected in a survey. The information I would like to keep visible is in the first column and in one of the rows. In this example, that would be the information headings starting on row 23.

DraggedImage.3da20fe037f44479a49f53b4f00f39c5.png

 

DraggedImage.31c205abe1b5411fb4de7c3e00da6f48.png

To freeze a column select the column by clicking the column heading. In this example, that would be column B.

DraggedImage.5a941cee960e4306b41c452ea3b07a4b.png

Click on View in the menu and go down to the Freeze option. In the Freeze option click on the “up to current column (B)” option. We are selecting this option because the information in column A is hidden. Choosing the option to freeze up to column B will include column A and B.

DraggedImage.83da30eaeb264d139795c6e092bd2a12.png

We won’t see much happen but if we look at the right edge of the column, we can see that there is a light gray bar to the right of the column.

DraggedImage.4eefe6b4658344a1bc7b1fec42e64fb7.png

Scroll to the right of the data to see that the column remains visible and the data seems to pass under the headings.

DraggedImage.0ac92cfd8b544cbe884115b7fade8aa5.png

Go all the way to the end of the data and the headings will remain visible.

DraggedImage.8879699acc7c4965967bf561a95f7886.png

We can repeat the process to freeze a row of headings. Click on the row 23 heading. This will provide a basis for our selection in the menu.

DraggedImage.51d744792c17451d9d124ee6414903ab.png

Go back to the View menu option and down to the Freeze option. Select the option to freeze “up to current row (23)”. This will freeze all the rows from the first row up to row 23.

DraggedImage.ebf7b6cbd20147e195aac1cc12ae447c.png

The same light gray bar will appear below the row to indicate that this row of information is frozen. We can scroll up and down or left and right and the headings for both the column and the row will remain where they are and make it easier for us to review the data.

DraggedImage.fa018b1726eb4c77944b83b22eab2317.png

To unfreeze a row or column go back to the View menu option. To unfreeze the column or row we need to select the option to either freeze “no rows” or “no columns”.

Posted in Google Sheets.