Check Marks in Excel - Podcast 1180

If you like this content, please consider visiting the video on YouTube and subscribe to the MrExcel Channel to show your support!
This video has been published on Feb 24, 2010.
A client wants to know how to insert checkmarks into a spreadsheet for printing only.
maxresdefault.jpg


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!
 

Forum statistics

Threads
1,213,551
Messages
6,114,266
Members
448,558
Latest member
aivin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top