Using Format Painter continuously

If you want to copy the formatting to more than one thing, double-click Format Painter instead of single-clicking it. Your copied formatting will be applied to everything you click until you press Esc.

To quickly copy the width of one column or row to a second column or row, select the heading of the first column or row, click Format Painter, and then click the heading of the second column or row. You can’t copy the width if the column or row contains a merged cell.