Google Sheets

Fun with Google Sheets, Part 2

I am back with another installment of Fun with Google Sheets. Let’s dive in.

You can also visit Part 1 here.

Drop Down Menus

I use this when I’m creating my own data sheets but you could also create this in an activity because conditional formatting will still work with it.

Select the cell to place the drop down menu.

Click Data and then Data Validation.

Under criteria, select list of answers.

Type in your selection with commas between.

Click save

Conditional Formatting

This is my 100% absolute favorite thing to do in Google Sheets. It’s so simple and makes you look like a rock star. I use this in my data tracking sheets with students and the many activities I create from escape room to pixel art.

Insert Images

When Google updated Sheets to include images in cells, I was so excited. Prior to that, the image just floated over the cell and it was somewhat clunky! Now you can do both. I use this with activities, escape room, and the it was very handy for the surface area and volume calculator I created.

Now go have some fun with Google Sheets. I will be sharing more Fun with Google Sheets in the coming weeks.

Google Sheets

Fun with Google Sheets -Part 1

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.

Checkboxes

-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.