How to Select Two Sets of Data in Excel

Trying to compare data from two different parts of your Excel spreadsheet can feel like a clumsy juggling act. Copying and pasting cells just to create a simple chart is time-consuming and clutters an otherwise clean worksheet. Fortunately, Excel has a straightforward built-in feature that lets you select multiple, separate ranges of data at once - a fundamental skill for anyone looking to work more efficiently.

This tutorial will walk you through the simplest ways to select two or more non-adjacent sets of data in Excel. We'll cover the most common keyboard and mouse shortcuts and then explore some practical examples of when and why you'd want to use this handy skill.

What Does "Selecting Two Sets of Data" Mean?

In Excel, you're usually working with a continuous range of data - a single, solid block of cells like A1:B7. However, there are times when you want to work with data at separate places in your sheet. These selections are referred to as non-adjacent ranges, like A1:A3, F2:F10.

The ability to select these non-adjacent ranges is powerful because it allows you to create charts, format cells, or even print only the cells that matter, without rearranging the worksheet. It's about working smart, not hard.

Method 1: The Keyboard Shortcut (Ctrl/Command Key)

The easiest method to select multiple sets of data is by using a combination of your mouse and the Ctrl (Cmd on Mac) key. It's a simple trick but can be incredibly efficient if you know when to use it.

Here’s how to use the keyboard shortcut:

Steps to Select Non-Adjacent Ranges

1. Start by clicking and dragging to select your first set of data. For example, select A1:A3 by dragging your mouse over that range.
2. Once the first range is highlighted, press and hold the Ctrl/Command key on your keyboard. While holding this key, you can now click and drag your mouse to select a second set of data - say, E1:E5. Release the mouse button and then the Ctrl/Command key.
3. Continue selecting additional data ranges by holding the Ctrl/Command key and clicking and dragging over new sets of data. Each range you select will be added to your overall selection.

Congratulations! You've successfully selected two or more non-adjacent data sets. Now you can create a chart, format them as needed, or copy them elsewhere.

Note: Watch out for common pitfalls when using this method. If you accidentally click while holding down the Ctrl/Command key, you will deselect everything, and you’ll have to start over. Be careful and patient as you make your selections.

Method 2: Using Named Ranges

While the Ctrl/Command method is great for quick jobs, it’s inefficient when you frequently work with the same set of data. Naming a range is simply a section of cells that has been given a name. You can use this name to quickly select the cells.

Steps to Name Your Data Ranges

1. Select your first data range (e.g., A1:A10).
2. In the Name Box next to the formula bar, type "FirstQuarterSales" and press Enter. Names cannot contain spaces and must start with a letter or underscore.
3. Repeat the process for each range of data you want to select later.

Step: Selecting with "Go To"

1. Press F5 on your keyboard or go to Home > Find & Select > Go To.
2. When the "Go To" dialog box appears, type the names of your ranges you want to select, separated by a comma. For example, you could type "JanuarySales,FebruaryProfit".
3. Excel will instantly highlight both data sets on your worksheet.

Being able to select multiple non-adjacent datasets in Excel is fundamental. Whether you're just adjusting a report or doing insightful data analysis, this technique boosts your capability to work efficiently and intelligently.

Final Thoughts

Knowing how to select multiple, non-adjacent datasets in Excel is fundamental. It allows you to work the way you want without wasting time. It's about being more efficient and intelligent through your workflow. While data can always be wrangled in spreadsheets, spending hours merging datasets manually shouldn't be an option. At Graphed, we developed solutions for these inefficiencies by simplifying connections and creating a streamlined dashboard where you can get instant data reports. Explore how Graphed can help you modernize your data practices - simply try Graphed today.