9 replies
by anskey_nick Accepted solution
by thumbsup2 Accepted solution
by anskey_nick Accepted solution
by thumbsup2 Accepted solution
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 Accepted solution
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 Accepted solution
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 Accepted solution
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 Accepted solution
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.
by bizzo Accepted solution
Apparently it's never been a feature of Excel.
Here's a couple of links that may be of use to you:
VBS code to add this feature:
http://www.cpearson.com/excel/unselect.htm
An add-in (Ultimate Add-In) for Excel, to do unselect and more:
http://www.dom-and-lis.co.uk/
This discussion is closed to new replies.
Trending Software posts
Sort by Trending