Question Locked

Unselecting a single cell after highlighting a range

0 helpful
9 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
In Excel, if I highlight a range of cells, and then realise I have accidentally highlighted one I don't want, is there a way I can I un-highlight that cell without losing all the rest of the selected cells?

9 replies

by thumbsup2

Hold down the CTRL key while clicking the cell you want to de-select.

by anskey_nick

it appears to unhighlight that cell, but in fact if you hold control down and click on a cell, then go to format the rest, all the cells are formatted, including the one you had highlighted.

by thumbsup2

If you're formatting cell borders, the cells around it will have borders and make it appear as if that one cell has borders.

So, what kind of formatting are you applying?

by thumbsup2

The only way I could keep it from formatting that one cell was to go back and highlight just the cells I wanted formatted using the CTRL key to selectively highlight around it, never having selected that cell to begin with.

Once you highlight them all then CTRL click that one cell to unhighlight it, the black border is only around that one cell which means it's active. So, it in fact is actually selected but not highlighted. The rest are highlighted but not selected. And, formatting is applied to both active and selected cells.

It could be scripted to do what you want, but I highly doubt it would be worth the effort.

by anskey_nick

for example - if I highlight a group of cells, and then wanted to make them bold. If I pick a group of cells in a spreadsheet, and then realise I've picked one of the cells by mistake, so as you said, hold down control and pick the wrong cell, then hit CTRL-B, for example, all the cells, including the one I didn't want to make bold, are bold.

It's more of laziness thing - I could always just start selecting the cells again from scratch, but sometimes you just wonder if there's a clever way to fix something.

by heludaye

1st click the 1st cell after that press CTRL then click the 2nd cell,3rd cell,4th cell,... you want select.
(CTRL + the cells)

by thumbsup2

Please re-read the original and subsequent posts.

The original question asked how to UN-SELECT one or more cells after they have ALREADY been highlighted as a group so that formatting could be applied to all but that cell. We've already shown that s/he can go back and re-select only what s/he wants selected using CTRL+click. But, that doesn't answer the original question.

This discussion is closed to new replies.