Teacher Tech

Paperless Is Not A Pedagogy

Menu
  • Teacher
    • Blog Posts
    • Teacher Tech Facebook Group
  • Google Certified Innovator
    • CoffeeEDU
    • Tour of Google Classroom
    • Back to Classroom
  • Author
    • Alice Keeler Books on Amazon
    • Bulk Order Books
  • Developer
    • Schoolytics
    • Google Developer Expert
    • Add-ons By Alice Keeler
      • Doc to Slides by Alice Keeler
      • Roster Extras by Schoolytics
      • TemplateTab
      • toTabs
      • Form Printer
      • Quiz Helper
      • Dice Slides by Alice Keeler
      • Scheduler by Alice Keeler
      • Document Outline by Alice Keeler
      • Missing From (Google Forms™)
      • Randomize Slides by Alice Keeler
      • Speaker Notes by Alice Keeler
      • sheetPusher
      • Seating Chart Slides
      • Hyperlink Slides Choice Board
      • Add-a-Date
      • QuickShare Screenshot
      • Anyone Can View
      • Drive 20
    • Apps Script Tutorials
    • Templates
  • EdTech Coach
    • Premium Membership
    • Free Newsletter
  • Hire Alice
Menu

3 Tricks in Google Sheets to Try

Posted on October 7, 2015May 29, 2018 by Alice Keeler

3 tips for Google sheets

Here are 3 tips for Google Sheets you may not know.

1. Set Word Wrapping

In particular when students submit a response in Google Forms, the text is not word wrapped in the cell. Look in the toolbar for an icon with 2 lines and an arrow sticking out of the lines. This shows that your cell formatting is “overflow.” Meaning, if the cell next to the cell is empty, the contents of the cell will overflow into the next cell. In general, this drives me crazy.
Word Wrapping

Select the cell, or range of cells, and click on the little arrow next to the overflow icon. The 3 choices are: overflow, word wrap, and clip. Word wrap will wrap the text in the cell. You may want to make the column width wider to accommodate the cell showing all of the text. The clip option restricts the text to the cell but does not word wrap. The full content of the cell is still there; however, the end of the text string is not visible.

2. Protect Range

One of my favorite activities is to use collaborative Google Sheets for a class discussion. The problem is that students sometimes accidentally delete my question on the sheet. In any situation where I create a graphic organizer, I want to prevent students from editing the column headers or other elements in the sheet.

Select the cell or range of cells you do not want students to be able to edit. Right click and choose “Protect range.”
protect range

You can define who has editing access of those cells. I usually choose “Only me.”

In a collaborative spreadsheet I will on occasion go in and protect the range of some of the student responses to prevent other students from accidentally deleting or editing peer responses.

3. Hide Columns

When I have a spreadsheet that contains student names I will want to hide these names before I show the spreadsheet to others or project responses to the class. Select a column or range of columns. Right click over the column indicator or find the arrow in the column indicator of the column you wish to hide. Choose “Hide column.”
Hide Column

Related

Related Alice Keeler Blog Posts:

  1. Google Sheets: Students Protect Their Work
  2. Measurement Activity: Google Sheets for Littles
  3. Google Sheets: Create A Student Response Box
  4. Google Sheets: Split Text to Columns

Continue Reading

Next Post:
3 Tricks in Google Slides to Try
Previous Post:
Google Classroom + Google Forms = Magic

2 thoughts on “3 Tricks in Google Sheets to Try”

  1. Pingback: 3 Tricks in Google Sheets to Try | Teacher Tech #f… | EducatorAl's Tweets
  2. D Tisdale says:
    October 7, 2015 at 7:15 pm

    Ahh! Word wrapping! I was just wondering about that (again!) this week. Perfect timing. Thanks!

    Log in to Reply

Leave a Reply Cancel reply

You must be logged in to post a comment.

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Alice Keeler is a mom of 5. Current High School math teacher. Developer for Schoolytics.com. Google Certified Innovator, Microsoft Innovative Educator, Google Cloud Innovator Champion, and Google Developer Expert. Founder of #coffeeEDU
Teaching with Google Jamboard
Developer Schoolytics
Schoolytics is FREE for teachers.

Find ALL My Blog Posts


Link to List

Google Classroom Books

Alice Keeler: Mom of 5. Current High School math teacher. Developer for Schoolytics. Founder #coffeeEDU. Google Certified Innovator. Microsoft Innovative Educator. Google Developer Expert. EdTech Specialist.

My Referral Links


Custom Stickers, Die Cut Stickers, Bumper Stickers - Sticker Mule

 

©2022 Teacher Tech | Theme by SuperbThemes