How to Select Non Adjacent Ranges in Excel

Using the Mouse and Ctrl Key

To select non-adjacent ranges using a mouse, click the first cell or range, hold down the Ctrl key, and then click additional cells or ranges you want to include in your selection.

Selecting with Keyboard Shortcuts

Press the Ctrl key followed by clicking on individual cells to select non-contiguous cells. Utilize the ALT + ; shortcut to select only visible cells within a range.

Using the Name Box

Enter the cell references separated by commas in the Name Box to select multiple non-adjacent cells or ranges.

Utilizing the Go To Special Feature

To select non-adjacent cells that are visible, use the Go To Special feature by pressing Ctrl + G, then choosing 'Special' and 'Visible cells only'.

Employing VBA for Advanced Selection

Select non-contiguous ranges programmatically with VBA to perform more complex tasks such as selecting all cells with data on a sheet or a named range.

Common Use Cases

• 
  Comparing quarterly sales data from different years without including other quarters
• 
  Applying the same formatting to multiple, non-contiguous cells containing specific criteria
• 
  Summarizing data from separate sections of a large dataset without altering the arrangement
• 
  Copying and pasting non-adjacent cells with important metrics to a separate report
• 
  Creating complex charts that require data from non-sequential cells

Comparing Excel and Sourcetable for Data Management

Excel and Sourcetable serve as powerful tools for data management and analysis. Excel, a well-established application, is renowned for its versatility in handling complex datasets. Sourcetable, on the other hand, streamlines data integration from multiple sources into a user-friendly spreadsheet interface.

Sourcetable differentiates itself with its AI copilot feature, providing users with assistance in formula creation and templating. This AI integration contrasts with Excel's traditional formula setup, which relies on user expertise and manual input.

The AI copilot in Sourcetable enhances productivity by simplifying the technical aspects of data manipulation. In comparison, Excel users may require a deeper understanding of functions and formulas to achieve similar results.

While Excel is a robust tool for data analysis, Sourcetable's approach to consolidate data and its AI-driven user assistance offers a more accessible platform for users across various skill levels.