Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

General discussion

Excel question

Apr 23, 2005 2:29AM PDT

I created some spread sheets for a particular project that I am working on. I want to copy the information within the cells in Excel to MS Word without having the gray borders show up when I do paste it into Word. When I do a print preview in Excel, it shows the spread sheet without the gray cell boxes and that's how I want it to look when I paste it into Word.

I would appreciate any help with this issue.

Thanks!

Discussion is locked

- Collapse -
The gray borders ...
Apr 23, 2005 7:40AM PDT

indicate that the copy and paste makes a table in Word, which seems quite logical. You can set the table to "No formatting" (that's Word 2000), and then the cell borders won't be printed, but they are still visible on the screen in Word. Thtt's the best you can do, I think, but the results on paper are what you need.

Hope this helps.


Kees

- Collapse -
Disable Gridlines in Excel
Apr 23, 2005 10:43PM PDT

The way I prefer to do it when I copy from Excel to Word or PowerPoint is to disable the gridlines in Excel before the copy. Tools - Options - View - Gridlines.