G
Guest
We are having formatting problems when we copy and paste an Excel spreadsheet
into a Word document.
into a Word document.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Beth Melton
Can you expand on the formatting problems you are encountering?
--
Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.
~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP
Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/
--
Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.
~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP
Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/
G
Guest
Sure. If it is a multiple page table, the 'heading row repeat' option is not
available from the Table menu. I have since learned that if we split the
table, the heading row repeat becomes available, but then when we remove the
split, the repeated row(s) go away.
For the most part, the table will require cleanup and formatting. We are
wondering the best way to "convert" the spreadsheet to a table with as little
clean-up as possible. Thanks!
available from the Table menu. I have since learned that if we split the
table, the heading row repeat becomes available, but then when we remove the
split, the repeated row(s) go away.
For the most part, the table will require cleanup and formatting. We are
wondering the best way to "convert" the spreadsheet to a table with as little
clean-up as possible. Thanks!
B
Beth Melton
I can't seem to duplicate this. If I copy/paste an Excel worksheet to
a Word document, which will convert the copied data to a Word table, I
can set the first row(s) as "Headings" in Word.
What version of Word and Excel are you using? Is the Excel data
converted to a Word table when you paste or are you adding additional
steps? What type of information is contained in the heading row(s)?
Are there merged cells?
--
Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.
~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP
Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/
a Word document, which will convert the copied data to a Word table, I
can set the first row(s) as "Headings" in Word.
What version of Word and Excel are you using? Is the Excel data
converted to a Word table when you paste or are you adding additional
steps? What type of information is contained in the heading row(s)?
Are there merged cells?
--
Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.
~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP
Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/
G
Guest
Its bazaar! I have done a few tests (copied/pasted spreadsheet data into
Word) and sometimes the "heading rows repeat" is available and sometimes not!
I can't establish a pattern!
Anyway, we have a work-around (splitting table) when the command isn't
working.
Regardless, is copy/paste the best alternative? In most cases, we don't
need to embed the spreadsheet because we don't utilize formulas very often.
We are using Office 2000. Thanks!
Word) and sometimes the "heading rows repeat" is available and sometimes not!
I can't establish a pattern!
Anyway, we have a work-around (splitting table) when the command isn't
working.
Regardless, is copy/paste the best alternative? In most cases, we don't
need to embed the spreadsheet because we don't utilize formulas very often.
We are using Office 2000. Thanks!
B
Beth Melton
If you can determine the exact scenario when it doesn't work that
would be helpful in finding a solution. Look for things like merged
cells, number of columns, number of rows, etc. Also, would there
happen to be an empty row you aren't seeing above what you are using
as the heading row? Does it occur with some worksheets but not all?
How are you selecting the Excel data?
Copy/paste is really the only alternative I know to easily convert
Excel data to a Word table. You might try some of the Paste options
found under Edit/Paste Special in Word. For example you could use
"Unformatted text" and then select the data in Word and use
Table/Convert/Text to table.
Without knowing more about the specific formatting issues you are
encountering, such as is there a problem with column width, row
height, fonts, etc. I'm not sure what the best method would be.
--
Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.
~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP
Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/
would be helpful in finding a solution. Look for things like merged
cells, number of columns, number of rows, etc. Also, would there
happen to be an empty row you aren't seeing above what you are using
as the heading row? Does it occur with some worksheets but not all?
How are you selecting the Excel data?
Copy/paste is really the only alternative I know to easily convert
Excel data to a Word table. You might try some of the Paste options
found under Edit/Paste Special in Word. For example you could use
"Unformatted text" and then select the data in Word and use
Table/Convert/Text to table.
Without knowing more about the specific formatting issues you are
encountering, such as is there a problem with column width, row
height, fonts, etc. I'm not sure what the best method would be.
--
Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.
~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP
Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/