Teacher Tech blog with Alice Keeler

Paperless Is Not a Pedagogy

Alice Keeler

PUSH a Value to Other Sheets

Want to know how to copy a value to other sheets? Push cell value to all sheets by hacking Alice Keeler's Add-on. Use the feature to push the selected cell in a spreadsheet to the other sheets in the spreadsheet.
How to copy a value to other sheets

PUSH a Value to Other Sheets

If you use spreadsheets you may add a value to one sheet of the spreadsheet and then wonder how to copy a value to the other sheets. I have added a free feature to my Add-on Bingo by Alice Keeler. While the intention of this feature is to copy directions from one Bingo sheet to the other Bingo sheets, it will work with ANY spreadsheet.

Select a Cell in a Spreadsheet and send to the other sheets.

Hacking Alice’s Bingo Add-on

ANY SPREADSHEET! This does not have to be used with Bingo.

Playing Bingo is FUN! You can start a new spreadsheet and use the Add-on menu to select “Bingo by Alice Keeler.” This will allow you to create a list of words or terms and turn them into unique Bingo Sheets per student. AFTER creating the Bingo sheets, select any sheet and type in some text. Use the Extensions menu to select “Bingo by Alice Keeler” and choosing “Push Cell.” This will send the selected cell to all of the other sheets.

Extensions Menu select Bingo and choose Push Cell

If you are NOT using Bingo, that is okay! You can select ANY cell in your spreadsheet by single clicking on the cell. Use the Extensions menu and choose “Bingo by Alice Keeler” and choose “Push Cell.” This will send whatever value is in that cell to all of the sheets.

Value Only

Please note that this only copies the VALUE of the cell. It does NOT push the formula. It does NOT push the formatting.

Fast and Easy

Single click on any cell on any sheet. Use the menu to select “Push cell” and nearly instantly that value will show up on all of the other sheets.

NOT the First Sheet

Since this is designed to be used with the Bingo Add-on it is assumed that the FIRST sheet is your terms list. If you are on, for example, the 3rd sheet and push a value from that sheet it will copy to ALL of the other sheets EXCEPT the first sheet. If you want the first sheet to have the value copied also simply temporarily add a new sheet in the first position.

TemplateTab by Alice Keeler

One of my favorite things is to have ONE document with all students in the same document. What my free Add-on TemplateTab does is duplicates a graphic organizer per student. However, what if you want to make an update to each of the sheets created you can use the Bingo Add-on to push the VALUE of a particular cell to the other sheets.

SheetPusher by Alice Keeler

I also have an Add-on that is designed to create a separate spreadsheet per student. This is different from TemplateTab that creates a sheet per student in the same spreadsheet. After creating a spreadsheet and copying the graphic organizer per student, it is already built into SheetPusher to allow you to highlight a range of cells and push those cells to each students individual sheets.

How to Push Cell Value to All Sheets

How to Copy a Value to Other Sheets

5 Easy Steps for Teaching with Digital Tools

Introducing digital tools into your teaching can seem challenging at first. There are many tools out there, and it might feel like there’s a lot to learn. But with easy steps for teaching with digital tools, you can start simply and gradually. There’s no need to dive in all at once – just take it one step at a time. Taking easy steps for teaching with digital tools starts with trying something!

Read More »
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