Many times, I believe, when we are selecting multiple Cells or Ranges of Cells in a Microsoft Excel Spreadsheet, we accidentally select on or more that we didn’t mean to do. What did we usually do? We started all over again, wishing that we would be more accurate and luckier this time. Well, we do not have to worry any more. We can Deselect any Cells within the Selected Range by simply pressing the Ctrl Key button on our keyboard. We just press the Ctrl Key, and click, or click and drag to deselect Cells or Ranges of Cells. Just on keep on reading the post below to find out, how it can be done.
In the image below I have selected the Data that begins from the Cell A1 until the Cell D100 (which cannot be seen in the screenshot). I selected the first Cell and then by simply dragging my mouse I reached at the end of what I wanted to select. The range of Cells is from A1 until D100.
Now let’s say, that by accident I didn’t want some Cells to be selected. How can I deselect them and not by selecting them again from the beginning? As all the Cells are selected as shown below, I move my mouse over the first Cell that I want to be deselected and for my example is the Cell A2. I press the Ctrl button on my keyboard and then with my mouse I do a left click on the Cell A2. That is it. We follow the same procedure for the rest of the Cells that we want to be deselected, and all this just by holding the Ctrl button at the same time we do the left click on our mouse.
In the image below, while holding down the Ctrl key of my keyboard, I have deselected the Cells, B4, B11, B15, C10, C18, D5, D8 and D14. If we click with our mouse anywhere in the Spreadsheet without holding down the Ctrl key, all the Selections will be lost.
Below you can check out the video describing How To Deselect A Selection in a Spreadsheet in Microsoft Excel?
Don’t Forget To Subscribe To My YouTube Channel.