Web Applications Asked by Blake Landry on November 3, 2021
I have been creating a contact list in Google Sheets to continually add and update names, emails, organizations, etc. for work. I am often copying and pasting this information from other sources as to avoid typoes. I know I can paste as special, though at times I am copying and pasting a handful of entries and this would take more time than I would like. Is there any way to have a script automatically change the font styling of a cell (size, bold, background, typeface, etc.) if it doesn’t match the default?
If I understand your question correctly, you don't need a script at all.
You can use Shift-Ctrl-V instead of Ctrl-V to match the target styling. I do this all the time. As long as you're comfortable with keyboard shortcuts, it's significantly faster than doing Edit > Paste special > ... - in fact, just as fast as regular Ctrl-V :)
You can also paste stuff in however you normally do, and then use Ctrl- to undo all formatting (at which point it'll just be plain Arial 10pt, or whatever), and then bulk change afterwards, once you've cleaned up the text -- at first glance this option doesn't really answer your question, but I've found that in some cases the first "cleaning-up" of data after it's been pasted in can be easier to do with a bare bones look.
Answered by Alicja Z on November 3, 2021
You can use macro that records your desired font, size, cell color etc. It's a script that don't need coding. You may check more info on this link
Found in: Tools > Macros > Record Macro
Answered by kuryano on November 3, 2021
Get help from others!
Recent Questions
Recent Answers
© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP