Teacher Tech blog with Alice Keeler

Paperless Is Not a Pedagogy

Alice Keeler

Add Some Poo ? to Your Spreadsheet

poo emoji in google sheets

Add Some Poo ? to Your Spreadsheet

poo emoji in google sheets

Add Poo Emoji’s to Google Sheets

Who says spreadsheets are not fun? So far I am batting 1000 when I add poo emoji’s to a spreadsheet to see a look of delight on student’s faces when they use the sheet. Create a spreadsheet that makes emoji’s show up when students enter something on the spreadsheet.

Copy Poo Emoji

Your first step is to do a Google search for “Poop emoji.” I’ve used this site to copy the emoji.
copy poo emoji

Paste the Emoji

The lesson here is really that you can paste emoji’s into a spreadsheet. Use Control V to paste the emoji into a cell of your choice. Pro tip: if you want the emoji to be a surprise… hide it in a cell they can’t easily see.
Paste the Poo emoji

=REPT()

The formula you might want to use when adding emoji’s to your spreadsheet is =REPT(). This will repeat a character a certain number of times. For example =REPT(G,3) will result in GGG when you press enter.
repeat with cell referencing

Cell Referencing

However, we do not want to type out the character and pick the number of repetitions, we want to reference them somewhere in the spreadsheet. For example, if your emoji were in cell B1 and in cell A2 is the number of times you want to repeat the emoji then your formula would be =REPT(B1,A2). You REFERENCE the cell that has the value you want.

Change the number in the cell you are referencing to indicate the number of repeats, the spreadsheet will display a different number of poop emoji’s.
change the number of repetitions

Absolute Cell Referencing

Probably you will want to copy and paste your =REPT() formula. However, unless you use absolute cell referencing you won’t get the results you wanted. The emoji you pasted is ALWAYS in the same cell. It does not move. In my example, my poo emoji is in cell B1. To lock down the B1 put a dollar sign in front of the B and a dollar sign in front of the 1. =REPT($B$1, A2). Press enter. Click back on that cell that now has the absolute cell referencing and look for the fill down square in the bottom right of the cell. DRAG the fill down square down to copy and paste your formula down the column. Now type numbers into the column you used to indicate the number of repetitions (mine is column A) and notice how poo emoji’s magically appear.
Paste the absolute reference




Students Prepare to Present

Help Your Students Prepare to Present

Maximize student success in presentations with ‘Speaker Notes by AliceKeeler,’ the ideal Google Slides add-on. Enhance how students prepare to present with easy transfer of speaker notes to Google Docs, promoting effective communication skills. Dive into the world of engaging, technology-aided presentations and empower students to shine in their academic endeavors. Discover the key to transforming student presentations into interactive, skill-building experiences.

Read More »

Infographic 7 Basic Steps for a Google Form

New to using Google Forms? This tool is essential for teachers to not only save time but to be adaptive to student needs. Use Forms to survey students, play games, personalize instruction, and assessment. This infographic on the 7 basic steps for a Google Form will help you get started.

Read More »

Online Workshop: Get Your Add-on Published

How can you make Google Workspace (Docs/Sheets/Slides) even better? You can create custom Add-ons with Google Apps Script. Wondering How to Get Your Google Workspace Add-on Published? Join Alice Keeler, Google Developer Expert, to learn the steps to get your Add-on officially published.

Read More »

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d