Microsoft Excel (Flash Fill)
In this lesson, we will learn about flash fill in Microsoft
Excel.
Let's say column A contains first names, column B
has last names, and you want to fill column C with first and last names
combined. If you establish a pattern by typing the full name in column C,
Excel's Flash Fill feature will fill in the rest for you based on the pattern
you provide.
1. Enter the full name
in cell C2, and press ENTER.
2. Start typing the
next full name in cell C3. Excel will sense the pattern you provide, and show
you a preview of the rest of the column filled in with your combined text.
3. To accept the
preview, press ENTER.
If Flash Fill doesn't generate the preview, it
might not be turned on. You can go to Data > Flash
Fill to run it manually, or press Ctrl+E. To turn Flash Fill on, go
to Tools > Options > Advanced > Editing
Options > check the Automatically Flash Fill box.
No comments:
Post a Comment