Excel – How to insert empty rows in Excel when I have copied rows in the clipboard

microsoft excelmicrosoft-office

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.

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:

enter image description here

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

  • Ctrl-Space - Select column
  • Shift-Space - Select row
  • Shift-Space - ArrowKey - Extend selection to get multiple rows/columns

Step 2:

  • Copy (Ctrl-C) or
  • Cut(Ctrl-X) or
  • Delete (Ctrl--)

Step 3: Insert

  • Select target row/column similar to step 1
  • If only one column/row is selected, Excel will insert the source as selected. However, multiples of the selected rows/columns can be selected and will then be filled, e.g. if you copy 3 rows and select 12 rows, the it'll be filled 4 times
  • Either insert (Ctrl-+) new columns/rows, or overwrite existing one (Ctrl-V)

Esp. Ctrl-Space, Ctrl-X and then Ctrl-+ is extremly usful to quickly move columns/rows!

Related Question