Click and drag the border up or down according to your needs.You can move this border manually to readjust the rows you would like to keep static. Once any row or set of rows has been frozen, a thick, grey border will appear separating the frozen rows from the non-static portion of the sheet.
Click on the row number along the left-hand side.If you want to freeze rows further down the spreadsheet: 2 Rows: If you want to freeze up to two rows (both row 1 and 2), select “2 Rows.” This is a good option for those who have merged cell headers.1 Row: If you want to freeze one row, select “1 Row.” This is a good option for those who have a simple header.From here, you will click on the Freeze option.The feature does not rely on populated cell data to work. Even before you fill in your spreadsheet you’ll be given three different freeze options.
Now with that little disclaimer, let’s get to showing you how to freeze rows on Google Sheets! Using the Freeze Rows Feature You can always undo any freeze/hide later on.
If there is important information on a non-consecutive row that you need to see, you’ll have to freeze up to that row and hide the rows before the desired one. If You Want to Isolate a Non-Consecutive Row This makes the feature a bit more limited than what you would find in a program like Microsoft Excel. For instance, you can freeze rows 1-4, but you cannot freeze row 4 on its own. However, when it comes to the “freeze” feature, the simplicity may prove a bit limiting to some more advanced users.Īs of now, Google Sheets only allows you to freeze rows that appear consecutively from the top down. Google Sheets is known for simplifying spreadsheet tasks and doing a good job at keeping up with some more of the advanced features Excel users have come to love. If You Want to Isolate a Non-Consecutive Row.