Add Non Adjacent Cells to Selection?
- Average speed
- km/h
- Result
- Finish time
- 50 min
- You entered
- Distance
- 10 km
- You entered
To add non-adjacent cells to an existing selection in most spreadsheet and table programs, hold the Ctrl key (Windows) or Command key (Mac) while clicking or dragging over the additional cells. This works in Microsoft Excel, Google Sheets, Apple Numbers, and most other modern spreadsheet applications, and it lets you select multiple separate ranges at once for formatting, data entry, or calculations.
Formula
The calculator above computes two related running metrics from a finish time and a distance:
- Average pace (min/km) = Finish time (minutes) ÷ Distance (km)
- Average speed (km/h) = Distance (km) ÷ (Finish time (minutes) ÷ 60)
Variables:
- t – finish time in minutes (e.g., 50 min)
- d – distance in kilometers (e.g., 10 km)
Pace tells you how many minutes each kilometer took; speed tells you how many kilometers you covered in one hour. They are reciprocals when units are consistent.
Worked Example
Using the default values: t = 50 minutes, d = 10 km.
- Pace = 50 ÷ 10 = 5.00 min/km
- Speed = 10 ÷ (50 ÷ 60) = 10 ÷ 0.8333 = 12.00 km/h
The calculator shows 5.00 min/km and 12.00 km/h for these inputs.
Why Select Non-Adjacent Cells?
Selecting non-adjacent cells is useful when you want to apply a format, enter data, or run a calculation on scattered cells without including the cells between them. For example, you might want to bold the totals in cells A1, C1, and E1 while leaving B1 and D1 normal. Or you might need to sum only specific cells that are not next to each other, like A2, A5, and A9.
In Excel and Google Sheets, a non-contiguous selection is often shown with a dashed border around each selected region, and the Name Box may display something like “A1,A3,B2” to indicate the multiple areas. The status bar (in Excel) can show the sum, average, and count of all selected cells combined, which is handy for quick checks.
How to Do It in Excel, Google Sheets, and Numbers
The basic method is the same across all major spreadsheet apps:
- Click the first cell or drag to select the first range.
- Press and hold Ctrl (Windows) or Command (Mac).
- Click additional cells or drag over additional ranges.
- Release the key when done.
In Excel, you can also use the keyboard: select the first range, then press Shift+F8 to add to the selection without holding Ctrl. The status bar shows “Add to Selection” and you can click or arrow to other cells. Press Shift+F8 again to exit that mode.
In Google Sheets, the same Ctrl/Command method works. On touch devices, you may need to tap and hold to enter selection mode, then tap additional cells while holding the key.
Apple Numbers also uses Command for multiple selection. If you are using a Mac with a mouse, Ctrl-click may behave like a right-click, so use Command instead.
Common Mistakes and Pitfalls
- Forgetting to hold the key – If you click without Ctrl/Command, you lose the previous selection.
- Using Ctrl on a Mac – On macOS, Ctrl-click usually opens a context menu. Use Command.
- Dragging over unwanted cells – When dragging, you select every cell in the rectangle. To add only specific cells, click them individually.
- Mixing up Shift and Ctrl – Shift extends the current selection to include everything between the anchor and the new cell; it does not add a separate range.
Another common issue: after selecting non-adjacent cells, pressing Delete or typing a value will affect all selected cells. That is usually intended, but be careful not to overwrite data accidentally.
Using Non-Adjacent Selections in Formulas
You can use a non-adjacent selection directly in some formulas. For example, in Excel, typing =SUM( and then Ctrl-clicking cells A1, A3, and B2 will insert =SUM(A1,A3,B2). The same works in Google Sheets. This is different from a range like A1:B2, which includes all cells in the rectangle.
However, not all functions accept multiple ranges. For instance, =AVERAGE(A1,A3,B2) will average only those three cells, but some functions like =COUNTIF may require a single range. In those cases, you may need to use a union formula or combine multiple functions.
Alternatives to Non-Adjacent Selection
If you frequently need to work with scattered cells, consider these alternatives:
- Named ranges – Assign a name to a group of cells (even non-adjacent) and use that name in formulas.
- Tables – Convert data to a table and use structured references.
- Filtering – Use filters to show only the rows you want, then select the visible cells (Alt+; in Excel) to apply changes only to them.
- Go To Special – In Excel, use Ctrl+G → Special to select blanks, constants, or formulas.
These methods can be more efficient than manually selecting many separate ranges, especially for large datasets.
Frequently Asked Questions
How do I add non-adjacent cells on a Mac?
Hold the Command key (⌘) while clicking or dragging over the additional cells. If you use Ctrl, you may get a right-click menu instead.
Can I select non-adjacent cells in Google Sheets on a phone?
Yes, but it is trickier. Tap the first cell, then tap and hold to enter selection mode, then tap additional cells while holding the Command (iOS) or Ctrl (Android) key. The exact gesture may vary by device.
Why does my selection keep resetting when I click another cell?
You are probably not holding the Ctrl/Command key. If you are on a Mac and using Ctrl, that is the problem – use Command instead. Also, make sure you are not in “Extend Selection” mode (Shift+F8) which behaves differently.
Can I add non-adjacent cells to a chart data range?
Yes, in Excel and Google Sheets you can often select multiple ranges when creating a chart, but you may need to use a comma to separate them in the data range field (e.g., =SERIES(,,Sheet1!$A$1:$A$5,Sheet1!$C$1:$C$5)). The exact method depends on the application.
How do I select non-adjacent cells without a mouse?
Use the keyboard: select the first range with arrow keys and Shift, then press Shift+F8 to add to the selection, then use arrow keys to move to the next cell and press Shift+Space or Ctrl+Space to select a row or column. Press Shift+F8 again to exit.
Does the same trick work in other applications like Word or PowerPoint?
Yes, in Word and PowerPoint you can also select non-adjacent text or objects by holding Ctrl (Windows) or Command (Mac) while clicking. The principle is the same across most Office applications.
Related
Formula used
in t | Finish time | min | 50 | 0 in d | Distance | km | 10 | 0 out pace | Average pace | min/km | t / d | 2 out speed | Average speed | km/h | d / (t / 60) | 2
Each line is one input (in, sel, list) or one result (out: label, unit, formula, decimals). How the calculators work
Method: the standard formula for this calculation, rounded as each result states. See how the calculators work or report an error.