How to apply a formula to an entire column in Google Sheets on a computer

Table of contents:

In this article, we'll show you how to apply a formula to an entire column in Google Sheets on Windows and Mac OS X computers.

Steps

Apply a Formula to an Entire Column on Google Sheets on PC or Mac Step 1

Step 1. Go to https://sheets.google.com in your web browser

If you are already logged in, your documents (tables) will be displayed on the screen.

If you are not already signed in to your Google Account, sign in now

Apply a Formula to an Entire Column on Google Sheets on PC or Mac Step 2

Step 2. Open the required table

You can also click on the icon
Android_Google_New

to create a new table.

Apply a Formula to an Entire Column on Google Sheets on PC or Mac Step 3

Step 3. Enter the formula in the first cell of the column

If the table contains a row with headers, do not enter the formula in the cell with headers

Apply a Formula to an Entire Column on Google Sheets on PC or Mac Step 4

Step 4. Select a cell

To do this, click on it.

Apply a Formula to an Entire Column on Google Sheets on PC or Mac Step 5

Step 5. Copy the formula to other cells in the column

To do this, press and hold the small square icon in the lower right corner of the formula cell, and then drag this icon to the last cell you want. When you release the mouse button, the formula that is in the first cell will be displayed in all the required cells.

Apply a Formula to an Entire Column on Google Sheets on PC or Mac Step 6

Step 6. Use the keyboard shortcut

Do this if there are so many cells that dragging the cell with the formula becomes a problem, or if the formula needs to be copied to all the cells in the column at once: