Copying Excel data into Word: setting the Tabs

S

Sam

Hello

I need to create data tables in Word. I setup the a table template in word.
It has the column headings. Each column heading is separted by a tab. Then
I copy data from Excel and paste it into Word. The problem is that data from
Excel doesn't line up well with the table headings. The reason is the
following: the tab length is different for the text from Excel [Word treats
two values in adjacent cells as being separated by a tab].

Is there anything that can be done? Can the Excel data being pasted be
forced to confirm to existing tabs? Otherwise, can the tabs for the data
copied from Excel be edited [I tried changing the width of the cells in Excel
before I copy them, but that doesn't seem to work]?

Thank you!
 
D

Doug Robbins

Select the table and use the Convert Table to Text with tab as the separator
and then change the tab settings to those of your column headings.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP
 
S

Sam

Select the table and use the Convert Table to Text with tab as the separator
and then change the tab settings to those of your column headings.
Click to expand...

Thank you, this is very helpful. However, I need to do this for 144 tables
[4/page, 36 pages]. If I understand you correctly, the way above would
involve having to painstakingly set 8 tabs for every one of the 144
selections that I will be pasting.

Is there a way to make the selection adapt the tab structure of the
paragraphs that are already present on the page I am pasting this selection
into?

Thank you!
 
A

Anne Troy

I would rather see you paste, and then run a macro (while your cursor is
still inside the table) that does the following:
Table-->Properties, Set the width to 100, change inches to percent. This
tells the table to take up 100% the width of the page and often sets the
table up fairly nice.
Learn how to record a macro here:
http://www.officearticles.com/word/record_a_macro_in_microsoft_word.htm
*******************
~Anne Troy

www.OfficeArticles.com


Sam said:
Select the table and use the Convert Table to Text with tab as the separator
and then change the tab settings to those of your column headings.
Click to expand...

Thank you, this is very helpful. However, I need to do this for 144 tables
[4/page, 36 pages]. If I understand you correctly, the way above would
involve having to painstakingly set 8 tabs for every one of the 144
selections that I will be pasting.

Is there a way to make the selection adapt the tab structure of the
paragraphs that are already present on the page I am pasting this selection
into?

Thank you!
Click to expand...
 
Top