• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Lesson 3. Entering Data into the Workshe... > Copying (Filling) the Same Data to O...

Copying (Filling) the Same Data to Other Cells

Another way to enter labels or values onto a sheet is to use the Fill feature. You can copy (fill) an entry into surrounding cells. For example, suppose you have a list of salespeople on a worksheet, and they will each get a $100 bonus. You can enter the 100 once and then use the Fill feature to insert multiple copies of 100 into nearby cells. To use the Fill feature for copying, follow these steps:

  1. Click the fill handle of the cell (the small block in the lower-right corner of the cell) that holds the data that you want to copy (see Figure 3.5).

  2. Drag the fill handle down or to the right to copy the data to adjacent cells. A data tag appears to let you know exactly what data is being copied into the cells.

    Figure 3.5. Drag the fill handle to copy the contents of a cell into neighboring cells.

  3. Release the mouse button. The data is "filled" into the selected cells.

When you release the mouse, a shortcut box for Fill options appears at the end of the cells that you filled. Copy Cells is the default option for the Fill feature, so you can ignore the shortcut box for the moment. It does come into play when you enter a series in the next section.

Caution

Watch That Fill! The data you're copying replaces any existing data in the adjacent cells that you fill.


  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint