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.




Leave a Reply

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

You are commenting using your 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

%d bloggers like this: