{"id":330680,"date":"2021-08-26T18:00:25","date_gmt":"2021-08-26T15:00:25","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/how-to-insert-a-total-row-in-a-table-in-microsoft-excel\/"},"modified":"2021-08-26T18:00:25","modified_gmt":"2021-08-26T15:00:25","slug":"how-to-insert-a-total-row-in-a-table-in-microsoft-excel","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/how-to-insert-a-total-row-in-a-table-in-microsoft-excel\/","title":{"rendered":"#How to Insert a Total Row in a Table 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-6a21ee8cf0d88\" 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-6a21ee8cf0d88\" 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-insert-a-total-row-in-a-table-in-microsoft-excel\/#Insert_a_Total_Row_Using_Table_Design\" >Insert a Total Row Using Table Design<\/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-insert-a-total-row-in-a-table-in-microsoft-excel\/#Insert_a_Total_Row_Using_a_Keyboard_Shortcut\" >Insert a Total Row Using a Keyboard Shortcut<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-insert-a-total-row-in-a-table-in-microsoft-excel\/#Insert_a_Total_Row_by_Adding_a_Row_and_Formula\" >Insert a Total Row by Adding a Row and Formula<\/a><\/li><\/ul><\/nav><\/div>\n<p><strong>&#8220;#How to Insert a Total Row in a Table in Microsoft Excel&#8221;<\/strong><\/p>\n<div>\n<img loading=\"lazy\" decoding=\"async\" class=\"type:primaryImage alignnone size-full wp-image-731027\" srcset=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/MS-excel-logo-675.png?width=398&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1 400w, https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/MS-excel-logo-675.png?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1 1200w\" sizes=\"auto, 400w, 1200w\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/MS-excel-logo-675.png?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Microsoft Excel Logo\" width=\"1200\" height=\"675\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Tables in Microsoft Excel provide many benefits for working with your data. And if your table contains figures that you\u2019d like to total at the bottom, this is a simple task. Here are three ways to add a total row to a table in Excel.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Insert_a_Total_Row_Using_Table_Design\"><\/span>Insert a Total Row Using Table Design<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>You can add a total row to the bottom of your table using a simple checkbox.<\/p>\n<p>Select any cell in your table and go to the Table Design tab that displays. In the Table Style Options section of the ribbon, check the box for Total Row.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-743010\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/07\/TableDesignTotalRow-ExcelTable.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"On the Table Design tab, check Total Row\" width=\"650\" height=\"156\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You\u2019ll likely see only one total display, which is currently how the Total Row feature works. But in a few clicks, you can fill in the rest.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-743009\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/07\/TableDesignTotalRowAdded-ExcelTable.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Total row inserted\" width=\"570\" height=\"385\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>The total row at the bottom provides you with a drop-down list of options for each column. Click that arrow and choose \u201cSUM\u201d for one of the columns.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-743008\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/07\/TableDesignTotalRowDropDownSum-ExcelTable.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Select SUM in the drop-down list\" width=\"528\" height=\"500\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<blockquote class=\"admonishment_note\"><p><strong>Note:<\/strong> If you look at the formula bar, you\u2019ll see that the formula added is actually the SUBTOTAL function. This is a Structured Reference formula that\u2019s solely for tables in Excel.<\/p><\/blockquote>\n<p>Then, select the cell and place your cursor on the bottom-right corner to display <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/279148\/how-to-automatically-fill-sequential-data-into-excel-with-the-fill-handle\/\">the fill handle (plus sign). Drag to the remaining cells in that total row to copy the formula.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-743012 size-full\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/07\/FillHandleCopyTotalRowSum-ExcelTable.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Drag the fill handle to copy the formula\" width=\"570\" height=\"190\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Automatically Fill Sequential Data into Excel with the Fill Handle<\/em><\/strong><\/p>\n<p>If you prefer, you can also click the drop-down arrow in each cell and select \u201cSUM\u201d rather than copying the formula.<\/p>\n<p>You should then see the totals for all columns in your Excel table.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-743007\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/07\/TableDesignTotalRowComplete-ExcelTable.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Total row inserted in Excel table\" width=\"570\" height=\"380\" 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=\"Insert_a_Total_Row_Using_a_Keyboard_Shortcut\"><\/span>Insert a Total Row Using a Keyboard Shortcut<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>If you\u2019re a fan of using <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/361582\/all-the-best-microsoft-excel-keyboard-shortcuts\/\">keyboard shortcuts to perform tasks quickly, then this method is for you.<\/p>\n<p>Select any cell in your table and press Ctrl+Shift+T. And there you go! A total row is added to the bottom of your table.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-743009\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/07\/TableDesignTotalRowAdded-ExcelTable.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Total row inserted\" width=\"570\" height=\"385\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Luckily, this keyboard shortcut works the same way as the Total Row checkbox on the Table Design tab above, so you can follow the same steps to insert the remaining totals and copy the formula to the other cells in the total row.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>All the Best Microsoft Excel Keyboard Shortcuts<\/em><\/strong><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Insert_a_Total_Row_by_Adding_a_Row_and_Formula\"><\/span>Insert a Total Row by Adding a Row and Formula<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>One more way to easily insert a total row in your table is by adding a row, using the SUM formula, and copying it across.<\/p>\n<p>You can quickly <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/741208\/how-to-add-or-delete-columns-and-rows-in-a-table-in-microsoft-excel\/\">add a row to the bottom of your table\u00a0by going to the last cell in the first column and typing. For instance, you can type in the word Totals and hit Enter, which automatically creates a new table row.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-743015\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/07\/AddRowTotals-ExcelTable.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Add row for totals in Excel table\" width=\"643\" height=\"209\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Next, select the cell to the right to insert your first total. Go to the Home tab and click \u201cSum\u201d in the Editing section of the ribbon.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-743014\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/07\/AddRowTotalsClickSum-ExcelTable.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"On the Home tab, click Sum\" width=\"650\" height=\"312\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Now that you have the total for the first column, you can copy that formula to the other cells.<\/p>\n<p>Select the cell with the SUM formula, place your cursor on the bottom-right corner to display the fill handle, and then drag to the remaining cells in that total row.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-743013\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/07\/AddRowTotalsComplete-ExcelTable.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Drag the fill handle to copy the formula and view your total row\" width=\"647\" height=\"211\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>That\u2019s all there is to it!\u00a0From there, you can format the total row to make it stand out if you like.<\/p>\n<p>Totaling figures in a spreadsheet is a basic function, so having three simple ways to add a total row lets you use the method that\u2019s most comfortable for you.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Create Expense and Income Spreadsheets in Microsoft Excel<\/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\/742995\/how-to-insert-a-total-row-in-a-table-in-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;#How to Insert a Total Row in a Table in Microsoft Excel&#8221; Tables in Microsoft Excel provide many benefits for working with your data. And if your table contains figures that you\u2019d like to total at the bottom, this is a simple task. Here are three ways to add a total row to a table&#8230;<\/p>\n","protected":false},"author":1,"featured_media":330681,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/MS-excel-logo-675.png?height=200p&trim=2,2,2,2","fifu_image_alt":"","footnotes":""},"categories":[18],"tags":[],"class_list":["post-330680","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\/330680","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=330680"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/330680\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/330681"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=330680"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=330680"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=330680"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}