Pasting Excel tables into APA and MLA formatted documents

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:

  1. Copy your table from Excel
  2. Switch to Word
  3. In Word 2007 or later click the little down arrow below the paste icon. In Word 2003 or earlier click Edit
  4. Click “Paste Special”
  5. 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.