Microsoft Office Tutorials and References
In Depth Information
Filling cells and creating data series
Figure 8-33 You can select an example entry and then click the Flash Fill command to ill the
rest of the column for you.
Figure 8-34 Flash Fill can make repetitive work like this a lot easier.
Excel automatically hyperlinks email addresses when you type them in. Two actions
occur after you press Enter: the cell entry, and then the hyperlink. This is handy if you
want to be able to click and send email directly, but if you’d rather avoid the blue
underlined text, click Undo—once—immediately after pressing Enter to undo the
Flash Fill can go both ways. Suppose you have a column of data where first and last names
are already combined, but you need them in separate columns. Figure 8-35 shows such a