To use the Format Painter multiple times before turning it off, you can do so by (2) double-clicking the Format Painter button. By default, when you click the Format Painter button once, it allows you to apply the format to a single cell or range. However, if you double-click the Format Painter button, you can use it multiple times without having to click it again for each application. When you double-click the Format Painter button, it remains active until you manually turn it off by pressing the Esc key or by clicking the Format Painter button again. So, the correct answer is (2) double-clicking the Format Painter button.
Discusssion
Login to discuss.