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

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

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

Validation of cell values

Updated March 28, 2019 15:03 PM

Alignment is off in cells

Updated March 08, 2019 10:03 AM