Excel -- Office 365 -- Pasting text into default format?

Question

I'm in Office 365 and working in an Excel spreadsheet. I'm copying URL's and text from different websites and pasting them into the spreadsheet. I would like the text I'm pasting to automatically format to a uniform font and size in the spreadsheet. Is there a way to do this in 365?

Thank you --

Answer 1

Dear,

Good day!

Thank you for posting to Microsoft Community. We are glad to assist. We are looking into your situation, and we will update the thread shortly.

Appreciate your patience and understanding and thank for your time and cooperation.

Sincerely,

Waqas Muhammad

Answer 2

You may set the format in Excel and paste option to choose match Destination formatting.

Answer 3

Thank you for the quick response. Can I set that as the default setting for pasting in 365, instead of selecting it each time I paste?

It looks like I can in other versions of Excel (File :: Options :: Quick Access Toolbar), but I'm not seeing the same option in 365.

Thanks again --

Answer 4

There is no such setting to keep it as deafult paste option. However you may write a macro to do same function and add custom shortcut on that macro.

The option is in Commands not in the ribbon in Desktop application.