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:
- 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:
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:
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:
Now you just need to resize the table in PowerPoint accordingly:
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:
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:
You need to adjust to match the results:
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:
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:
Data copied from Word to Excel in tabular form
Do the same as when you copy text, on the Word file you copy normally:
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:
So with copying the original format saved you save time and easily convert data. Good luck!