Copy the formats from one cell to another
Format Painter can be used to copy the formatting present in a particular cell to other cells in the sheet.
To use Format Painter
- Select the cell you want to copy the format from.
- Click on the Format Painter icon
from the toolbar. The format of the cell has been copied.
- Now, click on the target cell(s) to paste the copied format.