New posts in Excel Auto Fill

How to fill a large series (over 10,000 rows) in Microsoft Excel without dragging or selecting cells?

How to make Excel 2010 auto-fill new row with formulas?