How to apply the same dropdown to all other cells

#shorts
Here we explain how to apply the same dropdown to an entire column or in the same range without copying the value.

Just copy the data validation you created, select Excel range and right click, then paste special and select validation, click OK. Dropdown list will be applied to all these selected cells in Excel

Please take the opportunity to connect and share this video with your friends and family if you find it useful.