How to integrate in a formula all the cells of a column in Google Sheets

How to integrate in a formula all the cells of a column in Google Sheets
How to integrate in a formula all the cells of a column in Google Sheets
Anonim

The Google Docs office suite is very useful and does not have to be ashamed of its competitors, some of whom have laid the foundations for these IT tools. The Google Sheets spreadsheet accessible directly on the internet allows you to perform many operations, such as integrating the data from a column into a formula.

Steps

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

Step 1. Go to Google Sheets

Search with your internet browser Google sheets. Note that if you have a Google account, when you open it, you will find a list of your documents.

Sign in to your Google Account, if you are not signed in automatically when opening Google Sheets

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

Step 2. Choose one of your documents

Open a spreadsheet from the list of your documents.

  • If you wish, you can open a new sheet by clicking on

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

Step 3. Enter the formula

Click in the cell where you want to see the result of the formula.

Note that if you have, for example, a title in the first cell of the column, do not enter the formula in that cell

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

Step 4. Select the cells

Click in the first cell of the column whose data you want to include in your formula.

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

Step 5. Use the fill-in handle

Once the cell is selected, you can see at the bottom right of the cell a small blue square, click on it and drag the cursor down to the cells in the column for which you want the formula to use the values. Then, once all the cells have been selected, release the pressure of the cursor. You have finished integrating the cells into your formula.

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

Step 6. Simplify your work

You can do the same job more simply and with just 2 clicks, if you want the formula to take into account a large number of cells in a column, rather than having to go down to the last cell in the column.

  • Click in the first cell of the column.
  • Select the letter of the column.
  • It's over ! You have included all the cells in the column in your formula.

Popular by topic