How To Deselect Multiple Selections in a Microsoft Excel Spreadsheet?

Posted on

Microsoft Excel Blog Banner

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.

How To Deselect Multiple Selections in a Microsoft Excel Spreadsheet

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.

How To Deselect Multiple Selections in a Microsoft Excel Spreadsheet

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.

How To Deselect Multiple Selections in a Microsoft Excel Spreadsheet

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.

YouTube Channel

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s