Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel to Word for Newspaper
I have an excel spreadsheet - a one column list (few hundred lines). I have
to get it into a Word document and have it continuously word wrap the lines into one big paragraph for printing in a newspaper. I know there has to be an easy way to do this but can't figure it out. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel to Word for Newspaper
Copy your Excel table to Word, the Excel text gets inserted as a table.
Select the entire table and click TABLE in the Word menu and select CONVERT, TABLE TO TEXT. Format the converted table text for columns and then move the insertion point to the end of the last column and click INSERT in the menu, select BREAK and click the CONTINUOUS option button. Click OK to exit. Inserting the continuous section break will balance your table columns -- Kevin Backmann "lori" wrote: I have an excel spreadsheet - a one column list (few hundred lines). I have to get it into a Word document and have it continuously word wrap the lines into one big paragraph for printing in a newspaper. I know there has to be an easy way to do this but can't figure it out. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel to Word for Newspaper
It isn't wrapping the text as one continuous paragraph. It is keeping it by
individual lines. "Kevin B" wrote: Copy your Excel table to Word, the Excel text gets inserted as a table. Select the entire table and click TABLE in the Word menu and select CONVERT, TABLE TO TEXT. Format the converted table text for columns and then move the insertion point to the end of the last column and click INSERT in the menu, select BREAK and click the CONTINUOUS option button. Click OK to exit. Inserting the continuous section break will balance your table columns -- Kevin Backmann "lori" wrote: I have an excel spreadsheet - a one column list (few hundred lines). I have to get it into a Word document and have it continuously word wrap the lines into one big paragraph for printing in a newspaper. I know there has to be an easy way to do this but can't figure it out. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel to Word for Newspaper
When you converted the table to text I'm assuming you used paragraph marks as
the cell break in the conversion. If that's the case you'll have to remove the paragraph mark from the end of each line. Click the Show/Hide button (the one with the following symbol ΒΆ) to display all the paragraph marks, it will be easier to find them that way. Move to the end of each line and delete each one, adjusting spacing as you go. Not knowing how many columns you've copied over or what type of text you're working with makes it a difficult to suggest another method. If that's the case -- Kevin Backmann "lori" wrote: It isn't wrapping the text as one continuous paragraph. It is keeping it by individual lines. "Kevin B" wrote: Copy your Excel table to Word, the Excel text gets inserted as a table. Select the entire table and click TABLE in the Word menu and select CONVERT, TABLE TO TEXT. Format the converted table text for columns and then move the insertion point to the end of the last column and click INSERT in the menu, select BREAK and click the CONTINUOUS option button. Click OK to exit. Inserting the continuous section break will balance your table columns -- Kevin Backmann "lori" wrote: I have an excel spreadsheet - a one column list (few hundred lines). I have to get it into a Word document and have it continuously word wrap the lines into one big paragraph for printing in a newspaper. I know there has to be an easy way to do this but can't figure it out. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 7, paste linked to word becomes black when word pdf'd | Excel Discussion (Misc queries) | |||
Copy from Word to Excel, and retain indent, plus word wrap | Excel Discussion (Misc queries) | |||
printing worksheet in newspaper columns | Excel Worksheet Functions | |||
Can you print xcel in "newspaper colmn" fashion? | Setting up and Configuration of Excel | |||
Newspaper layout using Excel? | Excel Discussion (Misc queries) |