Question

Que. 11:
If you want to select more than one column,
which option you will use?​

Answer 1

Explanation:

Now use Shift + Right (twice) arrow keys to select columns D and E, simultaneously. You can select columns C:A by using shortcut Shift + Left (twice) arrow keys. You can select columns to the end of sheet using Ctrl+Shift + Left shortcut.

Answer 2

Answer:

One of my colleagues asked me if it is possible to make multiple selections in a drop-down list in Excel. ... There is no way you can do this with Excel in-built features. The only way is to use a VBA code, which runs whenever you make a selection and adds the selected value to the existing value.