Starting with the Excel release available in June, Excel “Keeps” your copy longer. You can Copy your cells, and before you paste, you can still do other tasks like typing or inserting cells.
Based on customer feedback, the dotted “Marquee” stay active for much longer so that you can type, add formatting or many other things before the paste operation. We also made both the “Insert” and “Insert Copied Cells” commands available after the copy operation. Now, if you are copying data to another worksheet, only to realize you need more room, you can insert a variable number of cells and then paste without having to re-copy the original range!
If you want the Marquee to disappear, you can use the ENTER key to perform the paste operation, or after the paste, you can press the ESC key to cancel the copy.
More information about Copy Paste The way in which copy and paste works in Excel has always been a bit different than other applications. When both the source and destination are in Excel, the range is “Marked” and the dotted line marquee is shown for the range that was copied. Excel has this behavior because formulas are adjusted and recalculated when pasting to the new range. The Marquee shows the range that is currently marked and what will be pasted.