A
ArDn
Hi!!! I'd like limit value of cells. I want that the cells contain only 1 or
0. How can I do this?
Zanks.
ARdn
0. How can I do this?
Zanks.
ARdn
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
T
Tim Anderson
ArDn said:Hi!!! I'd like limit value of cells. I want that the cells contain only 1 or
0. How can I do this?
Select the cell or range.
From the Data menu, choose Validation.
Settings - Allow whole number between 0 and 1.
Tim
Why Tablet PC? see http://www.itwriting.com/tablet.php
A
ArDn
I've tried that but the sheet is protected., so ...
J
J.E. McGimpsey
Followup set to microsoft.public.excel.misc.
Just make sure the cell is unlocked prior to protection:
Format/Cells/Protection, uncheck the Locked checkbox). Validation
works fine on protected sheets.
Just make sure the cell is unlocked prior to protection:
Format/Cells/Protection, uncheck the Locked checkbox). Validation
works fine on protected sheets.