Copying and pasting an array of cells in Excel 2007 and pasting into Word 2007 transported the fonts, colors, etc. just fine. All of a sudden last week when I copy and pasted into Word, it reformats the cells and the fonts, loses the coloring etc. It looks nothing like Excel view. I have to go into each column and cell and move the tabs so I can read the contents of the cell. I sent both the source and target files to a co-worker, and he was able to copy and paste just fine. I don't know what settings I may have in advertantly changed, or had the system change, but I need help getting the copy and paste to work. I know about all the other paste options like linking and objects, but I don't want those...just a simple copy and paste. Thanks.

The solution for this query is to paste as formatted text in word 2007 which you have copied in excel 2007