Solved Multiple cell selection in Excel when you do not want it!!!

October 10, 2013 at 09:44:55
Specs: Windows XP
This is very annoying . . . I select a range of cells (a row) and then double-click Format Painter so that I may copy the format of this selected range of cells and paste the format within another range of cells --then the annoying thing happens after several "Paints" . . . several rows are selected instead of the "ONE" CELL or row. I click undo . . right click . . left click and it just keeps going and going and going . . . I press the up arrow once and SOMETIMES THIS CLEARS the selection to just one cell, but then it starts again.

Microsoft NEEDS to recognize that this is a problem!!!

See More: Multiple cell selection in Excel when you do not want it!!!

Report •

October 10, 2013 at 10:04:11
✔ Best Answer
I'm sure that MS recognizes it as a problem. Whether they take any action to fix it is another story. DAGS and you'll see that many others have experienced it, perhaps not specifically with respect to the Format Painter, but in general having multiple cells selected when attempting to select just one.

Adjusting the zoom level up then down then back to the required setting is reported to clear it.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

message edited by DerbyDad03

Report •
Related Solutions

Ask Question