Hello all,
I've been using "paint format" a lot on Google Sheets and wondered if there was a keyboard shortcut for it.
I tried Googling it, and found that "Ctrl + Alt + C" and "Ctrl + Alt + V" worked for a little bit - but it stopped working.
Does anyone know how to fix this, and if there's a different shortcut for paint format?
Thanks!
How do you "Paint Format" more than once in Google Sheets? - Web Applications Stack Exchange
Format painter tool - Google Docs Editors Community
How to do "format painter" in Google Sheets like Excel? - Stack Overflow
Sheets: need help with Paint Format - Google Docs Editors Community
Videos
I figured out a way that is almost as good. Early on in Google sheets double clicking the paintbrush icon worked. Why Google removed that I don't know. But while you can't make the paintbrush icon "stick" anymore, what you can do is:
- click the cell (or range of cells) whose format you want to copy.
- click the paint-format paintbrush icon (to copy format).
- click the first cell you want to copy that format to. That cell will receive the copied format.
- click the next cell (or range of cells) you want that same format copied to. Use ctrl-click to select multiple non-adjacent cells. Can select non-adjacent cells only if you selected just 1 cell in step 1.
- press CTRL-Y (to re-do the paste-format). That cell will receive the same format you originally copied in steps 1/2 above).
- Repeat 4/5 above for all cells that you want the format copied to.
In a (not-so-distant) past, it was possible to do what you want by double-clicking the Paint Format icon and then selecting the destination cells no matter if such cells were contiguous or not. However, this feature's been disabled by Google. Hence, it's currently not possible to do what you asked in your question above.
To add to the Bob Jones explanation of the Format Painter button:
If you select a cell whose format you want to copy and then double-click the Format Painter button, you get "sticky" behavior instead of the "one shot deal."
After you double-click the Format Painter button, to apply the previously selected format, you can click and click-and-drag to select non-adjacent cells and ranges.
Then turn off the "sticky" behavior by clicking the Format Painter button.
Thanks for you reply Mike. I had searched that link earlier and don't see any "Format Painter" or Format copy, Format Paste commands.
