This behavior has been going on for some time now, and I have not found anything on any thread or forum that can help. If I simply drag a figure, button, or shape, Excel acts as if I were holding control and duplicates the object at the dragged location. However, it does not act exactly as when one holds control. If you select a shape and press control while dragging, you'll notice you can still see the original shape throughout the drag and drop process, and an outline of the object is dragged with the cursor. However, in my case, the original shape itself moves when dragged (as if just moving the shape), but then a duplicate object also reappears at the original location when the object is released at the new location. So I have to drag the shape, chart, or button and then delete the original, which is annoying and also stacks up the button/chart/shape number on the "back end" with each drag and drop.
Any thoughts?
Any thoughts?