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