Applies ToExcel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web Excel 2024 Excel 2024 for Mac Excel 2021 Excel 2021 for Mac Excel 2019 Excel 2016
Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

  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.

Facebook LinkedIn Email

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Microsoft 365 subscription benefits

Microsoft 365 training

Microsoft security

Accessibility center