Correct option is C
In MS Excel, to use the
Format Painter multiple times:
·
Double-click the Format Painter icon instead of a single click.
· This keeps the Format Painter active, allowing you to apply the copied formatting to multiple cells or ranges without reselecting the Format Painter.
Important Key Points:
1. A single click on the Format Painter allows one-time use, while a double click enables multiple uses.
2. The Format Painter copies formatting, such as font, color, and border styles, from one cell to others.
3. To deactivate, press the
Esc key or click the Format Painter icon again.
Knowledge Booster:
·
Lock format painter icon: There is no lock feature for the Format Painter in Excel.
·
Multiple use option: Such an option does not exist under Format Painter settings.
· Double-clicking simplifies formatting tasks when working with large data sets.