Paint Cells to a New Format

You are here:
Estimated reading time: < 1 min

Let’s say you change not only the wrapping in a cell, but also the entire look—the font, the color, whatever. And you want to apply it to many, many other cells. The trick is the Format Painter tool, the one that is on the Home tab that looks like a paint brush.

Select the sell you like, click the icon, and then click on a different cell to paint in the format—they’ll match in looks, not in content. Want to apply it to multiple tabs? Double-click the paint brush icon, then click away on multiple cells.

Paint Cells to a New Format

Was this article helpful?
Dislike 0
Previous: Line Breaks and Wrapping Text
Next: Paste Special to Transpose