Google Sheets Tip #2

Hi All!!

I'm back again with another Google Sheets tip today.

• Do you have to deal with huge amounts of data? 
• Do you lose track of the headers as you scroll down the sheet?

I had similar problems, especially when dealing with student grades and ,marks. Is there a solution to the problem? Yes there is!

1. Select the row/s you want as your header.
2. Click on VIEW
3. From the Dropdown Menu select FREEZE
4. From the side menu select UP TO CURRENT ROW
5. Your header wont budge as you scroll down the sheet

Is left to right scrolling a problem too? Are you loosing your horizontal reference points?

1. Select columns you want as a constant
2. Click on VIEW
3. From the Dropdown Menu Select FREEZE
4. From the side menu select UP TO CURRENT COLUMN
5. Your Reference points wont budge as you scroll left to right!

More next time!