Page 215 - CITS - Computer Software Application -TT

COMPUTER SOFTWARE APPLICATION - CITS

4 May convert numbers to strings
When using Flash Fill for reformatting numbers, please be aware that it may convert your numbers to alphanumeric
strings. If you prefer to keep the numbers, use the capabilities of Excel format that changes only the visual
representation, but not the underlying values.

How to turn Flash Fill on and off
Flash Fill in Excel is turned on by default. If you do not want any suggestions or automatic changes in your
worksheets, you can disable Flash Fill in this way:
1 In your Excel, go to File> Options.

2 On the left panel, click Advanced.
3 Under Editing options, clear the Automatically Flash Fill box.
4 Click OK to save the changes.

To re-enable Flash Fill, simply select this box again.
Excel Flash Fill not working
In most cases, Flash Fill works without a hitch. When it falters, the below error may show up, and the following
tips will help you get it fixed.

202

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