validation list in multiple worksheets in a single workbook

[Guest]

i am trying to create a validation list in the same cell in multiple worksheets in a single workbook. the validation comand in the pulldown menu is grayed out when you hightlight all the worksheet tabs. thanks for your time in advance.

 

[Debra Dalgleish]

You can't create a validation list in multiple sheets simultaneously.

Name the range that contains the source list, then create the data
validation list on the first worksheet.
Copy that cell, and paste onto each of the remaining sheets.