Working with Formulas in Excel

1.Automatically fill the formulas down
Convert the data to an Excel table.
Select the dataset and go to the Insert and select table option in the table group OR simply select the dataset and press Ctrl+T Now enter the formula in the first row. All formulas entered in the first row will automatically get copied to the other rows in the table.

2.Evaluate parts of a formula Select the expression or part of the function you want to evaluate and press F9. That part of the formula to be evaluated will get replaced by the value it returns.

3.Save incomplete formulas in Excel Temporarily convert the formula to text, by adding a single apostrophe to the start of the formula before the ‘=’, or remove the equal sign. On doing this, excel will not evaluate the formula and will store it the way it is.

4.Highlight all formulas in an excel worksheet
In Excel, use Ctrl + G to open the Go To dialog box, then click the ‘Special’ button, then select Formulas and click on ‘OK’. All cells with formulas will be selected. Now you can highlight the selected cells in the color you wish to.

5.Enter the same formula in multiple cells:
Select all the cells in which the formula has to be entered (by pressing ctrl and then selecting the cells). Then enter the formula in the first cell, and press Ctrl + ‘Enter’. The same formula will be added to all cells in the selection.