How to Use Fill Down In Google Sheets

The Fill-Down function of Google Sheets lets you fill entire columns of complex data, dates, and numbers in a matter of seconds. 

First I will show you how to use fill-down for mathematic equations.

Mathematics

The most common way people use the fill down function is for math formulas.

Step #1: Click the Original Cell

How to Use Fill Down In Google Sheets Step 1

The first thing to do will be to click the cell where you input your original equation. As you can see in the formula box, this cell is dictated by a subtraction formula from Cell I2.

Step #2: Click and Drag

How to Use Fill Down In Google Sheets Step 2

At the bottom-right corner of the cell, there will be a small, blue square. Hold the left-click button on your mouse and drag it down the column.

As you drag down the column, any unlocked cells will fill themselves in to the equation. This will quickly do the math for you, as you only need to fill in the equation once.

Step #3: Verify

Fill Down In Google Sheets Step 3

As you can see, the fill-down function has done 11/12 of the subtraction problems for you. 

Other Applications

Now let's talk about the other major ways that you can use the fill down function. The main ways we will discuss are:

  • Dates
  • Numbers
  • Days

Step #1: Set the Pattern

Fill Down In Google Sheets Step 1b

The main thing that you need to know is that the fill down function works by recognizing and fulfilling patterns it sees. For things like Dates, Numbers, and Weekdays, you will be able to sometimes turn as little as one cell into a statement for Google Sheets to fill out.


Dates: For dates, simply fill in the date in the normal way you would on any form (MM/DD/YY) or (DD/MM/YY) if you do that sort of thing.

Number: For numbers, the way I do it is I fill in the starting number along with the following number in the cell below.

You will also need to highlight both and then click and drag from the 2nd cells corner.

Day of the Week: For listing days of the week, you can simply write down the day of the week or even its abbreviation (Mon, Tues, Wed, etc.).

Step #2: Verify

Fill Down In Google Sheets Step 2b

As you can see, the cells have filled themselves out thanks to the fill-down function.

Simply highlight and drag, and you can rapidly fill out your tables.

Leave a Reply

Your email address will not be published. Required fields are marked

{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}

Google Sheets Magic Tricks!

Interactive, Easy and Free Way to Learn 5 Awesomely Cool Google Sheets Tricks!