Teacher Tech blog with Alice Keeler

Paperless Is Not a Pedagogy

Alice Keeler

5 Typing Tips for Google Sheets [Infographic]

5 Google Sheets tips

5 Typing Tips for Google Sheets [Infographic]

5 Google Sheets tips

Tips for Navigating Google Sheets

I have been building some Google Expeditions lessons that pair up with a spreadsheet. Helping students know how to navigate a spreadsheet will help them to focus on the lesson rather than how to use a spreadsheet.

Spreadsheet Tips by Alice Keeler

Link to graphic

Google Sheets Tips

Be Aware of Your Cell

When you click on a cell, the edge is thicker and highlighted in blue. The row and column that define that cell are a darker grey. Before typing, ensure you have selected the cell you want to type in.
cell C3

1) Click Once

If you click one time on a cell and start typing it will type OVER the previous content. Control Z (undo) is a really good keyboard shortcut to know as it can be pretty easy to accidentally type over text in a spreadsheet. Do NOT delete the text out of a cell before entering new text. Simply start typing to replace the text.

Double click allows you to fine edit the text in a cell or modify a formula. Double clicking is NOT necessary when you initially input values.

2) Tab to Next Cell

After typing in a cell, no need to use the mouse. Use the Tab key to move to the right. (Shift Tab moves to the left). Knowing how to tab in a spreadsheet is an important skill, help students to be proficient with this.

Notice in the animation above I am not dragging the cursor to the next cell. Simply pressing the Tab key takes me to the next cell and allows me to start typing. Tab type tab type tab type tab type… At the end of the row, pressing the Enter key takes me to the next row, ready to start typing.

3) Press Enter

I see a lot of people not pressing the Enter key after entering information into a cell. This saves the information. Not pressing enter puts your input at risk. Either press the Enter key or use the Tab key to submit the cell entry.

4) Additional Sheets

A spreadsheet is oftentimes a collection of sheets. A spreadsheet user should always be in the habit of looking down for additional sheets to view or work on.
look for tabs

Notice along the bottom there are multiple sheets. Students can also find a list of all the sheets (and click on them to jump to that sheet) by clicking on the “Big Mac.” This is the 4 lines icon in the bottom left of the spreadsheet. The plus icon in the bottom left allows the student to add a new blank sheet.

5) Use Arrow Keys

Using the arrow keys on a keyboard can sometimes be more efficient than using the mouse or trackpad to get to another cell.

If you are trying to select a range on a spreadsheet, hold down the Shift key and use the arrow keys. This can be much easier than trying to use the mouse or trackpad.
Shift arrow to select a range


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.