please any one tell me how can i restrict a range of values to enter in a cell by using data validation of some other method.
suppose i want to restrict values (which are in D2:D10 range) to be entered in cell B5. how can i do this.
please any one tell me how can i restrict a range of values to enter in a cell by using data validation of some other method.
suppose i want to restrict values (which are in D2:D10 range) to be entered in cell B5. how can i do this.
suppose i want to restrict values (which are in D2:D10 range) to be entered in cell B5. how can i do this.
select B5
Goto
Data
Validation
Select list
In the range box enter D2:D10
You now have a drop down menu
Check out this site for more on Data Validation, You could also search your forum
http://www.contextures.com/xlDataVal01.html
[QUOTE=davesexcel]suppose i want to restrict values (which are in D2:D10 range) to be entered in cell B5. how can i do this.
select B5
Goto
Data
Validation
Select list
In the range box enter D2:D10
You now have a drop down menu
i know this method. this method allows values in range D2:D10 to be entered in cell B5. i actually want to restrict these values (D2:D10) to be entered in B5. how cant i do this by validation or any other method.
[QUOTE=davesexcel]suppose i want to restrict values (which are in D2:D10 range) to be entered in cell B5. how can i do this.
select B5
Goto
Data
Validation
Select list
In the range box enter D2:D10
You now have a drop down menu
thanks for replying
infact i know this method. this method allows values in range D2:D10 to be entered in cell B5. i actually want to restrict these values (D2:D10) to be entered in B5. how cant i do this by validation or any other method.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks