{"id":999,"date":"2017-06-29T18:45:18","date_gmt":"2017-06-29T18:45:18","guid":{"rendered":"https:\/\/courses.lumenlearning.com\/wm-compapp\/?post_type=chapter&#038;p=999"},"modified":"2024-05-16T19:08:02","modified_gmt":"2024-05-16T19:08:02","slug":"styles-within-excel","status":"publish","type":"chapter","link":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/chapter\/styles-within-excel\/","title":{"raw":"Table Styles","rendered":"Table Styles"},"content":{"raw":"<div class=\"textbox learning-objectives\">\r\n<h3>Learning Outcomes<\/h3>\r\n<ul>\r\n \t<li>Apply table styles.<\/li>\r\n<\/ul>\r\n<\/div>\r\nOne very common task in Excel is to format a table with a particular style. The controls for table styles are found in the Styles group of the ribbon under the Home tab.<a href=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/06\/29184533\/styleswithin2.png\"><img class=\"aligncenter wp-image-1003\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/06\/29184533\/styleswithin2.png\" alt=\"A blank Microsoft Excel sheet is open. There is a large green arrow pointing toward where the different style options are.\" width=\"800\" height=\"601\" \/><\/a>\r\n\r\nThere are many default table styles within Excel, as shown in the screenshot below. Among other uses, styles let you apply color schemes to tables that can make them more readable. In order to apply a particular table style:\r\n<ol>\r\n \t<li>Select all the cells that belong in your table.<\/li>\r\n \t<li>Click on the \u201cFormat as Table\u201d button.<\/li>\r\n \t<li>Choose which table style to apply.<\/li>\r\n<\/ol>\r\n[caption id=\"attachment_1005\" align=\"aligncenter\" width=\"800\"]<a href=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/06\/29184642\/styleswithin3.png\"><img class=\"wp-image-1005\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/06\/29184642\/styleswithin3.png\" alt=\"A Microsoft Excel sheet is open with text in cells A1 through C3. There are three boxes each a different color matched with a number. The first box is green and shows how you can select all the cells that belong in your table that you are creating. The second is a pink box demonstrating where the format as a table button is. The third is from a dropdown menu from the format as a table button and shows which table style to apply.\" width=\"800\" height=\"574\" \/><\/a> Select all the cells that belong in your table. Click on the \u201cFormat as Table\u201d button. Choose which table style to apply.[\/caption]\r\n\r\nIn the screenshot example, each column is a particular type of information (Last name, First Name, Address). These are known as headers. When applying the table style, be sure to check the box if your table has headers that you have already entered.\r\n<div class=\"textbox tryit\">\r\n<h3>Practice Question<\/h3>\r\nhttps:\/\/assess.lumenlearning.com\/practice\/64cb4ec2-5f1e-4696-a1fc-cf925552726b\r\n\r\n<\/div>\r\n<a href=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/06\/29184812\/styleswithin4.png\"><img class=\"aligncenter wp-image-1007\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/06\/29184812\/styleswithin4.png\" alt=\"A Microsoft Excel sheet is open with text in cells A1 through C3. The format as a table dialog box has been opened. There is a green arrow pointing to the option on the dialog box to ensure that the table that is being create has headers.\" width=\"800\" height=\"596\" \/><\/a>\r\n<div class=\"textbox tryit\">\r\n<h3>Practice Question<\/h3>\r\nhttps:\/\/assess.lumenlearning.com\/practice\/e0652eca-6a23-4071-b58f-823de3eed184\r\n\r\n<\/div>\r\nYour final table would look something like the table below using the options shown in the screenshots.\r\n\r\n<a href=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/06\/29184856\/styleswithin5.png\"><img class=\"aligncenter wp-image-1008\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/06\/29184856\/styleswithin5.png\" alt=\"A Microsoft Excel sheet is open with text in cells A1 through C3. Row 1 from A through C has become the header for a table.\" width=\"800\" height=\"599\" \/><\/a>","rendered":"<div class=\"textbox learning-objectives\">\n<h3>Learning Outcomes<\/h3>\n<ul>\n<li>Apply table styles.<\/li>\n<\/ul>\n<\/div>\n<p>One very common task in Excel is to format a table with a particular style. The controls for table styles are found in the Styles group of the ribbon under the Home tab.<a href=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/06\/29184533\/styleswithin2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1003\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/06\/29184533\/styleswithin2.png\" alt=\"A blank Microsoft Excel sheet is open. There is a large green arrow pointing toward where the different style options are.\" width=\"800\" height=\"601\" \/><\/a><\/p>\n<p>There are many default table styles within Excel, as shown in the screenshot below. Among other uses, styles let you apply color schemes to tables that can make them more readable. In order to apply a particular table style:<\/p>\n<ol>\n<li>Select all the cells that belong in your table.<\/li>\n<li>Click on the \u201cFormat as Table\u201d button.<\/li>\n<li>Choose which table style to apply.<\/li>\n<\/ol>\n<div id=\"attachment_1005\" style=\"width: 810px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/06\/29184642\/styleswithin3.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-1005\" class=\"wp-image-1005\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/06\/29184642\/styleswithin3.png\" alt=\"A Microsoft Excel sheet is open with text in cells A1 through C3. There are three boxes each a different color matched with a number. The first box is green and shows how you can select all the cells that belong in your table that you are creating. The second is a pink box demonstrating where the format as a table button is. The third is from a dropdown menu from the format as a table button and shows which table style to apply.\" width=\"800\" height=\"574\" \/><\/a><\/p>\n<p id=\"caption-attachment-1005\" class=\"wp-caption-text\">Select all the cells that belong in your table. Click on the \u201cFormat as Table\u201d button. Choose which table style to apply.<\/p>\n<\/div>\n<p>In the screenshot example, each column is a particular type of information (Last name, First Name, Address). These are known as headers. When applying the table style, be sure to check the box if your table has headers that you have already entered.<\/p>\n<div class=\"textbox tryit\">\n<h3>Practice Question<\/h3>\n<p>\t<iframe id=\"assessment_practice_64cb4ec2-5f1e-4696-a1fc-cf925552726b\" class=\"resizable\" src=\"https:\/\/assess.lumenlearning.com\/practice\/64cb4ec2-5f1e-4696-a1fc-cf925552726b?iframe_resize_id=assessment_practice_id_64cb4ec2-5f1e-4696-a1fc-cf925552726b\" frameborder=\"0\" style=\"border:none;width:100%;height:100%;min-height:300px;\"><br \/>\n\t<\/iframe><\/p>\n<\/div>\n<p><a href=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/06\/29184812\/styleswithin4.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1007\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/06\/29184812\/styleswithin4.png\" alt=\"A Microsoft Excel sheet is open with text in cells A1 through C3. The format as a table dialog box has been opened. There is a green arrow pointing to the option on the dialog box to ensure that the table that is being create has headers.\" width=\"800\" height=\"596\" \/><\/a><\/p>\n<div class=\"textbox tryit\">\n<h3>Practice Question<\/h3>\n<p>\t<iframe id=\"assessment_practice_e0652eca-6a23-4071-b58f-823de3eed184\" class=\"resizable\" src=\"https:\/\/assess.lumenlearning.com\/practice\/e0652eca-6a23-4071-b58f-823de3eed184?iframe_resize_id=assessment_practice_id_e0652eca-6a23-4071-b58f-823de3eed184\" frameborder=\"0\" style=\"border:none;width:100%;height:100%;min-height:300px;\"><br \/>\n\t<\/iframe><\/p>\n<\/div>\n<p>Your final table would look something like the table below using the options shown in the screenshots.<\/p>\n<p><a href=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/06\/29184856\/styleswithin5.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1008\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/06\/29184856\/styleswithin5.png\" alt=\"A Microsoft Excel sheet is open with text in cells A1 through C3. Row 1 from A through C has become the header for a table.\" width=\"800\" height=\"599\" \/><\/a><\/p>\n\n\t\t\t <section class=\"citations-section\" role=\"contentinfo\">\n\t\t\t <h3>Candela Citations<\/h3>\n\t\t\t\t\t <div>\n\t\t\t\t\t\t <div id=\"citation-list-999\">\n\t\t\t\t\t\t\t <div class=\"licensing\"><div class=\"license-attribution-dropdown-subheading\">CC licensed content, Original<\/div><ul class=\"citation-list\"><li>Styles within Excel. <strong>Authored by<\/strong>: Shelli Carter. <strong>Provided by<\/strong>: Lumen Learning. <strong>License<\/strong>: <em><a target=\"_blank\" rel=\"license\" href=\"https:\/\/creativecommons.org\/licenses\/by\/4.0\/\">CC BY: Attribution<\/a><\/em><\/li><\/ul><\/div>\n\t\t\t\t\t\t <\/div>\n\t\t\t\t\t <\/div>\n\t\t\t <\/section>","protected":false},"author":20,"menu_order":6,"template":"","meta":{"_candela_citation":"[{\"type\":\"original\",\"description\":\"Styles within Excel\",\"author\":\"Shelli Carter\",\"organization\":\"Lumen Learning\",\"url\":\"\",\"project\":\"\",\"license\":\"cc-by\",\"license_terms\":\"\"}]","CANDELA_OUTCOMES_GUID":"8189fb51-8af6-4f40-9be4-7acba86b12bc, cec5962a-5f95-49aa-a1ee-31f5d63e6d04","pb_show_title":"on","pb_short_title":"","pb_subtitle":"","pb_authors":[],"pb_section_license":""},"chapter-type":[],"contributor":[],"license":[],"class_list":["post-999","chapter","type-chapter","status-publish","hentry"],"part":975,"_links":{"self":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/chapters\/999","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/chapters"}],"about":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/wp\/v2\/types\/chapter"}],"author":[{"embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/wp\/v2\/users\/20"}],"version-history":[{"count":19,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/chapters\/999\/revisions"}],"predecessor-version":[{"id":5809,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/chapters\/999\/revisions\/5809"}],"part":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/parts\/975"}],"metadata":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/chapters\/999\/metadata\/"}],"wp:attachment":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/wp\/v2\/media?parent=999"}],"wp:term":[{"taxonomy":"chapter-type","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/chapter-type?post=999"},{"taxonomy":"contributor","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/wp\/v2\/contributor?post=999"},{"taxonomy":"license","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/wp\/v2\/license?post=999"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}