Then I would write the following formula in Cell say H21. Excel has a variety of formulas and functions. Things to Remember Formula with Text in Excel.
Excel has a variety of formulas and functions.
In the Formula Bar put the cursor in the cell which you want to make it constant then press the F4 key. In the Formula Bar put the cursor in the cell which you want to make it constant then press the F4 key. Excel has a variety of formulas and functions. For example to multiply 2 by 5 you type this expression in a cell with no spaces.