How to Freeze a Row in Google Sheets

0:00 So you're in your Google Sheet and you're scrolling up and down and you want to freeze a row. This is your header row here and you want to freeze that. I'm going to show you a couple ways how to do that. You can go up to view, freeze , one row. Absolutely you can do that. Let's undo that. But also right here between the A and the 1, where your cursor turns into a hand, you can click and drag that down and that also freezes the row. I think that's a pretty cool way to freeze a row because you can always click and drag it however many down you want. Do you want to show you one interesting thing is once you freeze a row and you want more rows in your header, you can insert a row above and If you insert a row below it will enter it Underneath the freeze row that's freeze area. It'll have the same formatting but if you want to move that again, you How to Insert Multiple Rows in Google Sheets (Easy to Hard) Absolute Basics of Google Sheets How to UnFreeze Columns in Google Sheets

0:45 can just go over to this hand and move it or Go back up to view freeze And you see, it says up to row 2. That's where our cursor is. So let's select row 3, view, freeze , and now it says up to row 3. So now you can select pretty much any row and freeze it. But once you freeze too many rows, you see it says the current window is too small to properly display this sheet. Consider resizing your sheet. We could undo the freeze, or You might just have to zoom out a little bit. And then we can view, freeze, up to row 15, and we don't have that error message. There you go. That's how to freeze a row. If you want to get more out of Google Sheets than you ever have before, consider subscribing here on BetterSheets on YouTube. How to Merge Cells in Google Sheets Spreadsheets Explained over 5 Levels of Difficulty How to UnFreeze Columns in Google Sheets

1:31 Please do, it really helps.