Table of Contents
Google Sheets allows you to quickly and easily copy values from one sheet to another using the Autofill feature. Using Autofill, you can fill in a range of cells with a series of values, such as numbers or dates, or copy the contents of an entire sheet into another sheet. To do this, simply select the range of cells you want to fill, select the Autofill option, and choose the source sheet. Autofill will then fill the values from the source sheet into the selected range. This is an incredibly useful tool for quickly copying data and is an essential feature for any Google Sheets user.
The following step-by-step example shows how to autofill values from another sheet in Google Sheets.
Step 1: Enter Data in First Sheet
First, let’s enter the following data into Sheet1 in Google Sheets:
Step 2: Autofill Data in Second Sheet
Now suppose we have another sheet titled Sheet2 that contains the following data:
Suppose we would like to autofill the values from the Points column in Sheet1 into a Points column in Sheet2.
To do so, we can type the following formula in cell C2 of Sheet2:
=Sheet1!B2
This will automatically populate cell C2 in Sheet2 with the value from cell B2 in Sheet1:
To autofill the rest of the values in column C, we can hover over the bottom right-hand corner of cell C2 until a tiny “+” appears.
Then click and drag down to all of the remaining cells in column C:
Notice that all of the values from the Points column in Sheet1 have been autofilled into Sheet2.