Microsoft Office Tutorials and References
In Depth Information
Doing It in Styles
To choose a new pattern for a cell selection, you must open the Format Cells
dialog box (Ctrl+1), and then click the Fill tab. To change the pattern of the
cell selection, click a pattern swatch from the Pattern Style button’s pattern
palette. To add a fill color to the pattern you select, click its color swatch in
the Background Color section of the Fill tab.
If you want to add a gradient effect to the cell selection that goes from one
color to another in a certain direction, click the Fill Effects button on the Fill
tab to open the Fill Effects dialog box. This dialog box contains a Gradient tab
with controls that enable you to determine the two colors to use as well as
shading style and variant.
After you select the colors and styles of the gradient, check the Sample
swatch in the Fill Effects dialog box. When you have it the way you want it,
click OK to close the Fill Effects dialog box and return to the Format Cells
dialog box. The selected gradient effect then appears in its Sample area on
the Fill tab in the Format Cells dialog box. Unfortunately, this is one area
where Live Preview doesn’t work, so you’re just going to have to click its OK
button to apply the gradient to the cell selection to see how it actually looks
in the worksheet.
Although you can’t select new patterns or gradients (only colors) with the Fill
Color button on the Home tab, 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.
Doing It in Styles
In Excel 2013, vibrant cell styles are a snap to assign to your worksheet data
using the Cell Styles gallery opened by selecting the Cell Styles button in the
Styles group on the Ribbon’s Home tab. The Cell Styles gallery contains loads
of ready-made styles you can immediately apply to the current cell
selection. Simply click the desired style sample in the gallery after using the Live
Preview feature to determine which style looks best on your data.
Creating a new style for the gallery
To create a new style for the gallery by example, manually format a single
cell with all the attributes you want (font, font size, font color, bold, italic,
underlining, fill color, pattern, borders, orientation, and so on) and then click
the Cell Styles button on the Home tab followed by the New Cell Style option
at the bottom of the gallery. Excel then opens a Style dialog box where you