In Excel or Word, if you double click the Format Painter button, it will stay until you click it again or until you press the Esc key. This allows applying Format Painter to several areas consecutive...
Daniil
Kudo Kingpin
7 years agoAnonymousLydia, Format Painter in Excel and Power BI do not behave the same.
By double click I mean double click in the common sense -- when you click twice quickly.
Try double clicking Format Painter in Excel, click on one cell, then release the mouse button, then note that you can still apply Format Painter to another cell because Format Painter stays. In Power BI, Format Painter will not be available after you use it once -- you will need to click the Format Painter button on the ribbon again.
Please let me know if it doesn't make sense -- I'll try to reword it or explain in a different way.