Google has started rolling out Google Sheets Formula Suggestions which automatically suggests formulas based on the entered data, Here's how you can use them.

To lock one or more cells in Google Sheets when scrolling, you will have to go to View more cell action > Protect Range > Set Permissions.

New to Google Sheets? This guide walks you through the basics of how to use Google Sheets, from creating a new sheet to entering and formatting data.