How To Select Non Adjacent Cells In Excel

To select non adjacent cells in Excel, hold down the Ctrl key and click on each individual cell that you want to include in the selection.

Excel is undoubtedly one of the most powerful and widely used tools in the world of data management and analysis. Whether you are a professional accountant, data analyst, or simply someone who likes to keep track of numbers, chances are you have spent a significant amount of time working with Excel.

Navigating through spreadsheets and selecting cells is a fundamental skill required to make the most out of Excel. While selecting adjacent cells is a straightforward process, selecting non-adjacent cells can be a bit trickier for some users.

In this blog post, we will guide you through the process of selecting non-adjacent cells in Excel. We will explore various methods and shortcuts that will make this task easier and more efficient. By the end of this post, you will have a solid understanding of how to select non-adjacent cells and optimize your workflow in Excel. So let’s dive in and unlock the full potential of your Excel skills!

How To Select Non Adjacent Cells In Excel: Step-by-Step


Step 1: Open Microsoft Excel,

To open Microsoft Excel, search for the program in your applications or programs list and click on the shortcut. It’s the first step towards utilizing the software’s powerful features and functions.

Next Step

Step 2: Open the Spreadsheet,

After launching Microsoft Excel, simply click on ‘File’ at the top left, then select ‘Open’ to choose and open your desired spreadsheet.

Next Step

Step 3: Initial Cell Selection,

After you have opened the Excel spreadsheet, simply click on the first cell you want to select, which will be indicated by a highlighted or bordered appearance.

Next Step

Step 4: Hold Control Key,

By pressing and holding the control (‘Ctrl’) key on your keyboard after selecting the initial cell, you can easily select multiple cells that are not next to each other, enhancing your efficiency and flexibility in working with data.

Next Step

Step 5: Select Non-Adjacent Cells,

While holding down the Control key, you can effortlessly select multiple non-adjacent cells within a spreadsheet by simply clicking on each desired cell. This allows for convenient and efficient selection of as many cells as necessary.

Next Step

Step 6: Release Control Key,

This is a useful feature when you want to perform multiple operations on different areas of a spreadsheet simultaneously, without having to continuously hold down the Control key.

Next Step

Step 7: Applying Further Function or Operation,

With the selected cells, you have the power to perform various actions effortlessly. Format them simultaneously or apply a function that will automatically be executed on all the chosen cells, simplifying your tasks significantly.


In conclusion, being able to select non-adjacent cells in Excel is a valuable skill that can greatly improve your efficiency and productivity. By using keyboard shortcuts or the mouse, you can easily select multiple cells across different ranges or non-adjacent rows and columns. This feature allows you to perform various operations simultaneously, such as formatting, data entry, or calculations.

Remember to utilize the Ctrl key (or the Command key on Mac) to select the desired cells non-adjacently. Additionally, you can combine the Shift key to select multiple continuous ranges of non-adjacent cells quickly.

Mastering the art of selecting non-adjacent cells in Excel will undoubtedly save you time and energy, enabling you to work smarter and achieve better results in your spreadsheets. So go ahead and start practicing this technique to streamline your Excel tasks and become a true Excel power user.

Table of Contents