How to select Multiple Range in Excel worksheet

Cells in Excel worksheet Range are contiguous. You may select multiple ranges (non-contiguous) in an Excel worksheet. Following are the different ways to select many ranges in an Excel worksheet.

Before continuing, please click below links to learn more about Range Addresses.

What is Range in Excel Worksheet and How to form a Range Address

Examples of Range Addresses in Excel worksheet

1 - Press and hold "Ctrl" key to select multiple Ranges in same worksheet

Normally when you select a Range and then click on another cell, first selected Range will be deselected. 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.

2 - Enable "Add or Remove Selection" mode to select multiple Ranges in same worksheet

Press "Shift" & "F8" keys together to select multiple Ranges in same worksheet. When you press "Shift" & "F8" keys together, "Add or Remove Selection" mode is enabled. You can watch whether "Add or Remove Selection" mode is enabled from Excel Status bar, as shown below.

3 - Enter the Range Addresses separated by a comma in Cell Name box of Formula bar

You can select multiple Ranges in same Excel worksheet by keying-in Range addresses separated by a comma in Cell Name box of Formula bar.

For Example : Enter B2:C4,D6:E8,F10:G12 in Cell Name box and press "Enter" key to get multiple selection as below.

4 - Enter the Range Addresses separated by a comma in "Go To" dialog box

Type the Range Addresses you want to select, separated by a comma in "Go To" dialog box. In this example three range addresses are combined together to form B2:C4,D6:E8,F10:G12. Click "OK" button.

Multiple Ranges are selected according to the Range addresses (B2:C4,D6:E8,F10:G12) entered in Go To dialog box as shown in below image.