Excel+A+Paste+That+Inserts+Instead+of+Replacing

Excel A Paste That Inserts Instead of Replacing

What do you do when you need to copy or cut cells in MS Excel and then insert them between existing data?

First, go to the data to be copied or cut and do your usual first steps (highlight the cell(s) and then copy or cut).

Next go to the desired paste location and right click over a column/row header or cell and choose Insert Copied (Cut) Cells from the menu.

If the Insert Paste dialogue box opens, choose an option and click OK. Voila! The simultaneous paste and insert is complete.

This technique may require a bit of experimentation time to get used to how it works, but with a little practice, you could definitely get some good use out of it!  