Copy cell formatting
-
Select the cell with the formatting you want to copy.
-
Select Home > Format Painter.
-
Drag to select the cell or range you want to apply the formatting to.
-
Release the mouse button and the formatting should now be applied.
Want more?
You can always ask an expert in the Excel Tech Community or get support in Communities.
Need more help?
Want more options?
Explore subscription benefits, browse training courses, learn how to secure your device, and more.
Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.