This seems like something which should be painfully simple to do but I can't figure it out. So with an empty clipboard I can right click on a row header and say insert row, no problem, it inserts a blank row. But now let's say I go to another spreadsheet and select 4 rows, copy those, then go back to that other spreadsheet and do the same as described above, the only option I have is to insert copied rows. What I was to do is to insert a couple blank rows first to make a little extra space than what will be created by inserting them and then insert my copied rows.
Excel – How to insert empty rows in Excel when I have copied rows in the clipboard
microsoft excelmicrosoft-office
Best Answer
Unfortunately it is not really possible: you can achieve insert blank rows, even if you have copied some rows by clicking on Home->Insert->Insert Sheet Rows:
This will insert the blank lines as you wish. However, it also voids your selection, i.e. the source rows are not in the clipboard anymore.
Overall however, inserting the copied rows/columns instead of blank rows/columns makes a lot of sense, as this is what one usually does right after copying. And adding blank rows afterwards is always easily doable.
I personally found it most efficient to do this with keyboard shortcuts and a few advanced tweaks:
Step 1: Select source
Step 2:
Step 3: Insert
Esp. Ctrl-Space, Ctrl-X and then Ctrl-+ is extremly usful to quickly move columns/rows!