Google Sheets: Copy Down FAST

Google Sheets: Copy Down FAST

Fill down square

One of my favorite features of Google Sheets spreadsheets is the ability to “fill down.” This copies a pattern and quickly allows me to count from 1 to 100 or apply a formula repeatedly.

Fill Down Square

When you click on a cell in the spreadsheet, notice the bottom right-hand corner of the cell has a small blue box. This is the fill down square. Click and hold down on the fill down square. Pull DOWN to copy the contents of the cell down the sheet. You can also pull up, right or left.

Fill down square (1)

Type 1 in a cell press enter type 2 in cell press enter highlight both grab and drag the fill down square

Use fill down square to copy text repeatedly

Double Click

If you want to fill down values in a spreadsheet that already has information on it. DOUBLE CLICK on the fill down square to instantly copy the cell contents to match the range of data. For example if you have a roster of student names on the spreadsheet, type a word/phrase/formula into a cell next to the student names. Press enter. Click back on that cell and double click on the fill down square.

Double Click the fill down square

I am using this trick of double clicking the fill down square on my “Grade the Folder” script. It allows me to set the grading status of all the students and renames the students document so they know if feedback has been given. I first type in “FB needed” and press the rename button in the sidebar. I then change the “FB needed” to “graded” and press the rename button again to update the grading status.

© 2024 All Rights Reserved.

❤️ Become a Premium Teacher Tech Member

Discount applies until you cancel!! 
Normally $12 a month, save 58%!! 

Monthly installments of only $4.99 a month.

Exclusive Teacher Tech Content! 
Exclusive Online Courses
Premium Add-ons for Google Workspace
Office Hours with Alice
Weekly Check In Support
Exclusive Webinars
And more! 

Exit this pop up by pressing escape or clicking anywhere off the pop up.

💥 FREE OTIS WORKSHOP

Join Alice Keeler, Thursday Oct24th or register to gain access to the recording.
Create a free OTIS account.

Join Alice Keeler for this session for using FigJam to start every lesson.

Exit this pop up by pressing escape or clicking anywhere off the pop up.