I'm working with several people whom are dealing with very large spreadsheets right now. Unfortunately it took me too long to realize that they were unaware of this very useful Sheets feature - the ability to freeze some of the rows and columns so they could always view (in their case) the student names in the first column, and the data fields in the first row.
Here is a spreadsheet with some sample data. I want to always see the top row (Row 1) and the first column (Column A) -
Go to the View menu, mouse over the first option of Freeze, and you get a pop-up that shows your choices for freezing rows and columns -
The options 1 row/column and 2 rows/columns are available as they are the most common needs. But occasionally you need more than that, so there is the customizable option of Up to the current row/column - this is based on the cell you current have active (selected) on the spreadsheet.
Once you select what you want to freeze, a think gray border line appears where you have frozen it. As you scroll through the data, those items will remain on the screen -
