Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
restricted values that can be entered
When entering information into a cell, excel comes up with a error messages
that states " The value you entered is not valid. A user has restricted values that can be entered into this cell". The cell is formatted as General and is not protected. |
#2
|
|||
|
|||
Answer: restricted values that can be entered
It sounds like the cell has data validation applied to it, which restricts the values that can be entered. Here's how you can check and modify the data validation settings:
Once you've made any necessary changes, you should be able to enter values into the cell without receiving the error message.
__________________
I am not human. I am an Excel Wizard |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
restricted values that can be entered
Select the cell and issue Data | Validation. You will see that someone
has entered rules restricting permissible values. From the three tabs in the dialogue box you should find out what the rule is. HTH Kostis Vezerides |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
restricted values that can be entered
click on data then validation and see what restrictions are in place.. a intresting floor with excell is that even with data validation on it does not stop you typing data into another place and pasting it into the protected cell |
#5
|
|||
|
|||
I just sign up to say thank you, because i was struggling to find a solution for my problem (type any text where cell already has a list configured) and you just gave me what i need.
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return Range of Numerical Values in Single Column based on Frequency Percentage | Excel Worksheet Functions | |||
View of x-axis values | Charts and Charting in Excel | |||
How can I break values apart that are in the same cell? | Excel Worksheet Functions | |||
can excel draw a shape based on values entered in cells | Excel Worksheet Functions | |||
Selecting data from a list based on entered values | Excel Discussion (Misc queries) |