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 tim...
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.