Teacher Tech blog with Alice Keeler

Paperless Is Not a Pedagogy

Alice Keeler

Google Sheets: Fill Down Square

Google Sheets: Fill Down Square

Copy and Paste Faster in a Spreadsheet

Use the fill down square in Google Sheets to copy and paste faster.
Fill down square

Single Click

If you single click on a cell or a range of cells in a spreadsheet you will notice the blue fill down square in the bottom right hand corner. Use your mouse to click, hold down and drag. Usually you will drag down but you can also drag up, left, or right.
Fill down square

Fill down square copies and pastes

Double Click the Square

You can do this even FASTER if you double click the square. It will automatically copy and paste down so long as it is matching values next to it. In other words, if you have a list of student names and you type something next to the first name. Double click on the fill down square and it will paste that message for all students in the list. EXCEPT if you have a hole in your list. Notice in my animation below that the “4th” student is missing. A blank cell. Double clicking on the fill down square only pasted for the 2 students below. I had to drag the fill down square manually to the next name and then double click on the fill down square to finish the job.
Double click to copy and paste

The reason for the double trick square only matching values next to the cell is there are probably 1000 rows in the spreadsheet. NO JOKE 1000!! You probably do not want to paste something down 1000 rows. The spreadsheet is smart enough to only paste a copy of what you had in the cell for the range of data you have.

Patterns

If you do a math formula, the fill down square will adjust the pattern of the formula. Notice in the animation below that I calculated the first students average by dividing their points earned by 100. When I double clicked on the fill down square that contains the formula (notice I had to go back and single click on that cell since I pushed enter) it pasted the formula for each student and adjusted the formula for each students points.
fill down square on a formula

The spreadsheet realizes that when you have a list, you are performing a mathematical action per ROW. When I typed =D2/100 the spreadsheet read that as “Take the cell one to the right and divide it by 100.” It identified the pattern and applied that to each row.
Formula is adjusted

Numerical Patterns

If you type a 1 and then a 2, highlight BOTH cells and use the fill down square for the range the spreadsheet picks up on the pattern between the 2 cells and finishes it for you.
Fill down the pattern

One More Pattern For Fun

There are many fun patterns that Google Sheets will do for you. One that is pretty useful is days of the week. Type the word Monday (or any day of the week). Press enter and single click on the cell. Grab the fill down square and pull it down or to the right. It will automatically give you Tuesday, Wednesday, etc…
Days of the Week pattern in a spreadsheet

 

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