Data Validation Question
 

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!

Data Validation Question
 

Copy the cell with validation
Select the entire column from column header.
Right clickPasteSpecialcheck Validationsok

If this post helps click Yes
---------------
Jacob Skaria


"NFL" wrote:

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!

Data Validation Question
 

Very helpful.... thank you!

"Jacob Skaria" wrote:

Copy the cell with validation
Select the entire column from column header.
Right clickPasteSpecialcheck Validationsok

If this post helps click Yes
---------------
Jacob Skaria


"NFL" wrote:

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!