Copy cell formatting with the Format Painter
Copy cell formatting in your worksheet using copy and paste options, Format Painter, and dragging techniques.
-
Select the shape, text, picture, or worksheet cell with the formatting you want to copy.
-
Select Home > Clipboard > Format Painter.
-
Drag to select the shape, text, or worksheet cell and apply the Style.
Need more help?
You can always ask an expert in the Excel Tech Community, get support in the Answers community, or suggest a new feature or improvement on Excel User Voice.
No comments:
Post a Comment