Fill a Series Faster with Flash Fill

Flash Fill can recognize a pattern from your example and complete the remaining values automatically.

• Enter the first example.
• Press Ctrl + E.
• Review the generated values before accepting.

Tip: Keep the examples clear so Excel can detect the pattern correctly.