Assume you have red text in your Excel sheet and when you paste into Word, you want the text to stay red. You would select B. Keep the source formatting.
Step-by-step explanation:
- You can keep the original formatting, merge with the destination formatting, or paste just plain text. Keep Source Formatting (K) This option retains formatting that was applied to the copied text. Any style definition that is associated with the copied text is copied to the destination document.
- This option preserves the look of the original text. Keep Text Only This option removes all the original formatting from the text.
- Keeps the formatting of the text you copied. Use Destination Styles: Matches the formatting where you pasted your text. Kept Text Only: Discards both the text formatting AND the non-text elements you copied, such as pictures or table, and then matches the formatting where you pasted the text
- In Word, you can choose to paste text using the formatting of the source, destination, or just pure text. If you always want one of the options, set it as the default for pasted text.