Forum Discussion
Excel Paste formats/highlights all cells to the left
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.
- JohnnyangloMar 02, 2022Copper Contributor
HansVogelaar 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.