{"id":361309,"date":"2021-11-01T18:00:00","date_gmt":"2021-11-01T15:00:00","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/how-to-share-cell-styles-across-microsoft-excel-workbooks\/"},"modified":"2021-11-01T18:00:00","modified_gmt":"2021-11-01T15:00:00","slug":"how-to-share-cell-styles-across-microsoft-excel-workbooks","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/how-to-share-cell-styles-across-microsoft-excel-workbooks\/","title":{"rendered":"#How to Share Cell Styles Across Microsoft Excel Workbooks"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_85 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-6a431e37263ea\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #dd3333;color:#dd3333\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #dd3333;color:#dd3333\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-6a431e37263ea\" checked aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-share-cell-styles-across-microsoft-excel-workbooks\/#Merge_Cell_Styles_in_Excel\" >Merge Cell Styles in Excel<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-share-cell-styles-across-microsoft-excel-workbooks\/#Modify_or_Delete_Cell_Styles\" >Modify or Delete Cell Styles<\/a><\/li><\/ul><\/nav><\/div>\n<p><strong>&#8220;#How to Share Cell Styles Across Microsoft Excel Workbooks&#8221;<\/strong><\/p>\n<div>\n<img loading=\"lazy\" decoding=\"async\" class=\"type:primaryImage alignnone size-full wp-image-731027\" srcset=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/MS-excel-logo-675.png?width=398&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1 400w, https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/MS-excel-logo-675.png?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1 1200w\" sizes=\"auto, 400w, 1200w\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/MS-excel-logo-675.png?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Microsoft Excel Logo\" width=\"1200\" height=\"675\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>When you create cell styles in Microsoft Excel, those styles are available in all sheets for your current workbook. But there is a way to share those styles you spend time creating and editing with other Excel workbooks.<\/p>\n<p>if you create a style for a custom border or number format that you want to reuse, you can merge styles and use them over and over. And if you make modifications to one of the premade cell styles, you can share those changes across workbooks as well. Both can save you time from recreating or remodifying those same styles.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Merge_Cell_Styles_in_Excel\"><\/span>Merge Cell Styles in Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Launch Excel and open the workbook that contains the styles you want to share with other workbooks. We\u2019ll call this workbook Share 1. Then, open the workbook that you want to copy the styles to, which we\u2019ll call Share 2.<\/p>\n<p>With both workbooks open at the same time, select the workbook you want to share the styles with. Here, that\u2019s Share 2.<\/p>\n<p>Go to the Home tab and click the Cell Styles drop-down arrow. Pick \u201cMerge Styles.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-754684\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/HomeMergeStyles-ExcelShareCellStyles.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Select Merge Styles\" width=\"557\" height=\"500\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>In the small pop-up window, select the workbook containing the cell styles you want to copy. Here, that\u2019s Share 1. Click \u201cOK.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-754683\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/MergeStylesFrom-ExcelShareCellStyles.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Select the workbook to merge styles from\" width=\"424\" height=\"234\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>If you\u2019ve made changes to premade cell styles in the first workbook, you\u2019ll be asked if you want to merge styles that have the same name. Click \u201cYes\u201d to merge those as well or \u201cNo\u201d to only merge custom styles you\u2019ve created.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-754682\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/MergeStylesSameName-ExcelShareCellStyles.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Pick Yes or No to merge same named styles\" width=\"349\" height=\"145\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Now, you should see all merged styles in your second workbook, Share 2. Click \u201cCell Styles\u201d on the Home tab to view them all.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-754680\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/MergedStyles-ExcelShareCellStyles.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Merged cell styles in Excel\" width=\"550\" height=\"500\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You can continue to merge cells with each new workbook you open the same way.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Modify_or_Delete_Cell_Styles\"><\/span>Modify or Delete Cell Styles<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>If you\u2019ve only worked with new cell styles so far, remember that you can modify or delete existing cell styles in any workbook.<\/p>\n<p>Click \u201cCell Styles\u201d on the Home tab. Then, right-click the style and choose \u201cModify\u201d to make changes to it or \u201cDelete\u201d to remove it.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-754681\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/ModifyDeleteStyles-ExcelShareCellStyles.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Pick Modify or Delete for a style\" width=\"536\" height=\"252\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Using cell styles in Excel, you can format a cell or cell range quickly. So if you spend time creating a custom style or editing an existing one, why not merge them with other workbooks to keep making good use of them?<\/p>\n<\/div>\n<p><script>\n setTimeout(function(){\n  !function(f,b,e,v,n,t,s)\n  {if(f.fbq)return;n=f.fbq=function(){n.callMethod?\n  n.callMethod.apply(n,arguments):n.queue.push(arguments)};\n  if(!f._fbq)f._fbq=n;n.push=n;n.loaded=!0;n.version='2.0';\n  n.queue=[];t=b.createElement(e);t.async=!0;\n  t.src=v;s=b.getElementsByTagName(e)[0];\n  s.parentNode.insertBefore(t,s) } (window, document,'script',\n  'https:\/\/connect.facebook.net\/en_US\/fbevents.js');\n   fbq('init', '335401813750447');\n   fbq('track', 'PageView');\n  },3000);\n<\/script><\/p>\n<blockquote><p><strong><span style=\"color: #ff6600;\">If you liked the article, do not forget to share it with your friends. Follow us on\u00a0<span style=\"color: #ff0000;\"><a style=\"color: #ff0000;\" href=\"https:\/\/news.google.com\/publications\/CAAqBwgKMLG0nwswvr63Aw\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">Google News<\/a><\/span>\u00a0too, click on the star and choose us from your favorites.<\/span><\/strong><\/p><\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\">For forums sites go to <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/forum.buradabiliyorum.com\/\" target=\"_blank\" rel=\"noopener\">Forum.BuradaBiliyorum.Com<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\"><strong>If you want to read more like this article, you can visit our <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/en.buradabiliyorum.com\/technology\/\" target=\"_blank\" rel=\"noopener\">Technology category.<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<p><span style=\"color: black;\"><a style=\"color: #ff9900;\" href=\"https:\/\/www.howtogeek.com\/754677\/how-to-share-cell-styles-across-microsoft-excel-workbooks\/\" target=\"_blank\" rel=\"noopener\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;#How to Share Cell Styles Across Microsoft Excel Workbooks&#8221; When you create cell styles in Microsoft Excel, those styles are available in all sheets for your current workbook. But there is a way to share those styles you spend time creating and editing with other Excel workbooks. if you create a style for a custom&#8230;<\/p>\n","protected":false},"author":1,"featured_media":361310,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/MS-excel-logo-675.png?height=200p&trim=2,2,2,2","fifu_image_alt":"","footnotes":""},"categories":[18],"tags":[],"class_list":["post-361309","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology"],"_links":{"self":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/361309","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/comments?post=361309"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/361309\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/361310"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=361309"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=361309"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=361309"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}