Formatting with the Format Painter
You can use the Format Painter to apply the format of a cell to one or more other cells, without copying the cell's content. The Format Painter has two modes. In single-use mode you can apply the format of a cell to another cell or to a group of adjacent cells. In multiple-use mode, you can apply the format of a cell to multiple non-adjacent cells or to multiple, non-adjacent, groups of cells.
You can access the Format Painter in the Edit Toolbar, in the Format Toolbar, or by selecting
.In the toolbars, single-click
to enable single-use mode, or double-click to enable multiple-use mode.To apply the format of one cell to others: