Forum Discussion
JANETBIGGAR
Feb 22, 2021Copper Contributor
keep source formatting from word to excel
Please someone tell me how to keep the source formatting when pasting from word to excel!!! It's driving me mad and generating a lot of extra work š
6 Replies
Sort By
In Excel, click the lower half of the Paste button on the home tab of the ribbon, and select the first option: Keep Source Formatting.
ā
- JANETBIGGARCopper Contributor
yes, but that is greyed out when pasting more than one line of test - sorry should've been clearer...HansVogelaar
Are you trying to paste multiple lines/paragraphs into a range, or into a single cell?