Fill Series in Excel
Excel Tips and Tricks

Fill Series in Excel

In this article, we have explained how to use Fill Series in Microsoft Excel. Fill Series is used to fill the series of numbers or dates quickly.

 

You can fill the series in Rows or Columns. Shortcut Key to open the Series window is Alt+EIS or Alt+HFIS

 

Using the Series feature you can fill a continuous date series, weekday date series, Month Series or Year Series.

 

Fill Series in Excel
Fill Series in Excel

 

Watch the step-by-step video tutorial:

Click here to download the practice file.

 

PK
My Name is PK. I am founder of PK-AnExcelExpert.com. I am a Microsoft Certified Professional. I have more than 12 years of experience in Data Visualization, Excel Automation and dashboard creation. Excel is my passion and I like to do always something innovative in Excel and share it with other people.
https://www.pk-anexcelexpert.com