Copying from Excel to Word

Elbi

Hi,

Probably a stupid question but how do I get the grid-lines to disappear when I copy an excel document onto word.

Every time i do it all the lines come out on the word document.

Thanks

KAGY

Elbi wrote: »

Hi,

Probably a stupid question but how do I get the grid-lines to disappear when I copy an excel document onto word.

Every time i do it all the lines come out on the word document.

Thanks

Depends what you want.
You could try "paste as special" and choose text, but you would lose the columns that way.
You could convert the table that is created to text, that would keep the column (separated by tabs IIRC)
or, You could select the table and apply "no border"

If you need any help doing any of those that let me know what version you're using (2003, 2010?)

fionny

You have manually drawn the grid lines in excel? Because when I paste one to the other the grid is hidden unless i tell it otherwise.

Elbi

Thank you both for your replies,

Il try that tomorrow when i am in work and if I am having problems I will come back to. Think that paste special and text might work I just didnt think at the time, I will try it out anyway

Thanks for the help,

fionny

If you paste special / text you will lose ALL formatting so all columns etc... will be gone and youll get a wall of text

Tony10

After you've formatted your Excel worksheet(so the lines on every side of your data are darkened ie.grid) highlight the whole lot of what you want to copy to bring across to Word. Once in Word, select Paste Special, and then you should be presented with a choice of how to paste. the choices should be AS:Microsoft Excel Worksheet Object, Formatted Text(RTF), Unformatted Text, Picture,HTML Format, PDF. Select the 1st option- Microsoft Excel Worksheet Object and it should work.I've done that process here, although i am using Office '11. I hope the same process works for you in previous versions.