The menu options have changed. You can still create a Google Form from a spreadsheet.
Search Results for: sheets
The menus have changed for Google Sheets. There is a new Extensions menu and the Add-on menu is OUT.
Automate tasks you do in Google Sheets, Docs, Slides, Forms, etc… Setting a trigger is the easy part!
ELA teachers here are 4 tips to help you love spreadsheets for your class.
Break up student names written as Last, First into two columns.
Install Add-on TemplateTab TemplateTab is a Google Sheets Add-on that allows you to duplicate a graphic organizer within a spreadsheet for every student on your roster. Hack TemplateTab Hack TemplateTab to simply create a lot of tabs quickly. Add-on Menu After installing TemplateTab you will find it permanently installed in the Add-on menu. Meaning it is available in any spreadsheet.… Read More »Make Tabs FAST in Google Sheets
Google Sheets is great for creating a checklist in. You can share the spreadsheet with others to check off tasks. You can sort and filter your checklist. I created template that allows you to create your checklist and when you check off the items the checkbox turns green and the item on the sheet greys out. Template
This week I was asked…. when you need to go back to a cell, how do you edit the cell so as to not have to start over? Single Click to Replace Cell Text When you click on a cell and start typing it will override what is in the cell. Use Control Z to undo if you did not… Read More »Google Sheets: Edit in the Cell
It’s my birthday and everyone knows no one loves a spreadsheet more than I love a spreadsheet! Here are 5 things you can do with a spreadsheet that will save you time! 1) Automatic Numbering Spreadsheets recognize a pattern. Highlight the pattern and grab the fill square to drag the pattern. The fill square is the small square in the… Read More »5 Time Saving Tips for Teaching with Spreadsheets
Math facts for many students, including myself when I was in elementary school, is anxiety producing. A worksheet filled with 30+ problems is hardly engaging either. A focus on number sense and viewing math as patterns helps students to get into math rather than fear it. “Sometimes we focus on memorizing math facts instead of understanding math facts” – Geoff… Read More »Math Facts Without Worksheets
I had a request by a premium member that they had one Google Sheets spreadsheet with a tab per teacher to keep track of the daily contacts with students and parents. She wanted to add a column each day with the date to each of the sheets for the spreadsheet. Authorize the Add-on After making a copy of the spreadsheet… Read More »Push a Column to Each Sheet in Google Sheets
It is easier to use rubrics in Google Classroom with Google Sheets. Try out my free templates!
In my Intro to Google Sheets spreadsheets webinar I showed 6 key skills that you need for teaching with Google Sheets spreadsheets. One of the things we covered in the webinar is how to create a seating chart using Google Sheets. Resize the Cells To the left of the column indicator A and above the row indicator 1 is the… Read More »Begin with Google Sheets: Make a Seating Chart
My favorite part of Google Sheets is inserting checkboxes! WICKED USEFUL FOR TEACHERS! My daughter is helping me with my YouTube thumbnails (check out her handiwork and subscribe to my channel 🙂 She is using a Google Sheets spreadsheet to keep track of how many thumbnails she creates for me, and I’m paying her. She made a list of checkboxes… Read More »Count Up Checkboxes in Google Sheets
Today someone asked me if they could hyperlink parts of the text within a cell in Google Sheets and I responded with no. Literally minutes later I was editing a spreadsheet cell that happened to have a hyperlink in the cell and all of a sudden the link became live. I think my eyes literally bugged out of my head… Read More »??Google Sheets Multiple Hyperlinks in the SAME Cell