Creating Text, Number and Date Series

---

---

Here, we will look into creating text, number and data series −

Creating Text Series

• Select the cell that contains starting text.

• Then drag fill handle (+) over the cell where you want to fill text.

Creating Number Series

• Open a new excel sheet.

• Select the cell that contains starting number.

• Then drag fill handle (+) over the cell where you want to fill number.

Example

Creating Dates Series

• Returns the sequential serial number that represents a particular date.

• Select the cell that contains starting date.

• Then drag fill handle (+) over the cell where you want to fill date.