EXCEL FOR MAC UNSELECT CELLS HOW TO
If we click with our mouse anywhere in the Spreadsheet without holding down the Ctrl key, all the Selections will be lost.īelow you can check out the video describing How To Deselect A Selection in a Spreadsheet in Microsoft Excel?ĭon’t Forget To Subscribe To My YouTube Channel. Then, you accidentally click some cells that should not be in the selection. 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. You are selecting multiple ranges in Excel using Ctrl. 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. I press the Ctrl button on my keyboard and then with my mouse I do a left click on the Cell A2. 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. Now let’s say, that by accident I didn’t want some Cells to be selected.
The range of Cells is from A1 until D100. I selected the first Cell and then by simply dragging my mouse I reached at the end of what I wanted to select.
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). Just on keep on reading the post below to find out, how it can be done. We just press the Ctrl Key, and click, or click and drag to deselect Cells or Ranges of Cells. We can Deselect any Cells within the Selected Range by simply pressing the Ctrl Key button on our keyboard. What did we usually do? We started all over again, wishing that we would be more accurate and luckier this time.
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.
0 kommentar(er)
