How can I paste an excel spreadsheet into a word document without the grid lines showing?

Question

I also want to be able to retain the formulas in the spreadsheet so when I edit the values in some of the fields in Word, the other cells update. Can you help?

Thanks!

Answer 1

The only way to retain editable formulas is to link the spreadsheet to the document rather than pasting. When you paste anything from excel into word, it essentially becomes a graphic which cannot be altered. To link (which will copy the excel spreadsheet, but enable a double click to bring up the actual file), choose Insert, Object, Create from File, (find file) and click the "link to file" box.

To copy/paste without the gridlines, go into page set up in your excel file and deselect print gridlines. Or you can select all cells (click above A1) and use the format cells feature, erasing any gridlines.

Answer 2

If you click on the Insert menu, then Object, then create a Microsoft Excel worksheet within the Word document. Then you can paste it straight in as if it were in excel. It may also let you create one from a file, so you could put the existing worksheet straight in to the file.

Answer 3

Edit ==> Paste Special ==> click on Unformatted

Answer 4

I have no problem, using Word and Excel 2004 for Mac. On my page setup under "Sheet", I have "Gridlines" UNchecked. (I think this may have been elsewhere -- like under "Display" or something -- in earlier versions.) I type formulas into cells (using "=" -- like "=SUM(A1:C1)" ). The gridlines show in Excel but they don't show in Word.