Most constant Excel users have actually tried to pick multiple cells or ranges and also accidentally selected too countless cells. Once you finish the selection, yes no way to deselect the unwanted cells. The only option has been to begin all over. Starting this month, Office 365 is rolling out a systems that will certainly let girlfriend deselect the unwanted cells.

You are watching: How to select a cell without deselecting another in excel


DESELECT CELLS

Consider figure 1. You’ve offered the mouse to choose B2:E4. You then held down Ctrl and used the computer mouse to choose B8:E10, climate I2:L4. However when friend did the exact same with cell I8:L10, friend went one tower too far and inadvertently selected cells M8:M10 together well. As soon as you released the mouse button, lock were component of the selection. You had to begin over again (and likely did it more slowly to make certain you no slip again).

*
Figure 1

With this new feature, however, you have the right to simply deselect the unwanted cells. Host down the Ctrl key. Through the mouse, click M8 and drag it come M10. Together you room dragging, the area becomes a lighter shade of gray. Relax the computer mouse button, and the three cells space no longer part of the selection. The a tiny brand-new feature, however you’ll be amazed at how quickly you begin using it.

People that subscribe to Office 365 will have this feature in February or march 2018 (depending on your IT department’s choice on how quickly you receive new features). Those there is no Office 365 subscriptions will get the feature when Office 2019 is released later on this year.

CELL selection TIPS

There space a number of methods you can use come make choosing cells simpler or much more efficient.

Go come Special. You can use go To distinct to select certain varieties of cells, together as just those containing a formula or those with only numbers.

In number 1, only the complete rows and also columns space formulas. The rest are numbers manually typed right into Excel. If you want to quickly select the formulas, pick cells B2:M11. Then, indigenous the home tab, go to find & Select, Formulas. Excel will pick just the formula cells.

If you want to select every one of the cells through numbers and not formulas, follow these steps:

Select B2:L10.Choose Home, discover & Select, go To Special.

*
Figure 2

In the walk To one-of-a-kind dialog, select Constants.The four checkboxes below Formulas additionally work because that Constants. Uncheck Text, Logicals, and also Errors. This leaves Constants and Numbers, as displayed in number 2.

*
Figure 3

Click OK. Your choice will adjust to only the numeric cells that aren’t formulas.

*
Figure 4

Shift Key. another useful technique is utilizing the Shift key when selecting cells. Say that you have to pick a selection of cells that are a mix of north cells and also those through data. Click on the very first cell. Hold the transition button, use the computer mouse to click on the critical cell. Excel will choose everything in between the 2 cells.

*
Figure 5

Many world don’t realize the the Shift vital also deserve to be used to choose with the navigating keys. Say you space at the finish of a big data set. The active cell is M659. Pressing Ctrl+Home will jump to cell A1. If you add the transition key—Ctrl+Shift+Home—you’ll choose all cells from M659 come A1.

But what if girlfriend don’t want to select all the means to A1? her data has headings in row 1 and labels in pillar A. So girlfriend would choose to choose from M659 to B2. There’s no built-in shortcut crucial to jump to B2, yet there’s an easy way to carry out this:

Press Ctrl+End to take it the cursor to the critical cell in her data.Click in the Name crate (located to the left the the Formula bar).Type B2, however don’t press Enter.Hold under the Shift crucial while pushing Enter. Excel will select from the active cell ago to B2.

*
Figure 6

Alternatively, you might use the walk To dialog (Ctrl+G) to quickly move to B2. Then push Ctrl+Shift+End to choose to the last offered cell in the worksheet.

Extend Selection. press the F8 key, and also “Extend Selection” will appear in the standing Bar in ~ the bottom that Excel. As soon as you click in any kind of cell, Excel will choose from the active cell to the recently clicked cell. The nice feature around this is that you can easily reselect a various ending cell, and Excel will always select indigenous the energetic cell come the freshly clicked cell.

*
Figure 7

*
Figure 8

Extend an option also works utilizing the arrow keys. Begin in cabinet B2. Press F8. Usage the best arrow and also down arrow to move the cursor around, and also Excel will save selecting extr cells till you protect against pressing arrowhead keys.

Add come Selection. press Shift+F8 key, and also “Add come Selection” will appear in the condition Bar in ~ the bottom of Excel. You deserve to select extr areas making use of the mouse, however you don’t have to hold down the Ctrl key.

Go To. press F5 (or Ctrl+G) to open the walk To dialog. Friend can kind B2:M659 and press get in to quickly choose that range.

See more: How To Check Lra On Compressor Locked Rotor Diagnostic, How Can We Check The Lra Of A Compressor

SF SAYS

Selecting multiple areas was frustrating once there was no means to deselect one errant cell. Now there’s a solution.