Teacher Tech blog with Alice Keeler

Paperless Is Not a Pedagogy

Alice Keeler

Google Sheets: Format Painter Saves the Day

Google Sheets: Format Painter Saves the Day

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.

© 2024 All Rights Reserved.

💥 FREE OTIS WORKSHOP

Join Alice Keeler, Thursday Mar 28th or register to gain access to the recording.
Create a free OTIS account.

Join Alice Keeler for this session for a way to create dynamic and interactive digital lessons. The Desmos platform is completely free and allows for any topic to be created or customized.

Exit this pop up by pressing escape or clicking anywhere off the pop up.