After my post last week with my Groundhog activity (Pixel Art) I had some questions about how to use Google Sheets. I decided to do a little series about some basics in Google Sheets. This will be the first post about some fun tips and tricks I use. I am not a Google Sheets “Expert”. I’m just a teacher who will play with tools and learn some stuff.
-Click on the cell(s) you want the check box.
-Click INSERT and select
If you want the user to have the option to select something in the spreadsheet, check boxes might be what you are looking for. I have used this with students when they self-check standards or topics as they review. You can also use response validation but I like to have my students self-reflect on what they feel like they can do.
Return INSIDE a cell
on a Mac: Command + Return
on a PC: Alt + Enter
I know when I figured out you could do this my mind was blown. How many times have you wanted to start a new line but inside the same cell? For me it was A LOT!
Turn off Grid Lines
Have you ever created a really cool spreadsheet but you wished you couldn’t see the gridlines to make it look more like a document? You can quickly and easily turn off the gridlines and achieve that look. Any borders or cell shading you’ve placed on the cells will remain.
Go to View then unclick Gridlines
Check back in the next few weeks for more fun with Google Sheets.