Learn how to Select Non-Contiguous Cells in Excel

Generic filters

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

Account Register

Accounting Register

Accounting register template in excel allows you to track your …

Download Now

Cash Flow Planner

Company Cash Flow Planner spreadsheet is to plan more detail …

Download Now

Lesson Plan

Use our weekly lesson plan template as a free way to …

Download Now

Students Exam Hall Ticket Generator

Students’ Exam Hall Ticket Generator is an excel template to …

Download Now

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.