Format Painter can be used to copy the formatting present in a particular cell to other cells of the sheet.

To use Format Painter

1. Select the cell you want to copy the format from.

2. Click on the Format Painter icon  from the toolbar. The format of the cell has been copied.

3. Now, click on the target cell(s) to paste the copied format.