- Name the Sheet
- Understand References
- Enter Information
- Activate a Cell
- Enter Row Headings
- Enter Column Headings
- Make a Column Wider
- Enter Values
- Calculate a Difference
- Calculate a Percent Diff
- Sum Some Values
- Calculate Net Income
- Copy Formulas
- Copy and Paste
- Use the Fill Handle
- Change a Value
- Extra Bits
Copy Formulas
Excel lets you copy a formula in one cell to another cell that needs a similar formula. This can save a lot of time when building a worksheet with multiple columns or rows that need similar formulas.
For example, you can copy the formula in cell B6 (total income for budgeted amounts) to cell C6 (total income for actual amounts).
Similarly, you can copy the formula in cell D3 (difference between budgeted and actual sales) to D4 (difference between budgeted and actual interest income).
Excel automatically rewrites the cell references so they refer to the correct cells. You can view a cell’s formula by activating the cell and looking in the formula bar near the top of the window.