When connecting Microsoft Office applications we often use copy a table from Excel into PowerPoint or Word. Usually people would have used the simplest way, ie via CTRL + C (copy) and CTRL + V (paste). Such a procedure may not insert a table in the desired format. Check out this article on methods that a user opens more options to copy tables. If this guide has helped you, become a fan on Facebook and recommend this site to your friends, it can be useful for them too.

Ordinary copying

To copy tables between open files is the quickest to follow this procedure:

  1. Select the source table in Excel.
  2. Use combination CTRL+C.
  3. Inside the target file in Word / PowerPoint press CTRL+V.

Otherwise, it can be used by copy and paste icons on the Home tab or pop-up menu with right mouse button. Such a procedure inserts a table but in some default format that may not meet our requirement.

We can distinguish between three types of embedded table:

  • Table type PowerPoint / Word
    • default type when you use the CTRL+C a CTRL+V
    • does not support Excel functions and do not maintain the same formatting
    • when you change its size, the font size does not change the proportions (the problem can be worked around by changing the size by holding down the Shift key)
    • you can edit data and appearance
  • Table type Excel
    • supports the same functionality as Excel
    • it is an embedded Excel object
    • activated by double-click into the embedded spreadsheet
    • you can, among other things, edit data and appearance
  • Table in the form of an image
    • does not support the change of size or value
    • looks the same as in the original form in Excel

The last two mentioned types of embedden tables can be chosen by selecting Paste > Paste special in the destination file (Fig. 1).

Možnosti Vložit jinak

Fig. 1 – Paste special options (czech)

If you are interested in selecting Paste Link option, it is a method to insert a table with a link to the original file. It means that if the original file in Excel changes, in the copied table the change is updated in Word / Powerpoint.

Copy as shown when printed

When you use the Paste special > Picture of a table that has no set boundaries, light grid on the target file is displayed as well. It also appears e.g. indicators of comments in the form of a red triangle in the corner of a cell. These indicators are displayed even if the grid is disabled before copying by choosing View > Gridlines (learn more in videotutorial).

Kopírovat jako obrázek

Fig. 2 – Copy as picture (czech)

To have copied table in the form of an image without gridlines or indicators of comments, use the following procedure:

  1. Mark the source table in Excel.
  2. Choose Home> Copy picture > As shown when printed (Fig. 2).
  3. In the target file, press CTRL + V or click Home > Paste.
Kopírovat jako při tisku

Fig. 3 – As shown when printed (czech)

1 Comment

  1. ivo

    Chci poděkovat za tipy, velmi pomohlo. Mam prosbu o radu – z excelu do worldu chci zkopírovat data (oblast cca 18000 řádků / 3 sloupce) a tyto následně ve worldu (rozložení stránky) rozdělit do 3-4 sloupců. Velmi ocením pomoc, děkuji.

Leave a Reply

Your email address will not be published. Required fields are marked *