Question

4. It copies the same format to another new cell/cells​

Answer 1

Copy cell formatting

• 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.