[mso] Re: [mso]Re:check mark in Excel
- From: TomD <tdemma@xxxxxxxxxxxxxxxx>
- To: mso@xxxxxxxxxxxxx
- Date: Thu, 25 Sep 2003 08:44:08 -0700
We can copy the check mark to other cells with no problem. They just won't
print.
Using Office 2k.
paul tully wrote:
> 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
> *************************************************************
--
Tom Demma KD7MSM
Support Systems Analyst &
Systems Administrator
Civil Engineering and Engineering Mechanics
University of Arizona
(520)621-6578 (520)621-2550 fax
tdemma@xxxxxxxxxxxxxxxx
tdemma@xxxxxxxxxxxxxxxxx
"It's bad luck to be superstitious"
*************************************************************
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:
