Various Copy/Paste options between Excel and Word

On more than one occasion, I’ve been in the position of having some data stashed in an Excel spreadsheet, but I need to have it be part of a Word document. I could give my audience two files to see everything, but I really want to have everything in a single Word document… What to do?

Instead of just copying and pasting some cells from Excel into Word, I can use the Paste button dropdown to get some interesting options on how the data will show up in Word.

First, I’ll copy a small table in Excel:

word-excelformattingoptions-20171212-1

In Word, I’ll click on the Paste button dropdown to get six paste options on how the data will appear and act in Word:

word-excelformattingoptions-20171212-2

The first option pastes the data into Word, and it keeps the Excel table formatting:

word-excelformattingoptions-20171212-3

The second option pastes the data into Word, but it uses the default table formatting provided by Word:

word-excelformattingoptions-20171212-4

The third option pastes the data into Word using the Excel formatting, but it retains a link to the original Excel file. If the data changes in Excel, the data automatically gets updated in Word:

word-excelformattingoptions-20171212-5

Option four pastes the data into Word using the default Word table formatting, but like option 3, it retains a link to the original Excel file. If the data changes in Excel, the data automatically gets updated in Word:

word-excelformattingoptions-20171212-6

The fifth option pastes the data into Word as a picture. Using this option, you would not be able to change or update anything in the table. It’s just a picture you added to Word:

word-excelformattingoptions-20171212-7

Last but not least, the final option strips out all the table formatting, and simply copies over the raw data:

word-excelformattingoptions-20171212-8

So next time you have to copy data from Excel to Word, remember that you have more options than the default copy/paste function.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s