{"id":1416,"date":"2023-02-23T00:31:18","date_gmt":"2023-02-23T00:31:18","guid":{"rendered":"https:\/\/www.excelandmacros.com\/?p=1416"},"modified":"2023-02-23T00:39:09","modified_gmt":"2023-02-23T00:39:09","slug":"magic-use-of-format-painter-multiple-times","status":"publish","type":"post","link":"https:\/\/www.excelandmacros.com\/sr\/magazine\/formatting\/magic-use-of-format-painter-multiple-times\/","title":{"rendered":"Magic use of Format Painter multiple times"},"content":{"rendered":"<div data-elementor-type=\"wp-post\" data-elementor-id=\"1416\" class=\"elementor elementor-1416\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-2fb36fdf elementor-section-full_width elementor-section-height-default elementor-section-height-default\" data-id=\"2fb36fdf\" data-element_type=\"section\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t\t\t\t\t<div class=\"elementor-background-overlay\"><\/div>\n\t\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-453b4299\" data-id=\"453b4299\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-3cb7e43f elementor-widget elementor-widget-text-editor\" data-id=\"3cb7e43f\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>FORMATTING<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1cd07cc4 elementor-widget elementor-widget-heading\" data-id=\"1cd07cc4\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Magic use of Format Painter multiple times<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-6acacc4 elementor-section-full_width elementor-section-height-default elementor-section-height-default\" data-id=\"6acacc4\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-25 elementor-top-column elementor-element elementor-element-485d0fae\" data-id=\"485d0fae\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-468e2cde elementor-widget elementor-widget-sidebar\" data-id=\"468e2cde\" data-element_type=\"widget\" data-widget_type=\"sidebar.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div id=\"ocean_social_share-2\" class=\"sidebar-box widget-oceanwp-social-share social-share clr\">\t\t\t\t<ul class=\"owp-social-share style-colored name-hidden\">\r\n\t\t\t\t\t<li class=\"twitter\"><a href=\"https:\/\/twitter.com\/share?text=Magic%20use%20of%20Format%20Painter%20multiple%20times&#038;url=https%3A%2F%2Fwww.excelandmacros.com%2Fsr%2Fmagazine%2Fformatting%2Fmagic-use-of-format-painter-multiple-times%2F\" title=\"Share on X\"  style=\"border-radius:2px;\" onclick=\"owpShareOnClick( this.href );return false;\"><span class=\"owp-icon-wrap\"><svg class=\"owpss-icon\" aria-labelledby=\"owpss-twitter-icon\" role=\"img\" viewbox=\"0 0 512 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\">\r\n\t\t\t\t\t\t\t\t<path d=\"M389.2 48h70.6L305.6 224.2 487 464H345L233.7 318.6 106.5 464H35.8L200.7 275.5 26.8 48H172.4L272.9 180.9 389.2 48zM364.4 421.8h39.1L151.1 88h-42L364.4 421.8z\"\/>\r\n\t\t\t\t\t\t\t<\/svg><\/span><\/a><\/li><li class=\"facebook\"><a href=\"https:\/\/www.facebook.com\/sharer.php?u=https%3A%2F%2Fwww.excelandmacros.com%2Fsr%2Fmagazine%2Fformatting%2Fmagic-use-of-format-painter-multiple-times%2F\" title=\"Share on Facebook\"  style=\"border-radius:2px;\" onclick=\"owpShareOnClick( this.href );return false;\"><span class=\"owp-icon-wrap\"><svg class=\"owpss-icon\" aria-labelledby=\"owpss-facebook-icon\" role=\"img\" viewbox=\"0 0 512 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\">\r\n\t\t\t\t\t\t\t\t<path d=\"M504 256C504 119 393 8 256 8S8 119 8 256c0 123.78 90.69 226.38 209.25 245V327.69h-63V256h63v-54.64c0-62.15\t\t\t\t\t\t\t\t37-96.48 93.67-96.48 27.14 0 55.52 4.84 55.52 4.84v61h-31.28c-30.8 0-40.41 19.12-40.41 38.73V256h68.78l-11\t\t\t\t\t\t\t\t71.69h-57.78V501C413.31 482.38 504 379.78 504 256z\"\/>\r\n\t\t\t\t\t\t\t<\/svg><\/span><\/a><\/li><li class=\"linkedin\"><a href=\"https:\/\/www.linkedin.com\/shareArticle?mini=true&#038;url=https%3A%2F%2Fwww.excelandmacros.com%2Fsr%2Fmagazine%2Fformatting%2Fmagic-use-of-format-painter-multiple-times%2F&#038;title=Magic%20use%20of%20Format%20Painter%20multiple%20times&#038;summary=FORMATTING+Magic+use+of+Format+Painter+multiple+times+Do+you+know+what+Excel+Format+Painter+command+can+do+for+you%3F+Format+Painter+tool+is+a+very+useful+Microsoft+Excel+tool.+People+use+it+for+taking+the+format+of+a+single%26hellip%3B&#038;source=https:\/\/www.excelandmacros.com\/sr\/\" title=\"Share on LinkedIn\"  style=\"border-radius:2px;\" onclick=\"owpShareOnClick( this.href );return false;\"><span class=\"owp-icon-wrap\"><svg class=\"owpss-icon\" aria-labelledby=\"owpss-linkedin-icon\" role=\"img\" viewbox=\"0 0 448 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\">\r\n\t\t\t\t\t\t\t\t<path d=\"M416 32H31.9C14.3 32 0 46.5 0 64.3v383.4C0 465.5 14.3 480 31.9 480H416c17.6 0 32-14.5 32-32.3V64.3c0-17.8-14.4-32.3-32-32.3zM135.4\t\t\t\t\t\t\t\t416H69V202.2h66.5V416zm-33.2-243c-21.3 0-38.5-17.3-38.5-38.5S80.9 96 102.2 96c21.2 0 38.5 17.3 38.5 38.5 0 21.3-17.2 38.5-38.5 38.5zm282.1\t\t\t\t\t\t\t\t243h-66.4V312c0-24.8-.5-56.7-34.5-56.7-34.6 0-39.9 27-39.9 54.9V416h-66.4V202.2h63.7v29.2h.9c8.9-16.8 30.6-34.5 62.9-34.5 67.2 0 79.7 44.3 79.7 101.9V416z\"\/>\r\n\t\t\t\t\t\t\t<\/svg><\/span><\/a><\/li><li class=\"viber\"><a href=\"\" title=\"Share on Viber\"  style=\"border-radius:2px;\" onclick=\"owpShareOnClick( this.href );return false;\"><span class=\"owp-icon-wrap\"><svg class=\"owpss-icon\" aria-labelledby=\"owpss-viber-icon\" role=\"img\" viewbox=\"0 0 512 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\">\r\n\t\t\t\t\t\t\t\t<path d=\"M444 49.9C431.3 38.2 379.9.9 265.3.4c0 0-135.1-8.1-200.9 52.3C27.8 89.3 14.9 143 13.5 209.5c-1.4 66.5-3.1 191.1 117\t\t\t\t\t\t\t\t224.9h.1l-.1 51.6s-.8 20.9 13 25.1c16.6 5.2 26.4-10.7 42.3-27.8 8.7-9.4 20.7-23.2 29.8-33.7 82.2 6.9 145.3-8.9 152.5-11.2 16.6-5.4 110.5-17.4\t\t\t\t\t\t\t\t125.7-142 15.8-128.6-7.6-209.8-49.8-246.5zM457.9 287c-12.9 104-89 110.6-103 115.1-6 1.9-61.5 15.7-131.2 11.2 0 0-52 62.7-68.2 79-5.3 5.3-11.1\t\t\t\t\t\t\t\t4.8-11-5.7 0-6.9.4-85.7.4-85.7-.1 0-.1 0 0 0-101.8-28.2-95.8-134.3-94.7-189.8 1.1-55.5 11.6-101 42.6-131.6 55.7-50.5 170.4-43 170.4-43 96.9.4\t\t\t\t\t\t\t\t143.3 29.6 154.1 39.4 35.7 30.6 53.9 103.8 40.6 211.1zm-139-80.8c.4 8.6-12.5 9.2-12.9.6-1.1-22-11.4-32.7-32.6-33.9-8.6-.5-7.8-13.4.7-12.9 27.9\t\t\t\t\t\t\t\t1.5 43.4 17.5 44.8 46.2zm20.3 11.3c1-42.4-25.5-75.6-75.8-79.3-8.5-.6-7.6-13.5.9-12.9 58 4.2 88.9 44.1 87.8 92.5-.1 8.6-13.1 8.2-12.9-.3zm47 13.4c.1\t\t\t\t\t\t\t\t8.6-12.9 8.7-12.9.1-.6-81.5-54.9-125.9-120.8-126.4-8.5-.1-8.5-12.9 0-12.9 73.7.5 133 51.4 133.7 139.2zM374.9 329v.2c-10.8 19-31 40-51.8\t\t\t\t\t\t\t\t33.3l-.2-.3c-21.1-5.9-70.8-31.5-102.2-56.5-16.2-12.8-31-27.9-42.4-42.4-10.3-12.9-20.7-28.2-30.8-46.6-21.3-38.5-26-55.7-26-55.7-6.7-20.8 14.2-41\t\t\t\t\t\t\t\t33.3-51.8h.2c9.2-4.8 18-3.2 23.9 3.9 0 0 12.4 14.8 17.7 22.1 5 6.8 11.7 17.7 15.2 23.8 6.1 10.9 2.3 22-3.7 26.6l-12 9.6c-6.1 4.9-5.3 14-5.3 14s17.8\t\t\t\t\t\t\t\t67.3 84.3 84.3c0 0 9.1.8 14-5.3l9.6-12c4.6-6 15.7-9.8 26.6-3.7 14.7 8.3 33.4 21.2 45.8 32.9 7 5.7 8.6 14.4 3.8 23.6z\"\/>\r\n\t\t\t\t\t\t\t<\/svg><\/span><\/a><\/li>\t\t\t\t<\/ul>\r\n\r\n\t\t\t\t\r\n\t\t\r\n\t\t\t<\/div>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-4beea042\" data-id=\"4beea042\" data-element_type=\"column\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-78d4aab2 elementor-widget elementor-widget-heading\" data-id=\"78d4aab2\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Do you know what Excel Format Painter command can do for you?<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-35118985 elementor-widget elementor-widget-text-editor\" data-id=\"35118985\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Format Painter tool is a very useful Microsoft Excel tool. People use it for taking the format of a single cell or range of cells. Then they apply it to other cell or range.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3f23deb elementor-widget elementor-widget-text-editor\" data-id=\"3f23deb\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>You can find Format Painter inside the Home tab. It is under the Clipboard group of controls, together with the Cut, Copy and Paste function. Also, you can find it in the <a href=\"https:\/\/www.excelandmacros.com\/sr\/magazine\/basics\/excel-right-click-menu-explained\/\">Right-click menu<\/a>. The location of the tool itself suggests that the tool is attractive. It&#8217;s well known that Cut, Copy and Paste instructions we use most frequently.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6f10b50d elementor-widget elementor-widget-image\" data-id=\"6f10b50d\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"181\" height=\"169\" src=\"https:\/\/www.excelandmacros.com\/wp-content\/uploads\/2023\/02\/format-painter.png\" class=\"attachment-large size-large wp-image-1418\" alt=\"\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-40363688 elementor-widget elementor-widget-text-editor\" data-id=\"40363688\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>And yes, people use Format Painter very often, too. Especially when they do Formatting and Data processing. Let\u2019s remind ourselves, how to use it in three easy steps:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3c18417 elementor-widget elementor-widget-text-editor\" data-id=\"3c18417\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ol><li><strong>Select the cell <\/strong>or range of cells you want to take the format from.<\/li><li><strong>Click the Format Painter<\/strong> button located in Home tab with single click.<\/li><li><strong>Select the cell <\/strong>or range of cells where you want to apply your format.<\/li><\/ol>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5dcecc6 elementor-widget elementor-widget-text-editor\" data-id=\"5dcecc6\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>After you do so, the format you took will be applied to dedicated cells and that\u2019s it. Format Painter finished its task. Then you cannot use it again to apply it on another range of cells. We often need to apply the same format multiple times. With the process we explained, the only thing we can do is to repeat all three steps again.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1eaa82fe elementor-widget elementor-widget-heading\" data-id=\"1eaa82fe\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">But is this really the only way to use it multiple times?<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-349e197 elementor-widget elementor-widget-text-editor\" data-id=\"349e197\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>It\u2019s interesting how some things can be so simple and yet we don\u2019t use them.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-23b589ce elementor-widget elementor-widget-text-editor\" data-id=\"23b589ce\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>The solution to this issue about using Excel Format Painter multiple times is simple. You need to do a double click in step #2 from above instead of a single click.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4e1d3af elementor-widget elementor-widget-text-editor\" data-id=\"4e1d3af\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>In that case when you apply the format to a new cell, you will be free to continue. You can do it again and again, as many times as you need. When you want to disable the Format Painter just press the <strong>Esc<\/strong> button on the keyboard. So, the steps for using Format Painter multiple times are:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-494093e elementor-widget elementor-widget-text-editor\" data-id=\"494093e\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>#1<\/strong> \u2013 Select the cell or range of cells you want to take the format from.<\/p><p><strong>#2<\/strong> \u2013 Click the Format Painter button located in Home tab with double click.<\/p><p><strong>#3<\/strong> \u2013 Select the cell or range of cells where you want to apply your format.<\/p><p><strong>#4<\/strong> \u2013 Repeat step #3 as many times as you need.<\/p><p><strong>#5<\/strong> \u2013 Press Esc button on the keyboard to disable the Excel Format Painter command.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c404b92 elementor-widget elementor-widget-text-editor\" data-id=\"c404b92\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Now when you know the secret, it just needs repetition to become a part of muscle memory, similar to <a href=\"https:\/\/www.excelandmacros.com\/sr\/magazine\/\">other Excel tricks<\/a> you already use every day.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-25 elementor-top-column elementor-element elementor-element-1ff751d4\" data-id=\"1ff751d4\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>","protected":false},"excerpt":{"rendered":"<p>FORMATTING Magic use of Format Painter multiple times Do you know what Excel Format Painter command can do for you? Format Painter tool is a very useful Microsoft Excel tool. People use it for taking the format of a single cell or range of cells. Then they apply it to other cell or range. You [&hellip;]<\/p>","protected":false},"author":1,"featured_media":1417,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"ocean_post_layout":"","ocean_both_sidebars_style":"","ocean_both_sidebars_content_width":0,"ocean_both_sidebars_sidebars_width":0,"ocean_sidebar":"0","ocean_second_sidebar":"0","ocean_disable_margins":"enable","ocean_add_body_class":"","ocean_shortcode_before_top_bar":"","ocean_shortcode_after_top_bar":"","ocean_shortcode_before_header":"","ocean_shortcode_after_header":"","ocean_has_shortcode":"","ocean_shortcode_after_title":"","ocean_shortcode_before_footer_widgets":"","ocean_shortcode_after_footer_widgets":"","ocean_shortcode_before_footer_bottom":"","ocean_shortcode_after_footer_bottom":"","ocean_display_top_bar":"default","ocean_display_header":"default","ocean_header_style":"","ocean_center_header_left_menu":"0","ocean_custom_header_template":"0","ocean_custom_logo":0,"ocean_custom_retina_logo":0,"ocean_custom_logo_max_width":0,"ocean_custom_logo_tablet_max_width":0,"ocean_custom_logo_mobile_max_width":0,"ocean_custom_logo_max_height":0,"ocean_custom_logo_tablet_max_height":0,"ocean_custom_logo_mobile_max_height":0,"ocean_header_custom_menu":"0","ocean_menu_typo_font_family":"0","ocean_menu_typo_font_subset":"","ocean_menu_typo_font_size":0,"ocean_menu_typo_font_size_tablet":0,"ocean_menu_typo_font_size_mobile":0,"ocean_menu_typo_font_size_unit":"px","ocean_menu_typo_font_weight":"","ocean_menu_typo_font_weight_tablet":"","ocean_menu_typo_font_weight_mobile":"","ocean_menu_typo_transform":"","ocean_menu_typo_transform_tablet":"","ocean_menu_typo_transform_mobile":"","ocean_menu_typo_line_height":0,"ocean_menu_typo_line_height_tablet":0,"ocean_menu_typo_line_height_mobile":0,"ocean_menu_typo_line_height_unit":"","ocean_menu_typo_spacing":0,"ocean_menu_typo_spacing_tablet":0,"ocean_menu_typo_spacing_mobile":0,"ocean_menu_typo_spacing_unit":"","ocean_menu_link_color":"","ocean_menu_link_color_hover":"","ocean_menu_link_color_active":"","ocean_menu_link_background":"","ocean_menu_link_hover_background":"","ocean_menu_link_active_background":"","ocean_menu_social_links_bg":"","ocean_menu_social_hover_links_bg":"","ocean_menu_social_links_color":"","ocean_menu_social_hover_links_color":"","ocean_disable_title":"on","ocean_disable_heading":"default","ocean_post_title":"","ocean_post_subheading":"","ocean_post_title_style":"","ocean_post_title_background_color":"","ocean_post_title_background":0,"ocean_post_title_bg_image_position":"","ocean_post_title_bg_image_attachment":"","ocean_post_title_bg_image_repeat":"","ocean_post_title_bg_image_size":"","ocean_post_title_height":0,"ocean_post_title_bg_overlay":0.5,"ocean_post_title_bg_overlay_color":"","ocean_disable_breadcrumbs":"default","ocean_breadcrumbs_color":"","ocean_breadcrumbs_separator_color":"","ocean_breadcrumbs_links_color":"","ocean_breadcrumbs_links_hover_color":"","ocean_display_footer_widgets":"default","ocean_display_footer_bottom":"default","ocean_custom_footer_template":"","ocean_post_oembed":"","ocean_post_self_hosted_media":"","ocean_post_video_embed":"","ocean_link_format":"","ocean_link_format_target":"self","ocean_quote_format":"","ocean_quote_format_link":"post","ocean_gallery_link_images":"off","ocean_gallery_id":[],"footnotes":""},"categories":[7],"tags":[],"class_list":["post-1416","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-formatting","entry","has-media"],"aioseo_notices":[],"rttpg_featured_image_url":{"full":["https:\/\/www.excelandmacros.com\/wp-content\/uploads\/2023\/02\/format-painter-cover-e1677097811746.jpg",1920,1080,false],"landscape":["https:\/\/www.excelandmacros.com\/wp-content\/uploads\/2023\/02\/format-painter-cover-e1677097811746.jpg",1920,1080,false],"portraits":["https:\/\/www.excelandmacros.com\/wp-content\/uploads\/2023\/02\/format-painter-cover-e1677097811746.jpg",1920,1080,false],"thumbnail":["https:\/\/www.excelandmacros.com\/wp-content\/uploads\/2023\/02\/format-painter-cover-e1677097811746-150x150.jpg",150,150,true],"medium":["https:\/\/www.excelandmacros.com\/wp-content\/uploads\/2023\/02\/format-painter-cover-e1677097811746-300x169.jpg",300,169,true],"large":["https:\/\/www.excelandmacros.com\/wp-content\/uploads\/2023\/02\/format-painter-cover-e1677097811746-1024x576.jpg",1024,576,true],"1536x1536":["https:\/\/www.excelandmacros.com\/wp-content\/uploads\/2023\/02\/format-painter-cover-e1677097811746-1536x864.jpg",1536,864,true],"2048x2048":["https:\/\/www.excelandmacros.com\/wp-content\/uploads\/2023\/02\/format-painter-cover-e1677097811746.jpg",1920,1080,false],"trp-custom-language-flag":["https:\/\/www.excelandmacros.com\/wp-content\/uploads\/2023\/02\/format-painter-cover-e1677097811746.jpg",18,10,false]},"rttpg_author":{"display_name":"adminMilos","author_link":"https:\/\/www.excelandmacros.com\/sr\/magazine\/author\/adminmilos\/"},"rttpg_comment":0,"rttpg_category":"<a href=\"https:\/\/www.excelandmacros.com\/sr\/magazine\/category\/formatting\/\" rel=\"category tag\">Formatting<\/a>","rttpg_excerpt":"FORMATTING Magic use of Format Painter multiple times Do you know what Excel Format Painter command can do for you? Format Painter tool is a very useful Microsoft Excel tool. People use it for taking the format of a single cell or range of cells. Then they apply it to other cell or range. You&hellip;","_links":{"self":[{"href":"https:\/\/www.excelandmacros.com\/sr\/wp-json\/wp\/v2\/posts\/1416","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.excelandmacros.com\/sr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.excelandmacros.com\/sr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.excelandmacros.com\/sr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.excelandmacros.com\/sr\/wp-json\/wp\/v2\/comments?post=1416"}],"version-history":[{"count":77,"href":"https:\/\/www.excelandmacros.com\/sr\/wp-json\/wp\/v2\/posts\/1416\/revisions"}],"predecessor-version":[{"id":1495,"href":"https:\/\/www.excelandmacros.com\/sr\/wp-json\/wp\/v2\/posts\/1416\/revisions\/1495"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.excelandmacros.com\/sr\/wp-json\/wp\/v2\/media\/1417"}],"wp:attachment":[{"href":"https:\/\/www.excelandmacros.com\/sr\/wp-json\/wp\/v2\/media?parent=1416"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.excelandmacros.com\/sr\/wp-json\/wp\/v2\/categories?post=1416"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.excelandmacros.com\/sr\/wp-json\/wp\/v2\/tags?post=1416"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}