Excel for the web Microsoft 365Microsoft 365 for MacWeb Click a cell to select it or use the keyboard arrows to navigate to a cell. To select non-adjacent cells, hold down Ctrl and select the cells. To select all cells, press Ctrl+A. Select row number or column letter to select the...
But both of these methods work when you want to select a contiguous range of cells. But what if you want toselect non-adjacent cells in Excel? You can do that too… it’s not as easy as selecting the adjacent cells, but it’s still quite easy. ...
The Microsoft Excel'sGo tocommand can help you select non-adjacent cells or ranges quickly with following steps: 1. Click theHome>Find & Select>Go to(or press theF5key). 2. In theGo Todialog box, enter the cell/range positions in theReferencebox, and click lick theOKbutton. ...
Select one or more cells To select a range, select a cell, then with the left mouse button pressed, drag over the other cells. Or use the Shift + arrow keys to select the range. To select non-adjacent cells and cell ranges, hold Ctrl and select the cells. Select one or more r...
Select Adjacent Cells Say you want to select cells A1:C6. To do that, place the cursor on the first cell of the range (A1) and drag the cursor till the last cell (C6). This selects all the cells between A1 and C6. Select Non-Adjacent Cells To select multiple non-adjacent cells (...
Use shortcuts:Excel includes many shortcuts that can make selecting data faster and easier. For example, you can use the “Ctrl” key to select non-adjacent cells, or the “Shift” key to select a range of cells. Avoid overwriting data:When copying and pasting data, be careful not to ...
If your data isn't in a continuous range, select nonadjacent cells or ranges. Just make sure your selection forms a rectangle. Tip:If you don't want to include specific rows or columns of data in a chart, you can simplyhide them on the worksheet, or you can apply chart filters to ...
Select non-adjacent cells or ranges Deselect cells from selected ranges Reverse selections of selected rangesBest Office Productivity Tools 🤖 Kutools AI Aide: Revolutionize data analysis based on: Intelligent Execution | Generate Code | Create Custom Formulas | Analyze Data and Generate Charts | Invo...
Method 2 – Inserting a Range of Non-adjacent Cells in an Excel Formula We can also sum up non-adjacent cells using the Excel formula. For example, let’s sum the sales amounts for the Nashville, Atlanta, and Seattle outlets in February (cells D5, D7, and D9). Follow these steps:...
Keyboard shortcut. To streamline your workflow even further, you can use keyboard shortcut. Select several adjacent cells in one row and press theCtrl + Spacekeys simultaneously to select the entire columns. Tip.When you want tofreeze selected rows, keep in mind that Microsoft Excel allows free...