View Single Post
  #2   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
Tim Anderson Tim Anderson is offline
external usenet poster
 
Posts: 1
Default validation of cells

"ArDn" wrote in message
...
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