Microsoft Office Tutorials and References

In Depth Information

**Creating formulas to calculate values**

The following table summarizes many of those shortcuts.

Key sequence

Description

Shift+Right Arrow

Extend the selection one cell to the right.

Shift+Left Arrow

Extend the selection one cell to the left.

Shift+Up Arrow

Extend the selection up one cell.

Shift+Down Arrow

Extend the selection down one cell.

Ctrl+Shift+Right Arrow

Extend the selection to the last non-blank cell in the row.

Ctrl+Shift+Left Arrow

Extend the selection to the first non-blank cell in the row.

Ctrl+Shift+Up Arrow

Extend the selection to the first non-blank cell in the column.

Ctrl+Shift+Down Arrow

Extend the selection to the last non-blank cell in the column.

Ctrl+*

Select the entire active region.

Shif t+Home

Extend the selection to the beginning of the row.

Ctrl+Shift+Home

Extend the selection to the beginning of the worksheet.

Ctrl+Shift+End

Extend the selection to the end of the worksheet.

Shift+Page Down

Extend the selection down one screen.

Shift+Page Up

Extend the selection up one screen.

SEE ALSO
For a complete list of keyboard shortcuts, see “Keyboard shortcuts” at the end 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 in which 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
).

Relative references are useful when you summarize rows of data and want to use the same

formula for each row. As an example, suppose you have a worksheet with two columns of

data, labeled
SalePrice
and
Rate
, and you want to calculate your sales representative’s

commission by multiplying the two values in a row. To calculate the commission for the first sale,

you would enter the formula
=A2*B2
in cell C2.