{"id":24761,"date":"2021-10-27T12:54:48","date_gmt":"2021-10-27T10:54:48","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=24761"},"modified":"2024-03-25T22:42:38","modified_gmt":"2024-03-25T21:42:38","slug":"copy-a-custom-style-into-a-new-workbook","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/copy-a-custom-style-into-a-new-workbook\/","title":{"rendered":"Copy a custom style into a new workbook"},"content":{"rendered":"

\"Copy<\/a><\/p>\n

If data is presented aesthetically, it will be easily interpreted by the users. When you present your data in a clean as well as visually pleasing way<\/strong>, it makes the report more attractive and easier to read.<\/p>\n

One of the best methods of presenting data is through Excel Pivot Tables<\/a> <\/strong>and Slicers<\/strong>.<\/p>\n

A Pivot Table<\/a> can have custom styles<\/strong> applied to them to correspond with the general theme and color of the entire worksheet<\/strong>. You can copy a custom style<\/a> applied to a slicer and paste it to another slicer in another workbook.<\/p>\n

Companies usually follow a certain color pattern<\/strong>, so a custom-made slicer style must be mimicked<\/strong> so that the color palette matches all their worksheets. This custom style can be copied and applied in different workbooks as well.<\/p>\n

Let’s see how this can be achieved.<\/p>\n

Don’t forget to download the Exercise Workbook<\/strong> below and follow along with us!<\/p>\n

download excel workbook<\/strong><\/i><\/span>Copy-a-custom-style-into-a-new-workbook.zip<\/span><\/a><\/p>\n

 <\/p>\n

You can see two workbooks here. The workbook on the left side has the custom style<\/strong> that we want. Let’s say we want this style to be applied to the slicer on the right workbook<\/strong>.<\/p>\n

<\/div>\n

\"Copy<\/p>\n

Creating custom styles takes some work, but once done you can reuse this across multiple workbooks with just a few clicks!<\/p>\n

 <\/p>\n

STEP 1:<\/strong><\/span> On the workbook that has the custom style that you want to copy, right-click on the slicer and select Copy<\/strong><\/p>\n

 <\/p>\n

\"Copy<\/p>\n

STEP 2:<\/strong><\/span> Let us jump over to the second workbook, on any blank space, click\u00a0Home > Clipboard > Paste<\/strong><\/em><\/p>\n

\"Copy<\/p>\n

You can see the slicer with the custom style show up inside the\u00a0Slicer Styles<\/strong><\/p>\n

\"Copy<\/p>\n

STEP 3:<\/strong><\/span> Now pick on the slicer that you want to apply the custom style to. Go to\u00a0Slicer > Slicer Styles > Custom Style<\/strong><\/em><\/p>\n

\"Copy<\/p>\n

STEP 4:<\/strong><\/span> Now we do not need the extra slicer that we copied anymore, select that and press\u00a0Delete<\/strong><\/p>\n

\"Copy<\/p>\n

This is how you can have the custom style of a Pivot Table slicer copied over into another workbook!<\/p>\n

\"Copy<\/p>\n

 <\/p>\n

Click here<\/strong><\/a> to learn more about Pivot Table Slicers!<\/p>\n

 <\/p>\n

Make sure to download our FREE PDF on the\u00a0333 Excel keyboard Shortcuts here<\/a>:<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"

If data is presented aesthetically, it will be easily interpreted by the users. When you present your data in a clean as well as visually pleasing way, it makes the report more attractive and easier to read. One of the best methods of presenting data is through Excel Pivot Tables and Slicers. A Pivot Table […]<\/p>\n","protected":false},"author":2,"featured_media":25089,"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":[4],"tags":[780,781,782],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/24761"}],"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\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=24761"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/24761\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/25089"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=24761"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=24761"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=24761"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}