OneNote Formatting

Question

Why is that Google Sheets formatted text remains the same yet Excel formatting gets removed when I paste it into ONENOTE?

Obviously, Excel formula isnt the only one. When I paste any code into OneNote or Text for that matter, it gets reformatted. This make absolutely no sense what so ever. Why do I have to copy formula code/text into a third party product like Notepad++ or Google sheets and then copy it into OneNote? Its been like this forever. Can someone PLEASE advise why this is the case. And if there are any work arounds, or is Microsoft ever going to resolve this issue.

Answer 1

Hi UKYank66,

As per your description, it seems you are loss formatting when you copy some formula/text from Excel to OneNote.

First, may I know are you using OneNote 2016 or OneNote windows 10 app from copy Excel file to OneNote.

Also, please confirm Which option did you select in OneNote when pasting the data? Please check the screenshot below for reference.

I’ll suggest you try Keep source formatting option when pasting the content into OneNote 2016 or OneNote Windows 10 app.

 ![Image](https://learn-attachment.microsoft.com/api/attachments/dd35207f-b6c8-4869-a17e-261229eb49fa?platform=QnA"https://learn-attachment.microsoft.com/api/attachments/bd6908cb-e8f4-410e-90c4-a9d2e565c175?platform=QnA" rel="ugc nofollow">![Image](https://learn-attachment.microsoft.com/api/attachments/bd6908cb-e8f4-410e-90c4-a9d2e565c175?platform=QnA"https://learn-attachment.microsoft.com/api/attachments/b7988f12-84d4-4ffc-89c1-7c558c7d4976?platform=QnA" rel="ugc nofollow">![Image](https://learn-attachment.microsoft.com/api/attachments/b7988f12-84d4-4ffc-89c1-7c558c7d4976?platform=QnA

Answer 2

Hi UKYank66,

Feel free to post back if you need further assistance.

Best Regards,

Waqas Muhammad

Answer 3

You are trying to compare two different products. Google is web based, excel is not unless using OWA