Filling Cells Based on Existing Data

Front

What should you do if Flash Fill does not provide suggestions?

Back

It may need more examples or it could be disabled.

Front

How can you enable or disable Flash Fill?

Back

Select the File tab to open the Backstage view. Then select Options > Advanced and check/uncheck the box for Automatically Flash Fill under Editing Options.

Front

What are the Auto Fill options?

Back

Auto Fill options include the ability to fill series and flash fill.

Front

What can Flash Fill be used for?

Back

Flash Fill can be used to add punctuation or additional text, such as an email domain name.

Front

What does a linear series do in advanced fill series options?

Back

A linear series adds or subtracts the step value.

Front

What does a growth series do in advanced fill series options?

Back

A growth series multiplies the previous value by the step value.

Front

How do you activate Flash Fill using a keyboard shortcut?

Back

Press Ctrl+E to activate Flash Fill in Excel.

Front

What is the difference between Auto Fill and Flash Fill?

Back

Auto Fill continues a pattern or series, while Flash Fill recognizes patterns and automatically fills in data based on examples you provide.

Front

Where can you find the Flash Fill command on the Ribbon?

Back

Flash Fill can be found under the Data tab in the Data Tools group.