Watch the Excel Tutorial Video. This video shows how the multiple select and remove features work. You can also see the Excel VBA code, and the steps that it goes through, when you make a selection in the drop down list. ________________. Step by Step: Select the range of cells you want to deselect. Press the Esc key on your keyboard. The previous selection is now deselected, and you can proceed with another selection. Step 1: Click Kutools > Select Tool >> Select Range Helper…. Step 2: In Select Range Helper dialog box, check the Deselect Cells option, and then click or drag mouse to deselect cells or ranges from the selection. See screenshot: Step 3: And the cells you unwanted have been deselected from the selection. Step 1: Select the cells you want to deselect. Step 2: Click on the "Home" tab in the Ribbon. Step 3: Click on "Editing" group to reveal the dropdown arrow located under "Clear". Step 4: Click on "Clear" to display another set of options. Choose "Clear Formats" or "Clear Contents" depending on your need. Click on the Cell to Deselect: Identify the cell that you wish to remove from your selection. With the Control key still pressed, click on the undesired cell. This action will deselect that particular cell. Deselecting a Range of Cells: In some cases, you might need to deselect an entire range of cells. Click on " Deselect " from the menu (second from the top) to deactivate all area selections. You can use keyboard shortcuts to make a quick deselection by simultaneously pressing ⌘ and D (mac) or Ctrl and D (Windows PC). It is a lot easier to deselect an object than what it can be to make complexed selection in the first place. 1. Using CTRL Key to Deselect Multiple Cells/Columns/Rows. You can use the CTRL key to deselect specific cells or ranges of cells from a larger selection. This feature can be useful when you have selected a large range of cells, but need to remove one or more cells, columns from that selection to perform certain operations. There are two ways that you can deselect your selection in Photoshop. You can use your mouse or the keyboard shortcut . To do it the long way, go up to Select on the menu bar and choose Deselect from the dropdown menu. I know, super long, right? The second way is even easier. Just hit Ctrl + D ( Command + D on a Mac) on the keyboard. Voila! You can see after the selection that selected columns get unselected. Deselect the Entire Columns in Excel. First, press and hold the "Control" key from the keyboard. After that, click on the column header and drag to the entire column to deselect that column from your current selection. 3 Answers Sorted by: 5 By using the SHIFT and/or the CTRL keys you can select non-contiguous ranges. However, if you select a cell or area by mistake, there is no built in way to remove that from the selection without losing the entire selection and having to start over. If you want to deselect specific cells, you can hold down the "Ctrl" key and click on the individual cells that you want to deselect. This will remove the highlight around that particular cell without removing the entire selection. You can also use the "Ctrl" key while you click and drag the mouse. Hold the Control key Click on the cell which you want to deselect. In case you want to deselect a range of cells (such as a quarter column in our example), click and drag to cover the entire column/range) To unselect a range of selected cells hold down the CTRL (or Command for Mac) key and drag the range you want to deselect, starting from within a selected range. Deselect a selected cell in Excel How to multi select cells or ranges This has not changed, you can still use the CTRL (or Command on Mac) key to click on an unselected cell to select it. 5W8Ay.

how can you deselect a selection