Tip #4705 - Insert Many Where There Are None
Printer Friendly Version | E-Mail This Tip
Insert
Many Where There Are None
Do you do a lot
of copy/paste or cut/paste moves in MS Excel? If so, are you tired
of shifting cells around to make space for the stuff you need inserted
into the middle of your current data set?
How would you
like a way to get Excel to do the data shift for you? That's right!
Excel can shift data at the same time it does the paste. Here's the
scoop!
First, you'll
need to highlight the data and either cut
or copy it as needed.
Next, go to the
new place where the data is to be inserted, selecting the
cell just below the insertion point. Then right click.
From the menu
that opens, select Insert Copied/Cut Cells.
From there, a
small window will appear (Insert Paste) where you'll have to decide
how you want the existing data to be moved.
You can either
shift right or down.
If you shift
right, the data in only the rows to be affected
by the paste will shift, just far enough to accommodate the pasted
cells. It won't clear the whole column, so be careful when you're
dealing with complex worksheets. You could accidentally separate related
data from rows not affected by the paste that really belong in the
same column as the items that were moved.
Should you choose
to shift down, all the data from the selected cell
and below in only the affected column(s) will be
moved down just enough rows to insert the pasted cells. Again, this
does not move all the data across the rows. It only moves the data
in the pasted columns, so be careful when using this feature!
Click OK
once you've made a directional decision.
Voila. The copied/cut
cells are inserted and you never had to manually move a thing!
~ 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
