{"id":336,"date":"2014-09-25T17:55:26","date_gmt":"2014-09-25T15:55:26","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=336"},"modified":"2023-11-30T01:33:33","modified_gmt":"2023-11-30T00:33:33","slug":"excel-table-styles","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/excel-table-styles\/","title":{"rendered":"Excel Table: Styles"},"content":{"rendered":"<p>There are lots of different <em>Table Styles<\/em> that you can choose from to spice up your Excel Table.\u00a0 You can also customize your own style if you don&#8217;t like any of the default Excel styles.<\/p>\n<p>To access the <em>Table Styles<\/em>, you simply need to click inside your Table and then the <em>Table Tools<\/em> Ribbon tab will activate.<br \/>\n<iframe src=\"https:\/\/www.youtube.com\/embed\/kVzeO0IeKTM?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><br \/>\n<span style=\"color: #0000ff;\"><a class=\"IRPP_minimalist icon-download\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Table-Styles.xlsx\" target=\"_blank\"><span class=\"ctaText px-3 text-capitalize\"><span style=\"color: #0000ff;\">download workbook<\/span><\/span><span class=\"postTitle px-3\">Table-Styles.xlsx<\/span><\/a><\/span><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1:<\/strong><\/span> While selecting a cell in the table, go to\u00a0<em><strong>Table Tools &gt; Design &gt; Table Styles<\/strong><\/em><\/p>\n<p>Pick any style that you prefer<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Excel Table: Styles\"  class=\"alignnone size-full wp-image-19830\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Excel-Table-Styles-01.jpg\" alt=\"Excel Table: Styles\" width=\"1330\" height=\"640\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Excel-Table-Styles-01.jpg 1330w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Excel-Table-Styles-01-300x144.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Excel-Table-Styles-01-1024x493.jpg 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Excel-Table-Styles-01-768x370.jpg 768w\" sizes=\"(max-width: 1330px) 100vw, 1330px\" \/><\/p>\n<p>You now have your updated table.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Excel Table: Styles\"  class=\"alignnone size-full wp-image-19836\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Excel-Table-Styles-02.jpg\" alt=\"Excel Table: Styles\" width=\"677\" height=\"318\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Excel-Table-Styles-02.jpg 677w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Excel-Table-Styles-02-300x141.jpg 300w\" sizes=\"(max-width: 677px) 100vw, 677px\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2:<\/strong><\/span> You can also create your own style! Go to\u00a0<em><strong>Table Tools &gt; Design &gt; Table Styles &gt; New Table Style<\/strong><\/em><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Excel Table: Styles\"  class=\"alignnone size-full wp-image-19831\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Excel-Table-Styles-03.jpg\" alt=\"Excel Table: Styles\" width=\"523\" height=\"503\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Excel-Table-Styles-03.jpg 523w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Excel-Table-Styles-03-300x289.jpg 300w\" sizes=\"(max-width: 523px) 100vw, 523px\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 3:<\/strong><\/span> You can give the new table style a name. Click\u00a0<strong>Format<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Excel Table: Styles\"  class=\"alignnone size-full wp-image-19832\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Excel-Table-Styles-04.jpg\" alt=\"Excel Table: Styles\" width=\"586\" height=\"382\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Excel-Table-Styles-04.jpg 586w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Excel-Table-Styles-04-300x196.jpg 300w\" sizes=\"(max-width: 586px) 100vw, 586px\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 4:<\/strong><\/span> Let us select <strong>Fill<\/strong> and pick a color. Click OK twice.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Excel Table: Styles\"  class=\"alignnone size-full wp-image-19833\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Excel-Table-Styles-05.jpg\" alt=\"Excel Table: Styles\" width=\"532\" height=\"518\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Excel-Table-Styles-05.jpg 532w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Excel-Table-Styles-05-300x292.jpg 300w\" sizes=\"(max-width: 532px) 100vw, 532px\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 5:<\/strong><\/span> Go to\u00a0<em><strong>Table Tools &gt; Design &gt; Table Styles<\/strong><\/em><\/p>\n<p>Pick your newly created style<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Excel Table: Styles\"  class=\"alignnone size-full wp-image-19834\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Excel-Table-Styles-06.jpg\" alt=\"Excel Table: Styles\" width=\"504\" height=\"559\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Excel-Table-Styles-06.jpg 504w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Excel-Table-Styles-06-270x300.jpg 270w\" sizes=\"(max-width: 504px) 100vw, 504px\" \/><\/p>\n<p>It is now reflected in your Excel Table!<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Excel Table: Styles\"  class=\"alignnone size-full wp-image-19835\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Excel-Table-Styles-07.jpg\" alt=\"Excel Table: Styles\" width=\"716\" height=\"440\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Excel-Table-Styles-07.jpg 716w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Excel-Table-Styles-07-300x184.jpg 300w\" sizes=\"(max-width: 716px) 100vw, 716px\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>There are lots of different Table Styles that you can choose from to spice up your Excel Table.\u00a0 You can also customize your own style if you don&#8217;t like any of the default Excel styles. To access the Table Styles, you simply need to click inside your Table and then the Table Tools Ribbon tab [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":17518,"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":[6,36],"tags":[88,97],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/336"}],"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=336"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/336\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/17518"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=336"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=336"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=336"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}