Format painter on 2 different pages

[Anonymous]

Hello,

I would like to copy the format of a graph using format painter and paste in on another graph in another page of my report. However, when moving from one page to another, the format painter selection is cancelled.

Is there any way to do this ?

Thanks,

Antoine

[cwright2106]

If you hold down CTRL and click the Format painter, you can select another sheet, and apply it to any visual you want. It's been a huge game changer for me since I discovered this trick.

[adam12237]

why even have Format Painter then?

[amitchandak]

@Anonymous , Copy(Copy and paste) that visual to another page. Do the format and delete the visual

[Mariusz · Accepted solution]

Hi @Anonymous 

You can cut the visual, paste in the page format paint it, cat again and paste back.

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

[tululum]

It's a really sad that it is a only possibility ... ☹️

[Anonymous]

Did not think about this trick, thank you ! 🙂