Insert Cells And Paste Simultaneously In #Excel

Here is how you can cut or copy cells and insert them into the middle of a data range in just a couple steps:

This one is new to me and I would love to know if it’s one you’ve heard of. Please leave a comment below and let me know.

I recently learned the keyboard shortcuts Ctrl + (Ctrl key plus the Plus sign) and Ctrl – (Ctrl key plus the Minus sign) to use to insert or delete cells, rows, or columns.

In playing around with them, I tried the following. Below I have a data range of numbers and I want to insert the AAA cells between the threes and fours:

ctr1

Normally I would insert cells or a row between the threes and fours, then cut the cells that contain the A’s and paste them, so the result would be this:

ctr2

But in playing around with it, I discovered a way to cut out a step or two. Here’s what I did:

1) highlighted the cells with the A’s
2) used the keyboard shortcut Ctrl X to cut them
3) highlighted the three cells below the 3’s – where I want the A’s to go
4) used the keyboard shortcut Ctrl + (Ctrl key and the Plus sign from the keypad – you can also use Ctrl + Shift + Plus sign from the numbers row)

It inserted the rows and pasted the cells in one step!

Try it out and see if it works for you.

Happy Excelling!

Related Post

Free Download!

Subscribe to Download Your FREE Copy of
"My 70+ Favorite Excel Keyboard Shortcuts" Today!

, , , , ,

4 Responses to Insert Cells And Paste Simultaneously In #Excel

  1. Dave Bruns March 31, 2014 at 11:59 pm #

    Nice tip, Michael, I didn’t realize that Control + can do a paste insert in one step. Cool.

    I was reminded of something else similar this week. Using drag and drop, with the Shift key held down, you can cut and insert in one step. And if you add Control, you can copy and insert in one step.

  2. Don Davis April 4, 2014 at 9:02 am #

    Great short cut, I will diffidently be using that for sure. This is why I subscribed to your site.

    • Michael Rempel April 4, 2014 at 9:49 am #

      Thanks, Don. Glad you liked it and it can be helpful to you!

Leave a Reply