In this case, drag the blue box in the column direction. These cells need to be in the same row or column.Ĥ. Click and drag the small blue box in the direction contrary to number orientation. Here’s how to do it:Ģ. Enter the numbers in two or more cells adjacent to one another. It functions like a copy-paste feature, so you can only add the same numbers you’ve initially entered. Google Sheets gives you the option to add numbers to multiple cells. How Do I Automatically Add Numbers in Google Sheets? You can select a range of cells in any row or column in your spreadsheet. In this case, we selected two ranges of cells (A1:A10 and B1:B10) in two different columns for our Array function. Use the Array function for rows or columnsĢ. Click on a cell where you want to enter the Array function.ģ. Type in “ ARRAYFORMULA(A1:A10*B1:B10)” and press “Enter.”.Note: With the Multiply function, you can use only two values. Note: You can use as many values as you want.Ģ. Click on a cell where you want to use the Multiply function.ģ. Type in “ =MULTIPLY(2,B3)” and press “Enter.”Īgain, replace the values in the example with your values. Replace the values in the example with your values. Still, we’ll describe each method.ġ. Open your spreadsheet in Google Sheets.Ģ. Click on the cell where you want to insert the multiplication formula.ģ. Type in “ =20*3*C4” and press “Enter.” The Multiply function operates similarly, while the Array function gives you the option to multiply a selection of rows or columns at once. The multiplication formula is only one way of multiplying values in your spreadsheet. To get the product of any multiplication formula, press “Enter.” How to Multiply on Google Sheets? A typical multiplication formula in Google Sheets cell would look like this: Then, you can add the numbers and/or cell notations you want to multiply and write an asterisk () between them. Whenever you want to multiply numbers or cell values in Google Sheets, you need to use the multiplication formula.įor Google Sheets to recognize that you’re typing a formula in a cell, you need to start the formula with the equals sign (=).

What Is the Multiplication Formula in Google Sheets? Now, click on the small arrow button in a cell to which you added a list of values, and you’ll be able to select one of your custom values.

How to add shapes in google sheets