Wednesday, June 10, 2009

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,
2.click Paste Special
3.Click Microsoft Office Excel Worksheet Object, and then click OK

Note: If you are using word 2007 then press ALT+CTRL+V. This reduces formatting problems between Word and Excel.

No comments:

Computers Add to Technorati Favorites Programming Blogs - BlogCatalog Blog Directory