Microsoft Office Tutorials and References
In Depth Information
One of the most useful tools on your formatting tool belt is the Format Painter button. The
Clipboard group on the Home tab is home to the Format Painter button, which looks like
a little paintbrush. Select the cell or range from which you want to copy formatting, and
click the Format Painter button. (A small paintbrush icon appears next to the pointer.) Then
select the cell or drag through the range of cells to which you want to copy the formatting.
It’s that simple.
If you copy formats from a range of cells and then select a single cell when you paste,
Format Painter selects and formats the same size range—from the selected cell down and to
the right. However, if you select a range of cells when you paste formats, Format Painter
limits the pasted formats to the shape of the destination range you select. If the range you
want to format is a different shape from the copied range, the pattern is repeated or
truncated as necessary.
To remove all formatting, select a cell or range, click the Clear menu (located in the
Editing group on the Home tab of the ribbon), and click Clear Formats. To remove the
values as well as the formatting in selected cells, click Clear All on the menu. For more
information, see “Clearing cells” in Chapter 8, “Worksheet editing techniques.”
Using themes and cell styles
Excel now offers a couple of ways to format globally—meaning you can perform certain
tasks to help standardize the look of your worksheets and create a consistent appearance
for all your documents.
Formatting with themes
A theme is a set of formatting attributes that apply specifically to the line and ill effects, the
color palette, and the fonts that are available when formatting documents. The three
buttons that control these attributes—Colors, Fonts, and Effects—appear in the Themes group
on the Page Layout tab, shown in Figure 9-13. Themes give individuals or workgroups using
Microsoft Office programs (versions 2007 through 2013) the ability to use the same sets of
basic design attributes for all the documents they create. You’ll find corresponding themes
in Microsoft PowerPoint and Microsoft Word as well. You can use themes to standardize all
your internal documents, for example, or to maintain a consistent look between pages in a
package of presentation handouts.