Selecting Multiple Ranges

To select multiple ranges in same Excel worksheet, use "Ctrl" key. First select a Range and then press and hold "Ctrl" key while selecting next Range in same worksheet.

1. Can we select multiple ranges simultaneously?
2. How do I select multiple ranges in Excel chart?

Can we select multiple ranges simultaneously?

Just press and hold down the Ctrl key, and you can select multiple non-adjacent cells or ranges with mouse clicking or dragging in active worksheet. This does not require holding down keys during selection.

How do I select multiple ranges in Excel chart?

Click the first cell or cell range. Hold down the Ctrl key and select any non-adjacent cells or cell ranges.