Data Validation
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. -- starguy ------------------------------------------------------------------------ starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434 View this thread: http://www.excelforum.com/showthread...hreadid=523027 |
Data Validation
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 -- davesexcel ------------------------------------------------------------------------ davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708 View this thread: http://www.excelforum.com/showthread...hreadid=523027 |
Data Validation
davesexcel Wrote: 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. -- starguy ------------------------------------------------------------------------ starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434 View this thread: http://www.excelforum.com/showthread...hreadid=523027 |
Data Validation
davesexcel Wrote: 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. -- starguy ------------------------------------------------------------------------ starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434 View this thread: http://www.excelforum.com/showthread...hreadid=523027 |
All times are GMT +1. The time now is 02:48 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com