Forum home » Delegate support and help forum » Microsoft Excel Training and help » Data Validation - Drop down list with multiple option selection

Data Validation - Drop down list with multiple option selection

ResolvedVersion 2016

Thu 3 Oct 2019, 16:29 Delegate arun said...

arun has attended:
Excel Advanced course

Data Validation - Drop down list with multiple option selection

Is there an option to select more than one option in the dropdown list without having to create macro?

Thu 3 Oct 2019, 17:10 Trainer Jens said...

RE: Data Validation - Drop down list with multiple option select

Hi Arun,

Thank you for the forum question.

No you will only be able to select one from the drop-down list.

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Thu 10 Oct 2019: Automatically marked as resolved.

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Turn Function tooltips on and off

Excel 2002 (XP) and Excel 2003 have the Function tooltips facility. When you type in a function name followed by a bracket, for example, =IF(, a yellow box appears beside the function name and lists the function's arguments. This is very useful when you can't quite remember the order of a function's arguments or what the arguments actually are!

However, Function tooltips can become annoying. To turn them off, choose Tools|Options. and select the General tab. Then, untick the Function tooltips box and choose OK.

View all Excel hints and tips

Data Validation - Drop down list with multiple option selection

Data Validation - Drop down list with multiple option selection

RE: Data Validation - Drop down list with multiple option select

Excel articles

Excel tip:

Turn Function tooltips on and off