#Excel 2013 remove paintbrush icon how to#

Here, I want to apply Conditional Formatting in the Expenditure column. To explain the procedure, I’m going to use the dataset of particular customer expenditure. Using Format Painter to Copy Conditional FormattingĮxcel Format Pointer also supports Conditional Formatting while copying format. Uses of CELL Color A1 in Excel (3 Examples)ĥ.Dealing with Time Format in Excel (5 Suitable Ways).

#Excel 2013 remove paintbrush icon how to#

How to Format Cell Based on Formula in Excel (13 Examples).

Read more: How to Use Excel Cell Format Formula To start the procedure, select the cell range from where you want to copy Format.Īs a result, the copied format will be pasted in the C4:C13 cell range row by row. I want to copy the format row by row in the Order ID column. Here, in the Status column, I have two types of values one is Delivered, and another is Pending where different formatting is used. Because one column may contain different types of formatting. In case you want to copy the format row by row you can do it by using the Format Painter. Read more: How to Use Format Painter in Excel for Multiple Cells ⏩ Here, the copied format is applied to the E4:E13 cell. ⏩ Now, the copied format is applied to the D4:D13 cell.Īgain, place the Format Painter icon on the next column and click. ⏩ Now, the copied format is applied to the C4:C13 cell.Īgain, place the Format Painter icon on the next column and click there. Now, open the Home tab > select Format Painter (double click ) To begin with, select the cell range from where you want to copy Format. Here, I want to copy the format of the Product Name column to the Order ID, Price and Status column. Using Format Painter in Multiple Columnsįormat Painter gives us the opportunity to copy format in multiple columns or non-adjacent cells. Read more: How to Custom Format Cells in Excelģ. Therefore, the copied format will be pasted in the C4:C8 cell range. Then, an icon of Format Painter will appear. To start with, select the cell range from where you want to copy Format. To perform this task, I sorted the values of the Status column using the Sort command of Excel. And I will apply it in the Order ID column. Here, I want to copy the format of Status column cells where the delivery status is Delivered. Using Format Painter to Copy Formatting to Range of Cellsįormat Painter not only supports a single cell but also you can use it for the range of cells. Read more: Formula to Copy Cell Value and Format in ExcelĢ. Hence, the format will be applied to the resultant cell C4. Place the icon in the place or cell where you want to paste the copied format. Next, you will see an icon of Format Painter. For more shortcut ways to use Format Painter, you can check this Format Painter Shortcut in the Excel article. If you want you can use the shortcut, press ALT, H, F, P (remember to press these keys one by one) to trigger Format Painter. Now, open the Home tab > select Format Painter To start with, select the cell or cell range from where you want to copy Format. I want to copy the format of the E4 cell of the Status column to apply it in the Order ID column cell.

Here, I want to format the Order ID column depending on the values of the Status column.

If you want, you can use Format Painter in Excel to copy a cell format. Using Format Painter to Copy Cell Formatting Since the macro can be assigned to a shortcut key, you end up with an easier shortcut than what has already been discussed.7 Ways to Use Excel Format Painter 1. To use the macro, follow steps 1 through 3 as previously outlined, and then run the macro. The following is an example of such a macro. If you prefer a real shortcut key (only a single key press), then you will need to develop your own macro to paste only the format. The first displays the Context menu for the cells and the other uses the regular menu system. In step 4 you could also press Shift+F10 rather than Alt+E. This sequence displays the Paste Special dialog box and chooses to paste only the format. Select the cells to receive the format.Select the cell from which the format is to be copied.You can, however, use the following steps: Unfortunately, Excel doesn't provide a single shortcut key you can use for the Format Painter. He would find it much easier to use if there were a shortcut key instead. Fred loves to use the Format Painter, but doesn't like to use the mouse to use the tool.