Paint Roller Tool in Google Sheets

I’m a big fan of the Paint Roller (Paint Format) tool in the gSuite platform.  I’ve posted before about using it in Google Docs, as well as in Google Slides.  I probably use it most often, though, in Google Sheets.  I love a nice, organized Google Sheet and this tool helps a lot with that.  My favorite part about it is that it even applies to number formatting (i.e., decimal places, date format, currency, etc.).  Check it out in the animated GIF below!

Paint Format in Google Sheets Animation

Published by

Jake Miller

Jake is a Google for Education Certified Trainer and is the Lead Technology Integration Specialist for Brady Middle School in Ohio's Orange City Schools. In the past he taught STEM, Science & Math in Stow-Munroe Falls, Ohio, where he was also a leader in the district's Technology Leadership Team and a co-advisor for the middle school's STEM Club. He has been an educator since 2003. His Bachelor's Degree is in middle-level education (math/science) from the University of Akron and his Master's Degree is in Instructional Technology from Kent State University. He has enjoyed providing more than 100 professional development opportunities at conferences and school districts across the state of Ohio. He is very involved in Twitter (@JakeMillerTech) and provides regular pointers for educators with his #GAFETip tweets.