Share via

Formatting Excel Worksheets

Anonymous
2021-07-18T19:21:51+00:00

How do I have the formatting (NOT THE DATA, but just the setup) that I used on Sheet 1 carry over to Sheet 2. I know there is a simple way to do it, but it has been a long time since I used Excel that I don't remember.

This should be such a simple question that the answer would be easy to find; however, I can find all sorts of information for PRINTING a worksheet, but not for carrying FORMATTING from one sheet to the next.

Thank you!

Mary Helmers

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. HansV 462.6K Reputation points
    2021-07-18T19:27:44+00:00

    Select the range on the source worksheet and copy it.

    Next, select the top left cell of the range where you want to paste the formatting.

    Click the lower half of the Paste button on the Home tab of the ribbon and select Formatting.

    Was this answer helpful?

    0 comments