A client wants to know how to insert checkmarks into a spreadsheet for printing only.
Transcript of the video:
MrExcel podcast is brought to you by ”Easy-XL”!
Hey, welcome back to the MrExcel netcast, I'm Bill Jelen.
I want to send a big thank you out to everyone who saw yesterday's podcast and voted.
I want to send a big thank you to all of my Australian customers who put up with me at 9PM, three hours before the deadline, spamming them and asking them to vote.
It was neck-and-neck, I pulled ahead of Dan English around 6 o'clock yesterday, Dan did pull ahead though, so congratulations to Dan with his BI Conference Flight Analysis.
You should go out to Alpha Geek Challenge and check this out, of Excel guys, under this contest, Tushar Mehta took 17 million census records through PowerPivot and created this gorgeous map.
I still don't know how he did it, I'm begging Tushar to tell me.
And then I also took data through PowerPivot, created a tag cloud and interactive SmartArt, you know.
So PowerPivot is an interesting product it’s, SQL Server analysis guys and Excel guys that are interested in this product.
The SQL Server analysis guys are, you know, they know SQL Server really well, the Excel people are taking Excel and stretching it to the limit.
So go check out Tushar’s Visualization there, and mine if you haven't seen it.
Again, thanks everyone who voted, and congratulations to Dan on winning that, it was just a lot of fun to try, got to reconnect with some folks yesterday.
Margaret happened to call the office last night, I was there late trying to try to drum up some votes in.
Margaret said “Hey, I got this project for this, my managers drive me crazy, I need to show check marks!” And check marks are really, really hard to do in Excel, really hard to do, especially if you want to be able to check them on and off.
But Margaret just wants to be able to print the check marks, and I have a great solution for that.
So, here's what we're going to do, we're going to choose this data where the check marks are going to be and, we're going to put capital R, we're going to put capital R’s there.
We'll make those large, let's go about 24 points, and we're going to center them and center them.
Alright, and then we're going to go into the font drop-down, and all the way at the bottom you have a fun called Windings 2, really important they use Wingdings 2, and check that out!
Wingdings 2, the R character is a checkmark, and let's see, right before R is Q. Right, so Q is really nice X, so you can create a great visualization that has check marks and X’s just by using that font.
Now Margaret called me back about two minutes later, she's like “Oh my gosh, it quit working, all of a sudden I started getting 9’s!” Now you have to be really careful with that Q and the R, because if you type a lowercase Q you get an 8, and a lower case R you get at 9.
So you almost want to turn on the Caps Lock when you type your Q’s and R’s to make sure that that works.
So there you go, very easy trick after all of these hard PowerPivot podcasts we've done recently.
Want to thank you for stopping by, we'll see you next time for another netcast from MrExcel!
Hey, welcome back to the MrExcel netcast, I'm Bill Jelen.
I want to send a big thank you out to everyone who saw yesterday's podcast and voted.
I want to send a big thank you to all of my Australian customers who put up with me at 9PM, three hours before the deadline, spamming them and asking them to vote.
It was neck-and-neck, I pulled ahead of Dan English around 6 o'clock yesterday, Dan did pull ahead though, so congratulations to Dan with his BI Conference Flight Analysis.
You should go out to Alpha Geek Challenge and check this out, of Excel guys, under this contest, Tushar Mehta took 17 million census records through PowerPivot and created this gorgeous map.
I still don't know how he did it, I'm begging Tushar to tell me.
And then I also took data through PowerPivot, created a tag cloud and interactive SmartArt, you know.
So PowerPivot is an interesting product it’s, SQL Server analysis guys and Excel guys that are interested in this product.
The SQL Server analysis guys are, you know, they know SQL Server really well, the Excel people are taking Excel and stretching it to the limit.
So go check out Tushar’s Visualization there, and mine if you haven't seen it.
Again, thanks everyone who voted, and congratulations to Dan on winning that, it was just a lot of fun to try, got to reconnect with some folks yesterday.
Margaret happened to call the office last night, I was there late trying to try to drum up some votes in.
Margaret said “Hey, I got this project for this, my managers drive me crazy, I need to show check marks!” And check marks are really, really hard to do in Excel, really hard to do, especially if you want to be able to check them on and off.
But Margaret just wants to be able to print the check marks, and I have a great solution for that.
So, here's what we're going to do, we're going to choose this data where the check marks are going to be and, we're going to put capital R, we're going to put capital R’s there.
We'll make those large, let's go about 24 points, and we're going to center them and center them.
Alright, and then we're going to go into the font drop-down, and all the way at the bottom you have a fun called Windings 2, really important they use Wingdings 2, and check that out!
Wingdings 2, the R character is a checkmark, and let's see, right before R is Q. Right, so Q is really nice X, so you can create a great visualization that has check marks and X’s just by using that font.
Now Margaret called me back about two minutes later, she's like “Oh my gosh, it quit working, all of a sudden I started getting 9’s!” Now you have to be really careful with that Q and the R, because if you type a lowercase Q you get an 8, and a lower case R you get at 9.
So you almost want to turn on the Caps Lock when you type your Q’s and R’s to make sure that that works.
So there you go, very easy trick after all of these hard PowerPivot podcasts we've done recently.
Want to thank you for stopping by, we'll see you next time for another netcast from MrExcel!
