Saturday, August 26, 2017

Turn Flash Fill on in Excel 2016

Turn Flash Fill on in Excel 2016

Flash Fill is on by default and automatically fills your data when it senses a pattern. However, if it's not working as expected, here's how you can check if Flash Fill is turned on.

  1. Click File > Options.

  2. Click Advanced and make sure the Automatically Flash Fill box is checked.

    Option to enable Flash Fill if it was turned off

  3. Click OK, and restart your workbook.

Start Flash Fill manually

If Flash Fill is turned on but doesn't start automatically when you type data that matches a pattern, you can try starting it manually by clicking Data > Flash Fill, or by pressing Ctrl+E.

Flash fill option on the ribbon

1 comment:

  1. Microsoft Office Tutorials: Turn Flash Fill On In Excel 2016 >>>>> Download Now

    >>>>> Download Full

    Microsoft Office Tutorials: Turn Flash Fill On In Excel 2016 >>>>> Download LINK

    >>>>> Download Now

    Microsoft Office Tutorials: Turn Flash Fill On In Excel 2016 >>>>> Download Full

    >>>>> Download LINK 1h

    ReplyDelete