{"id":370117,"date":"2021-11-20T19:00:19","date_gmt":"2021-11-20T16:00:19","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/how-to-move-cells-in-microsoft-excel\/"},"modified":"2021-11-20T19:00:19","modified_gmt":"2021-11-20T16:00:19","slug":"how-to-move-cells-in-microsoft-excel","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/how-to-move-cells-in-microsoft-excel\/","title":{"rendered":"#How to Move Cells in Microsoft Excel"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_90 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-6b00bdb0868ae\" 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-6b00bdb0868ae\" 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-move-cells-in-microsoft-excel\/#About_Moving_Cells_in_Excel\" >About Moving Cells 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-move-cells-in-microsoft-excel\/#Move_Cells_in_Excel_Using_Drag_and_Drop\" >Move Cells in Excel Using Drag and Drop<\/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-move-cells-in-microsoft-excel\/#Move_Cells_in_Excel_Using_Cut_and_Paste\" >Move Cells in Excel Using Cut and Paste<\/a><\/li><\/ul><\/nav><\/div>\n<p><strong>&#8220;#How to Move Cells in Microsoft Excel&#8221;<\/strong><\/p>\n<div>\n<img loading=\"lazy\" decoding=\"async\" class=\"type:primaryImage alignnone size-full wp-image-757715\" srcset=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/microsoft_excel_hero_1200x675.jpg?width=398&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1 400w, https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/microsoft_excel_hero_1200x675.jpg?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\/09\/microsoft_excel_hero_1200x675.jpg?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Microsoft Excel logo on a green background\" width=\"1200\" height=\"675\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Need to rearrange data in your spreadsheet? You can move cells in Microsoft Excel to different spots in the same sheet or to another spreadsheet or workbook. Use one of these methods to take your cell contents wherever you like.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"About_Moving_Cells_in_Excel\"><\/span>About Moving Cells in Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>When you move a cell or cell range in Excel, you are moving all of the cell\u2019s contents as-is. So whether the cell contains a word, value, formula, or function, it will be moved.<\/p>\n<p>In addition, if you have comments attached to a cell or special formatting, those items will move with the cells.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Move_Cells_in_Excel_Using_Drag_and_Drop\"><\/span>Move Cells in Excel Using Drag and Drop<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>If you want to move a cell or group of cells to another location in your spreadsheet, drag and drop is the simplest method.<\/p>\n<p>Select the cell and place your cursor over an edge of the cell. You\u2019ll see a four-sided arrow <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>ear.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-760963\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/10\/MoveArrowCell-ExcelMoveCells.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Select a cell and click the arrow\" width=\"341\" height=\"79\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Then just click and drag the cell where you want it in your sheet. As you drag, you\u2019ll notice a green outline of the cell and the new cell reference (location) display. Simply release when the cell lands in its new spot.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-760962\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/10\/MoveCell-ExcelMoveCells.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Drag a cell to its new spot\" width=\"550\" height=\"94\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You can use the same drag-and-drop action to move a group of cells or even a table. Select the cell range you want to move and place your cursor on the edge of the group to display the four-sided arrow.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-760965\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/10\/MoveArrowRange-ExcelMoveCells.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Select the cells and click the arrow\" width=\"650\" height=\"322\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Click the arrow and like with a single cell, you\u2019ll see an outline of the group as you drag along with the new cell range. Release when the cells are in their new locations.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-760964\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/10\/MoveCellRange-ExcelMoveCells.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Drag the cells to their new spots\" width=\"650\" height=\"166\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>If you\u2019re using Excel on Mac, you\u2019ll see a small hand instead of a four-sided arrow when dragging a cell or cell range. But the rest of the drag and drop method works the same as it does on Windows.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-760966\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/10\/MoveHandCell-ExcelMoveCells.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Select a cell and click the hand on Mac\" width=\"220\" height=\"74\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>When you move a cell or cell range and it overlaps with cells already containing data, you\u2019ll receive an alert message.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-760968\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/10\/MoveOverlappingRange-ExcelMoveCells.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Moving overlapping cells\" width=\"650\" height=\"167\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>The message explains that the destination cells already contain data and asks if you want to replace that data with the cells you\u2019re moving. Click \u201cOK\u201d to replace the data or \u201cCancel\u201d to stop the move.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-760967\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/10\/MoveOverlappingRangeMessage-ExcelMoveCells.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Moving overlapping cells alert\" width=\"398\" height=\"145\" 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=\"Move_Cells_in_Excel_Using_Cut_and_Paste\"><\/span>Move Cells in Excel Using Cut and Paste<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>If you want to move a cell or group of cells to a different spreadsheet or workbook, you can use the cut and paste method.<\/p>\n<p>Select the cell or cell range and then either right-click and pick \u201cCut\u201d or go to the Home tab and click \u201cCut\u201d in the Clipboard section of the ribbon.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-760970\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/10\/Cut-ExcelMoveCells.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Right-click and pick Cut\" width=\"650\" height=\"359\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Go to a cell in the new sheet or book where you want to paste the cell(s) you just Cut. Either right-click and pick \u201cPaste\u201d or go to the Home tab and click \u201cPaste\u201d in the Clipboard section of the ribbon.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-760969\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/10\/Paste-ExcelMoveCells.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Right-click and pick Paste\" width=\"534\" height=\"461\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>For a quick way to cut and paste cells, you can also use keyboard shortcuts. On Windows, press Ctrl+X to Cut and Ctrl+V to Paste. On Mac, use Command+X to Cut and Command+V to Paste.<\/p>\n<p>Rearranging data in your Excel sheets doesn\u2019t have to be time-consuming and both of these methods allow you to move cells easily. You can also move rows and columns just as easily. And if it\u2019s entire sheets you need to move, learn how to move a sheet to another workbook in Excel.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>All the Best Microsoft Excel Keyboard Shortcuts<\/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\/760960\/how-to-move-cells-in-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;#How to Move Cells in Microsoft Excel&#8221; Need to rearrange data in your spreadsheet? You can move cells in Microsoft Excel to different spots in the same sheet or to another spreadsheet or workbook. Use one of these methods to take your cell contents wherever you like. About Moving Cells in Excel When you move&#8230;<\/p>\n","protected":false},"author":1,"featured_media":370118,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/microsoft_excel_hero_1200x675.jpg?height=200p&trim=2,2,2,2","fifu_image_alt":"","footnotes":""},"categories":[18],"tags":[],"class_list":["post-370117","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\/370117","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=370117"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/370117\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/370118"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=370117"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=370117"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=370117"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}