How-To: Copy Excel cells into a Word document

Just thought of writing about one of the pain points i often come across while working on Excel and Word. Whenever we try to paste some excel cells into Word, the usual problem faced is the loss of formatting. This can be overcome by following the steps mentioned below

  1. Select your cells in Excel, copy (Ctrl+C) then in your Word document, on the Edit menu, click Paste Special
  2. Click Microsoft Office Excel Worksheet Object, and then click OK

This reduces formatting problems between Word and Excel.

Cheers,

Vaibhav

Advertisements

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s

%d bloggers like this: