Pasting Excel Tables into APA or MLA Style Documents
If you paste an Excel table to a document with APA or MLA-style margins, it is very likely that the table will get scrambled because it does not fit within Word’s margins.
To get around this:
- Copy your table from Excel
- Switch to Word
- In Word 2007 or later click the little down arrow below the paste icon. In Word 2003 or earlier click Edit
- Click “Paste Special”
- Select Picture (enhanced metafile)
Not only will your table fit and look exactly like it did in Excel, you can even re-size it as needed by grabbing a corner and dragging.