Skip to content
Home » Google » Google Sheets: Equal That Cell

Google Sheets: Equal That Cell

equal that cell in Google Sheets

Use the Equals Sign to Cell Reference

You do not need to know anything fancy to use a spreadsheet. Just type in it. It’s a giant table. But here is the easiest formula that kicks it up a notch.

equals sign

Use the Equals Sign

All formulas start with an equals sign. Type an equals sign into any cell. This is the start of your formula.

Click on Any Cell

Click on any cell on any sheet! Press Enter! That is it!! This tells the spreadsheet that this cell is equal to whatever is in that other cell.
Press Enter

Cell referencing

Want More Help with This? Become a Premium Member

Only Type it Once

In a spreadsheet any value you only want to type it once. That way when you change the value in the original spot it updates throughout the spreadsheet.

change one value change them all

And remember this works across sheets! If you have students type their name on the first sheet into cell A1, a simple =Sheet1!A1 onto other sheets will cause the student’s name to appear on each of those sheets. You don’t even have to type the formula, simply click on the other sheet and click on the cell you want to reference and the formula is written for you!
Reference another sheet

Roster On Every Sheet

On the first sheet of the spreadsheet paste your roster. Insert a second sheet and use the cell referencing with the equals sign trick to reference the first name on the spreadsheet. You only need to do this once where you click on the first name in the roster on the first sheet. On the 2nd sheet click on the cell with the formula and notice the bottom right hand corner has a blue square. Click and hold down on the blue fill down square and pull down. This will copy the formula to reveal the entire roster. If you make any changes to the roster on the first sheet it will be updated on the 2nd sheet. On the 2nd sheet, click on the tiny triangle on the tab and choose “Duplicate.” This will make a second sheet that references the roster on the first sheet.
Roster on every sheet

How to Update Student Spreadsheets

You make a copy of a spreadsheet per student, but what if you have a typo or want to add to the spreadsheet? sheetPusher by Alice Keeler and Heather Lyon helps you update student spreadsheets. Here is…

Google Docs Google Play App Store Install

If you use Google Docs you want to be sure to have the mobile version as well. Use google play app store install

Navigate Google Forms Sections

If you use Google Forms you want to be using SECTIONS in Google Forms and controlling how students navigate the Form.. Navigate Google Forms Sections

BETTER – Print Google Form Quiz

Have more control over how your Google Form™ Quiz prints. Sometimes you need your Google Form on paper and this solution will help you to do it better! Print Google Form Quiz to a Google Doc and custo…

Something Fun for the End of the Year

What is something fun for students to do at the end of the year? While there are many choices, a fun word search can give students something to do while other students are finishing a task. Try my tem…

2 thoughts on “Google Sheets: Equal That Cell”

  1. Pingback: Google Sheets: Equal That Cell – Technology and Electronics

  2. Pingback: Diigo Links (Weekly) | Another EducatorAl Blog

Leave a Reply

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