{"id":102820,"date":"2025-04-30T15:46:13","date_gmt":"2025-04-30T15:46:13","guid":{"rendered":"https:\/\/goodwriterz.com\/site\/?p=102820"},"modified":"2025-04-30T15:46:13","modified_gmt":"2025-04-30T15:46:13","slug":"everything-you-need-to-know-about-excel-tables-and-why-you-should-always-use-them","status":"publish","type":"post","link":"https:\/\/goodwriterz.com\/site\/everything-you-need-to-know-about-excel-tables-and-why-you-should-always-use-them\/","title":{"rendered":"Everything You Need to Know About Excel Tables (And Why You Should Always Use Them)"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_68_1 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >\u062c\u062f\u0648\u0644 \u0627\u0644\u0645\u062d\u062a\u0648\u064a\u0627\u062a<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" 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: #999;color:#999\" 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><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 eztoc-toggle-hide-by-default' ><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/goodwriterz.com\/site\/everything-you-need-to-know-about-excel-tables-and-why-you-should-always-use-them\/#Quick_Links\" title=\"Quick Links\">Quick Links<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/goodwriterz.com\/site\/everything-you-need-to-know-about-excel-tables-and-why-you-should-always-use-them\/#Convert_Data_Into_an_Excel_Table\" title=\"Convert Data Into an Excel Table\">Convert Data Into an Excel Table<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/goodwriterz.com\/site\/everything-you-need-to-know-about-excel-tables-and-why-you-should-always-use-them\/#Change_the_Table_Design\" title=\"Change the Table Design\">Change the Table Design<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/goodwriterz.com\/site\/everything-you-need-to-know-about-excel-tables-and-why-you-should-always-use-them\/#Dont_Freeze_the_Top_Row\" title=\"Don&#8217;t Freeze the Top Row\">Don&#8217;t Freeze the Top Row<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/goodwriterz.com\/site\/everything-you-need-to-know-about-excel-tables-and-why-you-should-always-use-them\/#Use_the_Filter_Buttons\" title=\"Use the Filter Buttons\">Use the Filter Buttons<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/goodwriterz.com\/site\/everything-you-need-to-know-about-excel-tables-and-why-you-should-always-use-them\/#Filter_With_Slicers\" title=\"Filter With Slicers\">Filter With Slicers<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/goodwriterz.com\/site\/everything-you-need-to-know-about-excel-tables-and-why-you-should-always-use-them\/#Add_Columns_and_Rows\" title=\"Add Columns and Rows\">Add Columns and Rows<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/goodwriterz.com\/site\/everything-you-need-to-know-about-excel-tables-and-why-you-should-always-use-them\/#Make_Column-Based_Calculations\" title=\"Make Column-Based Calculations\">Make Column-Based Calculations<\/a><\/li><\/ul><\/nav><\/div>\n<div>\n<div class=\"w-table-content\">\n<h3 class=\"title icon i-flash\"><span class=\"ez-toc-section\" id=\"Quick_Links\"><\/span>Quick Links<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<div class=\"table-content\">\n<div class=\"w-table-content-list\">\n<ul class=\"table-content-list\">\n<li class=\"table-content-element icon\">\n<div class=\"table-content-link\">\n                                        <a rel=\"nofollow noopener\" target=\"_blank\" href=\"#convert-data-into-an-excel-table\">Convert Data Into an Excel Table<\/a>\n                                        <\/div>\n<\/li>\n<\/ul>\n<ul class=\"table-content-list\">\n<li class=\"table-content-element icon\">\n<div class=\"table-content-link\">\n                                        <a rel=\"nofollow noopener\" target=\"_blank\" href=\"#make-column-based-calculations\">Make Column-Based Calculations<\/a>\n                                        <\/div>\n<\/li>\n<\/ul><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<p>When I learned how to use tables in Microsoft Excel, it totally transformed how I work with data. Even if you think you already know everything there is to know about Excel tables, hopefully, you&#8217;ll pick up some additional tips in this guide!<\/p>\n<p>    <!-- Not injecting Ads due to No-Ads mode. --><!-- Not injecting Ads due to No-Ads mode. --><\/p>\n<h2 id=\"convert-data-into-an-excel-table\">\n                        Convert Data Into an Excel Table<br \/>\n               <\/h2>\n<p>Before you convert your Excel data into a table, make sure you have column headers along the top row. This will make dealing with and using the data much more straightforward down the line.<\/p>\n<div class=\"body-img landscape \">\n<div class=\"responsive-img  image-expandable  img-article-item\" :35.200845665962%\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/Everything-You-Need-to-Know-About-Excel-Tables-And-Why.png\" data-modal-id=\"single-image-modal\" data-modal-container-id=\"single-image-modal-container\" data-img-caption=\"&quot;&quot;\">\n<figure>\n        <picture><source media=\"(min-width: 1024px)\" data- \/><source media=\"(min-width: 768px)\" data- \/><source media=\"(min-width: 481px)\" data- \/><source media=\"(min-width: 0px)\" data- \/><img data-recalc-dims=\"1\" width=\"946\" height=\"333\" loading=\"lazy\" decoding=\"async\" alt=\"An Excel spreadsheet containing unformatted data, with the column headers in row 1 highlighted.\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/Everything-You-Need-to-Know-About-Excel-Tables-And-Why.png\" src=\"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/Everything-You-Need-to-Know-About-Excel-Tables-And-Why.png?resize=946%2C333&#038;ssl=1\" style=\"display:block;height:auto;max-width:100%;\" title=\"\">\n    <\/picture>\n<\/figure><\/div>\n<\/p><\/div>\n<p> Then, select all the cells you want to convert, including your column headers. Alternatively, if your range is contiguous (in other words, all the cells are next to each other with no blank columns or rows), simply select one cell in the data. Then, in the Insert tab on the ribbon, click &#8220;Table,&#8221; or use the Microsoft Excel keyboard shortcut, Ctrl+T.<\/p>\n<div class=\"display-card  article article-card small  no-badge  active-content                      \" data-include-community-rating=\"false\" id=\"cd97-4d7d-81c479cdad88\" data-nosnippet=\"\">\n<div class=\"w-img \">\n<div class=\"body-img landscape \">\n<div class=\"responsive-img  img-featured-4-pin-single-size-featured-secondary\" :66.666666666667%\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/Everything-You-Need-to-Know-About-Excel-Tables-And-Why.jpg\" data-modal-id=\"single-image-modal\" data-modal-container-id=\"single-image-modal-container\" data-img-caption=\"&quot;&quot;\">\n<figure>\n        <picture><source media=\"(min-width: 1024px)\" data- \/><source media=\"(min-width: 768px)\" data- \/><source media=\"(min-width: 481px)\" data- \/><source media=\"(min-width: 0px)\" data- \/><img data-recalc-dims=\"1\" width=\"1200\" height=\"800\" loading=\"lazy\" decoding=\"async\" alt=\"Person typing on a keyboard.\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/Everything-You-Need-to-Know-About-Excel-Tables-And-Why.jpg\" src=\"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/Everything-You-Need-to-Know-About-Excel-Tables-And-Why.jpg?resize=1200%2C800&#038;ssl=1\" style=\"display:block;height:auto;max-width:100%;\" title=\"\">\n    <\/picture>\n<\/figure><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<p>                    <span data-field=\"label\" class=\"article-card-label\">Related<\/span><\/p>\n<div class=\"w-display-card-content regular article-block\">\n<h5 class=\"display-card-title \">\n<p>\t\t\tThe Best Excel Keyboard Shortcuts I Use as a Power User<\/p>\n<\/h5>\n<p class=\"display-card-excerpt\">The key to excelling in your spreadsheet work.<\/p>\n<\/p><\/div>\n<\/p><\/div>\n<div class=\"body-img landscape \">\n<div class=\"responsive-img  image-expandable  img-article-item\" :46.666666666667%\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/1746027964_110_Everything-You-Need-to-Know-About-Excel-Tables-And-Why.png\" data-modal-id=\"single-image-modal\" data-modal-container-id=\"single-image-modal-container\" data-img-caption=\"&quot;&quot;\">\n<figure>\n        <picture><source media=\"(min-width: 1024px)\" data- \/><source media=\"(min-width: 768px)\" data- \/><source media=\"(min-width: 481px)\" data- \/><source media=\"(min-width: 0px)\" data- \/><img data-recalc-dims=\"1\" width=\"750\" height=\"350\" loading=\"lazy\" decoding=\"async\" alt=\"A cell in some data in Excel is selected, and the Table button in the Insert tab on the ribbon is highlighted.\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/1746027964_110_Everything-You-Need-to-Know-About-Excel-Tables-And-Why.png\" src=\"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/1746027964_110_Everything-You-Need-to-Know-About-Excel-Tables-And-Why.png?resize=750%2C350&#038;ssl=1\" style=\"display:block;height:auto;max-width:100%;\" title=\"\">\n    <\/picture>\n<\/figure><\/div>\n<\/p><\/div>\n<p> Now, in the Create Table dialog box, double-check that the whole range is selected, make sure &#8220;My Table Has Headers&#8221; is checked, and click &#8220;OK.&#8221;<\/p>\n<div class=\"body-img landscape \">\n<div class=\"responsive-img  image-expandable  img-article-item\" :36.666666666667%\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/1746027964_34_Everything-You-Need-to-Know-About-Excel-Tables-And-Why.png\" data-modal-id=\"single-image-modal\" data-modal-container-id=\"single-image-modal-container\" data-img-caption=\"&quot;&quot;\">\n<figure>\n        <picture><source media=\"(min-width: 1024px)\" data- \/><source media=\"(min-width: 768px)\" data- \/><source media=\"(min-width: 481px)\" data- \/><source media=\"(min-width: 0px)\" data- \/><img data-recalc-dims=\"1\" width=\"750\" height=\"275\" loading=\"lazy\" decoding=\"async\" alt=\"The Create Table dialog box in Excel, with the range field highlighted, the header checkbox checked, and the OK button selected.\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/1746027964_34_Everything-You-Need-to-Know-About-Excel-Tables-And-Why.png\" src=\"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/1746027964_34_Everything-You-Need-to-Know-About-Excel-Tables-And-Why.png?resize=750%2C275&#038;ssl=1\" style=\"display:block;height:auto;max-width:100%;\" title=\"\">\n    <\/picture>\n<\/figure><\/div>\n<\/p><\/div>\n<p> Your data is now a formatted Excel table, with filter buttons added to your column headers.<\/p>\n<div class=\"body-img landscape \">\n<div class=\"responsive-img  image-expandable  img-article-item\" :24.021352313167%\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/1746027964_964_Everything-You-Need-to-Know-About-Excel-Tables-And-Why.png\" data-modal-id=\"single-image-modal\" data-modal-container-id=\"single-image-modal-container\" data-img-caption=\"&quot;&quot;\">\n<figure>\n        <picture><source media=\"(min-width: 1024px)\" data- \/><source media=\"(min-width: 768px)\" data- \/><source media=\"(min-width: 481px)\" data- \/><source media=\"(min-width: 0px)\" data- \/><img data-recalc-dims=\"1\" width=\"1124\" height=\"270\" loading=\"lazy\" decoding=\"async\" alt=\"A formatted table in Microsoft Excel.\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/1746027964_964_Everything-You-Need-to-Know-About-Excel-Tables-And-Why.png\" src=\"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/1746027964_964_Everything-You-Need-to-Know-About-Excel-Tables-And-Why.png?resize=1124%2C270&#038;ssl=1\" style=\"display:block;height:auto;max-width:100%;\" title=\"\">\n    <\/picture>\n<\/figure><\/div>\n<\/p><\/div>\n<h2 id=\"change-the-table-design\">\n                        Change the Table Design<br \/>\n               <\/h2>\n<p>Once your table is created, it&#8217;s time to adjust its layout. When you select any cell in your newly created table, the Table Design tab appears on the ribbon. Open this tab to see the different options.<\/p>\n<div class=\"body-img landscape \">\n<div class=\"responsive-img  image-expandable  img-article-item\" :43.466666666667%\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/1746027964_868_Everything-You-Need-to-Know-About-Excel-Tables-And-Why.png\" data-modal-id=\"single-image-modal\" data-modal-container-id=\"single-image-modal-container\" data-img-caption=\"&quot;&quot;\">\n<figure>\n        <picture><source media=\"(min-width: 1024px)\" data- \/><source media=\"(min-width: 768px)\" data- \/><source media=\"(min-width: 481px)\" data- \/><source media=\"(min-width: 0px)\" data- \/><img data-recalc-dims=\"1\" width=\"750\" height=\"326\" loading=\"lazy\" decoding=\"async\" alt=\"A cell is selected in a formatted Excel table, and the Table Design tab on the ribbon is opened.\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/1746027964_868_Everything-You-Need-to-Know-About-Excel-Tables-And-Why.png\" src=\"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/1746027964_868_Everything-You-Need-to-Know-About-Excel-Tables-And-Why.png?resize=750%2C326&#038;ssl=1\" style=\"display:block;height:auto;max-width:100%;\" title=\"\">\n    <\/picture>\n<\/figure><\/div>\n<\/p><\/div>\n<p> First, click the down arrow in the Table Styles group to choose from the different layout options. In my case, I&#8217;ve gone for the medium plum style.<\/p>\n<div class=\"body-img landscape \">\n<div class=\"responsive-img  image-expandable  img-article-item\" :51.866666666667%\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/1746027965_200_Everything-You-Need-to-Know-About-Excel-Tables-And-Why.png\" data-modal-id=\"single-image-modal\" data-modal-container-id=\"single-image-modal-container\" data-img-caption=\"&quot;&quot;\">\n<figure>\n        <picture><source media=\"(min-width: 1024px)\" data- \/><source media=\"(min-width: 768px)\" data- \/><source media=\"(min-width: 481px)\" data- \/><source media=\"(min-width: 0px)\" data- \/><img data-recalc-dims=\"1\" width=\"750\" height=\"389\" loading=\"lazy\" decoding=\"async\" alt=\"The down arrow in the Table Styles group of the Table Design tab in Excel is selected.\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/1746027965_200_Everything-You-Need-to-Know-About-Excel-Tables-And-Why.png\" src=\"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/1746027965_200_Everything-You-Need-to-Know-About-Excel-Tables-And-Why.png?resize=750%2C389&#038;ssl=1\" style=\"display:block;height:auto;max-width:100%;\" title=\"\">\n    <\/picture>\n<\/figure><\/div>\n<\/p><\/div>\n<p> Next, head to the Table Style Options group in the Table Design tab to see several checkboxes.<\/p>\n<div class=\"body-img landscape \">\n<div class=\"responsive-img  image-expandable  img-article-item\" :38.4%\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/1746027965_87_Everything-You-Need-to-Know-About-Excel-Tables-And-Why.png\" data-modal-id=\"single-image-modal\" data-modal-container-id=\"single-image-modal-container\" data-img-caption=\"&quot;&quot;\">\n<figure>\n        <picture><source media=\"(min-width: 1024px)\" data- \/><source media=\"(min-width: 768px)\" data- \/><source media=\"(min-width: 481px)\" data- \/><source media=\"(min-width: 0px)\" data- \/><img data-recalc-dims=\"1\" width=\"750\" height=\"288\" loading=\"lazy\" decoding=\"async\" alt=\"The Table Style Options group in Excel&#039;s Table Design tab on the ribbon.\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/1746027965_87_Everything-You-Need-to-Know-About-Excel-Tables-And-Why.png\" src=\"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/1746027965_87_Everything-You-Need-to-Know-About-Excel-Tables-And-Why.png?resize=750%2C288&#038;ssl=1\" style=\"display:block;height:auto;max-width:100%;\" title=\"\">\n    <\/picture>\n<\/figure><\/div>\n<\/p><\/div>\n<ul>\n<li>\n                                        <strong>Header Row:<\/strong> If you checked &#8220;My Table Has Headers&#8221; in the Create Table dialog box, leave Header Row checked.\n                        <\/li>\n<li>\n                                        <strong>Total Row:<\/strong> Checking this option adds an extra row to the bottom of your table where you can add column totals (more on this soon).\n                        <\/li>\n<li>\n                                        <strong>Banded Rows: <\/strong>Enable this option to make it easier to read across the table&#8217;s rows. This is especially useful if you have lots of columns.\n                        <\/li>\n<li>\n                                        <strong>First Column:<\/strong> This applies formatting to the left-most column in your table, essentially turning this column into row headers.\n                        <\/li>\n<li>\n                                        <strong>Last Column:<\/strong> This applies formatting to the right-most column in your table, which is handy if it contains overall or summary figures.\n                        <\/li>\n<li>\n                                        <strong>Banded Columns: <\/strong>Check this option to help people follow columns downward. I would advise that you check <em>either<\/em> Banded Rows <em>or<\/em> Banded Columns\u2014checking both could cause confusion and make the table look untidy.\n                        <\/li>\n<li>\n                                        <strong>Filter Button:<\/strong> This option adds filter arrows to the header row.\n                        <\/li>\n<\/ul>\n<p>After checking &#8220;Total Row,&#8221; decide which columns you want to be totaled by selecting the relevant cell in the total row, clicking the down arrow, and selecting one of the aggregation options.<\/p>\n<div class=\"body-img landscape \">\n<div class=\"responsive-img  image-expandable  img-article-item\" :50.266666666667%\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/1746027965_251_Everything-You-Need-to-Know-About-Excel-Tables-And-Why.png\" data-modal-id=\"single-image-modal\" data-modal-container-id=\"single-image-modal-container\" data-img-caption=\"&quot;&quot;\">\n<figure>\n        <picture><source media=\"(min-width: 1024px)\" data- \/><source media=\"(min-width: 768px)\" data- \/><source media=\"(min-width: 481px)\" data- \/><source media=\"(min-width: 0px)\" data- \/><img data-recalc-dims=\"1\" width=\"750\" height=\"377\" loading=\"lazy\" decoding=\"async\" alt=\"The drop-down option in one of the columns in the total row of an Excel table is expanded.\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/1746027965_251_Everything-You-Need-to-Know-About-Excel-Tables-And-Why.png\" src=\"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/1746027965_251_Everything-You-Need-to-Know-About-Excel-Tables-And-Why.png?resize=750%2C377&#038;ssl=1\" style=\"display:block;height:auto;max-width:100%;\" title=\"\">\n    <\/picture>\n<\/figure><\/div>\n<\/p><\/div>\n<section class=\"emaki-custom-block emaki-custom-note\" data-nosnippet=\"\">\n<div class=\"emaki-custom note\" id=\"custom_block_21\">\n<div class=\"custom_block-content note\">\n<p>If you apply a filter to one of the columns, only the values on display in the table will contribute to the totals in the total row.<\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/section>\n<p>The final adjustment you should make in the Table Design tab is to give your table a name. By default, Excel tables are called Table1, Table 2, Table3, and so on. However, changing the table name makes your spreadsheet more navigable, helps people using screen readers, and makes formulas easier to understand if they reference data in the table.<\/p>\n<div class=\"display-card  article article-card small  no-badge  active-content                      \" data-include-community-rating=\"false\" id=\"8c53-4ea3-bb5f9d4e5440\" data-nosnippet=\"\">\n<div class=\"w-img \">\n<div class=\"body-img landscape \">\n<div class=\"responsive-img  img-featured-4-pin-single-size-featured-secondary\" :56.25%\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/1746027965_237_Everything-You-Need-to-Know-About-Excel-Tables-And-Why.png\" data-modal-id=\"single-image-modal\" data-modal-container-id=\"single-image-modal-container\" data-img-caption=\"&quot;&quot;\">\n<figure>\n        <picture><source media=\"(min-width: 1024px)\" data- \/><source media=\"(min-width: 768px)\" data- \/><source media=\"(min-width: 481px)\" data- \/><source media=\"(min-width: 0px)\" data- \/><img data-recalc-dims=\"1\" width=\"1200\" height=\"675\" loading=\"lazy\" decoding=\"async\" alt=\"Three Excel tables with their names above them and the Excel logo at the top.\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/1746027965_237_Everything-You-Need-to-Know-About-Excel-Tables-And-Why.png\" src=\"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/1746027965_237_Everything-You-Need-to-Know-About-Excel-Tables-And-Why.png?resize=1200%2C675&#038;ssl=1\" style=\"display:block;height:auto;max-width:100%;\" title=\"\">\n    <\/picture>\n<\/figure><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<p>                    <span data-field=\"label\" class=\"article-card-label\">Related<\/span><\/p>\n<div class=\"w-display-card-content regular article-block\">\n<h5 class=\"display-card-title \">\n<p>\t\t\tIf You Don\u2019t Rename Tables in Excel, Today\u2019s the Day to Start<\/p>\n<\/h5>\n<p class=\"display-card-excerpt\">What&#8217;s in a name? Well, quite a lot.<\/p>\n<\/p><\/div>\n<\/p><\/div>\n<p>To rename a table, head to the Properties group of the Table Design tab, and replace the default name with something more relevant.<\/p>\n<div class=\"body-img landscape \">\n<div class=\"responsive-img  image-expandable  img-article-item\" :37.866666666667%\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/1746027965_403_Everything-You-Need-to-Know-About-Excel-Tables-And-Why.png\" data-modal-id=\"single-image-modal\" data-modal-container-id=\"single-image-modal-container\" data-img-caption=\"&quot;&quot;\">\n<figure>\n        <picture><source media=\"(min-width: 1024px)\" data- \/><source media=\"(min-width: 768px)\" data- \/><source media=\"(min-width: 481px)\" data- \/><source media=\"(min-width: 0px)\" data- \/><img data-recalc-dims=\"1\" width=\"750\" height=\"284\" loading=\"lazy\" decoding=\"async\" alt=\"A table in Excel renamed to Employee_Data.\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/1746027965_403_Everything-You-Need-to-Know-About-Excel-Tables-And-Why.png\" src=\"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/1746027965_403_Everything-You-Need-to-Know-About-Excel-Tables-And-Why.png?resize=750%2C284&#038;ssl=1\" style=\"display:block;height:auto;max-width:100%;\" title=\"\">\n    <\/picture>\n<\/figure><\/div>\n<\/p><\/div>\n<section class=\"emaki-custom-block emaki-custom-note\" data-nosnippet=\"\">\n<div class=\"emaki-custom note\" id=\"custom_block_26\">\n<div class=\"custom_block-content note\">\n<p>Table names must start with a letter, underscore, or backslash, with the remaining characters being letters, numbers, periods, or underscores. They must also be unique, can&#8217;t contain a space, and mustn&#8217;t have the same name as an existing cell reference, like A1.<\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/section>\n<h2 id=\"don-39-t-freeze-the-top-row\">\n                        Don&#8217;t Freeze the Top Row<br \/>\n               <\/h2>\n<p>When working with large datasets in Excel, you might be used to freezing the top row, so that when you scroll down, the column headers remain visible.<\/p>\n<p>However, one of the many benefits of formatting your data as an Excel table is that you don&#8217;t have to take this step. Instead, providing you checked &#8220;My Table Has Headers&#8221; in the Create Table dialog box and one of the cells in the table is selected, when you scroll down, the letters above your spreadsheet that represent the columns (A, B, C, and so on) automatically turn into your table column headers. This works even if the column headers aren&#8217;t in the first row.<\/p>\n<div class=\"body-img landscape \">\n<div class=\"responsive-img  image-expandable  img-article-item\" :53.6%\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/1746027966_548_Everything-You-Need-to-Know-About-Excel-Tables-And-Why.png\" data-modal-id=\"single-image-modal\" data-modal-container-id=\"single-image-modal-container\" data-img-caption=\"&quot;&quot;\">\n<figure>\n        <picture><source media=\"(min-width: 1024px)\" data- \/><source media=\"(min-width: 768px)\" data- \/><source media=\"(min-width: 481px)\" data- \/><source media=\"(min-width: 0px)\" data- \/><img data-recalc-dims=\"1\" width=\"750\" height=\"402\" loading=\"lazy\" decoding=\"async\" alt=\"The column header letters in an Excel spreadsheet are replaced by the table column headers.\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/1746027966_548_Everything-You-Need-to-Know-About-Excel-Tables-And-Why.png\" src=\"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/1746027966_548_Everything-You-Need-to-Know-About-Excel-Tables-And-Why.png?resize=750%2C402&#038;ssl=1\" style=\"display:block;height:auto;max-width:100%;\" title=\"\">\n    <\/picture>\n<\/figure><\/div>\n<\/p><\/div>\n<p>Notice, also, how these column headers also display the filter buttons, meaning you don&#8217;t have to scroll to the top of your worksheet to change what your table displays.<\/p>\n<h2 id=\"use-the-filter-buttons\">\n                        Use the Filter Buttons<br \/>\n               <\/h2>\n<p>I&#8217;ve already mentioned the filter buttons in Excel tables several times in this guide, and that&#8217;s because they&#8217;re a real time-saver. In short, the filter buttons make it easy to narrow your data to the most relevant information, saving you from having to search through your rows and columns manually.<\/p>\n<p>The filter buttons give you different options depending on the type of data you have in each column. For example, the filter button for column D\u2014which contains text\u2014offers various text filters, like searching for values that begin or end with certain characters.<\/p>\n<div class=\"body-img landscape \">\n<div class=\"responsive-img  image-expandable  img-article-item\" :70.8%\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/1746027966_75_Everything-You-Need-to-Know-About-Excel-Tables-And-Why.png\" data-modal-id=\"single-image-modal\" data-modal-container-id=\"single-image-modal-container\" data-img-caption=\"&quot;&quot;\">\n<figure>\n        <picture><source media=\"(min-width: 1024px)\" data- \/><source media=\"(min-width: 768px)\" data- \/><source media=\"(min-width: 481px)\" data- \/><source media=\"(min-width: 0px)\" data- \/><img data-recalc-dims=\"1\" width=\"750\" height=\"531\" loading=\"lazy\" decoding=\"async\" alt=\"The text filter options in a Microsoft Excel table.\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/1746027966_75_Everything-You-Need-to-Know-About-Excel-Tables-And-Why.png\" src=\"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/1746027966_75_Everything-You-Need-to-Know-About-Excel-Tables-And-Why.png?resize=750%2C531&#038;ssl=1\" style=\"display:block;height:auto;max-width:100%;\" title=\"\">\n    <\/picture>\n<\/figure><\/div>\n<\/p><\/div>\n<p> On the other hand, when I click the filter button in a column containing numbers, the filters change accordingly.<\/p>\n<div class=\"body-img landscape \">\n<div class=\"responsive-img  image-expandable  img-article-item\" :76.8%\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/1746027966_950_Everything-You-Need-to-Know-About-Excel-Tables-And-Why.png\" data-modal-id=\"single-image-modal\" data-modal-container-id=\"single-image-modal-container\" data-img-caption=\"&quot;&quot;\">\n<figure>\n        <picture><source media=\"(min-width: 1024px)\" data- \/><source media=\"(min-width: 768px)\" data- \/><source media=\"(min-width: 481px)\" data- \/><source media=\"(min-width: 0px)\" data- \/><img data-recalc-dims=\"1\" width=\"750\" height=\"576\" loading=\"lazy\" decoding=\"async\" alt=\"The number filter options in a Microsoft Excel table.\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/1746027966_950_Everything-You-Need-to-Know-About-Excel-Tables-And-Why.png\" src=\"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/1746027966_950_Everything-You-Need-to-Know-About-Excel-Tables-And-Why.png?resize=750%2C576&#038;ssl=1\" style=\"display:block;height:auto;max-width:100%;\" title=\"\">\n    <\/picture>\n<\/figure><\/div>\n<\/p><\/div>\n<p> As well as the options to sort a column in ascending or descending order or filter by color, there&#8217;s also a search field in the filter drop-down, which helps you speed up the filtering process even further.<\/p>\n<div class=\"body-img landscape \">\n<div class=\"responsive-img  image-expandable  img-article-item\" :54.933333333333%\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/1746027966_340_Everything-You-Need-to-Know-About-Excel-Tables-And-Why.png\" data-modal-id=\"single-image-modal\" data-modal-container-id=\"single-image-modal-container\" data-img-caption=\"&quot;&quot;\">\n<figure>\n        <picture><source media=\"(min-width: 1024px)\" data- \/><source media=\"(min-width: 768px)\" data- \/><source media=\"(min-width: 481px)\" data- \/><source media=\"(min-width: 0px)\" data- \/><img data-recalc-dims=\"1\" width=\"750\" height=\"412\" loading=\"lazy\" decoding=\"async\" alt=\"The search field in an Excel table&#039;s filter contains the search query 202.\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/1746027966_340_Everything-You-Need-to-Know-About-Excel-Tables-And-Why.png\" src=\"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/1746027966_340_Everything-You-Need-to-Know-About-Excel-Tables-And-Why.png?resize=750%2C412&#038;ssl=1\" style=\"display:block;height:auto;max-width:100%;\" title=\"\">\n    <\/picture>\n<\/figure><\/div>\n<\/p><\/div>\n<p>Click &#8220;OK&#8221; once you have typed your filter search query and checked or unchecked the relevant options to apply the filter.<\/p>\n<p>Another nifty trick is to filter a column based on a selected value. In this example, I only want to display employees in the electronics department. To do this, I can right-click a cell containing the word &#8220;Electronics,&#8221; and in the Filter menu, click &#8220;Filter By Selected Cell&#8217;s Value.&#8221;<\/p>\n<div class=\"body-img landscape \">\n<div class=\"responsive-img  image-expandable  img-article-item\" :83.2%\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/1746027966_971_Everything-You-Need-to-Know-About-Excel-Tables-And-Why.png\" data-modal-id=\"single-image-modal\" data-modal-container-id=\"single-image-modal-container\" data-img-caption=\"&quot;&quot;\">\n<figure>\n        <picture><source media=\"(min-width: 1024px)\" data- \/><source media=\"(min-width: 768px)\" data- \/><source media=\"(min-width: 481px)\" data- \/><source media=\"(min-width: 0px)\" data- \/><img data-recalc-dims=\"1\" width=\"750\" height=\"624\" loading=\"lazy\" decoding=\"async\" alt=\"The Filter By Selected Cell&#039;s Value option is selected in Excel.\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/1746027966_971_Everything-You-Need-to-Know-About-Excel-Tables-And-Why.png\" src=\"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/1746027966_971_Everything-You-Need-to-Know-About-Excel-Tables-And-Why.png?resize=750%2C624&#038;ssl=1\" style=\"display:block;height:auto;max-width:100%;\" title=\"\">\n    <\/picture>\n<\/figure><\/div>\n<\/p><\/div>\n<h2 id=\"filter-with-slicers\">\n                        Filter With Slicers<br \/>\n               <\/h2>\n<p>While the filter buttons are great ways to organize and arrange your data, an even easier way to do this is by adding slicers, especially if a particular column is more likely to be filtered than the others.<\/p>\n<div class=\"display-card  article article-card small  no-badge  active-content                      \" data-include-community-rating=\"false\" id=\"124d-457b-9de85e5995c6\" data-nosnippet=\"\">\n<div class=\"w-img \">\n<div class=\"body-img landscape \">\n<div class=\"responsive-img  img-featured-4-pin-single-size-featured-secondary\" :56.25%\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/1746027967_376_Everything-You-Need-to-Know-About-Excel-Tables-And-Why.jpg\" data-modal-id=\"single-image-modal\" data-modal-container-id=\"single-image-modal-container\" data-img-caption=\"&quot;&quot;\">\n<figure>\n        <picture><source media=\"(min-width: 1024px)\" data- \/><source media=\"(min-width: 768px)\" data- \/><source media=\"(min-width: 481px)\" data- \/><source media=\"(min-width: 0px)\" data- \/><img data-recalc-dims=\"1\" width=\"1200\" height=\"675\" loading=\"lazy\" decoding=\"async\" alt=\"Microsoft Excel logo on a green background\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/1746027967_376_Everything-You-Need-to-Know-About-Excel-Tables-And-Why.jpg\" src=\"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/1746027967_376_Everything-You-Need-to-Know-About-Excel-Tables-And-Why.jpg?resize=1200%2C675&#038;ssl=1\" style=\"display:block;height:auto;max-width:100%;\" title=\"\">\n    <\/picture>\n<\/figure><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<p>                    <span data-field=\"label\" class=\"article-card-label\">Related<\/span><\/p>\n<div class=\"w-display-card-content regular article-block\">\n<h5 class=\"display-card-title \">\n<p>\t\t\tHow to Create Slicers in Microsoft Excel<\/p>\n<\/h5>\n<p class=\"display-card-excerpt\">Slicers are fun-to-use filter tools for your spreadsheets!<\/p>\n<\/p><\/div>\n<\/p><\/div>\n<p>In this example, let&#8217;s say the CEO is most interested in the profit made by employees in different departments and which people are the best candidates for promotion. You can make the CEO&#8217;s life much easier by adding slicers for these three columns.<\/p>\n<p>With any cell in the table selected, click &#8220;Insert Slicer&#8221; in the Table Design tab on the ribbon.<\/p>\n<div class=\"body-img landscape \">\n<div class=\"responsive-img  image-expandable  img-article-item\" :40.266666666667%\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/1746027967_879_Everything-You-Need-to-Know-About-Excel-Tables-And-Why.png\" data-modal-id=\"single-image-modal\" data-modal-container-id=\"single-image-modal-container\" data-img-caption=\"&quot;&quot;\">\n<figure>\n        <picture><source media=\"(min-width: 1024px)\" data- \/><source media=\"(min-width: 768px)\" data- \/><source media=\"(min-width: 481px)\" data- \/><source media=\"(min-width: 0px)\" data- \/><img data-recalc-dims=\"1\" width=\"750\" height=\"302\" loading=\"lazy\" decoding=\"async\" alt=\"The Insert Slicer button in Excel&#039;s Table Design tab is highlighted.\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/1746027967_879_Everything-You-Need-to-Know-About-Excel-Tables-And-Why.png\" src=\"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/1746027967_879_Everything-You-Need-to-Know-About-Excel-Tables-And-Why.png?resize=750%2C302&#038;ssl=1\" style=\"display:block;height:auto;max-width:100%;\" title=\"\">\n    <\/picture>\n<\/figure><\/div>\n<\/p><\/div>\n<p>Next, check the columns for which you want to add slicers, and click &#8220;OK.&#8221;<\/p>\n<div class=\"body-img landscape \">\n<div class=\"responsive-img  image-expandable  img-article-item\" :71.2%\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/1746027967_340_Everything-You-Need-to-Know-About-Excel-Tables-And-Why.png\" data-modal-id=\"single-image-modal\" data-modal-container-id=\"single-image-modal-container\" data-img-caption=\"&quot;&quot;\">\n<figure>\n        <picture><source media=\"(min-width: 1024px)\" data- \/><source media=\"(min-width: 768px)\" data- \/><source media=\"(min-width: 481px)\" data- \/><source media=\"(min-width: 0px)\" data- \/><img data-recalc-dims=\"1\" width=\"750\" height=\"534\" loading=\"lazy\" decoding=\"async\" alt=\"Three column headers are selected in Excel&#039;s Insert Slicers dialog box.\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/1746027967_340_Everything-You-Need-to-Know-About-Excel-Tables-And-Why.png\" src=\"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/1746027967_340_Everything-You-Need-to-Know-About-Excel-Tables-And-Why.png?resize=750%2C534&#038;ssl=1\" style=\"display:block;height:auto;max-width:100%;\" title=\"\">\n    <\/picture>\n<\/figure><\/div>\n<\/p><\/div>\n<p>Now, click and drag the slicers to reposition or resize them, or open the &#8220;Slicer&#8221; tab on the ribbon to see more options. You can also right-click a slicer and click &#8220;Slicer Settings&#8221; to further customize this advanced filtering tool.<\/p>\n<div class=\"body-img landscape \">\n<div class=\"responsive-img  image-expandable  img-article-item\" :84.4%\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/1746027967_941_Everything-You-Need-to-Know-About-Excel-Tables-And-Why.png\" data-modal-id=\"single-image-modal\" data-modal-container-id=\"single-image-modal-container\" data-img-caption=\"&quot;&quot;\">\n<figure>\n        <picture><source media=\"(min-width: 1024px)\" data- \/><source media=\"(min-width: 768px)\" data- \/><source media=\"(min-width: 481px)\" data- \/><source media=\"(min-width: 0px)\" data- \/><img data-recalc-dims=\"1\" width=\"750\" height=\"633\" loading=\"lazy\" decoding=\"async\" alt=\"Slicer Settings is selected in the right-click menu on a slicer in Excel.\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/1746027967_941_Everything-You-Need-to-Know-About-Excel-Tables-And-Why.png\" src=\"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/1746027967_941_Everything-You-Need-to-Know-About-Excel-Tables-And-Why.png?resize=750%2C633&#038;ssl=1\" style=\"display:block;height:auto;max-width:100%;\" title=\"\">\n    <\/picture>\n<\/figure><\/div>\n<\/p><\/div>\n<p> You and your CEO can now use the slicers to quickly filter data in the Excel table. In this example, the slicers are set to display employees in the beauty and clothing departments who have the potential for promotion to a higher role, and because those selections are colored blue, it&#8217;s easy to see how the data is filtered.<\/p>\n<div class=\"body-img landscape \">\n<div class=\"responsive-img  image-expandable  img-article-item\" :39.698046181172%\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/1746027967_555_Everything-You-Need-to-Know-About-Excel-Tables-And-Why.png\" data-modal-id=\"single-image-modal\" data-modal-container-id=\"single-image-modal-container\" data-img-caption=\"&quot;&quot;\">\n<figure>\n        <picture><source media=\"(min-width: 1024px)\" data- \/><source media=\"(min-width: 768px)\" data- \/><source media=\"(min-width: 481px)\" data- \/><source media=\"(min-width: 0px)\" data- \/><img data-recalc-dims=\"1\" width=\"1126\" height=\"447\" loading=\"lazy\" decoding=\"async\" alt=\"An Excel sheet containing a formatted table that is filtered based on conditions set in slicers.\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/1746027967_555_Everything-You-Need-to-Know-About-Excel-Tables-And-Why.png\" src=\"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/1746027967_555_Everything-You-Need-to-Know-About-Excel-Tables-And-Why.png?resize=1126%2C447&#038;ssl=1\" style=\"display:block;height:auto;max-width:100%;\" title=\"\">\n    <\/picture>\n<\/figure><\/div>\n<\/p><\/div>\n<section class=\"emaki-custom-block emaki-custom-tip\" data-nosnippet=\"\">\n<div class=\"emaki-custom tip\" id=\"custom_block_55\">\n<div class=\"custom_block-content tip\">\n<p>Hold Ctrl when selecting elements in a slicer to display them all at the same time, or press Alt+C to clear all selections in the slicer.<\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/section>\n<h2 id=\"add-columns-and-rows\">\n                        Add Columns and Rows<br \/>\n               <\/h2>\n<p>Adding a column to the right or a row to the bottom of a formatted Excel table is satisfyingly simple. In this example, as soon as I typed &#8220;Score&#8221; into cell K1 and pressed Enter, Excel expanded the table&#8217;s dimensions to capture the new column. This means I don&#8217;t need to apply any manual formatting to the new data.<\/p>\n<div class=\"body-img landscape \">\n<div class=\"responsive-img  image-expandable  img-article-item\" :36.533333333333%\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/1746027968_317_Everything-You-Need-to-Know-About-Excel-Tables-And-Why.png\" data-modal-id=\"single-image-modal\" data-modal-container-id=\"single-image-modal-container\" data-img-caption=\"&quot;&quot;\">\n<figure>\n        <picture><source media=\"(min-width: 1024px)\" data- \/><source media=\"(min-width: 768px)\" data- \/><source media=\"(min-width: 481px)\" data- \/><source media=\"(min-width: 0px)\" data- \/><img data-recalc-dims=\"1\" width=\"750\" height=\"274\" loading=\"lazy\" decoding=\"async\" alt=\"A new column labeled Score is added to a formatted Excel table.\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/1746027968_317_Everything-You-Need-to-Know-About-Excel-Tables-And-Why.png\" src=\"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/1746027968_317_Everything-You-Need-to-Know-About-Excel-Tables-And-Why.png?resize=750%2C274&#038;ssl=1\" style=\"display:block;height:auto;max-width:100%;\" title=\"\">\n    <\/picture>\n<\/figure><\/div>\n<\/p><\/div>\n<p> Similarly, when I added another employee ID to cell A32, not only did Excel expand the table downwards, but it also duplicated any formulas I had created in previous rows.<\/p>\n<div class=\"body-img landscape \">\n<div class=\"responsive-img  image-expandable  img-article-item\" :25.333333333333%\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/1746027968_486_Everything-You-Need-to-Know-About-Excel-Tables-And-Why.png\" data-modal-id=\"single-image-modal\" data-modal-container-id=\"single-image-modal-container\" data-img-caption=\"&quot;&quot;\">\n<figure>\n        <picture><source media=\"(min-width: 1024px)\" data- \/><source media=\"(min-width: 768px)\" data- \/><source media=\"(min-width: 481px)\" data- \/><source media=\"(min-width: 0px)\" data- \/><img data-recalc-dims=\"1\" width=\"750\" height=\"190\" loading=\"lazy\" decoding=\"async\" alt=\"A new row is added to the bottom of a formatted Excel table.\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/1746027968_486_Everything-You-Need-to-Know-About-Excel-Tables-And-Why.png\" src=\"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/1746027968_486_Everything-You-Need-to-Know-About-Excel-Tables-And-Why.png?resize=750%2C190&#038;ssl=1\" style=\"display:block;height:auto;max-width:100%;\" title=\"\">\n    <\/picture>\n<\/figure><\/div>\n<\/p><\/div>\n<p> If you prefer to prepare the new columns and rows <em>before<\/em> adding the data, click and drag the table&#8217;s fill handle right or downward. If you use this method, remember to name each new column by adding a header in the first row.<\/p>\n<div class=\"body-img landscape \">\n<div class=\"responsive-img  image-expandable  img-article-item\" :37.866666666667%\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/1746027968_102_Everything-You-Need-to-Know-About-Excel-Tables-And-Why.png\" data-modal-id=\"single-image-modal\" data-modal-container-id=\"single-image-modal-container\" data-img-caption=\"&quot;&quot;\">\n<figure>\n        <picture><source media=\"(min-width: 1024px)\" data- \/><source media=\"(min-width: 768px)\" data- \/><source media=\"(min-width: 481px)\" data- \/><source media=\"(min-width: 0px)\" data- \/><img data-recalc-dims=\"1\" width=\"750\" height=\"284\" loading=\"lazy\" decoding=\"async\" alt=\"The table fill handle in Excel is highlighted, with a right and down arrow indicating the directions to click and drag it to expand the table.\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/1746027968_102_Everything-You-Need-to-Know-About-Excel-Tables-And-Why.png\" src=\"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/1746027968_102_Everything-You-Need-to-Know-About-Excel-Tables-And-Why.png?resize=750%2C284&#038;ssl=1\" style=\"display:block;height:auto;max-width:100%;\" title=\"\">\n    <\/picture>\n<\/figure><\/div>\n<\/p><\/div>\n<p> You can also add a new row or column between existing data by right-clicking the row or column header, and clicking &#8220;Insert,&#8221; safe in the knowledge that the table formatting will be applied automatically to these new data entry points.<\/p>\n<div class=\"body-img landscape \">\n<div class=\"responsive-img  image-expandable  img-article-item\" :44.4%\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/1746027968_110_Everything-You-Need-to-Know-About-Excel-Tables-And-Why.png\" data-modal-id=\"single-image-modal\" data-modal-container-id=\"single-image-modal-container\" data-img-caption=\"&quot;&quot;\">\n<figure>\n        <picture><source media=\"(min-width: 1024px)\" data- \/><source media=\"(min-width: 768px)\" data- \/><source media=\"(min-width: 481px)\" data- \/><source media=\"(min-width: 0px)\" data- \/><img data-recalc-dims=\"1\" width=\"750\" height=\"333\" loading=\"lazy\" decoding=\"async\" alt=\"The Insert button is selected in a column&#039;s right-click menu in Excel.\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/1746027968_110_Everything-You-Need-to-Know-About-Excel-Tables-And-Why.png\" src=\"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/1746027968_110_Everything-You-Need-to-Know-About-Excel-Tables-And-Why.png?resize=750%2C333&#038;ssl=1\" style=\"display:block;height:auto;max-width:100%;\" title=\"\">\n    <\/picture>\n<\/figure><\/div>\n<\/p><\/div>\n<section class=\"emaki-custom-block emaki-custom-note\" data-nosnippet=\"\">\n<div class=\"emaki-custom note\" id=\"custom_block_65\">\n<div class=\"custom_block-content note\">\n<p>Clicking &#8220;Insert&#8221; on a column adds a new column to the left, while clicking &#8220;Insert&#8221; on a row adds a new row above.<\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/section>\n<h2 id=\"make-column-based-calculations\">\n                        Make Column-Based Calculations<br \/>\n               <\/h2>\n<p>Another benefit of formatting your data as an Excel table is that performing calculations between the columns becomes much easier and quicker.<\/p>\n<p>Let&#8217;s assume you have the table in the screenshot below, and your aim is to calculate the profit per unit by dividing the values in the Profit column by the values in the Units Sold column.<\/p>\n<div class=\"body-img landscape \">\n<div class=\"responsive-img  image-expandable  img-article-item\" :38.8%\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/1746027968_431_Everything-You-Need-to-Know-About-Excel-Tables-And-Why.png\" data-modal-id=\"single-image-modal\" data-modal-container-id=\"single-image-modal-container\" data-img-caption=\"&quot;&quot;\">\n<figure>\n        <picture><source media=\"(min-width: 1024px)\" data- \/><source media=\"(min-width: 768px)\" data- \/><source media=\"(min-width: 481px)\" data- \/><source media=\"(min-width: 0px)\" data- \/><img data-recalc-dims=\"1\" width=\"750\" height=\"291\" loading=\"lazy\" decoding=\"async\" alt=\"An Excel table with a blank column, headed Profit Per Unit, highlighted.\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/1746027968_431_Everything-You-Need-to-Know-About-Excel-Tables-And-Why.png\" src=\"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/1746027968_431_Everything-You-Need-to-Know-About-Excel-Tables-And-Why.png?resize=750%2C291&#038;ssl=1\" style=\"display:block;height:auto;max-width:100%;\" title=\"\">\n    <\/picture>\n<\/figure><\/div>\n<\/p><\/div>\n<p> To do this, in cell G2, type <strong>=<\/strong>, select cell F2, type a forward slash (<strong>\/<\/strong>), and select cell E2. As you do this, notice how Excel inserts the column headers\u2014also known as structured references\u2014into your formula, rather than direct cell references, and this is why it&#8217;s important to have named column headers in your table:<\/p>\n<pre>=(@Profit)\/(@(Units sold))<\/pre>\n<div class=\"body-img landscape \">\n<div class=\"responsive-img  image-expandable  img-article-item\" :38.8%\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/1746027968_930_Everything-You-Need-to-Know-About-Excel-Tables-And-Why.png\" data-modal-id=\"single-image-modal\" data-modal-container-id=\"single-image-modal-container\" data-img-caption=\"&quot;&quot;\">\n<figure>\n        <picture><source media=\"(min-width: 1024px)\" data- \/><source media=\"(min-width: 768px)\" data- \/><source media=\"(min-width: 481px)\" data- \/><source media=\"(min-width: 0px)\" data- \/><img data-recalc-dims=\"1\" width=\"750\" height=\"291\" loading=\"lazy\" decoding=\"async\" alt=\"A structured reference in Excel that divides the Profit column by the Units Sold column.\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/1746027968_930_Everything-You-Need-to-Know-About-Excel-Tables-And-Why.png\" src=\"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/1746027968_930_Everything-You-Need-to-Know-About-Excel-Tables-And-Why.png?resize=750%2C291&#038;ssl=1\" style=\"display:block;height:auto;max-width:100%;\" title=\"\">\n    <\/picture>\n<\/figure><\/div>\n<\/p><\/div>\n<div class=\"display-card  article article-card small  no-badge  active-content                      \" data-include-community-rating=\"false\" id=\"e5ab-4256-82d88f12ae31\" data-nosnippet=\"\">\n<div class=\"w-img \">\n<div class=\"body-img landscape \">\n<div class=\"responsive-img  img-featured-4-pin-single-size-featured-secondary\" :66.666666666667%\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/1746027969_20_Everything-You-Need-to-Know-About-Excel-Tables-And-Why.jpg\" data-modal-id=\"single-image-modal\" data-modal-container-id=\"single-image-modal-container\" data-img-caption=\"&quot;&quot;\">\n<figure>\n        <picture><source media=\"(min-width: 1024px)\" data- \/><source media=\"(min-width: 768px)\" data- \/><source media=\"(min-width: 481px)\" data- \/><source media=\"(min-width: 0px)\" data- \/><img data-recalc-dims=\"1\" width=\"1200\" height=\"800\" loading=\"lazy\" decoding=\"async\" alt=\"A laptop with the Microsoft Excel app.\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/1746027969_20_Everything-You-Need-to-Know-About-Excel-Tables-And-Why.jpg\" src=\"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/1746027969_20_Everything-You-Need-to-Know-About-Excel-Tables-And-Why.jpg?resize=1200%2C800&#038;ssl=1\" style=\"display:block;height:auto;max-width:100%;\" title=\"\">\n    <\/picture>\n<\/figure><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<p>                    <span data-field=\"label\" class=\"article-card-label\">Related<\/span><\/p>\n<div class=\"w-display-card-content regular article-block\">\n<h5 class=\"display-card-title \">\n<p>\t\t\tEverything You Need to Know About Structured References in Excel<\/p>\n<\/h5>\n<p class=\"display-card-excerpt\">Use table and column names instead of cell references.<\/p>\n<\/p><\/div>\n<\/p><\/div>\n<section class=\"emaki-custom-block emaki-custom-note\" data-nosnippet=\"\">\n<div class=\"emaki-custom note\" id=\"custom_block_74\">\n<div class=\"custom_block-content note\">\n<p>The square parentheses are Excel&#8217;s way of indicating that it&#8217;s using a structured reference, and the @ symbol (also known as the intersection operator) means that the calculation will be applied respectively to each row within the table.<\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/section>\n<p>When you press Enter, the remaining cells in the Profit Per Unit column adopt the formula.<\/p>\n<div class=\"body-img landscape \">\n<div class=\"responsive-img  image-expandable  img-article-item\" :38.8%\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/1746027969_620_Everything-You-Need-to-Know-About-Excel-Tables-And-Why.png\" data-modal-id=\"single-image-modal\" data-modal-container-id=\"single-image-modal-container\" data-img-caption=\"&quot;&quot;\">\n<figure>\n        <picture><source media=\"(min-width: 1024px)\" data- \/><source media=\"(min-width: 768px)\" data- \/><source media=\"(min-width: 481px)\" data- \/><source media=\"(min-width: 0px)\" data- \/><img data-recalc-dims=\"1\" width=\"750\" height=\"291\" loading=\"lazy\" decoding=\"async\" alt=\"An Excel table with the Profit Per Unit column populated with a structured reference.\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/1746027969_620_Everything-You-Need-to-Know-About-Excel-Tables-And-Why.png\" src=\"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/1746027969_620_Everything-You-Need-to-Know-About-Excel-Tables-And-Why.png?resize=750%2C291&#038;ssl=1\" style=\"display:block;height:auto;max-width:100%;\" title=\"\">\n    <\/picture>\n<\/figure><\/div>\n<\/p><\/div>\n<p> Structured references are easier to create, read, and parse than direct references, and they remain loyal to the relevant columns, even if extra columns are added. What&#8217;s more, because the whole column is referenced in the formula by its header, the calculation will automatically apply to any new rows you add.<\/p>\n<p>Even more impressively, if you rename one of the column headers, the structured reference adapts to accommodate this change. In this example, the Units Sold column has been renamed &#8220;Units,&#8221; and the formula in the Profit Per Unit column reflects this update.<\/p>\n<div class=\"body-img landscape \">\n<div class=\"responsive-img  image-expandable  img-article-item\" :27.866666666667%\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/1746027969_134_Everything-You-Need-to-Know-About-Excel-Tables-And-Why.png\" data-modal-id=\"single-image-modal\" data-modal-container-id=\"single-image-modal-container\" data-img-caption=\"&quot;&quot;\">\n<figure>\n        <picture><source media=\"(min-width: 1024px)\" data- \/><source media=\"(min-width: 768px)\" data- \/><source media=\"(min-width: 481px)\" data- \/><source media=\"(min-width: 0px)\" data- \/><img data-recalc-dims=\"1\" width=\"750\" height=\"209\" loading=\"lazy\" decoding=\"async\" alt=\"A structured reference in Excel that has adapted to a change in column name.\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/1746027969_134_Everything-You-Need-to-Know-About-Excel-Tables-And-Why.png\" src=\"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/1746027969_134_Everything-You-Need-to-Know-About-Excel-Tables-And-Why.png?resize=750%2C209&#038;ssl=1\" style=\"display:block;height:auto;max-width:100%;\" title=\"\">\n    <\/picture>\n<\/figure><\/div>\n<\/p><\/div>\n<p> Structured references work whether you&#8217;re working within or outside the table, meaning you can easily reference the table and its columns from anywhere in the workbook.<\/p>\n<p>Here, I&#8217;ve inserted extra rows above my table, as I want to calculate the total profit here rather than at the bottom to avoid having to scroll down each time. Another benefit of performing this calculation outside the table is that it ignores any filters. This means I could choose to insert a total row at the bottom that calculates only what is displayed <em>and<\/em> a grand total outside the table that calculates all the data.<\/p>\n<div class=\"body-img landscape \">\n<div class=\"responsive-img  image-expandable  img-article-item\" :31.2%\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/1746027969_307_Everything-You-Need-to-Know-About-Excel-Tables-And-Why.png\" data-modal-id=\"single-image-modal\" data-modal-container-id=\"single-image-modal-container\" data-img-caption=\"&quot;&quot;\">\n<figure>\n        <picture><source media=\"(min-width: 1024px)\" data- \/><source media=\"(min-width: 768px)\" data- \/><source media=\"(min-width: 481px)\" data- \/><source media=\"(min-width: 0px)\" data- \/><img data-recalc-dims=\"1\" width=\"750\" height=\"234\" loading=\"lazy\" decoding=\"async\" alt=\"An Excel sheet containing a formatted table starting in row 4, and a grand total cell in cell F2.\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/1746027969_307_Everything-You-Need-to-Know-About-Excel-Tables-And-Why.png\" src=\"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/1746027969_307_Everything-You-Need-to-Know-About-Excel-Tables-And-Why.png?resize=750%2C234&#038;ssl=1\" style=\"display:block;height:auto;max-width:100%;\" title=\"\">\n    <\/picture>\n<\/figure><\/div>\n<\/p><\/div>\n<p> Now, in cell F2, I will type:<\/p>\n<pre>=SUM(<\/pre>\n<p>Then, when I hover my cursor over the Profit column header, it turns to a black down arrow, indicating that it&#8217;s ready to select the whole column.<\/p>\n<div class=\"body-img landscape \">\n<div class=\"responsive-img  image-expandable  img-article-item\" :33.6%\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/1746027969_244_Everything-You-Need-to-Know-About-Excel-Tables-And-Why.png\" data-modal-id=\"single-image-modal\" data-modal-container-id=\"single-image-modal-container\" data-img-caption=\"&quot;&quot;\">\n<figure>\n        <picture><source media=\"(min-width: 1024px)\" data- \/><source media=\"(min-width: 768px)\" data- \/><source media=\"(min-width: 481px)\" data- \/><source media=\"(min-width: 0px)\" data- \/><img data-recalc-dims=\"1\" width=\"750\" height=\"252\" loading=\"lazy\" decoding=\"async\" alt=\"A SUM formula in Excel has been created, and the cursor has turned to a black down arrow when the mouse is hovered over a column name in an Excel table.\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/1746027969_244_Everything-You-Need-to-Know-About-Excel-Tables-And-Why.png\" src=\"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/1746027969_244_Everything-You-Need-to-Know-About-Excel-Tables-And-Why.png?resize=750%2C252&#038;ssl=1\" style=\"display:block;height:auto;max-width:100%;\" title=\"\">\n    <\/picture>\n<\/figure><\/div>\n<\/p><\/div>\n<p> At this point, when I click, Excel will add a structured column reference to the formula. However, this time, because the formula is outside the table, it also references the table name (Employee_Data):<\/p>\n<pre>=SUM(Employee_Data(Profit)<\/pre>\n<p>This is why it&#8217;s crucial you name your table in the Properties group of the Table Design tab on the ribbon. When I close the rounded parentheses and press Enter, the calculation is complete.<\/p>\n<div class=\"body-img landscape \">\n<div class=\"responsive-img  image-expandable  img-article-item\" :30.533333333333%\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/1746027969_324_Everything-You-Need-to-Know-About-Excel-Tables-And-Why.png\" data-modal-id=\"single-image-modal\" data-modal-container-id=\"single-image-modal-container\" data-img-caption=\"&quot;&quot;\">\n<figure>\n        <picture><source media=\"(min-width: 1024px)\" data- \/><source media=\"(min-width: 768px)\" data- \/><source media=\"(min-width: 481px)\" data- \/><source media=\"(min-width: 0px)\" data- \/><img data-recalc-dims=\"1\" width=\"750\" height=\"229\" loading=\"lazy\" decoding=\"async\" alt=\"A structured reference outside an Excel table that references the table name and the column name.\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/1746027969_324_Everything-You-Need-to-Know-About-Excel-Tables-And-Why.png\" src=\"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/1746027969_324_Everything-You-Need-to-Know-About-Excel-Tables-And-Why.png?resize=750%2C229&#038;ssl=1\" style=\"display:block;height:auto;max-width:100%;\" title=\"\">\n    <\/picture>\n<\/figure><\/div>\n<\/p><\/div>\n<p> To avoid using your mouse in this process, after typing <strong>=SUM(<\/strong>, start typing the table name, and press Tab when it appears in the tooltip list.<\/p>\n<div class=\"body-img landscape \">\n<div class=\"responsive-img  image-expandable  img-article-item\" :31.2%\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/1746027970_913_Everything-You-Need-to-Know-About-Excel-Tables-And-Why.png\" data-modal-id=\"single-image-modal\" data-modal-container-id=\"single-image-modal-container\" data-img-caption=\"&quot;&quot;\">\n<figure>\n        <picture><source media=\"(min-width: 1024px)\" data- \/><source media=\"(min-width: 768px)\" data- \/><source media=\"(min-width: 481px)\" data- \/><source media=\"(min-width: 0px)\" data- \/><img data-recalc-dims=\"1\" width=\"750\" height=\"234\" loading=\"lazy\" decoding=\"async\" alt=\"A tooltip in Excel with the name of a table to be added to a formula.\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/1746027970_913_Everything-You-Need-to-Know-About-Excel-Tables-And-Why.png\" src=\"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/1746027970_913_Everything-You-Need-to-Know-About-Excel-Tables-And-Why.png?resize=750%2C234&#038;ssl=1\" style=\"display:block;height:auto;max-width:100%;\" title=\"\">\n    <\/picture>\n<\/figure><\/div>\n<\/p><\/div>\n<p> Then, with the table name added to the formula, add a square bracket to see a list of the columns in the table, use the arrow keys to select the relevant label, and press Tab again to add it to the formula.<\/p>\n<div class=\"body-img landscape \">\n<div class=\"responsive-img  image-expandable  img-article-item\" :31.2%\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/1746027970_237_Everything-You-Need-to-Know-About-Excel-Tables-And-Why.png\" data-modal-id=\"single-image-modal\" data-modal-container-id=\"single-image-modal-container\" data-img-caption=\"&quot;&quot;\">\n<figure>\n        <picture><source media=\"(min-width: 1024px)\" data- \/><source media=\"(min-width: 768px)\" data- \/><source media=\"(min-width: 481px)\" data- \/><source media=\"(min-width: 0px)\" data- \/><img data-recalc-dims=\"1\" width=\"750\" height=\"234\" loading=\"lazy\" decoding=\"async\" alt=\"A tooltip in Excel with the name of a column to be added to the formula.\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/1746027970_237_Everything-You-Need-to-Know-About-Excel-Tables-And-Why.png\" src=\"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/1746027970_237_Everything-You-Need-to-Know-About-Excel-Tables-And-Why.png?resize=750%2C234&#038;ssl=1\" style=\"display:block;height:auto;max-width:100%;\" title=\"\">\n    <\/picture>\n<\/figure><\/div>\n<\/p><\/div>\n<p> Finally, close the square and rounded parentheses, and press Enter.<\/p>\n<hr\/>\n<p>Once you&#8217;ve created your table, you can go one step further and convert it into a PivotTable to adjust how the data is visualized, generate comprehensive data summaries, and perform complex analyses. What&#8217;s more, you can then produce PivotCharts, handy if you&#8217;re looking to create a dashboard containing all your key performance indicators.<\/p>\n<\/p><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Quick Links Convert Data Into an Excel Table Make Column-Based Calculations When I learned how to use tables in Microsoft Excel, it totally transformed how I work with data. Even if you think you already know everything there is to know about Excel tables, hopefully, you&#8217;ll pick up some additional tips in this guide! Convert &#8230; <a title=\"Everything You Need to Know About Excel Tables (And Why You Should Always Use Them)\" class=\"read-more\" href=\"https:\/\/goodwriterz.com\/site\/everything-you-need-to-know-about-excel-tables-and-why-you-should-always-use-them\/\" aria-label=\"Read more about Everything You Need to Know About Excel Tables (And Why You Should Always Use Them)\">\u0625\u0642\u0631\u0623 \u0627\u0644\u0645\u0632\u064a\u062f<\/a><\/p>\n","protected":false},"author":1,"featured_media":102821,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[24],"tags":[39,313,288],"class_list":["post-102820","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-microsoft","tag-microsoft","tag-microsoft-365","tag-microsoft-excel"],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/04\/1746027971_Everything-You-Need-to-Know-About-Excel-Tables-And-Why.jpg?fit=2400%2C1600&ssl=1","jetpack_sharing_enabled":true,"jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/goodwriterz.com\/site\/wp-json\/wp\/v2\/posts\/102820","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/goodwriterz.com\/site\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/goodwriterz.com\/site\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/goodwriterz.com\/site\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/goodwriterz.com\/site\/wp-json\/wp\/v2\/comments?post=102820"}],"version-history":[{"count":0,"href":"https:\/\/goodwriterz.com\/site\/wp-json\/wp\/v2\/posts\/102820\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/goodwriterz.com\/site\/wp-json\/wp\/v2\/media\/102821"}],"wp:attachment":[{"href":"https:\/\/goodwriterz.com\/site\/wp-json\/wp\/v2\/media?parent=102820"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/goodwriterz.com\/site\/wp-json\/wp\/v2\/categories?post=102820"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/goodwriterz.com\/site\/wp-json\/wp\/v2\/tags?post=102820"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}