1. The first step is to open your Google Sheets, and if you have to scroll down (or across) to see all of your data, your Sheet is a good candidate to freeze some rows or columns.

2. See, by scrolling down, we lost the ability to see our header row. 

Let's Scroll up to the header row to fix that.

3. Click on the header row's first cell to select that row.

4. Click View.

5. With your mouse, Hover over Freeze.

6. Click 1 row.

7. Now when you Scroll down...

8. Your header row still shows.

9. If instead you want more than one row to show when you scroll down, Click in the first cell of the last row you want to freeze.

10. Click View.

11. Hover over Freeze, and Click Up to row 3, which in this example is the last row we chose to freeze.

12. The gray line under row 3 shows where the frozen rows end.

13. You can also freeze columns.

Click into the first cell of the column you want to freeze.

14. Click View.

15. Click 1 column.

16. The gray line now separates the frozen column from the other columns so that when you Scroll back and forth through your data, the frozen column still shows.

17. You can also freeze multiple columns.

Click the top cell of the last column you want to freeze.

18. Click View.

19. Hover over Freeze, and Click Up to column C, which in this example is the last column we chose to freeze.

20. You can see the gray line ends after Column C, so columns A, B, and C are frozen, and will show when you Scroll back and forth through your data.

21. That's it. You're done.

Interactive tutorial