{"id":2284,"date":"2024-12-02T07:22:01","date_gmt":"2024-12-02T07:22:01","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/huong-dan-doi-vi-tri-cot-trong-excel-qua-2-cach-don-gian\/"},"modified":"2024-12-02T07:22:01","modified_gmt":"2024-12-02T07:22:01","slug":"huong-dan-doi-vi-tri-cot-trong-excel-qua-2-cach-don-gian","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/huong-dan-doi-vi-tri-cot-trong-excel-qua-2-cach-don-gian\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn \u0111\u1ed5i v\u1ecb tr\u00ed c\u1ed9t trong excel qua 2 c\u00e1ch \u0111\u01a1n gi\u1ea3n"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Trong b\u00e0i vi\u1ebft n\u00e0y, H\u1ecdc Excel Online s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n 2 c\u00e1ch \u0111\u01a1n gi\u1ea3n \u0111\u1ec3 <strong><a href=\"http:\/\/blog.ezworkapp.com\/cach-hoan-doi-vi-tri-cac-cot-trong-excel.html\">\u0111\u1ed5i v\u1ecb tr\u00ed c\u1ed9t trong Excel<\/a> .<\/strong>C\u1ee5 th\u1ec3 ra sao, h\u00e3y theo d\u00f5i n\u1ed9i dung b\u00ean d\u01b0\u1edbi:<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-674d601835d39\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/doi-vi-tri-cot-trong-excel-2-cach.html#Doi_vi_tri_cot_bang_cach_keo_tha\" title=\"\u0110\u1ed5i v\u1ecb tr\u00ed c\u1ed9t b\u1eb1ng c\u00e1ch k\u00e9o th\u1ea3\">\u0110\u1ed5i v\u1ecb tr\u00ed c\u1ed9t b\u1eb1ng c\u00e1ch k\u00e9o th\u1ea3<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/doi-vi-tri-cot-trong-excel-2-cach.html#Doi_vi_tri_cot_bang_thao_tac_Cut_Insert\" title=\"\u0110\u1ed5i v\u1ecb tr\u00ed c\u1ed9t b\u1eb1ng thao t\u00e1c Cut &amp; Insert\">\u0110\u1ed5i v\u1ecb tr\u00ed c\u1ed9t b\u1eb1ng thao t\u00e1c Cut &amp; Insert<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Doi_vi_tri_cot_bang_cach_keo_tha\"><\/span>\u0110\u1ed5i v\u1ecb tr\u00ed c\u1ed9t b\u1eb1ng c\u00e1ch k\u00e9o th\u1ea3<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Trong Excel, vi\u1ec7c k\u00e9o th\u1ea3 c\u1ed9t c\u00f3 th\u1ec3 ph\u1ee9c t\u1ea1p h\u01a1n t\u01b0\u1edfng t\u01b0\u1ee3ng m\u1ed9t ch\u00fat \u0111\u00f3.<\/p>\n<p>V\u00ed d\u1ee5 \u1edf \u0111\u00e2y, H\u1ecdc Excel Online c\u00f3 m\u1ed9t trang t\u00ednh v\u1edbi th\u00f4ng tin c\u01a1 b\u1ea3n v\u1ec1 sinh vi\u00ean v\u00e0 mu\u1ed1n thay \u0111\u1ed5i v\u1ecb tr\u00ed m\u1ed9t s\u1ed1 c\u1ed9t v\u1edbi nhau. C\u1ee5 th\u1ec3 l\u00e0 c\u1ed9t <strong>ID<\/strong> s\u1ebd \u0111\u01b0\u1ee3c \u0111\u1ea9y l\u00ean tr\u01b0\u1edbc c\u1ed9t\u00a0<strong>Gi\u1edbi t\u00ednh.<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23194\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/doi-vi-tri-1.png\" width=\"380\" height=\"460\" title=\"doi-vi-tri-1\"><\/p>\n<p>Ta s\u1ebd l\u00e0m nh\u01b0 sau:<\/p>\n<p>1.Ch\u1ecdn to\u00e0n b\u1ed9 c\u1ed9t B b\u1eb1ng c\u00e1ch \u1ea5n v\u00e0o ti\u00eau \u0111\u1ec1 c\u1ed9t.<\/p>\n<p>2.\u0110\u01b0a con tr\u1ecf chu\u1ed9t t\u1edbi r\u00eca v\u00f9ng ch\u1ecdn cho t\u1edbi khi n\u00f3 chuy\u1ec3n t\u1eeb h\u00ecnh ch\u1eef th\u1eadp tr\u1eafng sang m\u0169i t\u00ean 4 c\u1ea1nh.<\/p>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-175.gif\" title=\"ex101_92019-nho-175\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23195\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/doi-vi-tri-2.png\" width=\"444\" height=\"319\" title=\"doi-vi-tri-2\"><\/p>\n<p>3.<strong>Gi\u1eef n\u00fat SHIFT<\/strong> v\u00e0 k\u00e9o c\u1ed9t sang v\u1ecb tr\u00ed m\u1edbi. B\u1ea1n s\u1ebd nh\u00ecn th\u1ea5y m\u1ed9t l\u1eb1n ranh nh\u1ecf ch\u1ec9 v\u1ecb tr\u00ed \u0111\u00edch.<\/p>\n<p>4.Sau khi xong vi\u1ec7c, th\u1ea3 chu\u1ed9t v\u00e0 n\u00fat Shift ra. L\u00fac n\u00e0y c\u1ed9t ID s\u1ebd \u0111\u01b0a l\u00ean tr\u01b0\u1edbc c\u1ed9t gi\u1edbi t\u00ednh.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23196\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/doi-vi-tri-3.png\" width=\"380\" height=\"421\" title=\"doi-vi-tri-3\"><\/p>\n<ul>\n<li><em>\u0110i\u1ec1u g\u00ec s\u1ebd x\u1ea3y ra n\u1ebfu b\u1ea1n kh\u00f4ng gi\u1eef n\u00fat Shift?<\/em><\/li>\n<\/ul>\n<p>Khi b\u1ea1n th\u1ef1c hi\u1ec7n thao t\u00e1c k\u00e9o th\u1ea3 m\u00e0 kh\u00f4ng c\u00f3 n\u00fat Shift, Excel s\u1ebd hi\u1ec3n th\u1ecb th\u00f4ng b\u00e1o v\u00f9ng \u0111\u00e3 c\u00f3 d\u1eef li\u1ec7u. N\u1ebfu b\u1ea1n ch\u1ecdn Yes, Excel th\u1ef1c hi\u1ec7n thao t\u00e1c ghi \u0111\u00e8 l\u00ean c\u1ed9t kh\u00e1c d\u1eabn \u0111\u1ebfn vi\u1ec7c m\u1ea5t d\u1eef li\u1ec7u tr\u01b0\u1edbc \u0111\u00f3.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23198\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/doi-vi-tri-4.png\" width=\"888\" height=\"320\" title=\"doi-vi-tri-4\"><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23199\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/doi-vi-tri-5.png\" width=\"381\" height=\"318\" title=\"doi-vi-tri-5\"><\/p>\n<p>T\u01b0\u01a1ng t\u1ef1, b\u1ea1n c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n thao t\u00e1c n\u00e0y \u0111\u1ed1i v\u1edbi c\u00e1c c\u1ed9t <strong>li\u1ec1n k\u1ec1<\/strong> nhau.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Doi_vi_tri_cot_bang_thao_tac_Cut_Insert\"><\/span>\u0110\u1ed5i v\u1ecb tr\u00ed c\u1ed9t b\u1eb1ng thao t\u00e1c Cut &amp; Insert<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>C\u00e1ch th\u1ee9 hai \u0111\u1ec3 thay \u0111\u1ed5i v\u1ecb tr\u00ed c\u00e1c c\u1ed9t v\u1edbi nhau \u0111\u00f3 l\u00e0 s\u1eed d\u1ee5ng thao t\u00e1c Cut &amp; Paste. Ch\u1eb3ng h\u1ea1n, trong v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y, H\u1ecdc Excel Online s\u1ebd \u0111\u01b0a v\u1ecb tr\u00ed c\u1ed9t\u00a0<strong>Tu\u1ed5i<\/strong> v\u00e0o gi\u1eefa c\u1ed9t\u00a0<strong>T\u00ean\u00a0<\/strong>v\u00e0\u00a0<strong>ID<\/strong>. Ta th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/p>\n<p>1.Ch\u1ecdn c\u1ed9t mu\u1ed1n di chuy\u1ec3n<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23216\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/doivitri1.png\" width=\"382\" height=\"341\" title=\"doivitri1\"><\/p>\n<p>2.S\u1eed d\u1ee5ng thao t\u00e1c\u00a0<strong>Cut<\/strong> (ph\u00edm t\u1eaft\u00a0<strong>Ctrl+X<\/strong>)<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23217\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/doivitri2.png\" width=\"382\" height=\"302\" title=\"doivitri2\"><\/p>\n<p>3.Ch\u1ecdn c\u1ed9t n\u1eb1m b\u00ean\u00a0<strong>ph\u1ea3i<\/strong> c\u1ed9t mu\u1ed1n chen v\u00e0o gi\u1eefa, sau \u0111\u00f3 click\u00a0<strong>chu\u1ed9t ph\u1ea3i<\/strong> v\u00e0 ch\u1ecdn\u00a0<strong>Insert Cut Cells<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23218\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/doivitri3.png\" width=\"444\" height=\"345\" title=\"doivitri3\"><\/p>\n<p>K\u1ebft qu\u1ea3:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23219\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/doivitri4.png\" width=\"380\" height=\"302\" title=\"doivitri4\"><\/p>\n<ul>\n<li><em>N\u1ebfu b\u1ea1n s\u1eed d\u1ee5ng thao t\u00e1c\u00a0<strong>Paste,\u00a0<\/strong>t\u01b0\u01a1ng t\u1ef1 nh\u01b0 khi k\u00e9o th\u1ea3 b\u1eb1ng chu\u1ed9t m\u00e0 kh\u00f4ng c\u00f3 <strong>Shift<\/strong>, d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n s\u1ebd ghi \u0111\u00e8 l\u00ean c\u1ed9t c\u00f3 tr\u01b0\u1edbc \u0111\u00f3 d\u1eabn t\u1edbi vi\u1ec7c m\u1ea5t d\u1eef li\u1ec7u.<\/em><\/li>\n<\/ul>\n<p>\u00a0<\/p>\n<p>Th\u1eadt \u0111\u01a1n gi\u1ea3n ph\u1ea3i kh\u00f4ng n\u00e0o? Ch\u00fac c\u00e1c b\u1ea1n h\u1ecdc t\u1ed1t!<\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-175.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":2285,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-2284","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/2284","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=2284"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/2284\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/2285"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=2284"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=2284"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=2284"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}