ExcelBanter - Excel drop down list

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Excel drop down list (https://www.excelbanter.com/excel-discussion-misc-queries/211703-excel-drop-down-list.html)

Andy

Excel drop down list

Is there a way to make a dropdown list that has multiple columns? I have
1564 rows but I want it to reach from A to D.

muddan madhu

Excel drop down list

merge the cells from A to D, then use data validation.

On Nov 26, 7:27*pm, andy wrote:
Is there a way to make a dropdown list that has multiple columns? *I have
1564 rows but I want it to reach from A to D. *

All times are GMT +1. The time now is 05:28 PM.