Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel is automatically doing "text to columns" upon paste text. | Excel Discussion (Misc queries) | |||
Copy and Paste and keep format the same | Excel Discussion (Misc queries) | |||
Blank Cells in Pivot Tables | Excel Discussion (Misc queries) | |||
Move the last entry in a column to a different cell, when the loc. | Excel Worksheet Functions | |||
cut and paste format problem | Excel Discussion (Misc queries) |