Question

Which of these is a quick way to copy formatting from a selected cell to two other cells on the same worksheet?

• A. Use CTRL to select all three cells, then click the Paste Button image button on the Standard toolbar
• B. Copy the selected cell, then select the other two cells, click Style on the Format menu, then click Modify
• C. Click Format Painter Button image on the Formatting toolbar twice, then click in each cell you want to copy the formatting to
• D. Use Alt to select all three cells, then click the Paste Button image button on the Standard toolbar

Answer 1

The correct option is C Click Format Painter Button image on the Formatting toolbar twice, then click in each cell you want to copy the formatting to

Click Format Painter Button image on the Formatting toolbar twice, then click in each cell you want to copy the formatting to is a quick way to copy formatting from a selected cell to two other cells on the same worksheet.

When you create custom number formats, you can specify up to four sections of format code. These sections of code define the formats for positive numbers, negative numbers, zero values, and text, in that order. The sections of code must be separated by semicolons (;).

Steven. The quickest way to copy formatting from a selected cell to two other cells on the same worksheet is to click format painter on the Formatting toolbar twice then click in each cell you want to copy the formatting to. This is a procedure that is done on the Microsoft Excel.

Select the object whose formatting you want to copy and press Ctrl+Shift+C. Then, select the objects that you want to have the same formatting and press Ctrl+Shift+V to paste the formatting.