How do you "Paint Format" more than once in Google Sheets?

by BillyNair   Last Updated August 14, 2019 02:03 AM

In Google Sheets you can select a formatted row, click the "Paint Format" Tool, then click another row to apply the same format. You can drag down to do multiple rows if they are together (say rows 50-60).

Is there a way to do this with non-connected rows?

(ie. rows 50, 62, 89)

I tried to hold CTRL between clicks and it says

"This operation is not supported with multiple selections"

I am also fine with a keystroke option (after formatting the new row, hit something like CTRL+P or whatever to copy the Format of the newly formatted row) something to bypass having to go back up to the icon for another row.



Related Questions


Updated April 14, 2019 20:03 PM

Updated March 28, 2019 15:03 PM

Updated March 08, 2019 10:03 AM

Updated July 21, 2018 22:03 PM