How to Highlight Non-Adjacent Cells in Excel

Using the Mouse

To highlight non-adjacent cells with the mouse, click on the first cell, then hold the Ctrl key and click on each additional cell you want to include in the selection.

Using the Keyboard

Press and hold the Ctrl key, then use the arrow keys to move the cursor to a non-adjacent cell, and press the Spacebar to add it to your selection.

Using the Name Box

Enter cell references separated by commas in the Name Box to select non-adjacent cells. For example, type "A1, C1, E1" to highlight cells A1, C1, and E1.

Using Find and Replace

Use the Find and Replace feature to search for specific content, and then use the Ctrl key to select each cell from the search results that you wish to highlight.

Common Use Cases

• 
  Applying the same formatting to multiple non-adjacent cells
• 
  Summarizing data from non-contiguous areas in a single formula
• 
  Comparing or contrasting values from different parts of a worksheet
• 
  Copying or moving a selection of non-adjacent cells to another location
• 
  Creating a complex chart using data from non-connected cells

Excel vs. Sourcetable: A Comparative Analysis

Discover the new age of data handling with Sourcetable, a powerful alternative to the traditional Microsoft Excel. Sourcetable revolutionizes data management by integrating multiple data sources into a single, streamlined spreadsheet interface.

Unlike Excel, Sourcetable enhances productivity with its AI copilot. This intelligent feature assists users in creating complex formulas and templates effortlessly, leveraging a conversational chat interface.

Experience seamless data queries in Sourcetable without the typical constraints of Excel. Sourcetable's innovative approach simplifies data analysis, enabling users to focus on insights rather than data preparation.

Choose Sourcetable for a tailored spreadsheet experience. Its AI-powered assistance transforms data manipulation, offering a competitive edge over Excel's traditional, manual formula creation.