Teacher Tech

Paperless Is Not A Pedagogy

Menu
  • Teacher
    • Blog Posts
    • Teacher Tech Facebook Group
  • Google Certified Innovator
    • CoffeeEDU
    • Tour of Google Classroom
    • Back to Classroom
  • Author
    • Alice Keeler Books on Amazon
    • Bulk Order Books
  • Developer
    • Schoolytics
    • Google Developer Expert
    • Add-ons By Alice Keeler
      • Doc to Slides by Alice Keeler
      • Roster Extras by Schoolytics
      • TemplateTab
      • toTabs
      • Form Printer
      • Quiz Helper
      • Dice Slides by Alice Keeler
      • Scheduler by Alice Keeler
      • Document Outline by Alice Keeler
      • Missing From (Google Forms™)
      • Randomize Slides by Alice Keeler
      • Speaker Notes by Alice Keeler
      • sheetPusher
      • Seating Chart Slides
      • Hyperlink Slides Choice Board
      • Add-a-Date
      • QuickShare Screenshot
      • Anyone Can View
      • Drive 20
    • Apps Script Tutorials
    • Templates
  • EdTech Coach
    • Premium Membership
    • Free Newsletter
  • Hire Alice
Menu

Google Sheets: Copy Down FAST

Posted on February 3, 2016May 30, 2018 by Alice Keeler

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.

Related

Related Alice Keeler Blog Posts:

  1. Google Sheets: Partial Formatting Within a Cell
  2. Group Maker: Automatically Make Groups with Google Sheets
  3. Google Apps Script: Code Insert a Sheet
  4. Email Each Student a Note

Continue Reading

Next Post:
Google Classroom: OOPS, Fixing Assignments When You Forgot to Make Copies
Previous Post:
Google Drive: Filter Is:Starred

Leave a Reply Cancel reply

You must be logged in to post a comment.

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Alice Keeler is a mom of 5. Current High School math teacher. Developer for Schoolytics.com. Google Certified Innovator, Microsoft Innovative Educator, Google Cloud Innovator Champion, and Google Developer Expert. Founder of #coffeeEDU
Teaching with Google Jamboard
Developer Schoolytics
Schoolytics is FREE for teachers.

Find ALL My Blog Posts


Link to List

Google Classroom Books

Alice Keeler: Mom of 5. Current High School math teacher. Developer for Schoolytics. Founder #coffeeEDU. Google Certified Innovator. Microsoft Innovative Educator. Google Developer Expert. EdTech Specialist.

My Referral Links


Custom Stickers, Die Cut Stickers, Bumper Stickers - Sticker Mule

 

©2022 Teacher Tech | Theme by SuperbThemes