Excel for Mac. Anyway, when using Excel on a Mac — I’ve got versions 2008 and 2011 — you run into a learning curve with all the unusual shortcut keys, function keys (1, 2), and menu and ribbon things that are different from the Windows version of Excel. So there’s a tendency to forget about how the Delete key works on a Mac.
How to quickly select non-adjacent cells or ranges in Excel?
Sometimes you may need to format or delete some non-adjacent cells or ranges, and work will be easier if you can select these non-adjacent cells or ranges together firstly. And this article is going to brings you some tricky ways to select non-adjacent cells or ranges quickly.
Select non-adjacent cells or ranges with Kutools for Excel
Easily copy and paste multiple non-adjacent cells or ranges simultaneously in Excel
You may have noticed Microsoft Excel does not support copy multiple inconsecutive cells (staying in different columns) at the same time. But copying these cells/selections one by one waste of much time and is tedious! Kutools for Excel’s Copy Ranges utility can help get it done easily as below screenshot shown.Full Feature Free Trial30-day!
Office Tab Enable Tabbed Editing and Browsing in Office, and Make Your Work Much Easier...
Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by80%
- Reuse Anything: Add the most used or complex formulas, charts and anything else to your favorites, and quickly reuse them in the future.
- More than 20 text features: Extract Number from Text String; Extract or Remove Part of Texts; Convert Numbers and Currencies to English Words.
- Merge Tools: Multiple Workbooks and Sheets into One; Merge Multiple Cells/Rows/Columns Without Losing Data; Merge Duplicate Rows and Sum.
- Split Tools: Split Data into Multiple Sheets Based on Value; One Workbook to Multiple Excel, PDF or CSV Files; One Column to Multiple Columns.
- Paste Skipping Hidden/Filtered Rows; Count And Sum by Background Color; Send Personalized Emails to Multiple Recipients in Bulk.
- Super Filter: Create advanced filter schemes and apply to any sheets; Sort by week, day, frequency and more; Filter by bold, formulas, comment...
- More than300 powerful features; Works with Office2007-2019 and 365; Supports all languages; Easy deploying in your enterprise or organization.
Quickly select non-adjacent cells or ranges with keyboards
1. With Ctrl key
Just press and hold down the Ctrl key, and you can select multiple non-adjacent cells or ranges with mouse clicking or dragging in active worksheet.
2. With Shift + F8 keys
This does not require holding down keys during selection. Press the Shift + F8 keys firstly, and then you can easily select multiple non-adjacent cells or ranges in active worksheet.
Quickly select non-adjacent cells or ranges with Go To command
The Microsoft Excel's Go to command can help you select non-adjacent cells or ranges quickly with following steps:
1. Click the Home > Find & Select > Go to (or press the F5 key).
2. In the Go To dialog box, enter the cell/range positions in the Reference box, and click lick the OK button.
And then all corresponding cells or ranges will be selected in the workbook. See screenshot:
Note: This method requires user to figure out the cells or ranges position before selecting them.
Quickly select non-adjacent cells or ranges with Kutools for Excel
If you have Kutools for Excel, its Select Range Helper tool can help you select multiple non-adjacent cells or ranges in the whole workbook easily.
1. Click the Kutools > Select > Select Range Helper….
2. In the Select Range Helper dialog box, check the Union Selection option, next select multiple ranges as you need in the whole workbook, and then click the Close button. See screenshot:
For more detailed information about Select Range Helper, please visit Select Range HelperFree Download Kutools for Excel Now
Demo: select non-adjacent cells or ranges in Excel
Kutools for Excel includes more than300 handy tools for Excel, free to try without limitation in30 days. Download and Free Trial Now!
Related articles:
Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by80%
- Reuse: Quickly insert complex formulas, charts and anything that you have used before; Encrypt Cells with password; Create Mailing List and send emails...
- Super Formula Bar (easily edit multiple lines of text and formula); Reading Layout (easily read and edit large numbers of cells); Paste to Filtered Range...
- Merge Cells/Rows/Columns without losing Data; Split Cells Content; Combine Duplicate Rows/Columns... Prevent Duplicate Cells; Compare Ranges...
- Select Duplicate or Unique Rows; Select Blank Rows (all cells are empty); Super Find and Fuzzy Find in Many Workbooks; Random Select...
- Exact Copy Multiple Cells without changing formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Check Boxes and more...
- Extract Text, Add Text, Remove by Position, Remove Space; Create and Print Paging Subtotals; Convert Between Cells Content and Comments...
- Super Filter (save and apply filter schemes to other sheets); Advanced Sort by month/week/day, frequency and more; Special Filter by bold, italic...
- Combine Workbooks and WorkSheets; Merge Tables based on key columns; Split Data into Multiple Sheets; Batch Convert xls, xlsx and PDF...
- More than300 powerful features. Supports Office/Excel2007-2019 and 365. Supports all languages. Easy deploying in your enterprise or organization. Full features30-day free trial.
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
- Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by50%, and reduces hundreds of mouse clicks for you every day!
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
Hello friends, Today I will tell you a method on how to select Multiple cells in Excel. Users can select or deselect cells. You can also move cells in Excel. This method will work on both Windows and Mac. You can use this method directly on your Microsoft Excel. You can even select random cells from both row and column. You can also select multiple cells using your keyboard.
Contents
- 1 How to Select Multiple Cells in Excel – Excel Selecting Multiple Cells
Do you want to select multiple cells in Excel? Well, using this method you will be able to do so. To select multiple cells in Excel means that you are trying to select a range of cells. However, it is called a range of cells also that is why its known as the same name. You can use the ways to select multiple cells in Excel, either they are described by columns, rows, or at different places in the entire worksheet. Let’s check how to select multiple cells in Excel.
- To select multiple cells in Excel with respect to columns, then click on the column heading.
- To select multiple cells in Excel concerning rows, then click the entire row by clicking the row number.
- To select multiple cells in Excel differently, then hold the shift key and select your cells from different columns or rows.
- To select multiple cells in Excel (entire worksheet) then use the Ctrl+A shortcut key.
Read more: How to Create a Calendar in Excel 2013, 2010 & 2007 – With Code
What are Cells in Excel
A cell is the primary unit storage available in the spreadsheet programs or software like MS Excel, Google Spreadsheet. The data that gets stored in the spreadsheet is always stored directly in the cells. These cells look like a box structure. And each of the cells is located at the intersection point of vertical and horizontal rows in the worksheet. A worksheet can store up to 15,00 columns and 1 million rows in the program, such as Excel, etc. In simple words, a cell is an intersection between rows and columns on any spreadsheet like MS Excel that starts with the cell A1.
Read more: How to Make a Spreadsheet in Excel 2016, 2013 & 2007
How to Move Cells in Excel
Moving cells in MS Excel is very easy. When you move any cell in Excel, then it will move all the data from one cell to another cell that contains data. Moving the cells will also move the data, which are including formulas and their resulting values, comments, cell formats, and hidden cells. In this section, you will be going to introduce to the technique by using which you can quickly move cells in Excel. However, if you don’t know how to select multiple cells in Excel, then you will get to know the same right here. Let’s continue to the section and check it out.
- Select the cell which you want to move.
- Now, hover your cursor on that cell.
- Then, you will see the Plus icon.
- Click on it while keep pressing the Ctrl key.
- Now, transfer it to that area where you want to move it.
Read more: How to Update Graphics Driver on Windows 10
How to Deselect in Excel
Well, if you know that select multiple cells in Excel and now you want to know how to deselect in Excel, then this section will tell you. Select multiple cells in Excel, the deselecting method is also simple. Frankly, to deselect in Excel, you have to use both keyboard and mouse to do so. Otherwise, you will not be able to deselect in Excel. You can use this method in any MS Excel software wherever you want. I have shared a quick and straightforward way to do so. Have a look on the below tweak that how to deselect in Excel.
- Select the region which you want to use.
- Now, keep pressing Ctrl key.
- Then, from the mouseselect the region which you want to deselect.
Read more: Top 10 Best Free apps to Listen to Music Without WiFi on Android & iPhone
How to Select Non-Adjacent Cells in Excel
If you don’t know that how to select non-adjacent cells in Excel then this part of the article is going to help you. Well, selecting non-adjacent cells in Excel is not a tuff task. But, if you don’t know that how to do it then, of course, it’s very tuff task to do. I will tell you a method to select non-adjacent cells in Excel. Also, I will tell you a keyboard shortcut so that it will be easy for you to select non-adjacent cells in Excel. Without wasting time lets start the guide and known that how to select non-adjacent cells in Excel.
- Open that Excel file from where you want to select non-adjacent cells.
- Now, hold the Ctrl key and select the cells that are non-adjacent.
- Then, to view the sum, average or other details, simply click on the bottom of the button for the options.
Read more: How to Make a Spreadsheet in Microsoft Word
Last Words on How to Select Multiple Cells in Excel – Excel Selecting Multiple Cells
We have seen everything about Excel. We have seen how we can select multiple cells in Excel, deselection, select non-adjacent cells, move cells, and what are cells. Using all the above method, you can now use MS Excel without hesitation. Now, you have got all the key points that will guide you while using the Excel worksheet. I hope this guide has helped you a lot. You can share this article with your friends also to let them know how they can also use Excel or how to select multiple cells in Excel.
YesNo