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.

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