The new "deselect" in Excel is a rushed and worthy of a high school "learn to code" class

Copper Contributor

Before the most recent update if I wanted to select a group of cells to border them or w/e and there were overlapping sections it would work fine. So here are the steps I usually take

1) Select a group 1

2) ctrl-click a new cell to start the sub-group within group 1

3) Shift-Drag the second sub-group within group 1

But now this doesn't work at all, the cells either break or the borders don't happen at all. This is a small annoyance but I don't see any real reason why this was changed it certainly doesn't make anything faster or better. This is Microsoft, did no one check to see how their "deselect" actually works?
And also, how did it take 15 years to implement deselect.

This is what the current deselect does when you try to select a range inside of a highlighted range.

1 Reply

It's not quite clear what you want to happen here, but I went through a number of different situations when trying out the new deselect feature and here's the supposed rules it seems to follow:

 

1.  If selections overlap:  Apply borders by order of selection but clear any borders applied on any previous selection before applying borders.  For "outside borders" this has the effect of overlapping pieces of paper.  You see all of the border of the most recent selection, and less of the previous selections as if they were laid on top of each other.

 

2.  Deselect cells:  When cells are deselected, new independent selection ranges must be defined so each range is contiguous.  So the top rows are one selection, bottom rows a second selection, and the conjoining columns on each side are their own selections, leaving a cap of unselected cells in the center.  When applying an outside border to this, it will apply the border to each selection independently.

 

3.  Adding smaller selections inside an existing selection:  Not possible.  Any attempt to select a range entirely inside of an existing range will result in deselecting those cells (ctrl+click) as in #2, changing the size of the original selection (shift+click), or selecting a new range (click).  Selecting the inside box first and then the outside box second will result in #1 and only the outside box's border will appear (as if laying a larger piece of paper over a smaller one).

 

The only way to accomplish #3 is to apply borders in separate steps and making a new selection before applying the second border.  Select any non-overlapping ranges first to apply the border, then make a new selection to border around all of them.