How to Copy a Formula down a column in google sheets ( Quick & Easy Guide )

In this tutorial, we will learn How to Copy a Formula down a column in google sheets.

To Copy a Formula down a column in google sheets you can use the fill handle and drag it downwards on the respective cells which will apply the formula down to the rest of the cells in a column.

If you are someone who likes to use keyboard shortcuts you can use Control Key CTRL along with D (Ctrl+D )

How to Copy a Formula down a column in google sheets: Step by Step Guide

#Using Google Autofill

To copy a formula down a column in Google Sheets, you can use the Autocomplete feature in Google Sheets which will automatically apply the formula to the rest of the cells as soon as you type the formula on the first cell and confirm Auto-fill.

How to Copy a Formula down a column in google she

#Using Fill-hand for Small Dataset

How to use Column and Columns Formu...
How to use Column and Columns Formula in Excel | Excel Tutorial For Beginners | Lesson - 21

If your Google Sheet doesn’t have a large number of data, you can use the fill handle in Google Sheets.

Enclosed are the steps to Copy a Formula down a column in google sheets using Fill-handle :

  1. Choose the cell where the formula has been already applied.
  2. Drag the mouse cursor to the right bottom corner of the selected cell. As soon as you move the cursor to the corner it will turn into a plus symbol.
  3. Now using the left mouse click and drag it down the cells.
  4. Left-click and drag to cover all the cells in which you want to copy down the formula.
  5. Now release the left mouse click at the end of Cell.

Wrapping up.

We hope this tutorial will help you to easily Copy a Formula down a column in google sheets.

Related articles :

How To Transpose Data in Google Sheets

How to count non-empty cells in google sheets

How to Count Cells based on Color in Google Sheets

How to Get Absolute value in Google Sheets ( Easy Guide )