Forum Discussion
Unwanted pasting of data in new raw or column
There is a strange property of excel - when I have a range copied (a cell or more) and will like to add new columns or rows excel will add the with the copied rang pasted. It is awful, as it take time and sometimes leads to a crash. Is there a way to prevent excel from doing so?
By the way I wonder when Microsoft will produce excel that does not crash?
1 Reply
Hi Adam, that usually happens when Excel still has an active copied range. Before inserting rows or columns, press Esc once to clear the clipboard selection, then insert the row or column normally. If it keeps happening after Esc, I’d also test Excel in safe mode, because an add-in or macro can sometimes interfere with insert behavior.
