Excel Paste formats/highlights all cells to the left

%3CLINGO-SUB%20id%3D%22lingo-sub-3211941%22%20slang%3D%22en-US%22%3EExcel%20Paste%20formats%2Fhighlights%20all%20cells%20to%20the%20left%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3211941%22%20slang%3D%22en-US%22%3E%3CP%3EIn%20Excel%202021%2C%20there%20is%20an%20issue%20within%20Excel.%3C%2FP%3E%3CP%3E1.%20Copy%20cell(s)%20and%20paste%20using%20mouse.%3C%2FP%3E%3CP%3E2.%20Click%20on%20some%20other%20cell%20and%20select%20%22Format%20Painter%22%20to%20grab%20the%20cell%20formatting.%3C%2FP%3E%3CP%3E3.%20Then%20with%20the%20mouse%20(now%20showing%20the%20Format%20Painter%20brush%20icon)%20select%20any%20of%20the%20previously%20pasted%20cells.%3C%2FP%3E%3CP%3E4.%20Excel%20will%20Paste%20Format%20data%20across%20the%20column%20downward%20(if%20data%20is%20in%20the%20cell)%20and%20across%20the%20rows%20to%20the%20left.%3C%2FP%3E%3CP%3ENote%3A%20This%20only%20occurs%20if%20the%20original%20Copy'nPaste%20action%20is%20followed%20directly%20by%20Paste%20Format%20and%20only%20if%20Paste%20Format%20is%20done%20using%20the%20Clipboard%20Format%20Painter.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E5.%20Excel%20does%20a%20similar%20action%20when%20selecting%20a%20cell%20to%20drag%20that%20will%20blow%20the%20cursor%20across%20the%20sheet%20to%20the%20left%20for%20no%20apparent%20reason.%20No%20formatting%20is%20applied%20in%20that%20case%2C%20yet%20it%20highlights%20the%20entire%20row%20to%20the%20new%20cursor%20position.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%2C%20Excel%20has%20a%20bug.%20I%20used%20Excel%202016%20that%20didn't%20have%20these%20problems.%20I%20just%20switched%20to%202021%20and%20this%20issue%20happens%20constantly.%20Paste%20or%20drag%20a%20cell%20and%20zoom%2C%20off%20goes%20the%20cursor%20highlighting%20or%20pasting%20formatting%20across%20the%20row%20to%20the%20left.%20Undo%20restores%20the%20cells%20or%20Cntrl-Z%20returns%20the%20cursor%20back%20to%20where%20it%20was%20but%20also%20Undoes%20the%20last%20action%20(so%20clicking%20on%20Redo%20restores%20your%20last%20action%20before%20Excel%20went%20whacky).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAre%20Microsoft%20Excel%20developers%20aware%20of%20this%3F%20Is%20there%20a%20workaround%20for%20it%3F%20I%20don't%20think%20this%20has%20anything%20to%20do%20with%20double-clicking%20the%20cell%20border%20as%20it%20does%20this%20regardless%20(one%20click%20is%20enough).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EJohnnyanglo%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3211941%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3212006%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Paste%20formats%2Fhighlights%20all%20cells%20to%20the%20left%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3212006%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1317255%22%20target%3D%22_blank%22%3E%40Johnnyanglo%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20have%20Office%202021%2C%20and%20have%20been%20using%20it%20since%20it%20was%20released%20in%20October%20of%202021%2C%20but%20I%20cannot%20reproduce%20this%20problem.%20I%20performed%20the%20steps%20exactly%20as%20you%20described%2C%20but%20the%20Format%20Painter%20only%20acted%20on%20the%20cell(s)%20I%20clicked%20on.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

In Excel 2021, there is an issue within Excel.

1. Copy cell(s) and paste using mouse.

2. Click on some other cell and select "Format Painter" to grab the cell formatting.

3. Then with the mouse (now showing the Format Painter brush icon) select any of the previously pasted cells.

4. Excel will Paste Format data across the column downward (if data is in the cell) and across the rows to the left.

Note: This only occurs if the original Copy'nPaste action is followed directly by Paste Format and only if Paste Format is done using the Clipboard Format Painter. 

 

5. Excel does a similar action when selecting a cell to drag that will blow the cursor across the sheet to the left for no apparent reason. No formatting is applied in that case, yet it highlights the entire row to the new cursor position. 

 

So, Excel has a bug. I used Excel 2016 that didn't have these problems. I just switched to 2021 and this issue happens constantly. Paste or drag a cell and zoom, off goes the cursor highlighting or pasting formatting across the row to the left. Undo restores the cells or Cntrl-Z returns the cursor back to where it was but also Undoes the last action (so clicking on Redo restores your last action before Excel went whacky).

 

Are Microsoft Excel developers aware of this? Is there a workaround for it? I don't think this has anything to do with double-clicking the cell border as it does this regardless (one click is enough).

 

Johnnyanglo  

2 Replies

@Johnnyanglo 

I have Office 2021, and have been using it since it was released in October of 2021, but I cannot reproduce this problem. I performed the steps exactly as you described, but the Format Painter only acted on the cell(s) I clicked on.

@Hans Vogelaar Thanks for the reply. Perhaps that means there is some error within my copy of 2021 that is not endemic to Excel. Whenever I paste copied info into a cell there is a 33% risk that it will paste the data and everything on that row to the left for about 30 cells at once. If I click once in a cell I have the same probability that Excel will shoot 30 cells to the left highlighting along the way (making cells active and highlighted without overwriting them since it is not a paste action).

 

This issue makes it very hard to use. That is on top of the other irritants like having Excel highlight formula references when selected with the mouse. 

 

I guess I'll try and reinstall Excel 2021.