Using Excel’s Fill Handle

The Fill Handle is very useful for copying the contents of a cell or extending a series of data.  It is represented by a little blue square in the lower right corner of a selected cell.

To fill in a series of data:

  1. Enter the first part of your data set.
    • For instance, “1, 2, 3″ or “Monday, Tuesday, Wednesday”
  2. Select the data you just entered.
  3. Place your cursor over the Fill Handle, your cursor will change to a black plus sign.
  4. Click-and-drag the Fill Handle to extend your data set.

You can use these same steps to copy the contents of a single cell over a range of cells.

[Read more…]