Search

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.

Add or Remove Selection mode

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.

Multiple Range Selection using Cell Name Box

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 range selection using Go To dialog box

Tip

You can open "Go To" dialog box from Excel Ribbon's "Home" Tab > "Editing" Group > "Find & Select" Menu button

Or

Press "Ctrl" & "G" keys together.

Or

Press "F5"

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.

Multiple range selected using Go To dialog box

 

Related Tutorials
• Important Excel Worksheet Navigation keys
• Excel Cursor and Mouse Pointer Shapes
• Row, Column and Cell in Excel worksheet
• How to change the Row height in Excel worksheet
• Excel AutoFit Row Height
• How to change the Column width in Excel worksheet
• Excel AutoFit Column Width
• How to hide or unhide Rows in Excel worksheet
• How to hide or unhide Columns in Excel worksheet
• Maximum rows and columns in Excel Worksheet
• What is Active Cell in Excel and How to identify Active Cell
• What is Range in Excel Worksheet and How to form a Range Address
• Examples of Range Addresses in Excel worksheet
• Types of Ranges in Excel Worksheet
• How to select Range in Excel worksheet
• What is Group mode in Excel, How to exit Group edit mode
• How to select all worksheets to Excel group
• How to select Ranges from different worksheets using Excel Group edit mode
• How to hide or show Excel Worksheet Row and Column headings (Column Letter and Row Number)
• How to hide or show Excel Worksheet Gridlines
• How to change the color of Excel worksheet Tabs
• How to change the color of Excel Gridlines
• How to change the default font and size in Excel
• How to Move or Copy entire worksheet within an Excel workbook
• How to Move or Copy entire worksheet to another Excel workbook