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.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s