Which tool is used to quickly copy formatting from one cell to another without copying the cell's contents?

Which tool is used to quickly copy formatting from one cell to another without copying the cell's contents?

• A. Painter
• B. Format Button
• C. Fill Handle
• D. Copy

Answer: (A)

The main idea is applying the same look to another cell without changing its data. The Format Painter copies only formatting—like font, color, borders, alignment, and number formatting—from a source cell to a target cell. This leaves the cell’s actual contents intact while duplicating its appearance. To use it, select the cell with the formatting you want, click the Format Painter tool, and then click or drag over the cell (or cells) you want to format. If you double-click the tool, you can apply formatting to multiple cells; press Esc when finished. Other options either copy the data as well (Copy) or extend values with a drag (Fill Handle), so they aren’t suited for copying formatting alone.

The main idea is applying the same look to another cell without changing its data. The Format Painter copies only formatting—like font, color, borders, alignment, and number formatting—from a source cell to a target cell. This leaves the cell’s actual contents intact while duplicating its appearance. To use it, select the cell with the formatting you want, click the Format Painter tool, and then click or drag over the cell (or cells) you want to format. If you double-click the tool, you can apply formatting to multiple cells; press Esc when finished. Other options either copy the data as well (Copy) or extend values with a drag (Fill Handle), so they aren’t suited for copying formatting alone.