When it comes to education, Google provides a lot of useful programs for teachers. However, not everyone understands just how to use them. For Google Sheets specifically, there are a lot of hidden features available for teachers. To help you create better documents in less time, understanding how to use these features and apply them in the classroom is essential. Here are the most basic Google Sheets tips that every teacher should know about.
Use a Formula
You can enter a formula to keep you from pulling out the calculator and avoiding doing all of the math with your data. Type in the equal sign with the function you want to use in a cell. It will prompt a separate help box to pop up that gives you the list of available functions, the wording, and an example of how to use each of them.
Select the cell if you want to wrap the text in your spreadsheet. Click on the format tab to bring up a list of options, select text wrapping and then click “wrap.” To turn it off, follow the same steps but select a different final option.
Protect a Sheet or Range
Protect your spreadsheet from external edits with this nifty tip. Open up your spreadsheet and go to the data tab. There will be an option for protected sheets and ranges. After you click here, a separate box will appear asking if you want to add a sheet or range to your protection. Select the appropriate options and finish by following the prompts to set permissions or change permissions. Once done, save your work.
Add a Custom Date or Time
Highlight the data you want to convert to a specific date or time formula and head to the format tab and click on “number.” For further formatting, there is another option for “more formats” and then “more date and time formats.” Suit your style or set your own custom date and time format into the search box. Click apply to make it stick.