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.

Conclusion

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

Currency_Converter_V1.0

Currency Conversion Calculator

If you need an offline or currency table that you …

Swot analysis

Swot analysis

A SWOT Analysis is a structured brainstorming and evaluation tool used to …

Basic Pro Forma Invoice Format Template in excel

Basic Pro Forma Invoice Format in Excel

Introduction: A Crucial Tool for Preliminary Billing What Is a …

AccountingJournalPic

Accounting Journal

Simplify Your Financial Tracking with a Free Editable Excel Accounting …

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.