Tip #4212 - A Paste That Inserts Instead of Replacing
Printer Friendly Version | E-Mail This Tip
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?
Do you insert
the blank space needed (row, column or cells) and then go elsewhere
in the worksheet to copy or cut, only to return to the blank area
to paste?
That's too much
"back and forth" for me! Wouldn't it be nice to simply copy
or cut, go to the new location and then have Excel insert the new
space while you paste?
It definitely
sounds more efficient to me, so I was willing to give it a try. How
about you?
I'm assuming that
if you're still with me, you're ready to get to business, so here
we go!
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).
Now, 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!
~ April
Want To Comment On This Tip? Click Here! We'd love to hear from you :-)
Like These Tips? Get 'Em Free In Your E-mail
