Copy Text Formatting With Format Painter. The Paint Format tool in Sheets lets you copy formatting applied to text in cells just as you would in Docs. Format table rows and columns.
To turn off Format Painter single-click the icon again or press ESC. - You use it to pick up formatting copy and drop it paste onto other text. 2 Copy Formatting Using Format Painter.
Drag across the next text.
2 Copy Formatting Using Format Painter. If you want to copy text and paragraph formatting select an entire paragraph including the paragraph mark. This time double-click the Format Painter icon which keeps this option turned on or enabled. On any Excel worksheet click on the cell with the formatting youd like to copy.