{"id":3562,"date":"2023-01-31T20:38:42","date_gmt":"2023-01-31T20:38:42","guid":{"rendered":"https:\/\/www.bizinfograph.com\/resource\/?p=3562"},"modified":"2024-01-24T20:20:17","modified_gmt":"2024-01-24T20:20:17","slug":"how-to-use-format-painter-in-excel","status":"publish","type":"post","link":"https:\/\/www.bizinfograph.com\/resource\/how-to-use-format-painter-in-excel\/","title":{"rendered":"How to use Format Painter in Excel?"},"content":{"rendered":"<p>Format Painter in Excel stands as a testament to efficiency and aesthetic consistency in your spreadsheets, allowing you to effortlessly replicate formatting across multiple cells, ranges, or sheets. This tool not only saves time but also ensures that your data presentations are visually coherent and professional. Embrace the power and simplicity of Format Painter in Excel to transform your spreadsheet creation process, making it a seamless task to maintain uniformity and clarity in all your data-driven endeavors.<\/p>\n<p>This quick video demonstrates how to use the Format Painter, Fill Handle, and Paste Special tools in Excel to duplicate formatting. These methods are compatible with Excel 2007 to Excel 365.<\/p>\n<p><strong>This Tutorial Covers:<\/strong><\/p>\n<ol>\n<li><a href=\"#what-is-excel-format-painter\"><strong>What is Excel Format Painter<\/strong><\/a><\/li>\n<li><a href=\"#how-to-use-format-painter-in-excel\"><strong>How to Use Format Painter in Excel<\/strong><\/a>\n<ul>\n<li>Using Format Painter from Ribbon<\/li>\n<li>Using Shortcut<\/li>\n<\/ul>\n<\/li>\n<li><a href=\"#how-to-copy-formatting-to-a-range-of-cells\"><strong>How to copy formatting to a range of cells<\/strong><\/a><\/li>\n<li><a href=\"#how-to-copy-formatting-down-a-column-using-the-fill-handle\"><strong>How to copy formatting down a column using the Fill Handle<\/strong><\/a><\/li>\n<li><a href=\"#how-to-copy-cell-formatting-to-an-entire-column-or-row\"><strong>How to copy cell formatting to an entire column or row<\/strong><\/a><\/li>\n<li><a href=\"#how-to-copy-conditional-formatting-using-format-painter\"><strong>How to copy conditional formatting using format painter<\/strong><\/a><\/li>\n<li><a href=\"#how-to-copy-shape-formatting-using-format-painter\"><strong>How to copy shape formatting using format painter<\/strong><\/a><\/li>\n<li><a href=\"#how-to-keep-format-painter-active-for-multiple-use\"><strong>How to keep format painter active for multiple use<\/strong><\/a><\/li>\n<\/ol>\n<h2><strong id=\"what-is-excel-format-painter\">1. What is Format Painter in Excel?<\/strong><\/h2>\n<p>Use the handy Excel Format Painter tool to copy formatting from a group of cells and paste it in another location on the worksheet (or in multiple worksheets\/workbooks).<\/p>\n<p>Think about it! You receive some plainly unattractive data from a coworker, and you spend the next several minutes preparing it to make it look lovely. To do this, you might add borders, format the headers, change the column widths, take away the gridlines, etc.<\/p>\n<p>While you&#8217;re patting yourself on the back for transforming ugly data into beautiful data, another file arrives that requires the same formatting.<\/p>\n<p>Excel Format Painter can help in this situation and can save you a ton of time.<\/p>\n<p>The formatting you have already done can now be readily copied and pasted into the new dataset.<\/p>\n<p>The formatted data will be the same as if you had done everything manually, and woosh.<\/p>\n<h2><strong id=\"how-to-use-format-painter-in-excel\">2. How to Use Format Painter in Excel?<\/strong><\/h2>\n<p>To quickly copy all of the formatting from one cell to another, use the Format Painter. Without having to spend a lot of effort duplicating the formatting in each cell, this can assist maintain consistency.<\/p>\n<p>Excel&#8217;s format painter can be used in two different ways. Below is a description of them.<\/p>\n<ul>\n<li><strong>Using Format Painter from Ribbon:<\/strong><\/li>\n<\/ul>\n<p>Let\u2019s use a straightforward example to explain Format Painter in Excel.<\/p>\n<p>Let\u2019s say I want to duplicate the formatting from cell A1 (which is displayed below) to cell B1.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-3563\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Format-Painter-1.png\" alt=\"Format Painter\" width=\"182\" height=\"136\" \/><\/p>\n<p><strong>The following are the steps to copy formatting in Excel using Format Painter:<\/strong><\/p>\n<p><strong>Step 1:<\/strong> Choose the cell(s) whose formatting you want to replicate.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-3564\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Format-Painter-2.png\" alt=\"Format Painter\" width=\"276\" height=\"137\" \/><\/p>\n<p><strong>Step 2:<\/strong> Select \u201cFormat Painter\u201d from the \u201cHome\u201d Tab&#8217;s \u201cClipboard\u201d menu.<\/p>\n<p><img fetchpriority=\"high\" decoding=\"async\" class=\"aligncenter size-full wp-image-3565\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Format-Painter-3.png\" alt=\"Format Painter\" width=\"236\" height=\"261\" \/><\/p>\n<p><strong>Step 3:<\/strong> The cell that you want to transfer the formatting to is selected. Note that when you click on the Format Painter button in the ribbon, the pointer changes and you can see a brush in it. The format painter is now in use, as evidenced by this.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3566\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Format-Painter-4.png\" alt=\"Format Painter\" width=\"287\" height=\"151\" \/><\/p>\n<p>The formatting from cell A1 would be replicated to cell B1 immediately (as shown below).<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3567\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Format-Painter-5.png\" alt=\"Format Painter\" width=\"249\" height=\"167\" \/><\/p>\n<p>In the case above, format painter copied the following exactly:<\/p>\n<ul>\n<li>Cell Color<\/li>\n<li>Text formatting<\/li>\n<li>Text alignment<\/li>\n<\/ul>\n<p>The value in the cell is not copied by Format Painter; just the formatting is.<\/p>\n<p>Excel&#8217;s format painter can be used to:<\/p>\n<ul>\n<li>The same worksheet&#8217;s formatting should be copied.<\/li>\n<li>To another worksheet in the same workbook, copy the formatting.<\/li>\n<li>Formatting should be copied to another workbook.<\/li>\n<li><strong>Using Shortcut:<\/strong><\/li>\n<\/ul>\n<p><strong>The following are the steps to copy formatting using Format Painter in Excel with shortcut key:<\/strong><\/p>\n<p><strong>Step 1:<\/strong> Choose the cell(s) whose formatting you want to replicate. To duplicate the format of the chosen cells, use Ctrl+C.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3568\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Format-Painter-6.png\" alt=\"Format Painter \" width=\"278\" height=\"142\" \/><\/p>\n<p><strong>Step 2:<\/strong> Now click on the cells where the desired formatting will be pasted.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3569\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Format-Painter-7.png\" alt=\"Format Painter\" width=\"350\" height=\"161\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Format-Painter-7.png 350w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Format-Painter-7-300x138.png 300w\" sizes=\"(max-width: 350px) 100vw, 350px\" \/><\/p>\n<p><strong>Step 3:<\/strong> Press the shortcut keys for Alt, H, F, and P on the keyboard, followed by the &#8220;Enter&#8221; key. The formatting from cell A1 would be replicated to cell B1 immediately (as shown below).<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3570\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Format-Painter-8.png\" alt=\"Format Painter\" width=\"246\" height=\"165\" \/><\/p>\n<h2><strong id=\"how-to-copy-formatting-to-a-range-of-cells\">3. How to copy formatting to a range of cells?<\/strong><\/h2>\n<p><strong>The following are the steps to copy formatting <\/strong><strong>to a range of cells<\/strong><strong> in Excel using Format Painter:<\/strong><\/p>\n<p><strong>\u00a0<\/strong><strong>Step 1:<\/strong> Choose the cell(s) whose formatting you want to replicate.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3571\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Format-Painter-9.png\" alt=\"Format Painter\" width=\"415\" height=\"160\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Format-Painter-9.png 415w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Format-Painter-9-300x116.png 300w\" sizes=\"(max-width: 415px) 100vw, 415px\" \/><\/p>\n<p><strong>Step 2:<\/strong> Select \u201cFormat Painter\u201d from the \u201cHome\u201d Tab&#8217;s \u201cClipboard\u201d menu.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3572\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Format-Painter-10.png\" alt=\"Format Painter\" width=\"227\" height=\"161\" \/><\/p>\n<p><strong>Step 3:<\/strong> Drag the brush cursor over the cells you want to format after that.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3573\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Format-Painter-11.png\" alt=\"Format Painter\" width=\"398\" height=\"139\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Format-Painter-11.png 398w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Format-Painter-11-300x105.png 300w\" sizes=\"(max-width: 398px) 100vw, 398px\" \/><\/p>\n<p>The formatting from cell A1 would be replicated to cell B1, C1 and D1 immediately (as shown below).<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3574\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Format-Painter-12.png\" alt=\"Format Painter\" width=\"323\" height=\"153\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Format-Painter-12.png 323w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Format-Painter-12-300x142.png 300w\" sizes=\"(max-width: 323px) 100vw, 323px\" \/><\/p>\n<h2><strong id=\"how-to-copy-formatting-down-a-column-using-the-fill-handle\">4. How to copy formatting down a column using the Fill Handle?<\/strong><\/h2>\n<p><strong>The following are the steps to copy formatting <\/strong><strong>down a column using the Fill Handle<\/strong><strong>:<\/strong><\/p>\n<p><strong>Step 1:<\/strong> Hover your mouse over the fill handle after choosing the properly formatted cell (a small square at the lower right-hand corner). The white selection cross will turn into a black cross as you proceed. Holding the handle down while dragging it over the cells you want to format:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3575\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Format-Painter-13.png\" alt=\"Format Painter \" width=\"229\" height=\"151\" \/><\/p>\n<p>Don&#8217;t worry; we&#8217;ll undo it in the following step. This will also replicate the value of the first cell to other cells.<\/p>\n<p><strong>Step 2:<\/strong> Release the fill handle, choose \u201cFill Formatting Only\u201d from the Auto Fill Options drop-down menu:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3576\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Format-Painter-14.png\" alt=\"Format Painter\" width=\"282\" height=\"276\" \/><\/p>\n<p>That\u2019s it! The cell values return to their initial values, and other cells in the column are formatted as desired:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3577\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Format-Painter-15.png\" alt=\"Format Painter\" width=\"147\" height=\"157\" \/><\/p>\n<p><strong>Tip:<\/strong> Double-click the fill handle rather than dragging it, click AutoFill Options, and choose Fill Formatting Only to replicate the formatting along the column to the first empty cell.<\/p>\n<h2><strong id=\"how-to-copy-cell-formatting-to-an-entire-column-or-row\">5. How to copy cell formatting to an entire column or row?<\/strong><\/h2>\n<p>Small choices work wonderfully with Excel Format Painter and Fill Handle. But how do you transfer a cell&#8217;s formatting to a whole column or row such that the updated formatting is applied to every single cell in the column or row, even empty cells? The answer is to use Excel Paste Special&#8217;s Formats option.<\/p>\n<p><strong>The following are the steps to copy formatting <\/strong><strong>to an entire column or row<\/strong><strong> in Excel:<\/strong><\/p>\n<p><strong>Step 1:<\/strong> To copy the content and formats of a cell, select the cell with the desired format and press Ctrl+C.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3578\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Format-Painter-16.png\" alt=\"Format Painter\" width=\"384\" height=\"145\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Format-Painter-16.png 384w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Format-Painter-16-300x113.png 300w\" sizes=\"(max-width: 384px) 100vw, 384px\" \/><\/p>\n<p><strong>Step 2:<\/strong> By clicking on its heading, you can choose the entire column or row that you want to format.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3579\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Format-Painter-17.png\" alt=\"Format Painter\" width=\"390\" height=\"162\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Format-Painter-17.png 390w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Format-Painter-17-300x125.png 300w\" sizes=\"(max-width: 390px) 100vw, 390px\" \/><\/p>\n<p><strong>Step 3:<\/strong> Click \u201cPaste Special\u201d after doing a right-clicking on the selection.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3580\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Format-Painter-18.png\" alt=\"Format Painter\" width=\"265\" height=\"257\" \/><\/p>\n<p><strong>Step 4:<\/strong> Click \u201cFormats\u201d in the \u201cPaste Special\u201d dialog box, then click OK.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3581 size-full\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Format-Painter-19.png\" alt=\"Format Painter in Excel\" width=\"422\" height=\"310\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Format-Painter-19.png 422w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Format-Painter-19-300x220.png 300w\" sizes=\"(max-width: 422px) 100vw, 422px\" \/><\/p>\n<p>The formatting from cell A1 would be replicated to entire Row 1 immediately (as shown below).<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3582 size-full\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Format-Painter-20.png\" alt=\"Format Painter in Excel\" width=\"406\" height=\"160\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Format-Painter-20.png 406w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Format-Painter-20-300x118.png 300w\" sizes=\"(max-width: 406px) 100vw, 406px\" \/><\/p>\n<p>Alternatively, choose the \u201cPaste Special\u201d pop-up menu option for \u201cFormatting\u201d.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3583 size-full\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Format-Painter-21.png\" alt=\"Format Painter in Excel\" width=\"491\" height=\"304\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Format-Painter-21.png 491w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Format-Painter-21-300x186.png 300w\" sizes=\"(max-width: 491px) 100vw, 491px\" \/><\/p>\n<h2><strong id=\"how-to-copy-conditional-formatting-using-format-painter\">6. How to copy conditional formatting using format painter in Excel?<\/strong><\/h2>\n<p>Copying conditional formatting is one of my favorite things to do with Format Painter.<\/p>\n<p>Since conditional formatting enables you to declare several rules on a single data set, repeating the process for other data sets could take a while.<\/p>\n<p>Consider the following dataset, where students&#8217; grades are highlighted in red if they are less than 33 and in green if they are greater than 80.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3584\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Format-Painter-22.png\" alt=\"Format Painter\" width=\"304\" height=\"163\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Format-Painter-22.png 304w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Format-Painter-22-300x161.png 300w\" sizes=\"(max-width: 304px) 100vw, 304px\" \/><\/p>\n<p>Now, rather than repeating the conditional formatting process if I add a new column with marks in a new subject (Physics), I can just use the Format Painter to duplicate the cell formatting and conditional formatting rules.<\/p>\n<p><strong>The following are the steps to copy conditional formatting using format painter in Excel:<\/strong><\/p>\n<p><strong>Step 1:<\/strong> Select the entire column B.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3585\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Format-Painter-23.png\" alt=\"Format Painter\" width=\"376\" height=\"167\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Format-Painter-23.png 376w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Format-Painter-23-300x133.png 300w\" sizes=\"(max-width: 376px) 100vw, 376px\" \/><\/p>\n<p><strong>Step 2:<\/strong> Select \u201cFormat Painter\u201d from the \u201cHome\u201d Tab&#8217;s \u201cClipboard\u201d menu.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3586\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Format-Painter-24.png\" alt=\"Format Painter\" width=\"296\" height=\"189\" \/><\/p>\n<p><strong>Step 3:<\/strong> Select the cell where you want to copy conditional formatting. It will immediately apply the format.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3587\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Format-Painter-25.png\" alt=\"Format Painter\" width=\"333\" height=\"164\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Format-Painter-25.png 333w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Format-Painter-25-300x148.png 300w\" sizes=\"(max-width: 333px) 100vw, 333px\" \/><\/p>\n<h2><strong id=\"how-to-copy-shape-formatting-using-format-painter\">7. How to copy shape formatting using a format painter?<\/strong><\/h2>\n<p>You may rapidly copy formatting from shapes and paste it into other shapes with Format Painter.<\/p>\n<p><strong>The following steps will show you how to use Excel&#8217;s format painter to copy formatting from one shape and paste it into another:<\/strong><\/p>\n<p><strong>Step 1:<\/strong> Choose the shape whose formatting you want to duplicate.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3588\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Format-Painter-26.png\" alt=\"Format Painter \" width=\"273\" height=\"166\" \/><\/p>\n<p><strong>Step 2:<\/strong> Click \u201cFormat Painter\u201d under the \u201cClipboard\u201d category on the \u201cHome\u201d tab.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3589\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Format-Painter-27.png\" alt=\"Format Painter\" width=\"301\" height=\"141\" \/><\/p>\n<p><strong>Step 3:<\/strong> Wherever you wish to replicate the formatting, click on the shape. It will immediately apply the format.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3590\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Format-Painter-28.png\" alt=\"Format Painter\" width=\"298\" height=\"103\" \/><\/p>\n<h2><strong id=\"how-to-keep-format-painter-active-for-multiple-use\">8. How to keep format painter active for multiple uses?<\/strong><\/h2>\n<p>In some circumstances, you might want to copy the formatting from a group of cells and paste it into a group of cells that are not all adjacent. These could be found on multiple worksheets or workbooks or on the same worksheet.<\/p>\n<p>You can only copy and paste the formatting once when you select the \u201cFormat Painter\u201d button in the \u201cHome\u201d tab.<\/p>\n<p><strong>The following are the steps <\/strong><strong>to keep format painter active for multiple use<\/strong><strong> in Excel:<\/strong><\/p>\n<p><strong>Step 1:<\/strong> Select the entire column B.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3591\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Format-Painter-29.png\" alt=\"Format Painter \" width=\"483\" height=\"219\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Format-Painter-29.png 483w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Format-Painter-29-300x136.png 300w\" sizes=\"(max-width: 483px) 100vw, 483px\" \/><\/p>\n<p><strong>Step 2:<\/strong> You must double-click on the Format Painter icon in order to copy and paste the formatting several times. This will enable you to copy from a group of cells and repeatedly paste that formatting (until you disable the Format Painter).<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3592\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Format-Painter-30.png\" alt=\"Format Painter\" width=\"295\" height=\"188\" \/><\/p>\n<p><strong>Step 3:<\/strong> Now, select the cells where you want to format. It will immediately apply the format.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3594\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Format-Painter-31.png\" alt=\"Format Painter\" width=\"463\" height=\"181\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Format-Painter-31.png 463w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Format-Painter-31-300x117.png 300w\" sizes=\"(max-width: 463px) 100vw, 463px\" \/><\/p>\n<p>Simply click the Format Painter button once again or use the Escape key to turn it off.<\/p>\n<h2><strong>Application of Format Painter in Excel<\/strong><\/h2>\n<ol>\n<li><strong>Uniform Cell Formatting<\/strong>:\n<ul>\n<li>Quickly apply consistent text formatting (font type, size, color) and cell formatting (background color, borders) across various cells or ranges, ensuring your spreadsheet maintains a uniform and professional appearance.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Copying Number Formats<\/strong>:\n<ul>\n<li>Easily replicate number formats like currency, percentage, or date formats across different cells, saving time and preventing manual reformatting errors.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Aligning Text Consistently<\/strong>:\n<ul>\n<li>Apply the same text alignment and orientation (left, right, center, or justified) from a formatted cell to other cells, maintaining a consistent and organized look throughout your tables or data sets.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Transferring Conditional Formatting<\/strong>:\n<ul>\n<li>Use Format Painter in Excel to quickly copy conditional formatting rules from one set of cells to another, helping to highlight critical data points or trends across large datasets.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Applying Cell Styles<\/strong>:\n<ul>\n<li>Duplicate complex cell styles that involve multiple formatting options (like a combination of font style, cell borders, and fill color) to other cells or ranges, ensuring a cohesive design with minimal effort.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Replicating Data Bars or Color Scales<\/strong>:\n<ul>\n<li>Copy data bars or color scales from one set of cells to another, visually representing data comparison or trends efficiently and attractively.<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<p>Format Painter in Excel is a versatile tool that significantly enhances the visual appeal and consistency of your spreadsheets, saving time and ensuring that your data is presented in a clear and professional manner.<\/p>\n<p>You may be interested:<\/p>\n<ol>\n<li><a href=\"https:\/\/www.bizinfograph.com\/dashboard-templates#Finance\" target=\"_blank\" rel=\"noopener\">Financial Dashboards<\/a><\/li>\n<li><a href=\"https:\/\/www.bizinfograph.com\/dashboard-templates#Sales\" target=\"_blank\" rel=\"noopener\">Sales Dashboards<\/a><\/li>\n<li><a href=\"https:\/\/www.bizinfograph.com\/dashboard-templates#Human-Resource\" target=\"_blank\" rel=\"noopener\">HR Dashboards<\/a><\/li>\n<li><a href=\"https:\/\/www.executiveknowledge.org\/dashboard-templates\/35\" target=\"_blank\" rel=\"noopener\">Data Visualization Charts<\/a><\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"<p>Format Painter in Excel stands as a testament to efficiency and aesthetic consistency in your spreadsheets, allowing you to effortlessly replicate formatting across multiple cells, ranges, or sheets. This tool not only saves time but also ensures that your data presentations are visually coherent and professional. Embrace the power and simplicity of Format Painter in [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"default","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[439],"tags":[441,440],"class_list":["post-3562","post","type-post","status-publish","format-standard","hentry","category-format-painter-in-excel","tag-format-painter","tag-format-painter-in-excel"],"_links":{"self":[{"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/posts\/3562","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/comments?post=3562"}],"version-history":[{"count":6,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/posts\/3562\/revisions"}],"predecessor-version":[{"id":8260,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/posts\/3562\/revisions\/8260"}],"wp:attachment":[{"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/media?parent=3562"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/categories?post=3562"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/tags?post=3562"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}