Teacher Tech blog with Alice Keeler

Paperless Is Not a Pedagogy

Alice Keeler

Try This Trick: Pixel Art Fill Multiple Cells

Need to fill multiple cells in a Google Sheets spreadsheet at once? Try this trick! Pixel art fill multiple cells at the same time.
Pixel Art Trick Try This Trick: Pixel Art Fill Multiple Cells
Try This Trick: Pixel Art Fill Multiple Cells

Students love using pixel art. It is basically paint by number. There are lots of ways for students to use pixel art for academic reasons. However, it can be tedious to type the same number over and over again. Try this trick for pixel art fill multiple cells. 

Sample Pixel Art Lesson

Check out this brownie division activity adapted from a Jo Boaler Mathematical Mindsets activity. To represent their understanding of division multiple ways students use the pixel art to cut up “brownie pans” in the spreadsheet.

Pixel Art Fill Multiple Cells

To fill in a large number of cells in a spreadsheet the same color using pixel art you would need to type the same number over and over. 

There is a better way!

Shift Key

In a cell type a number into the pixel art template. Single click back on that same cell and hold down on the Shift key. While holding down the Shift key, click on another cell. This will automatically select the range of cells in between the two cells.

Control Enter

With the range selected hold down the Control key and press Enter. This will copy the value or formula in the upper left-hand corner to the entire range. In the case of pixel art it will place the number typed into all of the cells in the range, thus quickly painting an entire section of the spreadsheet.

© 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.