Teacher Tech blog with Alice Keeler

Paperless Is Not a Pedagogy

Alice Keeler

Get Link to This Cell

Link to a range in Google Sheets
Get Link to This Cell
Link to a range in google sheets

In Google Sheets Direct People to a Specific Cell

I have a spreadsheet (no kidding right) that has multiple tabs. I noticed one of the cells on the 13th tab had some information that needed to be updated. Google Sheets makes it easy to communicate which cell or range of cells you are referring to.

Right Click

Single click on a cell, or highlight a range of cells and right click. This will allow you to choose “Get link to this cell.”

Right click and choose get link to this cell

Control V Paste

The link is automatically copied to the clipboard. Use Control V to paste the link wherever you want to share it.

https://docs.google.com/spreadsheets/d/107eeb7VcPSju4MDN4CDDDLkdXZBAa0EGg38htofcFQQ/edit#gid=0&range=C7

Notice the end of the link indicates the range being linked to.

I have added over 30 sheets to this spreadsheet. Click on the link below to find my greeting.

https://docs.google.com/spreadsheets/d/107eeb7VcPSju4MDN4CDDDLkdXZBAa0EGg38htofcFQQ/edit#gid=1503797431&range=D6:G6

Teach with Linked Range

At least once a week have your students do the assignment in a spreadsheet. It’s a great life skill. A spreadsheet is a giant table, honestly what assignment can not be done in a spreadsheet? You and your students need just a few basics. Make rows and columns wider, set word wrap, and know how to merge cells together.

Here is an easy way to assign a spreadsheet. If students are answering questions at the end of the chapter, they can have a column for the question, an column for the answer, and a column for feedback.

Link to assignment tab: https://docs.google.com/spreadsheets/d/107eeb7VcPSju4MDN4CDDDLkdXZBAa0EGg38htofcFQQ/edit#gid=459648399

Ask students to turn in their answer to #7. In the answer box, they right click and choose to “Get link to this cell.” They can paste that into the Private Comments of Google Classroom, into a Google Form or however students can share information with you. This opens you up exactly to their answer spot.

On the flip side when you leave feedback in the feedback column, right click on a cell you left feedback in and “Copy link to this cell” and paste it where you put students feedback comments. Students can link right to your feedback.

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