{"id":571,"date":"2014-10-17T00:23:37","date_gmt":"2014-10-16T22:23:37","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=571"},"modified":"2023-11-30T01:31:08","modified_gmt":"2023-11-30T00:31:08","slug":"format-painter-multiple-cells","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/format-painter-multiple-cells\/","title":{"rendered":"Format Painter Multiple Cells"},"content":{"rendered":"<p>The Format Painter copies formatting from one place and applies it to another but this can also be extended to multiple cells.<\/p>\n<p>To activate this hidden gem you need to <strong>double click<\/strong> on the Format Painter and then go crazy with the paint brush!<\/p>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/p77b5bMAAPs?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p><a href=\"https:\/\/www.youtube.com\/c\/MyExcelOnlinecomtutorials?sub_confirmation=1\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignmiddle wp-image-111468 size-full\" style=\"vertical-align: middle;\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/04\/1.yt_.png\" alt=\"\" title=\"\"><\/a><\/p>\n<div class=\"after-post-box\">\n<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Format-Painter.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\"><span class=\"ctaText px-3 text-capitalize\"><strong> download excel workbook<\/strong> <i class=\"fa fa-download\"><\/i><\/span><span class=\"postTitle px-3\">Format-Painter.xlsx<\/span><\/a><\/p>\n<\/div>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1:<\/strong> <\/span>Pick a cell that contains the formatting you want to copy<\/p>\n<p>Go to\u00a0<em><strong>Home &gt; Clipboard &gt; Format Painter<\/strong><\/em> and make sure to <strong>double click on the format painter icon<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Format Painter Multiple Cells\"  class=\"alignnone size-full wp-image-19931\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/format-painter-01.jpg\" alt=\"Format Painter Multiple Cells\" width=\"845\" height=\"511\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/format-painter-01.jpg 845w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/format-painter-01-300x181.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/format-painter-01-768x464.jpg 768w\" sizes=\"(max-width: 845px) 100vw, 845px\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2:<\/strong> <\/span>These are the cells that we want to apply the same formatting. Click on all of them<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Format Painter Multiple Cells\"  class=\"alignnone size-full wp-image-19932\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/format-painter-02.jpg\" alt=\"Format Painter Multiple Cells\" width=\"844\" height=\"523\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/format-painter-02.jpg 844w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/format-painter-02-300x186.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/format-painter-02-768x476.jpg 768w\" sizes=\"(max-width: 844px) 100vw, 844px\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 3:<\/strong> <\/span>The same formatting is applied with just a click. Now try applying it to the entire <strong>YEAR Column<\/strong> by highlighting the entire column<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Format Painter Multiple Cells\"  class=\"alignnone size-full wp-image-19933\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/format-painter-03.jpg\" alt=\"Format Painter Multiple Cells\" width=\"835\" height=\"483\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/format-painter-03.jpg 835w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/format-painter-03-300x174.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/format-painter-03-768x444.jpg 768w\" sizes=\"(max-width: 835px) 100vw, 835px\" \/><\/p>\n<p>They now all have the same formatting!<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Format Painter Multiple Cells\"  class=\"alignnone size-full wp-image-19934\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/format-painter-04.jpg\" alt=\"Format Painter Multiple Cells\" width=\"853\" height=\"493\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/format-painter-04.jpg 853w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/format-painter-04-300x173.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/format-painter-04-768x444.jpg 768w\" sizes=\"(max-width: 853px) 100vw, 853px\" \/><\/p>\n<p><span style=\"color: #0000ff;\"><strong>Helpful Resource:<\/strong><\/span><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/100.html\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-722 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/728x901-e1413496235820.gif\" alt=\"728x90\" width=\"599\" height=\"74\" title=\"\"><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>The Format Painter copies formatting from one place and applies it to another but this can also be extended to multiple cells. To activate this hidden gem you need to double click on the Format Painter and then go crazy with the paint brush! \ufeff download excel workbook Format-Painter.xlsx STEP 1: Pick a cell that [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":17326,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[7,10],"tags":[62],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/571"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=571"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/571\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/17326"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=571"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=571"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=571"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}