PC Review


Reply
Thread Tools Rate Thread

How do I insert a checkmark into an excel spreadsheet?

 
 
=?Utf-8?B?QmFyYg==?=
Guest
Posts: n/a
 
      27th Jan 2006
How do I insert a checkmark into an excel spreadsheet? The shortcut does not
work using the ALT+0252.
 
Reply With Quote
 
 
 
 
Doug Kanter
Guest
Posts: n/a
 
      27th Jan 2006

"Barb" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> How do I insert a checkmark into an excel spreadsheet? The shortcut does
> not
> work using the ALT+0252.


If I recall, those shortcuts only work if you use the numeric keypad to
enter them, not the numbers across the top of the main keyboard area. If
you're already doing this, make sure the cell is formatted with a font which
actually contains the checkmark symbol. Wingdings is one of those fonts.

Here's a foolproof method, although it's a bit convoluted:

1) Click Start, Run, and enter charmap. At the top, switch to the Wingdings
font.

2) Scroll down to the end and you'll see a checkmark symbol. Click it, then
click the Select button, and finally, click the Copy button. The symbol is
now on the clipboard.

3) Go back to your Excel sheet and paste where you want the symbol. It will
not appear correctly until you change the font in that cell to Wingdings.


 
Reply With Quote
 
 
 
 
neopolitan
Guest
Posts: n/a
 
      27th Jan 2006

Try Insert>Symbols and then pick the WingDing font and highlite the
check mark symbol and click on Insert.


--
neopolitan


------------------------------------------------------------------------
neopolitan's Profile: http://www.excelforum.com/member.php...nfo&userid=611
View this thread: http://www.excelforum.com/showthread...hreadid=505704

 
Reply With Quote
 
=?Utf-8?B?U2xvdGg=?=
Guest
Posts: n/a
 
      27th Jan 2006
ü - checkmark - enter with ctrl+:,u
û - matching x - enter with ctrl+^,u

You can also copy and paste them. Change the font to wingdings to get the
marks to look like a checkmar and an x.

"Barb" wrote:

> How do I insert a checkmark into an excel spreadsheet? The shortcut does not
> work using the ALT+0252.

 
Reply With Quote
 
Bob Phillips
Guest
Posts: n/a
 
      27th Jan 2006
Letter a, marlett font.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Barb" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> How do I insert a checkmark into an excel spreadsheet? The shortcut does

not
> work using the ALT+0252.



 
Reply With Quote
 
=?Utf-8?B?R2FyeScncyBTdHVkZW50?=
Guest
Posts: n/a
 
      27th Jan 2006
Enter an upper-case P in a cell and then format as Wingdings 2
--
Gary''s Student


"Barb" wrote:

> How do I insert a checkmark into an excel spreadsheet? The shortcut does not
> work using the ALT+0252.

 
Reply With Quote
 
Dave Peterson
Guest
Posts: n/a
 
      27th Jan 2006
And if you're really frustrated:

=char(252)

You could even copy|paste special|values if you wanted. (and copy to new cells,
too)

And from a previous post:

Insert Symbol was added in xl2002.

So if you don't run xl2002+, you'll have to find a different way.

You can hit flying windows R (or windows start button|Run)
type charmap
hit enter

or even
windows start button|Programs|accessories|System tools|charmap
if you like to mouse.

Chip Pearson has an addin that may help (if you're using xl2k or lower).
http://www.cpearson.com/excel/download.htm
(look for Symbolizer and make sure you get the correct version)

Barb wrote:
>
> How do I insert a checkmark into an excel spreadsheet? The shortcut does not
> work using the ALT+0252.


--

Dave Peterson
 
Reply With Quote
 
=?Utf-8?B?Q2Fyb2xlIERyYWtl?=
Guest
Posts: n/a
 
      27th Jan 2006
Wahoo! That was fun!

"Doug Kanter" wrote:

>
> "Barb" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > How do I insert a checkmark into an excel spreadsheet? The shortcut does
> > not
> > work using the ALT+0252.

>
> If I recall, those shortcuts only work if you use the numeric keypad to
> enter them, not the numbers across the top of the main keyboard area. If
> you're already doing this, make sure the cell is formatted with a font which
> actually contains the checkmark symbol. Wingdings is one of those fonts.
>
> Here's a foolproof method, although it's a bit convoluted:
>
> 1) Click Start, Run, and enter charmap. At the top, switch to the Wingdings
> font.
>
> 2) Scroll down to the end and you'll see a checkmark symbol. Click it, then
> click the Select button, and finally, click the Copy button. The symbol is
> now on the clipboard.
>
> 3) Go back to your Excel sheet and paste where you want the symbol. It will
> not appear correctly until you change the font in that cell to Wingdings.
>
>
>

 
Reply With Quote
 
Doug Kanter
Guest
Posts: n/a
 
      27th Jan 2006
And, you now have a source for lots of utterly useless symbols! But, some of
the other peoples' methods are faster.

"Carole Drake" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Wahoo! That was fun!
>
> "Doug Kanter" wrote:
>
>>
>> "Barb" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>> > How do I insert a checkmark into an excel spreadsheet? The shortcut
>> > does
>> > not
>> > work using the ALT+0252.

>>
>> If I recall, those shortcuts only work if you use the numeric keypad to
>> enter them, not the numbers across the top of the main keyboard area. If
>> you're already doing this, make sure the cell is formatted with a font
>> which
>> actually contains the checkmark symbol. Wingdings is one of those fonts.
>>
>> Here's a foolproof method, although it's a bit convoluted:
>>
>> 1) Click Start, Run, and enter charmap. At the top, switch to the
>> Wingdings
>> font.
>>
>> 2) Scroll down to the end and you'll see a checkmark symbol. Click it,
>> then
>> click the Select button, and finally, click the Copy button. The symbol
>> is
>> now on the clipboard.
>>
>> 3) Go back to your Excel sheet and paste where you want the symbol. It
>> will
>> not appear correctly until you change the font in that cell to Wingdings.
>>
>>
>>



 
Reply With Quote
 
New Member
Join Date: Nov 2009
Posts: 2
 
      15th Aug 2011
To make a checklist in text editor you can use Unicode characters like: ☐☑☒☓✓✔.
For long list of checklist characters go here:
http://ojejej.blogspot.com/2011/08/c...haracters.html

Go on page above, and copy/paste characters you need. It is simple
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Re: Keyboard shortcut to insert a checkmark keepitcool Microsoft Excel Programming 2 15th Aug 2011 10:19 AM
How do I make a form checkmark look like a checkmark and not an X =?Utf-8?B?Q2hyaXM=?= Microsoft Word Document Management 9 8th Jun 2006 04:02 PM
insert checkmark symbol =?Utf-8?B?aW5rc3RlcnRlYzE=?= Microsoft Excel Misc 5 20th Dec 2004 07:20 PM
Re: Keyboard shortcut to insert a checkmark steve Microsoft Excel Programming 0 15th Aug 2003 06:22 PM
Re: Keyboard shortcut to insert a checkmark Tom Ogilvy Microsoft Excel Programming 0 15th Aug 2003 05:45 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 11:13 AM.