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.

  • So, not exactly what I am looking for (so an answer is still available) but, Ctrl+Alt+V will paste the format over and over. Click the Brush (or Ctrl+Alt+C) then click the cells/row, Ctrl+Alt+V then click another row, and Ctrl+Alt+V again, etc. – BillyNair Aug 16 at 5:02

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.