{"id":328364,"date":"2021-08-20T18:00:42","date_gmt":"2021-08-20T15:00:42","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/how-to-add-or-delete-columns-and-rows-in-a-table-in-microsoft-excel\/"},"modified":"2021-08-20T18:00:42","modified_gmt":"2021-08-20T15:00:42","slug":"how-to-add-or-delete-columns-and-rows-in-a-table-in-microsoft-excel","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/how-to-add-or-delete-columns-and-rows-in-a-table-in-microsoft-excel\/","title":{"rendered":"#How to Add or Delete Columns and Rows 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-6a2c691237276\" 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-6a2c691237276\" 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-add-or-delete-columns-and-rows-in-a-table-in-microsoft-excel\/#Use_the_Resize_Table_Feature_in_Excel\" >Use the Resize Table Feature in Excel<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-add-or-delete-columns-and-rows-in-a-table-in-microsoft-excel\/#Add_Columns_or_Rows_to_an_Excel_Table\" >Add Columns or Rows to an Excel Table<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-add-or-delete-columns-and-rows-in-a-table-in-microsoft-excel\/#Type_Data_in_the_Next_Column_or_Row\" >Type Data in the Next Column or Row<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-add-or-delete-columns-and-rows-in-a-table-in-microsoft-excel\/#Paste_Data_in_the_Next_Column_or_Row\" >Paste Data in the Next Column or Row<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-add-or-delete-columns-and-rows-in-a-table-in-microsoft-excel\/#Use_the_Insert_Feature\" >Use the Insert Feature<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-add-or-delete-columns-and-rows-in-a-table-in-microsoft-excel\/#Delete_Columns_or_Rows_in_an_Excel_Table\" >Delete Columns or Rows in an Excel Table<\/a><\/li><\/ul><\/nav><\/div>\n<p><strong>&#8220;#How to Add or Delete Columns and Rows 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>When you create a table in Microsoft Excel, you might need to adjust its size later. If you need to add or remove columns or rows in a table after you create it, you have several ways to do both.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Use_the_Resize_Table_Feature_in_Excel\"><\/span>Use the Resize Table Feature in Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>If you want to work with both tables and columns, whether adding or deleting them, the handiest way is with the Resize Table feature.<\/p>\n<p>Select any cell within the table. Go to the Table Design tab that <a href=\"https:\/\/buradabiliyorum.com\/en\/category\/download-scripts-themes-apps\/\" data-internallinksmanager029f6b8e52c=\"9\" title=\"Download Scripts &amp; Themes &amp; Apps\" target=\"_blank\" rel=\"noopener\">app<\/a>ears and click \u201cResize Table\u201d on the left side of the ribbon.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-741216\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/07\/TableDesignResizeTable-ExcelTable.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"On the Table Design tab, click Resize Table\" width=\"650\" height=\"106\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>In the pop-up window, you can use the cell range text box to adjust the cell references. If you prefer, you can drag through the columns and rows while the window is open. Click \u201cOK\u201d when you have the table sized as you want it.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-741217\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/07\/ResizeTable-ExcelTable.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Resize your table\" width=\"650\" height=\"249\" 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=\"Add_Columns_or_Rows_to_an_Excel_Table\"><\/span>Add Columns or Rows to an Excel Table<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>If you simply want to add more columns or rows, there are a few ways to do it. You can use whichever method is most convenient or comfortable for you.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Type_Data_in_the_Next_Column_or_Row\"><\/span>Type Data in the Next Column or Row<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>To add another column, type your data in the cell to the right of the last column. To add another row, type data in the cell below the last row. Hit Enter or Return.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-741219\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/07\/TypeAddColumnTable-ExcelTable.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Type data to add a column or row\" width=\"650\" height=\"327\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>This automatically adds a column or row that\u2019s included in the table.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Paste_Data_in_the_Next_Column_or_Row\"><\/span>Paste Data in the Next Column or Row<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Like typing into the cell, you can also paste data. So if you have data from another location on your clipboard, head to the cell to the right of the last column or below the last row and paste it. You can use \u201cPaste\u201d on the Home tab or right-click and select \u201cPaste.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-741218\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/07\/PasteAddColumnTable-ExcelTable.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Paste data to add a column or row\" width=\"650\" height=\"439\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>This also adds the number of columns or rows of data, which are then part of the table.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Use_the_Insert_Feature\"><\/span>Use the Insert Feature<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Whether you like to right-click or use the buttons in the ribbon, there\u2019s an Insert option that makes adding columns or rows easy. And like many other tasks, there are a few different ways to use Insert.<\/p>\n<ul>\n<li>Select a column or row, right-click, and pick \u201cInsert.\u201d This inserts a column to the left or in the row above.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-741222\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/07\/RightClickInsertColumnTable-ExcelTable.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Right-click and pick Insert\" width=\"650\" height=\"431\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<ul>\n<li>Select a column or row, go to the Home tab, and click \u201cInsert\u201d in the Cells section of the ribbon. You can also click the arrow next to the Insert button and choose \u201cInsert Sheet Columns\u201d or \u201cInsert Sheet Rows.\u201d Both options insert a column to the left or in the row above.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-741221\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/07\/InsertSheetColumnsTable-ExcelTable.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click Insert on the Home tab\" width=\"650\" height=\"188\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<ul>\n<li>Select any cell in the table, right-click, and move to \u201cInsert.\u201d Select \u201cTable Columns to the Left\u201d or \u201cTable Rows Above\u201d in the pop-out menu to add one or the other.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-741220\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/07\/InsertTableColumnsRows-ExcelTable.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Right-click, pick Insert and choose column or row\" width=\"650\" height=\"375\" 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=\"Delete_Columns_or_Rows_in_an_Excel_Table\"><\/span>Delete Columns or Rows in an Excel Table<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Like adding columns or rows to a table in Microsoft Excel, deleting them is just as simple. And as you\u2019ve probably already guessed, there\u2019s more than one way to do it! Here, you\u2019ll simply use the Delete feature.<\/p>\n<p>As you might have noticed when using the Insert feature above, there\u2019s also a Delete option nearby. So, use one of these actions to delete a column or row.<\/p>\n<ul>\n<li>Select a column or row, right-click, and pick \u201cDelete.\u201d<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-741226\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/07\/RightClickDeleteColumnTable-ExcelTable.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Right-click and pick Delete\" width=\"650\" height=\"425\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<ul>\n<li>Select a column or row, go to the Home tab, and click \u201cDelete\u201d in the Cells section of the ribbon. Alternatively, you can click the arrow next to the Delete button and choose \u201cDelete Sheet Columns\u201d or \u201cDelete Sheet Rows.\u201d<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-741225\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/07\/DeleteSheetColumnsTable-ExcelTable.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click Delete on the Home tab\" width=\"650\" height=\"203\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<ul>\n<li>Select a cell in the column or row that you want to remove. Right-click, move to \u201cDelete,\u201d and select \u201cTable Columns\u201d or \u201cTable Rows\u201d in the pop-out menu to remove one or the other.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-741224\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/07\/DeleteTableColumnsRows-ExcelTable.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Right-click, pick Delete and choose column or row\" width=\"650\" height=\"408\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>If you\u2019re interested in getting help with columns and rows in Excel outside of tables, take a look at how to freeze and unfreeze\u00a0columns and rows or how to convert a row to a column.<\/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\/741208\/how-to-add-or-delete-columns-and-rows-in-a-table-in-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;#How to Add or Delete Columns and Rows in a Table in Microsoft Excel&#8221; When you create a table in Microsoft Excel, you might need to adjust its size later. If you need to add or remove columns or rows in a table after you create it, you have several ways to do both. Use&#8230;<\/p>\n","protected":false},"author":1,"featured_media":328365,"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-328364","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\/328364","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=328364"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/328364\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/328365"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=328364"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=328364"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=328364"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}