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.
3. The double-click to fill down trick
A1; my other favorite thing to do is lock sheets or cells so students can’t change what I’ve written, but they can add to it! #DitchBook— Krista Harmsworth (@zonie71) May 10, 2019
A2: My favorite Google Sheets tricks are setting up check boxes and using data validation to create drop down menus within cells. These are great to know tricks for setting up a sheet as a rubric. #DitchBook— Nicholas Taylor (@n_taylor05) May 10, 2019
A2: My absolute new & fav trick in Google Sheets is using macros to run the same set of steps on all my sheets as I ran on the 1st sheet all in 1 little Click. You have go to try Record & Run a Macros! 💥 #ditchbook pic.twitter.com/FjIZNF79j9— Vicki (@33heupel) May 10, 2019
*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!
Also learned to use the $ sign in front of the column or row to lock the formula so it doesn’t change.— Dr. Lance McClard (@drmcclard) May 10, 2019
Want to get in on the next #DitchBook Twitter chat?
- They happen every Thursday at 7 p.m. Pacific / 8 p.m. Mountain / 9 p.m. Central / 10 p.m. Eastern.
- They often run for 30 minutes. Many times, moderators will offer bonus questions for those that want to continue chatting.
- Check out what’s happening on the #DitchBook Twitter chat by clicking here. (Even if you don’t have a Twitter account!)
- New to Twitter? Want to know the basics? Check out our Beginner’s Guide to Twitter for Educators free ebook.
- Want to sign up for Twitter? Here are the directions.
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!