Share via

Pasting From Excel into Word Keeping Font Formatting Without a Table

Anonymous
2010-11-29T17:45:19+00:00

Is there anyway to paste the data from the excel spreadsheet, many cells at a time, and keep the format of the font without putting it into a table?

I am working on data in an excel spreadsheet that I need to paste into a word document. I want to keep the formatting of the text inside the cells when I paste it. Some of the text needs to be italicized while the rest needs to standard formatting. When I paste the data normally, it puts it inside of a table in Word. When I paste special without the table, it eliminates the formatting of the text that needs to be italicized. I am working with a large amount of data otherwise I would simply go in after pasting it without formatting and add the Italics.

Thank You

Microsoft 365 and Office | Word | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

  1. HansV 462.6K Reputation points MVP Volunteer Moderator
    2010-11-29T17:49:25+00:00

    Start by pasting normally, resulting in a table with formatted text.

    Select the entire table (click in the table and press Alt+Num 5)

    Activate the Layout tab of the ribbon.

    Click Convert to Text in the Data group of the ribbon.

    Select the options you want, then click OK.

    7 people found this answer helpful.
    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest