Flash Fill automatically fills your data when it senses a pattern. For example, you can use Flash Fill to separate first and last names from a single column, or combine first and last names from two different columns.
Note: Flash Fill is only available in Excel 2013 and later.
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.
You can add emphasis to selected cells in an Excel 2007 worksheet by changing the fill color or applying a pattern or gradient effect to the cells. If you’re using a black-and-white printer, restrict your color choices to light gray in the color palette and use a simple pattern for cells that contain text so that the text remains legible.
Applying a fill color
To choose a new fill color for a cell selection, follow these steps:
Adding patterns to cells
Follow these steps to choose a pattern for a cell selection:
Applying a gradient effect
If you select multiple cells, the gradient you choose will be applied to each chosen cell individually instead of creating one gradient over multiple cells.
You can remove fill colors, patterns, and gradients assigned to a cell selection by clicking the No Fill option on the Fill Color button’s drop-down menu on the Home tab.
I admit that when I first went to Office 2007, I personally found “The Ribbon” quite daunting, but I ultimately found Microsoft’s logic – that there are features in Office that you wouldn’t even know you had with the old menu system, which are easily discovered with “The Ribbon” – to be true.
Even having arrived at the conclusion fairly quickly, it took a lot of ‘accustomization’ and tweaking of the Quick Access Toolbar to make Office 2007 or 2010 easy enough for the real advantages to become appreciable.
I made a fairly quick jump to Office 2010 because Office 2007 lacks some key advantages of 2010; particularly “Track Change” in Excel and PowerPoint.
Apparently, Microsoft Excel 2007 also lacks a key feature from Excel 2003: Pattern Fill for charts and graphs. This is a big deal if you print your charts or graphs in black and white, instead of color.
Today my wife, the “Anti-Ribbonist”, called me with a surprising question: How do you do Pattern Fill for a graph in Excel 2007? It seems that my wife’s lab people work on Excel 2007, and they couldn’t convert her Excel 2003 charts from color to monochromatic patterns.
I thought that this would be easy to figure out … until I searched the web and found that a lot of other people had the same questions, and answers were scarce and often confusing.
So as a public service, I decided to report my solution, and how I implemented it.
NOTE: When using these particular “Pattern Fill” add-ins, the “Undo” feature may not work with it. Or it may. On different machines, I’ve noticed it both ways. There’s probably a difference in settings of which I’m unaware.
In any case, on a site called “Dose of Excel”, I found this page. (http://www.dailydoseofexcel.com/archives/2007/11/17/chart-pattern-fills-in-excel-2007/
It directed me to this:“Microsoft’s Eric Patterson addressed this problem by creating an add-in. You can download it here: Chart Pattern Fills.” An alternative add-in his by Andy Pope, here. This procedure will work fine for either one, depending on which add-in’s functionality you prefer.
This is how your Ribbon will look after installing PatternUI.
Using Eric Patterson’s add-in as an example, here’s the solution I found to the Chart Pattern Fill, and how I implemented it.
See? Wasn’t that easy?
This will probably work for other 3rd party add-ins if you want to integrate them into Office.
Note: This article was updated on 7/12/11 in order to insert Andy Pope’s add-in link, and to further encourage the reader to seek additional options for Pattern Fill or other optional functionalities.
How do you create a pattern in Excel?
Select the cell or range of cells you want to format. Click Home > Format Cells dialog launcher, or press Ctrl+Shift+F. On the Fill tab, under Background Color, pick the color you want. To use a pattern with two colors, pick a color in the Pattern Color box, and then pick a pattern in the Pattern Style box.
How do I add patterns to an Excel chart?
To see this at work select a chart and choose Chart Tools > Layout Tab and select the series to edit from the dropdown box at the top left of the ribbon. Choose Format Selection (just below this on the ribbon) and choose Fill > Pattern Fill.
How do I get Excel to recognize a pattern?
From within Excel with a series of data entered:.
Select the data to format..
On the Home tab, click on "Conditional Formatting" to access the available formatting..
Select "Color Scales" from the menu..
Hover over any of the options in the pop-out menu to see how they would apply to your data and read their descriptions..
Does Excel 2007 have combo charts?
Microsoft Excel 2007 supports a variety of chart types to create a combination chart and help your viewers see the differences between two or more data series. For example, one data series in a line chart can represent actual profit and the second data series in a column chart can represent projected profits over time.