Copy cell formatting

1. Select the cell with the formatting you want to copy.
2. Select Home > Format Painter.
3. Drag to select the cell or range you want to apply the formatting to.
4. Release the mouse button and the formatting should now be applied.

Want more?

Ways to format a worksheet

You can always ask an expert in the Excel Tech Community or get support in Communities.