• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

Transfering Excel column to Word outline

mcurphy

Diamond Member
I am trying to copy a column of data from excel, and paste it into a word document that is set up as an outline. When I go to paste the data, the entire column is keeping it's source formatting and I am getting a table of data in my outline.

How can I copy a column of data from excel and paste it into w word outline so that each cell in the column is shown as a "level" of the outline.

Here's an example of what I am trying to do:

Level One Text
-----Level Two Text
------Level Three First Cell From Excel column
------Level Three Second Cell From Excel column
------Level Three Third Cell from Excel column
-----Level Two Text
etc

I have at least 100 entries in excel I would like to have entered as seperate items on this third level, but instead I am getting a table of data that doesn't follow the outline format.

Edit: Ahh nevermind, I figured it out. I needed to transfer the data to text (erase the table), and then I was able to convert it to the outline format.
 
Yep, you can use the paste special function and tell word it's unformatted text. It will do the same thing.
 
Back
Top