Pasting Spreadsheet into Word
in [General]
|
From: Marianne on 6 Jul 2008 18:49 I would like to paste a spreadsheet into a Word doc for a report. I tried doing it with copy/paste, but the lines show. Is it possible? Thank you. -- Marianne
From: Dave Peterson on 6 Jul 2008 18:52 Does this mean that you like the pasted table, just don't like the borders? If that's what you mean, you can click in a cell in that table (in MSWord) and then Table|Hide gridlines. If that's not what you mean, you may want to explain. Marianne wrote: > > I would like to paste a spreadsheet into a Word doc for a report. I tried > doing it with copy/paste, but the lines show. Is it possible? Thank you. > -- > Marianne -- Dave Peterson
From: Marianne on 6 Jul 2008 19:16 Actually, it's a balance sheet that I want to include in a report in Word. When I copy the data from the spreadsheet and paste it into the Word doc, it goes in fine, but there are dotted lines where the grid liines would be normally. Can they be removed? I have Office 2007 and do not see what you suggest. thanks -- Marianne "Dave Peterson" wrote: > Does this mean that you like the pasted table, just don't like the borders? > > If that's what you mean, you can click in a cell in that table (in MSWord) and > then Table|Hide gridlines. > > If that's not what you mean, you may want to explain. > > Marianne wrote: > > > > I would like to paste a spreadsheet into a Word doc for a report. I tried > > doing it with copy/paste, but the lines show. Is it possible? Thank you. > > -- > > Marianne > > -- > > Dave Peterson >
From: Dave Peterson on 6 Jul 2008 19:37 I used xl2003 and MSWord 2003 for that last post. Are you sure those dotted lines are gridlines? Could they be borders that you've applied to the range in Excel? Anyway, when I selected the cells in the table (in MSWord), I could see a "Table Tools" on the title bar. Clicking that gave me the option to add/remove borders (on the right hand side of the table styles group. Marianne wrote: > > Actually, it's a balance sheet that I want to include in a report in Word. > When I copy the data from the spreadsheet and paste it into the Word doc, it > goes in fine, but there are dotted lines where the grid liines would be > normally. Can they be removed? I have Office 2007 and do not see what you > suggest. thanks > -- > Marianne > > "Dave Peterson" wrote: > > > Does this mean that you like the pasted table, just don't like the borders? > > > > If that's what you mean, you can click in a cell in that table (in MSWord) and > > then Table|Hide gridlines. > > > > If that's not what you mean, you may want to explain. > > > > Marianne wrote: > > > > > > I would like to paste a spreadsheet into a Word doc for a report. I tried > > > doing it with copy/paste, but the lines show. Is it possible? Thank you. > > > -- > > > Marianne > > > > -- > > > > Dave Peterson > > -- Dave Peterson
From: Marianne on 6 Jul 2008 20:31
I was able to remove the grid lines in Excel and then again in Word. Do you know how I can shrink the text to fit one page? Right now, it spills onto a second page. How can I make it smaller to fit one page? thanks -- Marianne "Dave Peterson" wrote: > I used xl2003 and MSWord 2003 for that last post. > > Are you sure those dotted lines are gridlines? Could they be borders that > you've applied to the range in Excel? > > Anyway, when I selected the cells in the table (in MSWord), I could see a "Table > Tools" on the title bar. > > Clicking that gave me the option to add/remove borders (on the right hand side > of the table styles group. > > > Marianne wrote: > > > > Actually, it's a balance sheet that I want to include in a report in Word. > > When I copy the data from the spreadsheet and paste it into the Word doc, it > > goes in fine, but there are dotted lines where the grid liines would be > > normally. Can they be removed? I have Office 2007 and do not see what you > > suggest. thanks > > -- > > Marianne > > > > "Dave Peterson" wrote: > > > > > Does this mean that you like the pasted table, just don't like the borders? > > > > > > If that's what you mean, you can click in a cell in that table (in MSWord) and > > > then Table|Hide gridlines. > > > > > > If that's not what you mean, you may want to explain. > > > > > > Marianne wrote: > > > > > > > > I would like to paste a spreadsheet into a Word doc for a report. I tried > > > > doing it with copy/paste, but the lines show. Is it possible? Thank you. > > > > -- > > > > Marianne > > > > > > -- > > > > > > Dave Peterson > > > > > -- > > Dave Peterson > |