Format Painter

When designing a spreadsheet you likely need multiple cells to have the same formatting. That is the same font size, background color, etc… Format painter is a tool I use frequently to help me make my spreadsheets look spiffy.

Format Painter

In the toolbar is an icon that looks like a paint roller.
Format Painter

First, format a cell the way you like it. Use the paint can to have a colored background. Center the text. Bold the text. Set the formatting to display dollar signs or dates. Anything you like. Once you have the formatting set click one time on that cell. Click on the format painter icon to copy the formatting. Click on another cell or a range of cells to apply the formatting to that range.

Digiprove sealCopyright secured by Digiprove © 2015

50% Off February Special

Online Workshops for Google Sheets, Classroom, Slides and more are 50% off for February. Use the discount code february at checkout. Also annual subscriptions for access to all of the Go Slow online workshops are 50% off!

catching snowflakes on your tongue