FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -There are two ways to use the Format Painter: Single-click the Format Painter to copy the formatting from the selected cell, then click a different cell to paste the formatting. Alternatively, you can click and drag over a range of cells to paste the formatting to multiple cells.

Detailed explanation-2: -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. Select the text or graphic that has the formatting that you want to copy.

Detailed explanation-3: -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.

Detailed explanation-4: -Format Painter only copies the formatting and not the value in the cell. You can use format painter in Excel to: Copy formatting from the same worksheet. Copy formatting to some other worksheet in the same workbook.