To select more than one cell or range in a worksheet, select the first cell or range, hold down the Shift key, and select each additional cell or range.

Question

Quizplus · Accepted Answer

To select more than one cell or range in a worksheet non-adjacently, you should hold down the Ctrl key (Command key on macOS), not the Shift key. The Shift key is used for selecting adjacent cells or ranges by selecting the first cell or range, holding down the Shift key, and then selecting the last cell or range in the sequence.

To Select More Than One Cell or Range in a Worksheet