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
- Select your cells in Excel, copy (Ctrl+C) then in your Word document, on the Edit menu, click Paste Special
- Click Microsoft Office Excel Worksheet Object, and then click OK
This reduces formatting problems between Word and Excel.