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