How do I select columns not next to each other in Excel?

Add non-adjacent cells to selection

Windows shortcut
CtrlClick
Mac shortcut
Click

Hold down the control key and click (or click and drag) elsewhere on the worksheet to add another range of calls to the current selection.

See all shortcuts
The videos below demonstrate this shortcut.
How do I select columns not next to each other in Excel?
How to use the COUNT function
In this video we'll look at how to use the COUNT function to count cells that contain numeric data.
How do I select columns not next to each other in Excel?
How to highlight duplicates in a list
In this video we show you a way to highlight duplicate rows in a table that has many duplicate values.
How do I select columns not next to each other in Excel?
How to apply bold, italic, underlining styles in Excel
In this video we show you how to apply bold, italic, and underlining styles to text.
How do I select columns not next to each other in Excel?
Shortcuts for selecting cells
In this lesson, we cover shortcuts you can use to select cells.
How do I select columns not next to each other in Excel?
How to chart generations with floating bars
In this video, we'll plot American generations in a chart with floating bars. This seems like a simple problem, but a solution takes a little creative thinking.

Download 200+ Excel Shortcuts

Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.

Email
HP

Video