If you don’t know how Excel freeze panes, check the above content right now! Bonus Tip: What to Do When Freeze Panes Not Working Step 3: After that, the selected area will be frozen. Step 2: After selecting the target content, click Freeze Panes > Freeze Pane. For instance, to freeze the first 5 columns, you should choose the whole column F or cell F1. Step 1: Choose the column to the right of the last column that you would like to freeze. For any columns are out of viewing before freezing, they will be hidden after freezing. Columns in the middle of the worksheet can’t be frozen.
That’s all about Freeze Pane in Google Sheets.Note: You are only allowed to freeze columns in the left side of the sheet. Must Read: Repeat Page Titles in Google Sheets Please refer my below post for detailed info on printing titles / headings in Google Sheets. Just freeze the rows that you want to print as titles. It acts as header or you can say print titles. In such cases you can use this freeze pane feature in Google Sheets. Possibly your first row may contain the column headers / titles. So you may want the first row or first few rows repeated in every page as title rows. If you have lots of rows in your Google spreadsheet, when you print it may spread across several sheets. The Role of Freeze Pane in Google Sheets Header You can unfreeze rows and columns from the above same View menu Freeze.
How to Unfreeze Columns / Rows in Google Sheets? You may be interested in knowing what I did in the above freezing of rows and columns. First freeze rows and then freeze columns as said above. With one click you can’t freeze columns and rows together. How to Freeze Rows and Columns Together in Google Sheets That dark shaded line is the Freeze pane identification on a sheet. To do that click on cell E1 and go to the View menu Freeze Pane and click on “Up to current column (E)”. For example I want to freeze up to column E. Please make sure that you are in the very first row on your sheet. Users either freeze rows or freeze rows and columns together. How to Freeze Columns in Google Sheetsįreeze Pane in Google Sheets can also freeze columns. But it won’t work if your cells are merged. If you are on row # 6, if you access the View menu Freeze, you can see the suggestion “up to current row (6)”. Then as seen on the screenshot go to the menu View > Freeze > 2 rows.Īlso Google Sheet can show you the number of rows to freeze based on your current position (active cell) in the sheet. To freeze these two rows, I mean to make it say there when I scroll to down the page, just follow the below steps.Ĭlick the very first cell in the third row. In this certain cells in the first two rows are merged. To demonstrate, I am going to use one of my custom heat map file. Freeze Pane to Set as Headers or Page Titles in Google Sheets.