How to copy from Word to Excel, Powerpoint stays the same format
When you want to transfer data from Word or Excel to PowerPoint to avoid having to re-enter data, you can copy data from Word or Excel to PowerPoint too. However, if done by normal copying, data may be copied to PowerPoint not as the original data format. The following article shares with you how to copy from Word to Excel, PowerPoint keeps the format.
1. Copy from Word to PowerPoint format format
Copy content as text
For example, if you want to copy a piece of text to PowerPoint, you want to keep its original format in the Word file. To do that you do the following:
- In the Word source file, copy in the usual way by selecting the content to be copied, press Ctrl + C or right-click and choose Copy:
How to copy from Word to Excel, Powerpoint stays the same format Picture 1
- Open the PowerPoint file you want to paste the copied content -> right-click and choose Keep Source Formating (K) in Paste Special. With this feature, the copied content will retain the following format:
How to copy from Word to Excel, Powerpoint stays the same format Picture 2
Copy content from Word to PowerPoint as a spreadsheet
In case the source data in Word file is in tabular form, you perform the same operation:
How to copy from Word to Excel, Powerpoint stays the same format Picture 3
When paste the table in Word file to PowerPoint keep the format you right-click and select Keep Source Formating (K) or on the Home tab -> Paste -> Keep Source Formating (K) -> the table is copied to PowerPoint Keep the same format as in the Word file:
How to copy from Word to Excel, Powerpoint stays the same format Picture 4
Now you just need to resize the table in PowerPoint accordingly:
How to copy from Word to Excel, Powerpoint stays the same format Picture 5
2. Copy data from Excel to PowerPoint to keep the format
Similar to copying from Word to PowerPoint, copying from Word to Excel does the same thing.
Copy from Word to Escel with source data in text form
Select the data area you want to copy -> press Ctrl + C or right-click and choose Copy:
How to copy from Word to Excel, Powerpoint stays the same format Picture 6
Select the Excel file to paste the content into the Home tab -> Paste -> Keep Source Formating (K) -> the results are copied to Excel but the data will be on 1 cell:
How to copy from Word to Excel, Powerpoint stays the same format Picture 7
You need to adjust to match the results:
How to copy from Word to Excel, Powerpoint stays the same format Picture 8
However, in some cases when copying text to Word, the data is on a cell but aligned vertically, this error is because the source data source in Word is aligned on both sides:
How to copy from Word to Excel, Powerpoint stays the same format Picture 9
Fixing this error is very simple, you just need to select the data cell that has just been copied and the left alignment for it is OK:
How to copy from Word to Excel, Powerpoint stays the same format Picture 10
Data copied from Word to Excel in tabular form
Do the same as when you copy text, on the Word file you copy normally:
How to copy from Word to Excel, Powerpoint stays the same format Picture 11
Select the Excel file to paste the copied table -> into the Home tab -> Paste Special -> Keep Source Formating (K) the copied result will be copied to Excel in the same format:
How to copy from Word to Excel, Powerpoint stays the same format Picture 12
So with copying the original format saved you save time and easily convert data. Good luck!
You should read it
- How to copy Word data to Excel keeps formatting
- How to transfer tables from Word to PowerPoint
- Instructions to copy data from Excel to Word retain the format
- How to copy data from Excel to Word?
- How to change the default save file format in Word, Excel and Powerpoint 2016?
- How to copy PowerPoint file content to Word file
- Instructions on how to copy charts from Excel to Word
- How to transfer Word content to PowerPoint
- How to create PDF files from Word, Excel, Powerpoint files simply and quickly
- How to Convert PowerPoint to Word
- Quick formatting of words appears many times on Word
- Tips for copying fast and efficient paragraph formatting in Word