If you have spent some time formatting cells to make them look great, you can easily copy just the formatting of a cell.
- Select a cell or cell range with formatting that you want to copy.
- Click the Paint format button on the toolbar.
- Select a cell or cell range you want to paste the formatting onto.
The formatting is applied to the selected cell or range.