Simon Sez IT

Online software training and video tutorials for Microsoft, Adobe & more

  • Course List
    • Adobe
      • Dreamweaver
        • Dreamweaver CC
        • Dreamweaver CS6
        • Dreamweaver CS5
        • Dreamweaver CS4
      • Flash
        • Flash CS5
      • InDesign
        • InDesign CS6
        • InDesign CS5
      • Photoshop
        • Photoshop CS6
        • Photoshop CS5
        • Adobe Photoshop CS4
      • Photoshop Elements
        • Photoshop Elements 2022
        • Photoshop Elements 2019
        • Photoshop Elements 2018
        • Photoshop Elements 15
        • Photoshop Elements 14
        • Photoshop Elements 13
        • Photoshop Elements 12
        • Photoshop Elements 11
        • Photoshop Elements 10
        • Photoshop Elements 9
        • Photoshop Elements 8
    • Microsoft
      • Access
        • Access 2021 Beginners
        • Access 2019
        • Access 2019 Advanced
        • Access 2016
        • Access 2016 Advanced
        • Access 2013
        • Access 2013 Advanced
        • Access 2010
        • Access 2010 Advanced
        • Access 2007
      • Excel
        • Data Analytics in Excel
        • Excel 2021 Advanced
        • Excel 2021 Intermediate
        • Excel 2021 Beginners
        • PivotTables for Beginners
        • Excel Dashboards
        • Advanced Formulas in Excel
        • Excel for Business Analysts
        • Advanced PivotTables
        • Power Pivot, Power Query and DAX in Excel
        • Excel 2019 Beginners (Mac)
        • Excel 2019 Beginners
        • Excel 2019 Advanced
        • Excel 2016 Beginners
        • Excel 2016 Intermediate
        • Excel 2016 Advanced
        • Excel 2013
        • Excel 2013 Advanced
        • Excel 2010 Beginners
        • Excel 2010 Advanced
        • Excel 2007
      • OneNote
        • OneNote Desktop and Windows 10
        • OneNote 2016
      • Outlook
        • Outlook 2021
        • Outlook 2019
        • Outlook 2016
        • Outlook 2013
        • Outlook 2010
        • Outlook 2007
      • Power Automate
        • Introduction to Power Automate
      • Power BI
        • Power BI
        • Power BI Intermediate
      • PowerPoint
        • PowerPoint 2021
        • PowerPoint 2019
        • PowerPoint 2016
        • PowerPoint 2013
        • PowerPoint 2010
        • PowerPoint 2007
      • Project
        • Project 2021 Beginners
        • Project for the Web
        • Project 2019
        • Project 2019 Advanced
        • Project 2016
        • Project 2016 Advanced
        • Project 2013
        • Project 2013 Advanced
        • Project 2010
        • Project 2010 Advanced
      • Publisher
        • Publisher 2013
      • SharePoint
        • SharePoint Online
        • SharePoint Foundation 2013
        • SharePoint Server 2013
        • SharePoint Foundation 2010
      • Teams
        • Microsoft Teams
      • VBA
        • Macros and VBA for Beginners
        • VBA for Excel
        • VBA Intermediate Training
      • Visio
        • Microsoft Visio 2019
        • Visio 2016
        • Visio 2013
        • Microsoft Visio 2010
      • Windows
        • Windows 11
        • Windows 10 (2020 Update)
        • Windows 10
        • Windows 8
        • Windows 7
        • Windows Vista
      • Word
        • Word 2021
        • Word 2019 Advanced
        • Word 2019
        • Word 2016
        • Word 2013
        • Word 2010
        • Word 2007
    • QuickBooks
      • QuickBooks
        • QuickBooks Desktop Pro 2022
        • QuickBooks Pro 2021
        • QuickBooks Online Advanced
        • QuickBooks Online
        • QuickBooks Canada
        • QuickBooks Pro 2020
        • QuickBooks 2019
        • QuickBooks 2018
        • QuickBooks Pro 2017
        • QuickBooks Pro 2016
        • QuickBooks Pro 2015
        • QuickBooks Pro 2014
        • QuickBooks Pro 2013
        • QuickBooks Pro 2012
        • QuickBooks Pro 2011
        • QuickBooks Pro 2010
        • QuickBooks Pro 2009
    • Web Development
      • AngularJs
        • AngularJS Crash Course
      • Dreamweaver
        • Dreamweaver CC
        • Dreamweaver CS6
        • Dreamweaver CS5
        • Dreamweaver CS4
      • Bootstrap
        • Bootstrap Framework
      • Html/CSS
        • HTML/CSS Crash Course
        • HTML5 Essentials
      • Python
        • Python Object-Oriented Programming
        • Pandas for Beginners
        • Introduction to Python
      • Java
        • Java for Beginners
      • JavaScript
        • JavaScript for Beginners
        • jQuery Crash Course
      • MySql
        • MySQL for Beginners
      • PHP
        • PHP for Beginners
        • Advanced PHP Programming
      • XML
        • XML Crash Course
    • Data Analysis
      • Financial Modeling
        • Financial Risk Management
        • Financial Forecasting and Modeling
      • Alteryx
        • Alteryx Advanced
        • Introduction to Alteryx
      • Power BI
        • Power BI Intermediate
        • Power BI
      • Qlik Sense
        • Qlik Sense Advanced
        • Qlik Sense
      • R Programming
        • R Programming
      • Tableau
        • Tableau Desktop Advanced
        • Tableau Desktop
      • Python
        • Python Object-Oriented Programming
        • Pandas for Beginners
        • Introduction to Python
    • Work Productivity
      • Google Sheets
        • Google Sheets for Beginners
      • Confluence
        • Introduction to Confluence
      • Monday
        • Getting Started in Monday.com
      • Asana
        • Asana for Employees and Managers
        • Introduction to Asana
      • Jira
        • Getting Started in Jira
  • For Business
  • About Us
    • Testimonials
    • Contact Us
    • FAQ
    • Membership
    • About Us
  • Pricing
  • Free Resources
  • Sign In
  • Get Started
Home > Microsoft Excel > How to Select Non Adjacent Cells in Excel? 5 Simple Ways

How to Select Non Adjacent Cells in Excel? 5 Simple Ways

(Note: This guide on how to select non adjacent cells in Excel is suitable for all Excel versions including Office 365)

In Excel, we need to select cells to perform certain operations or to use functions. In those cases, we either select whole rows, columns, individual cells, or a group of cells.

There are a variety of methods to select adjacent cells. You can either select them by clicking and dragging, or by selecting adjacent cells by holding the Shift Key. But, selecting cells using these methods only selects the adjacent cells. What would you do if the cells are far from each other and you need to select them?

In this article, I will show you 5 ways to select non adjacent cells in Excel.

You’ll Learn

  • Using the Ctrl Key
  • Using the Function Keys
  • Using Name Box
  • Using Go-To
  • Select Non-Adjacent Cells With Similar Values

Watch our video on how to select non adjacent cells in Excel

Related Reads:

How to Rotate Text in Excel? 3 Effective Ways

How to Copy Only Visible Cells in Excel? 3 Easy Ways

How to Wrap Text in Excel? With 6 Simple Methods

Using the Ctrl Key

Holding the Ctrl key and selecting the cells is one of the best ways to select non adjacent cells in Excel. This approach is pretty straightforward. 

To select non-adjacent cells, first, select a cell. Once you click on it, this becomes the active cell. In this example, we have selected the cell E5, so it becomes the active cell.

Select a cell
Select a cell

By pressing and holding the Ctrl key, select the cells you want to select. You can either click on each cell or use the mouse and drag to select a range of cells. Once you have selected all the necessary cells, leave the Ctrl key.

Select a group of cells using the Ctrl Key
Select a group of cells using the Ctrl Key

Using the Function Keys

In some cases, you might have to use only the keyboard and perform certain operations. When confronted with that situation, you can use the function keys to select the non-adjacent cells.

To select the non-adjacent using function keys, click on any cell to act as an active cell. In this case, we’ll consider C5 as the active cell. 

Select any cell
Select any cell

Now, press the function key F8. This enables the Extended Selection mode. You can see the Extended Selection mode enabled from the bottom-left of the spreadsheet near the Accessibility status.

Enter Extended Selection mode
Enter Extended Selection mode

Since the sheet is in Extended Selection mode, you can use the arrow keys to select the adjacent cells. If you don’t want to select any adjacent cells, you can just skip to the next step.

Select the cells
Select the cells

To select the non-adjacent cells, press Shift+F8. This, in turn, enables the Add or Remove Selection mode.

Add or Remove Selection mode
Add or Remove Selection mode

Now, use the arrow keys to move the selection and select the cells you want. In this case, we move to cell J10 using the arrow keys.

How to select non adjacent cells in excel using function keys
How to select non adjacent cells in excel using function keys

Once you have moved to another non-adjacent cell, press F8 again to enable the Extended Selection mode and select the cell or group of cells.

Disable Extended Selection mode
Disable Extended Selection mode

After you have selected the non-adjacent cells, press F8 to get back to Normal mode.

Also Read:

Excel DATEVALUE – A Step-by-Step Guide

How to Use Excel Split Screen? 3 Simple Ways

How to Create a Venn Diagram in Excel? 2 Easy Ways

Using Name Box 

Another easy way to select non adjacent cells in Excel is by using their cell names to make the selection.

To select the cells, first, click on any cell. This marks the cell as the active cell.

Now, click on the Name Box in the top-left corner of the spreadsheet.

Click on the Name Box
Click on the Name Box

Type the name of the cells separated by a comma in the Name Box. You can enter the name of single cells, or the range of cells separated by a comma.

Enter the cells you want to select
Enter the cells you want to select

Press Enter. This selects all the non-adjacent cells in the spreadsheet.

The non adjacent cells are selected
The non adjacent cells are selected

Using Go-To

Another way to select non-adjacent cells is by using the Go-To option. This way of selecting non-adjacent cells is similar to selecting cells using the Name Box option.

To select non-adjacent cells using the Go-To option, navigate to Home. Under Editing, click on the dropdown from Find & Select and click on Go-To. Or, use the keyboard shortcut key Ctrl+H.

Navigate to Go To
Navigate to Go To

This opens up a Go To dialog box.

Since we have selected cell B5, it becomes the active cell and populates in the reference cell field.

Enter Cell name
Enter Cell name

Enter the name of the cells, or a range of cells separated by a comma, and click on OK.

Click on OK
Click on OK

This selects the non-adjacent cells in the Excel spreadsheet.

The non-adjacent cells are selected
The non-adjacent cells are selected

Select Non-Adjacent Cells With Similar Values

This is another special case to select non adjacent cells in Excel. However, this method can only be used if the content of the cells is similar. 

To find cells with similar values, navigate to Home. Under Editing, click on the dropdown from Find & Select and click on Find. Or, you can use the keyboard shortcut key Ctrl+F.

Click on Find
Click on Find

This opens up a Find and Replace dialog box.

Click Find and enter the value you want to locate. Click on Find All.

Enter the value and click Find All
Enter the value and click Find All

This shows the location and description of the cells with the specific value.

You can see all the cells with the same value
You can see all the cells with the same value

Click on Ctrl+A to select all the cells with similar values.

Select all the cells
Select all the cells

Now, either click on Close or the X button to close the Find and Replace dialog box and keep all the selected cells.

All the non adjacent cells are selected
All the non adjacent cells are selected

Suggested Reads:

How to Graph a Function in Excel? 2 Easy Ways

How to Enable Excel Dark Mode? 2 Easy Methods

How to Calculate Factorial in Excel? Along with 2 Easy Examples

Closing Thoughts

Selecting non-adjacent cells in Excel can be very helpful when replacing texts, performing any function and operations, or even deleting certain values from the spreadsheet.

In this guide, we saw how to select non adjacent cells in Excel using 5 easy ways. Depending on your preference you can choose to use any method to select the cells.

If you need more high-quality Excel guides, please check out our free Excel resources center. Simon Sez IT has been teaching Excel for over ten years. For a low, monthly fee you can get access to 130+ IT training courses. Click here for advanced Excel courses with in-depth training modules.

Simon Calder

Chris “Simon” Calder was working as a Project Manager in IT for one of Los Angeles’ most prestigious cultural institutions, LACMA. He taught himself to use Microsoft Project from a giant textbook and hated every moment of it. Online learning was in its infancy then, but he spotted an opportunity and made an online MS Project course - the rest, as they say, is history!

Most Popular Posts

  • Kanban vs Scrum: Project Management Methodologies and Their Differences [2022]
  • How to Insert a Checkbox in Excel? 3 EASY Examples
  • How to Autofit Excel Cells? 3 Best Methods
  • XLOOKUP Google Sheets – 4 Best Alternatives!
  • Dashboards in Excel Using Pivot Tables, Pivot Charts and Slicers
  • Free Microsoft Project Training Course
  • Free Microsoft Access Tutorial for Beginners (3.5 Hours Video)
  • How to Use Blending Mode With Layers in Adobe Photoshop Elements 15

Similar Posts

How to Use the Color Selection Tool & Magic Wand in Photoshop Elements 15

How to Enable Excel Dark Mode? 2 Easy Methods

How to Convert Speech to Text in Word? A step-by-Step Guide

How to Delete a Page in Word?

Finding Duplicate Records in Access 2013

Using Access Keys with PowerPoint 2010

Course Categories

  • Adobe
  • Data Analysis
  • QuickBooks
  • Microsoft
  • Web Development
  • Work Productivity

About Us

  • About Us
  • Free Resources
  • Affiliates
  • Become an Instructor

Products

  • Pricing and Plans
  • Business Pricing
  • Government Discounts
  • Non-Profit Discounts

Support

  • FAQ’s
  • Contact Us
  • DVD support

Connect

YoutubeFacebookLinkedIn
© 2023 Simon Sez IT, Inc.
  • Terms
  • Privacy Policy
  • Sitemap
888.817.6665 Monday thru Friday 7:30 a.m. - 5:00 p.m. (ET)