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

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

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