Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Pasting from Excel
Hi all,
My work agenda is as follows 1. Prepare a worksheet 2. Format the data to be used in a Word Template 3. Cut the data out of the worksheet ( select columns etc and the Ctrl + C) 4. Open Word Template and go to the table ready to insert from Excel (The template includes a table ready for the Excel data) 5. Ctrl + V to paste to word and now my problem 6 Ctrl + Z twice to remove the data just inserted and then right click and insert cells. I was hoping someone would give me a hint how to avoid the double Ctrl + Z - the menu item insert cells does not appear beforehand ?? I can not use the Excel sheet directly in Word - It basically does not fit the word document correctly and other users using the document once finished gives problems. Thanks |
#2
|
|||
|
|||
In step 5, choose Edit - Paste Special, and see if there is an option that
gives you what you want. If there is, you likely can create a macro for that specific paste option, then assign it to a keystroke. (For example, I frequently need Edit - Paste Special - Unformatted, so I have a macro that does that assigned to Ctrl+Shift+V. As it turns out, I use that combo in Word far more often than Ctrl+V.) -- Herb Tyson MS MVP Please respond in the newsgroups so everyone can follow along. http://www.herbtyson.com "Murray" wrote in message ... Hi all, My work agenda is as follows 1. Prepare a worksheet 2. Format the data to be used in a Word Template 3. Cut the data out of the worksheet ( select columns etc and the Ctrl + C) 4. Open Word Template and go to the table ready to insert from Excel (The template includes a table ready for the Excel data) 5. Ctrl + V to paste to word and now my problem 6 Ctrl + Z twice to remove the data just inserted and then right click and insert cells. I was hoping someone would give me a hint how to avoid the double Ctrl + Z - the menu item insert cells does not appear beforehand ?? I can not use the Excel sheet directly in Word - It basically does not fit the word document correctly and other users using the document once finished gives problems. Thanks |
#3
|
|||
|
|||
Thanks Herb, but unfortunately because the data I copy is always a diffent
amount of rows, any attempt to paste without marking the exact number of rows fails. All the copied data ends up in one field of the table. In Word 2000 it automatically adjusted the table to suit ie if I pasted in 50 rows from Excel, word would adjust the table to 50 rows, or if I had 100 rows Word would adjust accordingly. The "paste cells" on the pop up menu also has this function, unfornunately it only appears after copying and the Ctrl + Z to go back a step and then right clicking on the field. "Herb Tyson [MVP]" wrote: In step 5, choose Edit - Paste Special, and see if there is an option that gives you what you want. If there is, you likely can create a macro for that specific paste option, then assign it to a keystroke. (For example, I frequently need Edit - Paste Special - Unformatted, so I have a macro that does that assigned to Ctrl+Shift+V. As it turns out, I use that combo in Word far more often than Ctrl+V.) -- Herb Tyson MS MVP Please respond in the newsgroups so everyone can follow along. http://www.herbtyson.com "Murray" wrote in message ... Hi all, My work agenda is as follows 1. Prepare a worksheet 2. Format the data to be used in a Word Template 3. Cut the data out of the worksheet ( select columns etc and the Ctrl + C) 4. Open Word Template and go to the table ready to insert from Excel (The template includes a table ready for the Excel data) 5. Ctrl + V to paste to word and now my problem 6 Ctrl + Z twice to remove the data just inserted and then right click and insert cells. I was hoping someone would give me a hint how to avoid the double Ctrl + Z - the menu item insert cells does not appear beforehand ?? I can not use the Excel sheet directly in Word - It basically does not fit the word document correctly and other users using the document once finished gives problems. Thanks |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Simple question on cutting and pasting into Word from Excel | Microsoft Word Help | |||
Word 2000 hangs when pasting a Chart from Excel as a Metafile | Microsoft Word Help | |||
Pasting from Excel to Word | Microsoft Word Help | |||
Difficulty pasting Excel data into Word table only in XP versions | Tables | |||
Extra space when pasting link from excel to word as unformatted te | Microsoft Word Help |