Examples of using Format painter in English and their translations into German
{-}
-
Colloquial
-
Official
-
Ecclesiastic
-
Medicine
-
Financial
-
Ecclesiastic
-
Political
-
Computer
-
Programming
-
Official/political
-
Political
Select the Format Painter in the Home or Character tab of the Measurements palette.
In Excel, you can copy cells' formatting only with the Format Painter tool.
The Format Painter can copy the specific cell format to the cell or ranges.
To change the paintbrush to normal cursor, click the Format Painter button again.
Note: Format Painter also can copy formatting only to another worksheet.
Copy conditional formatting rules to another worksheet/workbook with Format Painter.
And with this Format Painter, all of the cell formatting will be copied to other cells.
To copy formatting from one place and apply it to another, you may use Format Painter.
Step 2: Click the Home> Format Painter button to change cursor to a paintbrush.
And then you can modify data in the table directly,or copy the table style with the Format Painter easily.
But the Format Painter will copy all the formatting of the cell and apply it to another.
Select the cell which contains the format you want to use,click Home> Format Painter.
You can use Format Painter to quickly copy all the formatting of cells and apply that formatting to other cells.
Select the range whose conditional formatting you will copy,and click Home> Format Painter.
If you click the Format painter button once, the paintbrush becomes to normal cursor after selecting a range.
Note: If you want to apply the formatting to many ranges,please double click the Format Painter button.
If you double click the Format Painter button, paintbrush won't change to normal cursor no matter how many times you select ranges.
But if you just want to copypart of the specific cell format to the cells, the Format Painter cannot help you.
With the Format Painter, all of the cell formatting will be copied, but with Kutools for Excel's Copy Cell Formatting, you can copy only the specific formatting that you need.
That's why we build the Kutools forExcel's Copy Cell Formatting utility, because Format Painter can only copy all formatting from one place in Excel.
After inserting the table with custom style into worksheet, you can change the data in the table directly,or copy the table style with the Format Painter easily.
Actually both Format Painter feature and Paste Special feature can help you solve it, and Kutools for Excel's Copy Cell Formatting utility can help you get it done easily too.
For keeping the original row height, please select the entire rows of the original cells that you want to copy theirrow height and then click Home> Format Painter.