Google Sheets: Sort Names Randomly

Use Randomize Range It seems there is a new trick in Google Sheets. When you highlight a range and right click you can choose “Randomize range.” This sorts the selected range in a random order. I used to have to insert a column, type the formula =rand()...

Add Bitmoji to Your Google Sheets

In Google Docs and Slides you can DRAG Bitmoji from the Chrome extension right onto the document. Not true for Google Sheets. Insert Drawing One way to add Bitmoji to your spreadsheet is to use the Insert menu and insert a drawing. You can then DRAG your Bitmoji right...

TemplateTab: Reuse Template

Reuse Your TemplateTab Template I am always tweaking my TemplateTab Add-on. TemplateTab allows you to use ONE spreadsheet with your entire class. Instead of 30 documents to open, you have one. Students can crowdsource and learn from each other. I use it a lot. I have...

It’s Summer – Make a Word Search

Have Some Fun, Make a Word Search As many of you know I am highly critical of busywork, low critical thinking, low learning activities for students. Word Searches are not learning activities. However, they are fun activities. Save yourself some money from buying a...

Google Sheets: Capitalize Text

Capitalize Your Text in Google Sheets Sometimes you need your text in capital letters (or all lowercase). If your information is in a spreadsheet you can use formulas to make your text in uppercase (or lowercase). =UPPER() In a spreadsheet cell type =UPPER( and click...
Page 2 of 3712345...102030...Last »