Paste and automatically move cells
 

I am creating an Excell spreadsheet. I have not used Excell in a long time,
so I cannot remember if what I am asking is possible. Is there a way to paste
data into a group of cells and have Excell move the existing cells down
instead of having the new data write over it?

--
Have a nice day!

~Paul
Express Scripts,
Charting the future of pharmacy

Hi Paul

Copy the selection (Ctrl V)

Move to the insertion point
Press<Ctrl<Shift<+
Select option to move cells down

"Paul (ESI)" wrote:

I am creating an Excell spreadsheet. I have not used Excell in a long time,
so I cannot remember if what I am asking is possible. Is there a way to paste
data into a group of cells and have Excell move the existing cells down
instead of having the new data write over it?

--
Have a nice day!

~Paul
Express Scripts,
Charting the future of pharmacy

After copying your selection, put your cursor in the first cell that you
would like the selection pasted into. Then right click on the cell, and
select "Insert Copied Cells". You will then be prompted to Shift the Cells
Down or Shift the Cells to the Right. Select your option and this should do
what you are looking for.

"Paul (ESI)" wrote:

I am creating an Excell spreadsheet. I have not used Excell in a long time,
so I cannot remember if what I am asking is possible. Is there a way to paste
data into a group of cells and have Excell move the existing cells down
instead of having the new data write over it?

--
Have a nice day!

~Paul
Express Scripts,
Charting the future of pharmacy

Wonderful! Thanks for the quick reply! You are a lifesaver. My favorite
flavor is cherry. Okay, that was lame. LOL. Thanks so much! :-)

--
Have a nice day!

~Paul
Express Scripts,
Charting the future of pharmacy


"Kassie" wrote:

Hi Paul

Copy the selection (Ctrl V)

Move to the insertion point
Press<Ctrl<Shift<+
Select option to move cells down

"Paul (ESI)" wrote:

I am creating an Excell spreadsheet. I have not used Excell in a long time,
so I cannot remember if what I am asking is possible. Is there a way to paste
data into a group of cells and have Excell move the existing cells down
instead of having the new data write over it?

--
Have a nice day!

~Paul
Express Scripts,
Charting the future of pharmacy

Hey, that's awesome! Thanks a million to you too! Now I know two ways to do
it. That's really cool.

--
Have a nice day!

~Paul
Express Scripts,
Charting the future of pharmacy


"HTC" wrote:

After copying your selection, put your cursor in the first cell that you
would like the selection pasted into. Then right click on the cell, and
select "Insert Copied Cells". You will then be prompted to Shift the Cells
Down or Shift the Cells to the Right. Select your option and this should do
what you are looking for.

"Paul (ESI)" wrote:

I am creating an Excell spreadsheet. I have not used Excell in a long time,
so I cannot remember if what I am asking is possible. Is there a way to paste
data into a group of cells and have Excell move the existing cells down
instead of having the new data write over it?

--
Have a nice day!

~Paul
Express Scripts,
Charting the future of pharmacy