Excel tools to demonstrate

Try it! Copy the formula in cell C2 down through cell C8 using Ctrl-c and Ctrl-v.



To copy and paste using toolbar buttons:

Proceed as above, but use the copy and paste buttons (in the left section of the Home ribbon) instead of the Ctrl-c and Ctrl-v key combinations.

Try it! Copy the formula in C2 down through cell C8 using the Copy and Paste buttons.

Buttons or key combinations? This is a matter of personal taste, but either is quicker than menu choices!

A frequent task is to enter a formula in one cell and copy it down a row or across a column. There are several very efficient ways to do this.

To avoid copying and pasting altogether, use Ctrl-Enter:

Starting with the top or left-hand cell, select the range where the results will go. (Use the selection methods described earlier, especially if this range is a long one.) Type in the formula, and press Ctrl-Enter instead of Enter.