Format Painter lets you copy the formatting of a selected cell and apply the formatting into another cell so that they look alike. It is very convenient when you need to specify a specific style repeatedly.
Copy and Apply Formatting
- Select the cell whose formatting you want to copy and click Edit-Copy Format.
- When the pointer turns into a spuit
, select the cell you want to apply the copied formatting to.
- The selected cell will be formatted with the formatting of the copied cell.
Note
Copied Cell Formatting
Format Painter copies cell formatting such as display format, align, text properties, border and patterns.