Microsoft Office Tutorials and References

In Depth Information

Troubleshooting
The appearance of buttons and groups on the ribbon changes depending

on the width of the program window. For information about changing the appearance of

the ribbon to match our screen images, see “Modifying the Display of the Ribbon” at the

beginning of this topic.

After you create a formula, you can copy it and paste it into another cell. When you do,

Excel tries to change the formula so that it works in the new cells. For instance, suppose

you have a worksheet where cell D8 contains the formula
=SUM(C2:C6)
. Clicking

cell D8, copying the cell’s contents, and then pasting the result into cell D16 writes

=SUM(C10:C14)
into cell D16. Excel has reinterpreted the formula so that it its the

surrounding cells! Excel knows it can reinterpret the cells used in the formula because

the formula uses a relative reference, or a reference that can change if the formula is

copied to another cell. Relative references are written with just the cell row and column

(for example,
C14
).