> ## Documentation Index
> Fetch the complete documentation index at: https://help.dingtalk.io/llms.txt
> Use this file to discover all available pages before exploring further.

# Format Painter and Clear Formatting

> DingTalk Sheets Format Painter copies all formatting — color, font, borders — from a source cell and applies it to target cells with one click. The Clear Formatting shortcut (Ctrl+/) instantly resets any cell back to the default style.

When processing and beautifying spreadsheets, you often need to make large-scale changes to colors, fonts, and formats. Modifying cells one by one is tedious and time-consuming. The Format Painter lets you complete these operations quickly and easily, eliminating the need to handle each cell individually.

## Format Painter

* First, select the source Cell whose format you want to copy.

* Then, click **Format Painter** on the left side of the toolbar. The format of the source Cell is copied immediately. When the cursor turns into a brush shape, the format has been copied successfully.

* Finally, select the target Cell to apply the format. Click once, and the copied format is applied to the target Cell. The target Cell instantly takes on the same format as the source Cell, indicating that the Format Painter has been applied successfully.

## Clear Formatting

* First, select the target Cell to be cleared.

* Then, click **Clear Formatting** on the left side of the toolbar, **or use the shortcut Ctrl + / (Mac: Cmd + /)** to complete the action efficiently. Alternatively, **right-click and choose Clear > Clear Formatting.**

***