Page 210 - CITS - Computer Software Application -TT

COMPUTER SOFTWARE APPLICATION - CITS

Tips:
• If you are unhappy with the Flash Fill results, you can undo them by pressing Ctrl + Z or via the
Flash Fill options menu.
• If Flash Fill does not start automatically, try these simple troubleshooting techniques.
• To find the number of the Flash Fill changed cells, just look at the Excel status bar.

How to Flash Fill in Excel with a button click or shortcut
In most situations, Flash Fill kicks in automatically as soon as Excel establishes a pattern in the data you are
entering. If a preview does not show up, you can activate Flash Fill manually in this way:

1 Fill in the first cell and press Enter.
2 Click the Flash Fill button on the Data tab or press the Ctrl + E shortcut.
Excel Flash Fill options
When using Flash Fill in Excel to automate data entry, the Flash Fill Options button appears near the auto-filled
cells. Clicking this button opens the menu that lets you do the following:
• Undo the Flash Fill results.
• Select blank cells that Excel has failed to populate.

• Select the changed cells, for example, to format them all at once.

197

CITS : IT&ITES - Computer Software Application - Lesson 63 - 77