Selecting two different columns in Excel helps you compare data, create charts, and build focused formulas. This guide walks through reliable methods so you can target the exact columns without affecting other parts of your worksheet.
Below is a quick reference that summarizes common scenarios, tools, and expected outcomes when you select two columns at once.
| Method | When to Use | Steps | Result |
|---|---|---|---|
| Click and Drag | Adjacent columns, simple selection | Click header of first column, hold Shift, click header of second column | Both columns selected, including intermediate columns |
| Ctrl + Click (Non-adjacent) | Two separate, non-adjacent columns | Click first column header, hold Ctrl, click second column header | Both columns selected independently, no intermediate columns |
| Name Box Technique | Specific columns, precise targeting | Type column letters separated by colon (e.g., A:C) or comma (e.g., A,C) in Name Box and press Enter | Exact columns selected as specified |
| Go to Special | Multiple non-contiguous columns with blanks | Press F5, choose Special, select Blanks or Constants, then narrow to columns | Target cells within chosen columns selected efficiently |
Use Keyboard Shortcuts to Select Two Non-adjacent Columns
Keyboard shortcuts let you grab two separate columns quickly without dragging through unwanted data.
Ctrl + Click Method
Click the header of the first column, hold the Ctrl key, then click the header of the second column. Excel selects each column independently, which is ideal when the columns are far apart.
Name Box Precision Input
Type the column references separated by a comma, such as B,D, into the Name Box and press Enter. This method is exact and helpful when you already know the column letters.
Select Adjacent Columns with Shift and Click
When your target columns are next to each other, Shift + click creates a continuous range that includes everything between them.
Click and Shift Technique
Click the first column header, hold Shift, then click the second column header. All columns from the first to the second are included in one selection.
Use Go to Special for Column-based Selections
Go to Special helps when you need to select entire columns based on cell content, such as blanks or constants, across two specific columns.
Target Blanks Across Two Columns
Press F5, choose Special, select Blanks, and then manually adjust to the two columns you want. This approach is useful for data cleanup tasks within a defined column pair.
Leverage Formulas That Reference Multiple Columns
Even if you are not selecting columns visually, formulas can work on two columns at once, which is helpful for analysis and reporting.
SUMPRODUCT Across Two Columns
Use SUMPRODUCT with two ranges, such as SUMPRODUCT(A:A, B:B), to calculate across two columns without manual selection. This keeps your model tidy and reduces the risk of selecting entire columns unintentionally.
Key Takeaways for Selecting Columns Efficiently
- Use Ctrl + Click for non-adjacent columns to avoid selecting extra data.
- Use Shift + click for adjacent columns to create a continuous range.
- Type column references in the Name Box for precise, repeatable selections.
- Combine Go to Special with column headers to target blanks or constants quickly.
- Reference multiple columns directly in formulas to reduce manual selection.
FAQ
Reader questions
How do I select exactly two specific columns without including others?
Press Ctrl and click each column header you want. This non-adjacent selection isolates only the two columns and ignores everything else.
What is the fastest way to select two adjacent columns?
Click the first column header, hold Shift, and click the second column header. The continuous range selection happens instantly.
Can I select two columns using the Name Box if I only know their letters?
Yes, type the two column letters separated by a comma, like X,Y, in the Name Box and press Enter to select them precisely.
How can I select two columns and immediately use them in a chart?
Select the two columns with Ctrl + Click, then insert your chart. Excel maps each column to a separate data series automatically.