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

Using AutoFill

When you need to fill a range of cells with consecutive numbers, dates, days of the week, or items that follow a specific pattern (such as every four days), you can employ AutoFill to automatically enter the sequence.

To AutoFill a range of cells

1.
In the first cell, type the first number, word, or date of the series.

Examples include 105, Sunday, March, 6/30/04, April 1, 2005, or Qtr 1.

2.
If the series isn't apparent from the initial cell entry, enter the next item in the series in an adjacent cell (the column to the right or the row below).

3.
Select the initial cell or cells. Then move the pointer over the lower-right corner of the lowest or rightmost cell. It becomes the fill cursor (Figure 9.8). Drag to extend the sequence, as desired (Figure 9.9).

Figure 9.8. Move the cursor over the lower-right edge of the cell. It becomes the fill cursor.


Figure 9.9. Drag to select the range you want to fill.


As you drag past each cell, the value that will be filled in the current cell is shown in a yellow ScreenTip.

4.
Release the mouse button when the destination cells have been selected.

The sequence appears in the selected cells (Figure 9.10).

Figure 9.10. When you release the mouse button, the new data appears.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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