![]() |
Drop List
Using MSOffice2003
From reading around the groups and following helpful links I learned how to create a list on sheet1 and name the range and use the offset command to set up data validation as a means for filling drop boxes on my main worksheet. Problem is, I don't know how to get the actual drop box into the cells in the necessary column on my worksheet. Duh, it can't be that hard but I have no clue how to proceed. All help gratefully accepted by this newbie. Thanks Joanne |
Drop List
hi
if you are using data validation... see this site. It explains how to do that. http://www.contextures.com/xlDataVal01.html#DataVal01 real good site too. lot of good tip concerning a great number of thing. after reading up on validation. click home then tips. Regards FSt1 "Joanne" wrote: Using MSOffice2003 From reading around the groups and following helpful links I learned how to create a list on sheet1 and name the range and use the offset command to set up data validation as a means for filling drop boxes on my main worksheet. Problem is, I don't know how to get the actual drop box into the cells in the necessary column on my worksheet. Duh, it can't be that hard but I have no clue how to proceed. All help gratefully accepted by this newbie. Thanks Joanne |
All times are GMT +1. The time now is 02:21 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com