Leave a Reply

Your email address will not be published. Required fields are marked *

How to Add Checkboxes to Microsoft Excel **New Feature!**

Updated on: Sep 17th, 2024
Data Visualization in Excel
, , , , , , ,
Thumbnail

Did you know… that Excel now has checkboxes?!?

In this video, you’ll learn:

  • how to add checkboxes to your spreadsheet,
  • how much better they look than the “old” way of doing it, and
  • what types of details we can edit (like the checkbox size and color).
https://www.youtube.com/watch?v=QERI7UjYk5A

What’s Inside

  • 0:00 Welcome
  • 0:21 Dataviz On The Go
  • 0:32 How to Add Checkboxes to Microsoft Excel
  • 0:59 The Old Way: Adding Icons (Image Files) One by One, Not Clickable, Yuck
  • 1:36 Another Old Way: Webdings g’s and c’s (Filled Squares and Empty Squares)
  • 2:26 Your Editing Power: Delete, Size, Color, Use in Formulas (“true” = filled in, “false” = empty)
  • 3:21 Conditional Color (e.g., everything is gray, turns green when filled in)
  • 5:34 Colorblind-Friendly & Grayscale-Friendly, hooray!!
  • 7:28 DON’T Transfer to Word/PowerPoint, darn. NO GRAINY SCREENSHOTS!!! Keep ’em in Excel and just PDF your Excel file directly.
  • 8:32 Don’t Forget to Like, Subscribe, and Share

Resources Mentioned

Colorblindness simulation tool: https://www.color-blindness.com/coblis-color-blindness-simulator/

Transcript

Ann K. Emery: [00:00:00] So today I’m here with Do you want to say your name? This is Isla, and she just got home from kindergarten, and you want to make a video together?

Alright, we’re going to show you how to make checkboxes in Excel. They’re pretty new, so you might not have seen them before. Today is the day.

Isla, should we tell them that they’re watching Dataviz on the Go?

And we make YouTube videos for them? To help them with their job and help them save time. Yeah.

So let me show you how you make these because they’re pretty easy. So what you’re going to do is you click on the empty cell where you want to add them. And then you go to insert and they’re there. They’re right there.

So you click on the checkbox box. It adds an empty one and you just drag them down and then you fill them in. Look, when you click on the square, do you know what happens? You get a little check mark like that.

What I used to do [00:01:00] is you would click on the cell, you go to insert, you go to icons. Do you see the little duck I love right there?

And then you’d have to scroll through the whole menu. Uh, if it loads, right? And do you see all these pictures in here? And you could pick one like this that’s kind of similar, right? That one has a circle. And you could add it and you could, this is a new ish feature too, you could place it in the cell, which is kind of nice.

But then you can’t click on it, you know, you get the same end result, but you don’t have the process, the clickable process in it. So that’s all right. That’s kind of the old way.

Um, what I used to do is, Isla, do you know what letter this is? Do you recognize that one? It makes the guh sound. That’s a “g.” I used to do like this, and then do you know that one?

That’s a “c.” Yeah, we were looking, that makes a kuh sound, right, like cat? We were looking at that in your Bob books last night. Okay, what I used to do is I would do g’s and c’s, uh, G for good, [00:02:00] C for, for crappy. We probably shouldn’t say that word out loud though. Um, and then you change them to webdings, if I can type with one hand, webdings, and you sort of, sort of get the same appearance, right?

Do you see how that’s not quite a checkbox? It’s like a filled in square and an empty square. So it’s. Not, not quite as cute. Yeah, it doesn’t have a check. That’s why I like these. They look like checks.

I also like them because, look, you can delete them if you change your mind. You just hit the delete key on your keyboard.

And you can change the size. You can make them like hugely huge. Whoa, too big. Probably we just want them the same size as the font though.

You can change the color. What color should we pick? Like, purple? Green. Green. We can make them green.

And we can also count them up. How many checks are filled in right here? Two. Yeah, exactly. And let’s say you had a really long list and you didn’t want to count [00:03:00] them all because it would just take forever. You could do this formula. You could do COUNTIF. And you could say, I’m going to count this list and I’m going to count the trues. True means filled in, false means not filled in, right? And then you get two to save yourself a little bit of time, right? And make sure you don’t make typos.

I also really like these because they have not just regular color, but conditional color. Conditional color means, you know, you could make them all black, you could make them all green, you could make them all red. But let me, um, let me show you, let me copy and paste these, right? I’m gonna make them all red, right? They’re all just red font. And then I’m going to make it so that when the check is checked, they’re green, right?

Stoplight, red, green. Do you know when we’re driving and we see the stoplight on the street and it’s like, red means, [00:04:00] red means stop. Yeah, you’re right. Um, so red means like, whoa, caution, bad. Everybody kind of understands that in the data world too. Uh, let’s see. Conditional formatting here. Let’s go to. New rule, and let’s say a, which one do we want?

Format cells that contain. And we want it to be a specific text, and if it is a true, then we will set that one to Is it gonna load? Is it gonna load? Let’s try it again. Format. Uh, we want the font color to be green. Okay, so you Yeah, we made it all red, except if it’s checked, it’s green. And then click OK a couple times, and you get the stoplight coding, which is possible, but I think it looks really ugly.

I don’t know. I think that’s like too colorful almost. What do you think? It is Christmas colored, you’re [00:05:00] right. Um, you could also do, you could make it all gray, and that everything’s checked in, then is green. I like this one better, it’s not quite so busy. What do you think? With the gray? You like the first one better?

You like a lot of colors, right? Mommy more likes plain stuff, I guess. We could focus on the checks. We could also focus on the boxes. Which we would do that with, um, I can’t remember. It doesn’t matter. It would be the opposite of what we just did in conditional formatting.

Alright, um, and then another reason I like checkboxes like this is that they are colorblind friendly and they are grayscale friendly.

Even technically this one with reds and greens is colorblind friendly. Um, Isla, do you know what colorblind means? Have you heard of that before? No. I bet some kids in your class may be colorblind. It’s pretty common. It’s like, um, 1 in 12 boys, they don’t see red and [00:06:00] green. Did you know that? They see it as yellow.

I’m going to show you what it looks like if you were colorblind. I’m going to take a little picture of the screen and we’ll put it here. So people wouldn’t see my red and green. No, they wouldn’t see red and green. I’m going to show you what it would look like for maybe, maybe some of the boys in your class, since it’s pretty common.

Let’s go to color- blindness. com. We clicked on color tools, CVD simulator, and we’re going to choose that screenshot that I just put on the desktop. Here it is. Color blind test. And this is what it looks like for me and you, right? We can see like the Christmas colors right here. But if somebody had red green color blindness, they wouldn’t see red and green.

They would see a bunch of yellows. But even though this looks like a bunch of yellows, it’s okay, they can still see [00:07:00] the checks versus the empty. So, so we’re good. They can see, they can see like the, the colored in part, right? Which is nice. Or if you printed this out, does your teacher, your teacher has printouts and worksheets at school, right?

Um, your teacher, to save ink, might print in grayscale sometimes, and this is what it would look like in grayscale. So it’s super colorblind friendly and grayscale friendly. So it gets Ann Approval.

Alright, the only downside to checkboxes is they do not transfer well to Word or PowerPoint. Can you, you want to see what happens if you try to put them into this thing called Word, Isla?

It’s not, it’s not good. It’s not good. They are not gonna show up as well. They’re gonna look like, um, gonna look like much, they’re gonna look like funny little, like, machine rectangles. They are gonna look like, let’s grab, I don’t know, like this one? Let’s say you wanted to copy [00:08:00] it, and you wanted to paste it, and it just looks like trues and falses, which isn’t, that’s not good, right?

That doesn’t look like checkboxes. Or, if you, even if you paste special and you do, like, a picture, um, it just looks, it looks funny. That doesn’t look good, right? And it does the same thing in PowerPoint, it’s just not very good.

So these are really meant to live inside of Excel, okay? Or you can PDF your Excel screen, and then you can share the PDF with your audience that way.

What do you think about checkboxes? Good? Thumbs up?

Do you want to tell them, um, anything at the end of the video? If I can move the mic closer to you? What do you want to do?

All right. Don’t forget to like, subscribe, and share! Bye!

You did great! What do you think of your first video? [00:09:00] Good.

More about Ann K. Emery
Ann K. Emery is a sought-after speaker who is determined to get your data out of spreadsheets and into stakeholders’ hands. Each year, she leads more than 100 workshops, webinars, and keynotes for thousands of people around the globe. Her design consultancy also overhauls graphs, publications, and slideshows with the goal of making technical information easier to understand for non-technical audiences.

Leave a Reply

Your email address will not be published. Required fields are marked *

You Might Like

Our complimentary mini course for beginners to dataviz. Takes 45 minutes to complete.

Enroll

The Data Visualization Design Process: A Step-by-Step Guide for Beginners

Visualizing numbers in charts, graphs, dashboards, and infographics is one of the most powerful strategies for getting your numbers out of your spreadsheets and into real-world conversations. But it can be overwhelming to get started with data visualization. In this step-by-step data visualization guide for beginners, I’ll walk you through the data visualization design process so that you can transform your spreadsheets into stories.

More »

Need practical how-to tips? In this course, you’ll learn how to make great graphs inside software you already have. Includes beginner, intermediate, and advanced tutorials for making charts from start to finish.

Enroll

Subscribe

Not another fluffy newsletter. Get actionable tips, videos and strategies from Ann in your inbox.