How to apply same drop down to all other cells
#shorts
Here we are covering how you can apply same dropdown list to entire column or in the same range without copying the value.
You just need to copy the data validation you created, select the excel range and right click, then paste special and select validation, Click Ok. Dropdown list will get applied to all those selected cells in Excel
