Move or copy a formula
When you move a formula, the cell references within the formula do not change. When you copy a
formula, the cell references may change based on the type of reference used.
Select the cell that contains the formula.
Proper format is used:
Account to be debited is
listed first. Account to be
credited is listed second and
indented. There is a blank
space between each journal
entry. Entry is neat and easy
Follows proper format with a Proper format
Using Excel functions can save time and effort. Their use reduces the possibility of making errors in your
calculations. Functions are formulas built into Excel to simplify solving certain problems.
Most function consists of two parts: the