Learn how to Select Non-Contiguous Cells in Excel

Select Non-Contiguous Cells in Excel

Table of Contents

Select cell without using Ctrl Key

By following these simple steps we can do it.

  1. At first, Select the cell from where you want to start your selection.
  2. Then press shortcut key Shift + F8 for once.
  3. There a message will show  “Add To Selection” on your status bar – bottom of your Excel window.
  4. Now, you can easily select the cells just by clicking on them.
  5. Now , you can do anything with your selection like (formatting, deleting, etc.).
  6. Just press ESC key to release your selection.

Without Using Mouse

To select non-continuous cells without using your keyboard just follow these simple steps.

  • Press shortcut key shift + F8 to activate the “Add To Selection” Mode.
  • Then, Navigate it  to the range you want to include in your selection, and  press Shift + F8 again.
  • Repeat the same process.

Note: While trying to select non-adjacent range without the keyboard. When you are trying to add single cells to your selection, this method will not work.


So, here is the story about this quick and smart way to select non-adjacent cells in Excel. What do you think method is better to use? First or second. Or, you still want to use the Ctrl key to select non-adjacent cells in Excel.

Free Excel Templates


HR To Employee Ratio Calculator

HR To Employee Ratio Calculator is an excel template that …


Accounting Journal

Simplify Your Financial Tracking with a Free Editable Excel Accounting …

Commercial Invoice Format in Excel Sheet

Commercial Invoice

Introduction: Navigating International Trade with Ease. Free Invoice Template Engaging …

27000+ list of SAP T-codes for CRM Module in Excel sheet

Customer Relationship Management (CRM) Module

Download Customer Relationship Management (CRM) Module SAP S4 Hana TCODE …

We Create Your Life Easy With Our Free Excel Templates & Spreadsheet Dashboards

Use free Excel Templates, Tools and Dashboards to create and draft a professional looking dashboards and computation sheet for your personal and business use. You can Explore Calendars, Activity Planners, Invoice Templates, Sales Forecast Sheets, Budget templates and various business information delivering Templates in Excel and Spreadsheet at XLSX Templates. 

These templates, dashboards and tools are useful in various occasions. You can also customize these templates as per your requirement. Modification of fields and data source helps in making the template more relevant.

Learn Microsoft Excel : Blogs and Articles

Learn about various tips and tricks in Microsoft Excel and Spreadsheet. Create best templates and dashboards using free tricks and tutorials in excel and spreadsheet. These tutorial posts are useful for everyone who wants to master the skills in excel and spreadsheet.