How To Apply Formulae On An Entire Column In Google Sheets

How to apply formulae on an entire column in google sheets

While you are working with a Google Spreadsheet where some formulas are needed to be copied down to the last row of your sheet. You may also need the formula to be added automatically when a new row is added to your Google Sheet. There are several ways to solve this kind of problem.

 

Method 1

1. Open your spreadsheet in Google sheet.

Enter your data in your working cell.

072320 1551 Howtoapplyf2

2.Input the formulae in cells then click enter

Formula=A1*B1

072320 1551 Howtoapplyf3

3. Drag cursor on the entire column to fill the remaining cells. Your cell combinations will be displayed in every cell in column C for each cell.

072320 1551 Howtoapplyf4

After inputting the formulae and getting the result. You may double click the result cell before dragging so it feels the entire column.

About The Author