Paint Cells to a New Format
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.