In Microsoft Excel, AutoFill fills data series automatically ... In the AutoFill Options menu, click Fill Series. In the drop-down list, click Series. A Series dialog box will appear.