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

3. The double-click to fill down trick

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!

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 @karlymouraSean Fahey @seanjfaheySandy Otto @sandyrottoRachel Marker @rachelmarkerEvan Mosier @emosier3Mandi Tolen @TTmomTTCraig Klement @craigklementTara Martin @taramartineduKrista Harmsworth @zonie71Anne Kamper @annekamperRayna Freedman @rlfreedmLance McClard @drmcclardStephanie DeMichele @sdemichele or David Platt @herrplatt!


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

Are you looking for quality, meaningful professional learning that both equips and inspires teachers?

Matt provides in-person and virtual keynotes, workshops and breakout sessions that equip, inspire and encourage teachers to create change in their classrooms. Teachers leave with loads of resources. They participate. They laugh. They see tech use and teaching in a new light. Click the link below to contact us and learn how you can bring Matt to your school or district!

Is Matt presenting near you soon? Check out his upcoming live events!

Explore The DTT Blog

FREE teaching ideas and templates in your inbox every week!
Subscribe to Ditch That Textbook
Love this? Don’t forget to share
  • t tom says:

    How to open a Google Sheet to a cell where you left off working.

  • […] Here are 10 Google Sheets tricks you (probably) don't know about […]

  • >