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.
To copy tables between open files is the quickest to follow this procedure:
- Select the source table in Excel.
- Use combination CTRL+C.
- 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).
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).
To have copied table in the form of an image without gridlines or indicators of comments, use the following procedure:
- Mark the source table in Excel.
- Choose Home> Copy picture > As shown when printed (Fig. 2).
- In the target file, press CTRL + V or click Home > Paste.