Publishers of technology books, eBooks, and videos for creative people

Home > Articles

  • Print
  • + Share This
This chapter is from the book

use the fill handle

A quick way to copy the contents of one cell to one or more adjacent cells is with the fill handle. We'll use the fill handle to finish up the worksheet entries.

one.jpg Activate cell B6.

two.jpg Position the mouse pointer on the selection's fill handle—a tiny square in the bottom-right corner of the selection box. The mouse pointer turns into a black cross.

three.jpg Press the mouse button and drag to the right. As you drag, the mouse pointer may change and a black or gray border stretches over the cells you pass over.

four.jpg When the border surrounds cells B6 and C6, release the mouse button. The formula in cell B6 is copied to cell C6.

five.jpg Repeat steps 1–4 for cell B27 to copy its formula to C27 and for cell B28 to copy its formula to cell C28. When you're finished, the worksheet should look like this.

six.jpg Drag to select cells D3 and E3.

seven.jpg Position the mouse pointer on the selection's fill handle.

eight.jpg Press the mouse button down and drag so the border completely surrounds cells D3 through E6.

nine.jpg Release the mouse button. The two formulas are copied down to the cells you dragged over.

ten.jpg Repeat steps 6–9 to copy cells D8 and E8 to the range beneath it (shown here) and cells D22 and E22 to the range beneath it.

When you're finished, the worksheet should look like this.

Have you been saving your work?

Now is a good time to click the Save button on the Standard toolbar to save your work up to this point.

savemenu.jpg

  • + Share This
  • 🔖 Save To Your Account