Format Painter

Version

Function Description

After adjusting the style of a cell, you can use Format Painter to apply the style to other cells or templates, ensuring page style consistency.

1. Taking cell style copying as an example, select a cell set with a style, click the Format Painter icon on the toolbar, and click a cell with no style, as shown in the following figure.

2. You can use Format Painter across different sheets and templates. In other words, after you select a rectangular area A and click the Format Painter icon, you can switch sheets or templates with the Format Painter icon selected, allowing you to apply the style of the rectangular area A to other sheets or templates, as shown in the following figure.

1. You can only use Format Painter for a single rectangular area. If you select multiple areas by pressing Ctrl, a prompt "You cannot use the format painter for multi-selected areas." will pop up when you click the Format Painter icon.

2. You can use Format Painter to apply the merged cell style to other merged cells. Additionally, you can click the left mouse button to apply the merged cell style to an equally sized range of cells or a selected area while pressing the left mouse button. However, you cannot apply the style of the merged cell to an individual cell, as shown in the following figure.