Data Validation Question

[NFL]

Hello:

Is there an easy way I can copy/pase a cell with a drop down menu list (data
validation) directly below the current cell to the last row 65,536?

Thank you!

 

[Jacob Skaria]

Copy the cell with validation
Select the entire column from column header.
Right click>PasteSpecial>check Validations>ok

If this post helps click Yes

 

[NFL]

Very helpful.... thank you!

Copy the cell with validation
Select the entire column from column header.
Right click>PasteSpecial>check Validations>ok

If this post helps click Yes