I have a workbook that multiple people access and I want to avoid people screwing up the formatting by pasting in text of all different sizes and formats.
Is there a way to force text to paste as plain text? Or, can I force all text to format to Arial at 11pts once its pasted without VBA code?
I seem to be unable to use VBA with Excel Online, but correct me if I'm wrong! Using Conditional Formatting won't work because it won't let me adjust the font and its size.
I've dug around quite a bit and the only answers seem to be "change your settings," which is a user-end issue (and I can't get 2 dozen people to do that), or use VBA, and I can't get Excel Online to function with that. Do I have other options?
I'm using Excel 365 myself to edit this workbook but can edit in Excel Online or Excel 2016 as well.
Thanks for any assistance.
(Also if you feel like being super, super cool, take a peak at my other question I'm stuck on maybe?)
