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

 

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