validation list in multiple worksheets in a single workbook

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.
 
Back
Top