How to easily copy a dropdown list, down a column or range in Excel

preview_player
Показать описание
In this video I will show you two easy and fast ways, to copy a Data Validation Dropdown List to a whole range in Excel.
Рекомендации по теме
Комментарии
Автор

This was driving me nuts how to do this to save time as I had over 2, 000 rows I needed a drop down. This was so simple after watching this video; thank you!

jasonf
Автор

i have to upload a lot of data, to this type of drop down, and i have answer form google form, can i copy my answer to that dropdown cells and stil format as a dropdown with exact answer ?

arifrahman
Автор

Fine and dandy but nobody explains how to cc the formula or dropdown list setup all the way to the end of the spreadsheet - i.e. all cells below the initial row.

Franklin-pcxd
Автор

is this english if yes - where u speak this, i found thi unique

flag_bearertruth