Share via

copy formatting when using offset function

Anonymous
2022-12-07T17:47:15+00:00

How to copy formatting when using offset function ?

Microsoft 365 and Office | Excel | For home | 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

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-12-08T16:21:36+00:00

    Not the answer I was hoping for. I have had success using tables and was looking for a simplier method.

    Thanks for your response.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2022-12-07T18:50:02+00:00

    Hello, I am Leonielhou, an Independent Advisor and a user like you, I am happy to help clarify any questions you may have.

    I'm afraid you can not copy formatting using OFFSET function. Instead, you will have to use VBA.

    May I know if my answer was able to settle everything for you? If there's anything else you need help with, please let me know right away. I'm always happy to help out where I can.

    Thank you for your time and have a wonderful day. Cheers!

    Best, Leonielhou

    Was this answer helpful?

    0 comments