Ed Tech Tips with E. Mosier
Make your classroom more E-fficient!
Easily Navigating Google Sheets
Overview
Admittedly, the Google tool that I have the least experience with is Google Sheets. It is a great platform for analyzing data, sorting data, and developing a clean organization of information. There are countless formulas, tips and tricks to use with Sheets. However, through trial and error, and patience, I have found a few tips and tricks that are quite useful when using this tool. Below are a few easy and efficient tips and shortcuts you can try the next time you utilize a Google Sheet.
Simply Sorting Data
Freeze a Row or Column
In Sheets, the ability to freeze a row or column of cells can be really beneficial. To do this, highlight the row or column you would like to freeze, then head up to View > Freeze, and you're able to select whether you would like to freeze, 1, 2, or more rows or columns. However, a tip I have learned about it so much easier. If you hover above the row you would like to freeze, you should notice the "hand" icon appear. Click and hold that down, then drag to which rows you would like to freeze. Let go of the mouse button, and voila! Rows and/or columns are easily frozen in place for easy viewing.
Linking in a Google Sheet
Inserting an Image
The option to insert an image, whether it be a logo or basic image, is another appealing feature when creating a Google Sheet. Of course, there is the option to cut and paste an image onto a Sheet and then move it around. However, the ability to insert an image from the web directly into a cell is an even more advanced trick! In order to do this, click on the cell where the image is desired to be placed. Then, type in the following formula: =IMAGE("PASTE IMAGE URL HERE"). Then hit Enter. The image will appear in the selected cell. If you desire to increase its size, highlight a few cells, merge them, and your image can be whatever size you wish!
Protected Sheets
Sharing a Google Sheet is an awesome way to foster collaboration. But, what if you don't want them to have access to the other tabs to change what's already been completed? The ability to Protect Tabs is the solution. In the Tools menu, you will notice that you have the option to "Protect Sheet." This allows for you to determine which sheets are able to be accessed and by whom when you're working together on a Google Sheets project.
Contact Mr. Mosier!
Email: mosiere@davenportschools.org
Website: www.davenportschools.org/sudlow
Location: Sudlow Intermediate School, East Locust Street, Davenport, IA, United States
Phone: 563-445-5150
Twitter: @emosier3