{"id":336815,"date":"2021-09-08T18:00:04","date_gmt":"2021-09-08T15:00:04","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/how-to-use-and-create-cell-styles-in-microsoft-excel\/"},"modified":"2021-09-08T18:00:04","modified_gmt":"2021-09-08T15:00:04","slug":"how-to-use-and-create-cell-styles-in-microsoft-excel","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/how-to-use-and-create-cell-styles-in-microsoft-excel\/","title":{"rendered":"#How to Use and Create Cell Styles in Microsoft Excel"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_84 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-6a28c897afdbc\" 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-6a28c897afdbc\" 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-use-and-create-cell-styles-in-microsoft-excel\/#Apply_a_Premade_Cell_Style_in_Excel\" >Apply a Premade Cell Style 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-use-and-create-cell-styles-in-microsoft-excel\/#Create_a_Custom_Cell_Style_in_Excel\" >Create a Custom Cell Style in Excel<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-use-and-create-cell-styles-in-microsoft-excel\/#Edit_a_Cell_Style\" >Edit a Cell Style<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-use-and-create-cell-styles-in-microsoft-excel\/#Remove_a_Cell_Style\" >Remove a Cell Style<\/a><\/li><\/ul><\/nav><\/div>\n<p><strong>&#8220;#How to Use and Create Cell Styles in Microsoft Excel&#8221;<\/strong><\/p>\n<div>\n<img loading=\"lazy\" decoding=\"async\" class=\"type:primaryImage alignnone wp-image-747210 size-full\" srcset=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/08\/UseCreateExcelCellStyles.png?width=398&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1 400w, https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/08\/UseCreateExcelCellStyles.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\/08\/UseCreateExcelCellStyles.png?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Cell Styles in Microsoft Excel\" width=\"1200\" height=\"675\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>There are many ways to format your Excel spreadsheets. From automatic conditional formatting to simple copying from another cell, we take shortcuts to format our sheets quickly. Another wonderful feature for formatting in Microsoft Excel is a Cell Style.<\/p>\n<p>Cell styles in Excel combine multiple formats. For instance, you might have a yellow fill color, a bold font, a number format, and a cell border all in a single style. This allows you to quickly <a href=\"https:\/\/buradabiliyorum.com\/en\/category\/download-scripts-themes-apps\/\" data-internallinksmanager029f6b8e52c=\"9\" title=\"Download Scripts &amp; Themes &amp; Apps\" target=\"_blank\" rel=\"noopener\">app<\/a>ly multiple formats to the cells while adding consistency to the appearance of your sheet.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Apply_a_Premade_Cell_Style_in_Excel\"><\/span>Apply a Premade Cell Style in Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Excel does a good job of offering many premade cell styles that you can use. These cover everything from titles and headings to colors and accents to currency and number formats.<\/p>\n<p>To view and apply a cell style, start by selecting a cell or range of cells. Go to the Home tab and click \u201cCell Styles\u201d in the Styles section of the ribbon. Click any style to apply it to your cell(s).<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-747212\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/08\/HomeCellStylesPremade-ExcelCellStyles.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"On the Home tab, click Cell Styles and pick one\" width=\"650\" height=\"321\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Create_a_Custom_Cell_Style_in_Excel\"><\/span><a rel=\"nofollow noopener\" target=\"_blank\" name=\"autotoc_anchor_1\">Create a Custom Cell Style in Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>While there are plenty of built-in cell styles to pick from, you might prefer to create your own. This lets you choose the exact formats that you want to use, and then reuse that cell style with ease.<\/p>\n<p>Head to the Home tab, click \u201cCell Styles,\u201d and choose \u201cNew Cell Style.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-747213\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/08\/HomeCellStylesNew-ExcelCellStyles.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click Cell Styles and pick New Cell Style\" width=\"623\" height=\"500\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Give your custom style a name at the top of the Style box. Then, click \u201cFormat.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-747214\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/08\/CreateNewStyle-ExcelCellStyles.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Name the style and click Format\" width=\"388\" height=\"451\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>In the Format Cells window, use the various tabs to select the styles for number, font, border, and fill as you want them to apply. As an example, we\u2019ll create My Custom Style and <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/240316\/how-to-change-the-currency-symbol-for-certain-cells-in-excel\/\">use a currency number format, bold and italic font, an outline border, and a gray, dotted fill pattern.<\/p>\n<p>After choosing the formats that you want, click \u201cOK,\u201d which returns you to the Style window.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-747215 size-full\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/08\/FormatNewStyle-ExcelCellStyles.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Choose the formats for the style\" width=\"640\" height=\"500\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>In the Style Includes section, you\u2019ll see the formats that you just picked. Uncheck any formats that you don\u2019t want to use and click \u201cOK\u201d when you finish.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-747216\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/08\/MyCustomStyle-ExcelCellStyles.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Uncheck any cell style items\" width=\"388\" height=\"451\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>To use your custom cell style, select the cells, go to the Home tab, and click \u201cCell Styles.\u201d You should see your newly created style at the top of the selection box under Custom. Click to apply it to your cells.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-747218\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/08\/HomeCellStylesMyCustomStyle-ExcelCellStyles.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click Cell Styles and pick your custom style\" width=\"650\" height=\"252\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<blockquote class=\"admonishment_note\"><p><strong>Note:<\/strong> A cell style that you create is available in all your spreadsheets, but only in the Excel workbook where you create it.<\/p><\/blockquote>\n<h3><span class=\"ez-toc-section\" id=\"Edit_a_Cell_Style\"><\/span>Edit a Cell Style<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>If you want to make changes to a custom cell style that you created or even to a premade style, head back to the Home tab. Click \u201cCell Styles,\u201d right-click the style that you want to edit, and pick \u201cModify.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-747219\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/08\/ModifyCustomStyle-ExcelCellStyles.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Right-click and pick Modify\" width=\"650\" height=\"302\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>When the Style window opens, click \u201cFormat\u201d to make your adjustments in the Format Cells window, and then click \u201cOK.\u201d Make any further changes in the Style window, such as inputting a new name if you\u2019re modifying a premade style, and then click \u201cOK\u201d there as well.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-747227\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/08\/EditedCustomStyle-ExcelCellStyles.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Edited custom cell style in Excel\" width=\"388\" height=\"451\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You can also delete a custom style that you created by choosing \u201cDelete\u201d instead of \u201cModify\u201d in the shortcut menu.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-747220\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/08\/DeleteCustomStyle-ExcelCellStyles.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Right-click and pick Delete\" width=\"650\" height=\"302\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Remove_a_Cell_Style\"><\/span><a rel=\"nofollow noopener\" target=\"_blank\" name=\"autotoc_anchor_3\">Remove a Cell Style<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>If you decide later on to remove a cell style that you applied, it only takes a few clicks to do so.<\/p>\n<p>Select the cell(s) and go back to the Home tab. Click \u201cCell Styles\u201d and choose \u201cNormal\u201d near the top under Good, Bad, and Neutral.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-747221\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/08\/HomeCellStylesNormal-ExcelCellStyles.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click Cell Styles and pick Normal\" width=\"650\" height=\"251\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Make your spreadsheet\u2019s appearance attractive and consistent with premade or custom cell styles in Microsoft Excel!<\/p>\n<p><strong>RELATED:<\/strong> <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/426633\/how-to-cross-reference-cells-between-microsoft-excel-spreadsheets\/\"><strong><em>How to Cross Reference Cells Between Microsoft Excel Spreadsheets<\/em><\/strong><\/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\/747207\/how-to-use-and-create-cell-styles-in-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;#How to Use and Create Cell Styles in Microsoft Excel&#8221; There are many ways to format your Excel spreadsheets. From automatic conditional formatting to simple copying from another cell, we take shortcuts to format our sheets quickly. Another wonderful feature for formatting in Microsoft Excel is a Cell Style. Cell styles in Excel combine multiple&#8230;<\/p>\n","protected":false},"author":1,"featured_media":336816,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/08\/UseCreateExcelCellStyles.png?height=200p&trim=2,2,2,2","fifu_image_alt":"","footnotes":""},"categories":[18],"tags":[],"class_list":["post-336815","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\/336815","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=336815"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/336815\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/336816"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=336815"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=336815"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=336815"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}