Note that the number in brackets after Up to current row reflects the current row selected. To freeze more than one row in Google Sheets, you can select either 2 rows to freeze the top two rows, or Up to current row (row) to freeze up to the row that you have selected. In the Menu, click View > Freeze > 1 row.Īs you scroll down, the top row remains in place.Ĭlick View > Freeze > No rows to remove the freeze. To remove the pane freeze, select Unfreeze Panes from the Freeze Panes menu. If you scroll down, these rows will remain in place. ![]() In the Ribbon, select View > Freeze Panes > Freeze Panes. ![]() Position your cursor in the row you wish to freeze. You might want to freeze more than one row. ![]() In the Ribbon, select View > Freeze Panes.Īs you scroll down in your worksheet, you will see that the top row remains visible regardless of how far you scroll down. In a large worksheet with headings, you might want to make sure that the top row repeats when scrolling, so you can always see it. This tutorial will demonstrate how to make the top row stay visible in Excel and Google Sheets.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |