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
Watch video How to apply same drop down to all other cells online without registration, duration hours minute second in high quality. This video was added by user Excel Sirji 29 May 2021, don't forget to share it with your friends and acquaintances, it has been viewed on our site 127,042 once and liked it 2.1 thousand people.