How to select multiple ranges in Excel
You can watch a video tutorial here.
In Excel, a range is a contiguous set of cells. When working with Excel you may need to select multiple ranges to format them or copy them or move them to a new location. There are 3 ways in which this can be done:
- Use the mouse and keyboard
- Use the Add or Remove Selection mode
- Use the Go To option
Option 1 – Use the mouse
Step 1 – Select the first range
![](https://spreadcheaters.com/wp-content/uploads/Option-1-Step-1-–-How-to-select-multiple-ranges-in-Excel--1024x668.png)
- Using the mouse, select the first range of cells
Step 2 – Select the other ranges
![](https://spreadcheaters.com/wp-content/uploads/Option-1-Step-2-–-How-to-select-multiple-ranges-in-Excel--1024x683.png)
- Hold down the Ctrl key
- Select the next range
- Repeat the above steps to select each of the ranges
Step 3 – Check the result
![](https://spreadcheaters.com/wp-content/uploads/Option-1-Step-3-–-How-to-select-multiple-ranges-in-Excel--1024x704.png)
- Multiple ranges are selected
Option 2 – Use Add or Remove Selection
Step 1 – Enable Add or Remove Selection mode
![](https://spreadcheaters.com/wp-content/uploads/Option-2-Step-1-–-How-to-select-multiple-ranges-in-Excel--858x1024.png)
- Press Shift+F8
- The ‘Add or Remove Selection’ mode is enabled
Step 2 – Select the ranges
![](https://spreadcheaters.com/wp-content/uploads/Option-2-Step-2-–-How-to-select-multiple-ranges-in-Excel--1024x656.png)
- Use the mouse to select the ranges
- Press Shift+F8 to disable the Add or Remove Selection mode
Option 3 – Use the Go To option
Step 1 – Open the Go To box
![](https://spreadcheaters.com/wp-content/uploads/Option-3-Step-1-–-How-to-select-multiple-ranges-in-Excel--1024x411.png)
- Go to Home > Editing
- Expand the Find & Select drop-down
- Click Go To
OR
- Press Ctrl+G
Step 2 – Enter the ranges
![](https://spreadcheaters.com/wp-content/uploads/Option-3-Step-2-–-How-to-select-multiple-ranges-in-Excel--1024x798.png)
- Using cell references, type the location of the ranges separated by commas:
- B4:C4, B6:C6
- Click OK
Step 3 – Check the result
![](https://spreadcheaters.com/wp-content/uploads/Option-3-Step-3-–-How-to-select-multiple-ranges-in-Excel--1024x681.png)
- Multiple ranges are selected