Creating Formulas in Microsoft Excel 31 David Host / Friday, August 2, 2024 / Categories: Microsoft Office, Microsoft Excel To create a formula in Microsoft Excel, you can do the following: Select the cell where you want to enter the formula Type the equal sign (=) Type or select a cell, or type in a function, like SUM Enter an operator, like minus (-) Select the cells or range that are part of the function Press Enter (Windows) or Return (Mac) for the result You can also use AutoSum to quickly sum a column or row of numbers. To do this, you can: Select a cell next to the numbers you want to sum Select AutoSum on the Home tab Press Enter (Windows) or Return (Mac) Once you create a formula, you can copy it to other cells. To do this, you can: Select the cell with the formula and the adjacent cells you want to fill Click Home > Fill, and choose either Down, Right, Up, or Left You can also press Ctrl+D to fill the formula down in a column, or Ctrl+R to fill the formula to the right in a row Print