Keyboard Shortcuts for Bullets & Numbering

Sometimes, I think a trick, hack or shortcut that I do with technology is unimpressive and something that everyone either knows or doesn’t care about.  But then, when I mention it to someone, and they’re like “Whoa!” I think “Welp, this should be an EduGIF.”

Recently, I had the good fortune to be recording a guest appearance on the Shukes & Giff Podcast (er, maybe it’s the Shukes & Jake Podcast, now!? Kidding!).  When I was chatting about Emoji Bullets with Kim Pollishuke (a.k.a. “Shukes”), I mentioned, “So, I’ll just click Shift+Command+8 and then…” and she said “Wait, What!?”  And then I knew it, EduGIF time.  So here it is . . .

in most Google Tools:

  • Click CTRL (Command on Mac) + Shift + 7 for Numbering
  • Click it again to undo numbering
  • Click CTRL (Command on Mac) + Shift + 8 for Bullets
  • Click it again to undo bullets

Here’s the EduGIF!

Shortcuts for Bullets and Numbering GIF

Tab-Level Edit Rights in Google Sheets

In Episode 50 of the Google Teacher Tribe Podcast, Bailee Sandsmark, a 6th-grade middle school PE teacher, asked a Google Sheets question that got my gears turning.  All that gear turning inspired a new #EduGIF from me.  First, let’s look at her question:

I’d like to send out a Sheets template to all 250 of my students for them to individually track their fitness testing data, but then I would like to have an efficient way for them to share that info with me so that I can see all of my students’ data in one sheet. Having to access 250 different sheets makes my head spin…

While Matt & Kasey had a handful of good ideas of their own, I had another one that I wanted to share.  It came from a thought that Matt shared: it’d be nice to give each student a tab in one spreadsheet, but then each student could edit the others’ tabs.  That’s where “tab-level permissions” comes into play.  If you click on the tabs at the bottom of your Google Sheet, there’s a Protect Sheet option.  It’s also accessible from under Tools.  As you’ll see in the Animated GIF below, you can use this to give tab-level edit rights to specific students.

Before we get the GIF, a few notes:

  • If each tab will be identical, you can duplicate the tabs.
  • If you’d like to create a tab for each of your students, you can use Alice Keeler’s Template Tab add-on.
  • You can also use this to give or limit edit access for just specific cells – I do this sometimes to make sure no one messes up formulas that I have running.
  • In Bailee’s, situation, she’ll still have the issue that each student can see their classmate’s information (even though they can’t edit it).  To prevent this, you could give them code names or numbers.
  • The tabs that we’re referring to are technically called sheets, but I think that’s super confusing that the individual parts of Google Sheets are Sheets.  What!?

And finally, the GIF:

Tab-Level Edit Rights in Google Sheets Animation