| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
To make sure only the Validated list can be put in the drop down b
I have a validation criteria for a column which has a drop down menu. When i
enter the data other than the List , it gives me an error. But when i copy and paste a cell from another excel sheet and i match the surce formatting it will be entered in the cell which has a validation. What am i to do ! Sholud i protect the cells |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
To make sure only the Validated list can be put in the drop down b
Protecting the cells will do the trick
"Belmeera Pinto" wrote: I have a validation criteria for a column which has a drop down menu. When i enter the data other than the List , it gives me an error. But when i copy and paste a cell from another excel sheet and i match the surce formatting it will be entered in the cell which has a validation. What am i to do ! Sholud i protect the cells |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I make the drop down list view larger? | Excel Discussion (Misc queries) | |||
| can you make a drop down list in a drop down list? | Excel Discussion (Misc queries) | |||
| Validated list - how to make conditional | Excel Discussion (Misc queries) | |||
| use color coded data on a drop down validated list | Excel Discussion (Misc queries) | |||
| Concatenate Results from a Validated Drop Down List | Excel Discussion (Misc queries) | |||
Hybrid Mode
