[mso] [mso]Re:check mark in Excel
- From: "paul tully" <gunstock@xxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Thu, 25 Sep 2003 22:46:47 +1200
For Excel 2000 I have a method for entering a check mark into a cell, though
not perfect:
Select a whole column, Select Wingdings Font, Select
Data-Validation-Settings tab-Allow-List, make sure "Ignore Blank" and
In-cell dropdown" are both ticked and your keypad numeral lock is on, in the
source box press Alt and type 0251 release Alt type a comma press Alt and
type 0252 click O.K.
Now when you select a cell in that column you'll get a drop down list with
two options, and this is where its not perfect, the data validation inherits
the font properties of the spreadsheet i.e. "Arial", so that the tick and
the cross don't look as such, though they will enter into the cell as a tick
or a cross, you could enhance it a little buy selecting the Input Message
Tab while in the Data Validation Form and entering: (Hold Alt) type
0251(release Alt) = WRONG,(Hold Alt) type 0252(release Alt) = RIGHT, click
O.K. Now you'll get a reminder when you select a cell in that column.
Cheers, Paul
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in
the subject line.
Or, visit the group's homepage and use the dropdown menu. This will also allow
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions. Once you are a member of the files group, you can go here to
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
Other related posts:
