{"id":2011,"date":"2022-08-07T09:45:51","date_gmt":"2022-08-07T06:45:51","guid":{"rendered":"https:\/\/www.addictivetips.com\/?p=178892https:\/\/www.addictivetips.com\/microsoft-office\/how-to-swap-values-between-cells-rows-or-columns-in-ms-excel\/"},"modified":"2022-08-07T09:45:51","modified_gmt":"2022-08-07T06:45:51","slug":"how-to-swap-values-between-cells-rows-or-columns-in-ms-excel","status":"publish","type":"post","link":"https:\/\/tojikon.net\/en\/2011-how-to-swap-values-between-cells-rows-or-columns-in-ms-excel\/","title":{"rendered":"How To Swap Values Between Cells, Rows, Or Columns In MS Excel"},"content":{"rendered":"<p>When selecting text in MS Word, you might have accidentally clicked at the wrong time, or released the mouse button when you didn\u2019t intend to and ended up rearranging text. Swapping text, when done accidentally is annoying but a swap function is nevertheless very useful and if you think about an application like MS Excel, a swap function is a must have. With MS Excel, you have cells filled with data that you may need to swap\u00a0between cells, or even between rows and columns. Fortunately MS Excel has a swap function that lets you swap date in cells easily. Here\u2019s how it works.<\/p>\n<p>Open the Excel file you want to swap cells, column, or rows in.<\/p>\n<p>Select the cell, row, or column you want to swap the contents of, and hold down the Shift key. Next, click at the rightmost border of the cell, and drag it outwards. Do not release the Shift key.<\/p>\n<p>You can see in the image below that as you drag the cursor out, it changes to a different shape depending on where the cursor is position.<\/p>\n<p><span class=\"post-image\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-178895\" src=\"https:\/\/files2.tojikon.net\/files-cloud\/wp-content\/uploads\/2021\/05\/how-to-swap-values-between-cells-rows-or-columns-in-ms-excel.gif\" alt=\"swap-cells-excel\" width=\"658\" height=\"250\"\/><\/span><\/p>\n<p>When the cursor becomes a thick horizontal \u2018I\u2019 shape at the bottom of the adjacent cell, it will\u00a0swap the value of the cell with\u00a0the cell below that line. Likewise, if you move it to the top of the adjacent cell and it turns into a thick horizontal \u2018I\u2019 shape at the top, the value\u00a0of the cell will be swapped with\u00a0the cell above the adjacent one.<\/p>\n<p>If, however, you drag it to the right of the adjacent cell and the cursor transforms into a thick \u2018I\u2019, contents of the selected cell will be swapped out with those in the adjacent cell as shown in the image above.<\/p>\n<p>To swap values between rows and columns, select an entire row or column, and then hold down Shift before dragging your cursor out to the row or column you want to swap its values with.<\/p>\n<p>Release the Shift key and the mouse button once you\u2019ve got the cursor positioned over where you want to swap the contents of the cell\/row\/column to.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>When selecting text in MS Word, you might have accidentally clicked at the wrong time, or released the mouse button when you didn\u2019t intend to and ended up rearranging text. Swapping text, when done accidentally is annoying but a swap function is nevertheless very useful and if you think about an application like MS Excel, &hellip;<\/p>\n","protected":false},"author":1,"featured_media":2012,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[23],"tags":[36],"_links":{"self":[{"href":"https:\/\/tojikon.net\/en\/wp-json\/wp\/v2\/posts\/2011"}],"collection":[{"href":"https:\/\/tojikon.net\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tojikon.net\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tojikon.net\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tojikon.net\/en\/wp-json\/wp\/v2\/comments?post=2011"}],"version-history":[{"count":0,"href":"https:\/\/tojikon.net\/en\/wp-json\/wp\/v2\/posts\/2011\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/tojikon.net\/en\/wp-json\/wp\/v2\/media\/2012"}],"wp:attachment":[{"href":"https:\/\/tojikon.net\/en\/wp-json\/wp\/v2\/media?parent=2011"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tojikon.net\/en\/wp-json\/wp\/v2\/categories?post=2011"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tojikon.net\/en\/wp-json\/wp\/v2\/tags?post=2011"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}