How to Select Multiple Data Sets in Excel

Selecting pieces of data scattered across an Excel spreadsheet doesn't have to be a tedious, one-by-one process. You can instantly highlight multiple, non-adjacent cells or data ranges to format them, chart them, or copy them all at once. This article will show you three simple methods for selecting multiple data sets in Excel, from the basic keyboard shortcut to a more advanced technique for recurring reports.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

What Do We Mean by "Multiple Data Sets"?

In this context, we're talking about selecting ranges of cells that aren't touching each other. This is often called a "non-contiguous" or "non-adjacent" selection. Instead of selecting one big block of data like A1:D10, you might want to select A1:A10, C1:C10, and F1:F10 all at the same time.

Why would you need to do this? There are several common scenarios where this skill is a huge time-saver:

• Creating Charts: You might want to plot a chart comparing Quarter 1 revenue against Quarter 4 revenue without showing the Q2 and Q3 data in between.
• Applying Formatting Simultaneously: Imagine you want to make all the headers for different tables on your sheet bold and blue. You can select them all in one go and apply the formatting once.
• Printing Specific Sections: You can select several different tables or summaries from a large worksheet and print only those selections on a single page.
• Batch Data Entry or Deletion: If you need to clear the contents of several specific areas, selecting them all first lets you hit the 'Delete' key just once.

Mastering this simple trick is a stepping stone to working much faster and more efficiently in Excel.

Method 1: The Ctrl/Cmd Key Shortcut

This is the most common and straightforward way to select multiple cells or ranges that aren't next to each other. It uses a simple keyboard combination that you're probably already familiar with from selecting files in your operating system.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Step-by-Step Instructions

Follow these simple steps:

1. Select your first cell or range. Click and drag your mouse to highlight the first block of data you want to include. Release the mouse button. For example, let's say you select cells A2:B10.
2. Press and hold the Ctrl key (on Windows) or the Cmd key (on a Mac). This is the important part - do not let go of this key until you are finished with all your selections.
3. Select the next cell or range. While still holding down the Ctrl/Cmd key, click and drag your mouse to highlight your second block of data (e.g., D2:D10). You will notice that your original selection remains highlighted.
4. Continue selecting. You can continue highlighting as many individual cells or ranges as you need. Just keep the Ctrl/Cmd key pressed down the entire time.
5. Release the key. Once you have selected everything you need, you can let go of the Ctrl/Cmd key. All your chosen ranges will remain highlighted.

A Practical Example: Formatting a Sales Report

Imagine you have a sales report with data for four different regions. You want to quickly format the header row and the totals row to make them stand out.

Here's how you'd do it:

1. Click and drag to select the header row, say A1:D1.
2. Press and hold the Ctrl key.
3. While holding Ctrl, click and drag to select the totals row, say A20:D20.
4. Release the Ctrl key.
5. Now, both the header and total rows are selected. You can click the 'Bold' button on the Home tab, and the text in both rows will become bold simultaneously.

Common Pitfall: The most common mistake is letting go of the Ctrl/Cmd key too early or accidentally clicking on a cell without holding the key down. If you do this, your previous selections will disappear. Just start over - it only takes a few seconds!

Method 2: Using the Name Box for Precise Selections

If you're working with a very large spreadsheet or already know the exact cell coordinates you need to select, scrolling and holding the Ctrl key can be cumbersome. A faster and more precise method is to use the Name Box.

The Name Box is the small input field to the left of the formula bar. It normally displays the address of the active cell (like A1).

Step-by-Step Instructions

This method doesn't require holding down any keys.

1. Click inside the Name Box where you see the current cell reference.
2. Type the addresses of the ranges you want to select, separating each range with a comma. Do not use spaces. For example, if you want to select the ranges A2:B10 and D2:E10, you would type: A2:B10,D2:E10.
3. Press the "Enter" key. As soon as you hit Enter, Excel will immediately highlight all the ranges you specified.

This trick is incredibly useful when you need to select a collection of known addresses quickly without having to hunt for them on the sheet. It's the method of choice for power users who know their way around a spreadsheet and value speed and precision.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Method 3: Create a Named Range for Repeated Selections

What if you find yourself selecting the same set of non-adjacent ranges over and over again? For example, perhaps you have a monthly dashboard where you always need to select the summary cells for US, European, and Asian sales to create a report. Doing this manually every time is a waste of effort. This is where Named Ranges come in.

A "Named Range" allows you to assign a simple, memorable name (like Monthly_Sales_Summary) to a single cell, a block of cells, or even a collection of multiple, non-adjacent blocks.

How to Create a Non-Contiguous Named Range

1. Make your initial selection. First, use the Ctrl/Cmd key method (Method 1) to select all the different ranges you want to include in your group.
2. Go to the Formulas tab. In the Excel ribbon at the top, click on the "Formulas" tab.
3. Open the Name Manager or Define Name. In the "Defined Names" section of the ribbon, click "Define Name."
4. Give your range a name. A dialog box will appear. In the "Name" field, type a descriptive name for your selection. For example: Regional_Totals.
5. Confirm the selection. The "Refers to" box will already contain the addresses of all the ranges you selected, separated by commas. You don't need to change anything here. Just click "OK."

How to Use Your Newly Created Named Range

Once you've created your named range, selecting that entire group of scattered cells becomes incredibly simple.

1. Click the small dropdown arrow on the right side of the Name Box.
2. A list of all the named ranges in your workbook will appear.
3. Click on the name you created (e.g., Regional_Totals).

Instantly, Excel will select every range you originally included in that named group. You can now format, copy, or reference this group in a formula (e.g., =SUM(Regional_Totals)) far more easily than referencing each individual range.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Applying These Techniques: A Charting Example

Let's tie this back to a common, real-world task: creating a chart from non-adjacent data.

Imagine you have data structured like this:

• Column A: Product Names (A2:A10)
• Column B: Q1 Sales (B2:B10)
• Column C: Q2 Sales (C2:C10)
• Column D: Q3 Sales (D2:D10)
• Column E: Q4 Sales (E2:E10)

You want to create a bar chart that compares only the Q1 Sales to the Q4 Sales for each product. Here's how:

1. Select the product names in Column A (A2:A10).
2. Press and hold the Ctrl key.
3. While holding it, select the Q1 Sales data in Column B (B2:B10).
4. Keep holding Ctrl and select the Q4 Sales data in Column E (E2:E10).
5. Now, release the Ctrl key. You have three non-adjacent ranges selected.
6. Go to the "Insert" tab and choose the bar chart you want to create. Excel will generate a chart using only the data you selected, ignoring the columns for Q2 and Q3 entirely.

Final Thoughts

Selecting multiple, non-adjacent data ranges in Excel is a fundamental skill that streamlines countless tasks. Whether you use the simple Ctrl/Cmd key for quick formatting, the Name Box for precision, or Named Ranges for recurring reports, these techniques reduce manual clicks and help you focus on analyzing your data rather than fighting with the software.

Putting these Excel tricks into action is a solid step toward automating tiresome reporting tasks. However, many marketing and sales teams still spend hours each week downloading CSVs from different platforms like Google Analytics, Shopify, or Salesforce and wrestling with them in spreadsheets. At Graphed, we remove this friction entirely. Instead of manual data wrangling, you can connect your sources once, then simply ask for the dashboards and reports you need in plain English. Your data stays in sync automatically, giving you live insights whenever you need them.