10 Google Sheets tricks you (probably) don’t know about

#DitchBook Twitter chat

#DitchBook Twitter chat | Friday, May 10, 2019

10 Google Sheets tricks you (probably) don’t know about

Google Sheets can be used in so many different ways and for so many different purposes. Here are 10 Google Sheets tricks plus a bonus collection of 30 ideas for using Sheets in the classroom.

Google Sheets might look a little scary and a bit threatening at first glance but once you take the time to unlock its secrets you’ll discover that it can do so much more than just crunch numbers.

So how can we get started using Google Sheets ourselves? And what are some great Google Sheets activities that we can use with our students?

During our weekly #DitchBook Twitter chat (Thursdays at 7 p.m. PST / 8 p.m. MST / 9 p.m. CST / 10 p.m. EST), hosted by Craig Klement, we discussed these questions and more. We even had some Google Sheets gurus stop by the chat to drop their knowledge and share some ideas for unlocking the power of Sheets!

Educators shared tons of great tips and tricks to help you get started using Sheets along with ideas for using them with your students. In addition to the 10 tricks you will find below we also curated the resources shared for using Google Sheets in the classroom. Be sure to check out this copyable Wakelet to see 30 ideas for using this versatile G Suite app with your class!


10 Google Sheets tricks you (probably) don’t know about

Click on the numbered subtitles for links to tutorials, videos, or blog posts.

1. Use RANDBETWEEN to make random writing prompts

2. Use the Glide app to create an app from a Google Sheet

3. The double-click to fill down trick

4. Save time with keyboard shortcuts

5. Keep sheets and cells protected

6. Create a drop-down menu

7. Summarize large amounts of data with pivot tables

8. Automate tasks with macros 

9. Use the $ sign to lock a formula

*Lance learned this tip from Jake Miller’s GIF-a-Day Google Sheets Ninja Level 1 course. Fill out this form to get on the list for the next session coming up soon!

10. Use conditional formatting for self-checking assessments

Want to get in on the next #DitchBook Twitter chat?

Having trouble? Still unclear on how a Twitter chat works? Feel free to tweet to these #DitchBook ambassadors and they’ll help — Karly Moura @karlymoura, Sean Fahey @seanjfahey, Sandy Otto @sandyrotto, Rachel Marker @rachelmarker, Evan Mosier @emosier3, Mandi Tolen @TTmomTT, Craig Klement @craigklement, Tara Martin @taramartinedu, Krista Harmsworth @zonie71, Anne Kamper @annekamper, Rayna Freedman @rlfreedm, Lance McClard @drmcclard, Stephanie DeMichele @sdemichele or David Platt @herrplatt!

For notifications of new Ditch That Textbook content and helpful links:

Interested in having Matt present at your event or school? Contact him by e-mail!

Matt is scheduled to present at the following upcoming events:

[getnoticed-event-table scope=”upcoming” max=”15″ expanding=”false”]

Ready to take your tech skills -- and student learning -- to another level?
Sign up for Tech to Learn online course! Just $49
Love this? Don’t forget to share
  • […] Here are 10 Google Sheets tricks you (probably) don't know about […]

  • >