FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -Use Format Painter to quickly apply the same formatting, such as color, font style and size, or border style, to multiple pieces of text or graphics. With format painter, you can copy all of the formatting from one object and apply it to another one-think of it as copying and pasting for formatting.

Detailed explanation-2: -Select the cell with the formatting you want to copy. Select Home > Format Painter. Drag to select the cell or range you want to apply the formatting to. Release the mouse button and the formatting should now be applied.

Detailed explanation-3: -The Format Painter tool is used to copy and paste character and paragraph formats to existing text. This tool, used in conjunction with styles, can make organizing and reformatting documents easier and more efficient.

Detailed explanation-4: -Copy conditional formatting from one control to another Select the control that has the conditional formatting you want to copy. On the Home tab, in the Clipboard group, click Format Painter. Click the control to which you want to copy the formatting.