Fill handle

When you click a cell or select a range of cells, you will see a thick border with a tiny black square at the lower right corner. This tiny black square is called the Fill handle. The Fill handle allows saving a great deal of data entry time by filling in cells with data automatically. You use the Fill handle to:

• Fill same data across multiple cells
• Fill data series like date, time, week days, and month names
• Fill data that increases by a fixed unit
• Copy formulas to other cells
• Copy cells
• Copy formatting

You can also add your own custom lists. This increases usefulness of the fill handle.