Question

5. Is it possible to freeze the top row? If yes, how?​

Answer 1

Answer:

Freeze the Top Row

Click on the “View” tab, click on “Freeze Panes” and then “Freeze Top Row.” Now when you scroll up and down, the top row stays put. If you want to reverse that, go back to the “View” menu, click on “Freeze Panes” again and select “Unfreeze Panes” to get things flowing back to normal

Answer 2

Answer:

Freeze the Top Row

Click on the “View” tab, click on “Freeze Panes” and then “Freeze Top Row.” Now when you scroll up and down, the top row stays put. If you want to reverse that, go back to the “View” menu, click on “Freeze Panes” again and select “Unfreeze Panes” to get things flowing back to normal.

Sometimes the left column has info that you want visible at all times. This is very straight-forward as well.

Go back to the “View” tab, select “Freeze Panes” and then select “Freeze First Column.”

The above two options work in a perfect world, but sometime the data you need visible on screen all the time isn’t the top row or first column. In some case, you want to freeze multiple rows or columns (or even both).

To freeze several rows, click on the row number below the bottom-most row that you want to freeze. So if you want rows 1-4 to freeze, click on row 5 (the number to the left of the row) to select the entire row:

Say we wanted to freeze the left three columns (A-C) and the top three rows (1-3) so they’d be visible as we scroll through the spreadsheet. To do this, select the upper-left-most cell that you don’t want to freeze. In this case, that would be cell D4. Click once on cell D4, and then head up to the View à Freeze Panes à Freeze Panes menu as before, and you can now scroll around the spreadsheet and those rows and columns will remain visible.

Explanation:

Hope it's helpful for you

↓↓↓↓↓↓↓↓