Add a multi-valued choice column

You can use a multi-valued choice column to select more than one item from the list of choices at a time. For example, in a task-tracking list, you can assign more than one person to each task. You enter the possible choices when you add the column to your list.

Add a multi-valued choice column

  1. Right-click any column heading or any cell in the list, and then click Add Column.

  2. Under Name and Type, enter a name for the column, and then click Choice.

  3. Under Additional Column Settings, type the choices that you want to appear in the column, and then click Checkboxes (allow multiple selections).

  4. Set any other options you want, and then click OK.

To use a multi-valued choice column while viewing the datasheet, click the drop-down arrow in the cell, and then select or clear the check box next to each value that you want to add or remove from the cell.

Edit the list of choices in a multi-valued choice column

To add, edit, or remove items from a multi-valued choice column, follow this procedure:

  1. Right-click the column heading or any cell in the column that you want to edit, and then click Edit/Delete Column.

  2. Under Additional Column Settings, edit the list of choices.

  3. Set any other options you want, and then click OK.

Use a multi-valued choice column

To use a multi-valued choice column, follow this procedure:

  1. Click the drop-down arrow in the cell that you want to edit.

  2. Select or clear the check box next to each item that you want to add or remove from the cell.

  3. Click OK.

The selected choices appear in the cell, separated by semicolons (;).

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×