Don’t use this time-saving method on a repeating series because Excel will include the heading text in the list.

Tips If you use AutoFill to populate a date series but want to use the date formatting from another cell, use "Fill Series" to complete your data.

How to use Excel’s Flash Fill feature, including a keyboard shortcut for both Windows and Excel for Mac.

An curved arrow pointing right. We all know and love the Auto Fill feature in Excel. Microsoft went a step further in Excel 2013 and created Flash Fill. This new feature recognizes patterns in ...

Microsoft Excel's Formula by Example helps automate repetitive tasks in structured tables in Excel for the Web. The tool is similar to Flash Fill, though it generates dynamic formulas that update ...

How to Do the Sum of an Indefinite Series in Excel. The Microsoft Excel program includes a variety of mathematical formulas that you can apply to any cell in a spreadsheet.

Why is my Fill series not working? There may be many reasons why your Fill series is not working in Excel. The most common cause of this issue is the disabled Fill handle.