How to Make Pixel Art in Google Sheets [Best Guide]

Hi, In this article, we will learn how to make pixel art in Google Sheets. Pixel art is graphical art made using pixels. It’s a kind of illustration that does not pixelate on zooming in, since it’s made by pixels, there is no drawing involved we only need to connect pixels to make an artwork. So, today I will teach you how you can make pixel art in Google Sheets using cells as pixels, and trust me this pixel art going to blow your mind.

These pixel arts don’t require anything such as Drawing tools, importing external images, using any add-on, or even not having an internet connection, you can make them all the way using fill-color only. But of course, you need a guide, so this is your guide, all you need to do is to follow this article step by step and you will end up creating perfect pixel art. Later, we will see how to make our pixel art more interactive using conditional formatting.

Importance of using Pixel Art in Google Sheets

If you are a teacher or a content creator then you must have creative content to make regular content and interact with your audience. Pixel art is a great idea to interact with your students and make them more engaged in the study 5 times by using pixel art. Students when they are in the primary stage love drawings, arts, and cartoon characters, and if you use them positively in the study material it can enhance the student’s interest in the study more than games.

So, it’s a good idea to make some quizzes with students and give them beautiful art if they answered correctly. This will convenience students to prepare more and score highest in the exams to unlock the full image of the character you have designed. There can be more reasons for creating pixel art. But now, let’s continue it from a teacher and content creator perspective. These are some reasons we need to learn how to make pixel art in Google Sheets.

How to Make Pixel Art in Google Sheets?

I have two beautiful pixels art for you. First, we will learn how to create a character in Google Sheets using pixel art, then we will see how to create a teddy bear using pixel art, and then we will see how to make it dynamic, we will apply conditional formatting to it, and we will design an MCQs test for primary students, and for each correct answer, we will unlock the part of the image for the student. This way the entire image will be unlocked when the student will complete the test and give all correct answers. So, let’s get started with this exciting guide.

Pixel Art in Google Sheets – Create Among us Character

In this section, we will learn how to create pixel art in Google Sheets, and we will create a very popular among us character. This will be very easy if you follow the below steps. You don’t need an internet connection to do it. Let’s get into the steps and start creating our pixel art from scratch.

Step 1

Select all the column headers and reduce their width i.e., 26px

Step 2

Zoom in 200% for reducing the chances of errors.

Step 3

Now start building the character’s body outline with a black fill color

Select the cell range F2:L2 and apply a black fill color

Then E3:F3, L3:M3, E4:E7, and M4:M23 and apply black fill color in all these ranges.

Step 4

J23:L23, J21:J22, H21:I21, H22:H23, then E23:G23, and E12:E13, and apply black fill color

Step 5

Now select F13:H13, I8:I12, E7:H7, then D8, C9:C11, and D12, and apply a black fill color.

Step 6

Now select N6, N18, and O6:O18, and apply the black fill color.

Step 7

Select E11:E22, D11, C8:C10,D7, F7:H7, I8:I10, E11:H11

Step 8

Your character body is ready, you can see it looks like a character, and now we need to color apply to fill colors inside it.

Select D9:H10 and apply dark sky-blue fill color.

Step 9

Select D8:H8 and apply a little lighter sky-blue color.

Step 10

Now select the entire interior body of the character in multiple selections and apply the red fill color.

Step 11 (Optional)

You can make a combination of red with dark red to make a double color effect.

Step 12

Here is your pixel art character ready.

Pixel Art in Google Sheets – Create a Teddy Bear

In this section, we will learn how to make pixel art in Google Sheets, and I will show you how to create a teddy bear. We will follow the same steps I will tell you all the cell ranges and their color to end up with a good teddy bear pixel art as I will show you below in this article. So, let’s get started.

Step 1

First, reduce the column width to 26px, and zoom in 200% for a better experience.

Step 2

Select J3:P3, I4, H5, Q4, R5, G6:G10, and S6:S10 and apply a black fill color

Step 3

Now select, H11, I12, J13:K13, O13:P13, Q12, and R11 and apply a black fill color

Step 4

Select F14:I14, Q14:T14, E15:E17, U15:U17, F18:I18, and Q18:T18, and apply black fill color

Step 5

Select I19:I20, H20:H22, G23:G24, Q19:Q20, R20:R22, and S23:S24 and apply black fill color.

Step 6

Select H25:K25, L22:L24, M21, N22:N24, O25:R25, and apply black fill color.

Step 7

To make its eyes, select J8, and K7:K8 then O8, and P7:P8 and apply black fill color

Step 8

To make its nose, fill black color in cells L10, M11, and N10

Step 9

Now, fill pink color in cells I8, I9, and J9, and then Q8, Q9, and P9

Step 10

Now in the rest empty cells, fill any color you want for your teddy, i.e., brown

Step 11

Now you see add extra detailing with any color.

And finally, you will get the final pixel art like below.

Pixel Art in Google Sheets – Create a Quiz

In this section, we will learn how to make pixel art in Google Sheets and we will see how to make a quiz for pixel art when a student will pass the quiz then the pixel art character will be unlocked for them.

Step 1

Add some simple questions in column A

Step 2

Keep Column B empty for the answers

Add at least 3 and at most 5 questions

Now let’s see how to apply conditional formatting rules to it.

Apply Conditional Formatting to Make a Dynamic Pixel Art in Google Sheets

Finally, now we will learn how to make pixel art in Google Sheets and we will see how to apply conditional formatting on it to make it interactive and dynamic. Let’s see how we can do that.

Step 1

Go to Format > Conditional Formatting

Step 2

In the section “Apply to range”, Select some random cells from the pixel art

Step 3

In Format Rules, select “Custom formula is”

Step 4

Write the custom formula with absolute reference

=$B$2<>16

This formula means that if the value in cell B2 is not equal to 16 then perform the below formatting

Step 5

Go to Formatting Style below, and select the fill color white for it

Click on the done button, and this rule will be saved

Step 6

Now, let’s remove or change the value of the cell on which we have applied the custom formula, and you can see the selected cells from the pixel art are white and the pixel art character is demolished.

Step 7

Now repeat these conditional formatting rules for the remaining answers as well, and for each answer remove approximately 25% of the image.

Step 8

First remove the value on which the conditional formatting is already applied, so that you don’t select a cell twice

Step 9

Add the second rule, and everything will remain the same only the cell reference in the custom formula will change and it will become

=$B$3<>10

Step 10

Now remove both of the cell values B2 and B2, and again go to Format > Conditional formatting

Step 11

Add the third rule with the same steps, just change the formula

=$B$4<>10

Step 12

Now remove cell values from B2, B3, and B4, and again go to Format > Conditional formatting > Add a new rule

Step 13

Select most of the remaining active cells, and now use the custom formula

=$B$5<>18

Step 14

Click Done, remove all the answers, and you can see a demolished image, now add answers to the questions one by one and you will see the vector image is being transformed into its original position with every right answer.

So, this is how to make pixel art in Google Sheets, prepare Quiz students with a pixel art character to develop their interests, and motivate them to prepare best for their quizzes.

This is an educational article, and I hope you like it.

Get a Free Template here

Get a free template used in this Article for 2 Pixel Arts with conditional formatting

Conclusion

So, this was all about how to make pixel art in Google Sheets, I hope you enjoyed this educational and little art-related guide from us. You can get your copy for the pixel art we created in this tutorial. I will see you soon with another useful guide, if you want to get more pixel art tutorials, you can comment with your character name below. Thank you. Keep learning with Office Demy.