{"id":11921,"date":"2022-03-21T00:33:42","date_gmt":"2022-03-20T17:33:42","guid":{"rendered":"https:\/\/teky.edu.vn\/blog\/?p=11921"},"modified":"2022-03-21T00:33:42","modified_gmt":"2022-03-20T17:33:42","slug":"di-chuyen-cot-trong-excel","status":"publish","type":"post","link":"https:\/\/teky.edu.vn\/blog\/di-chuyen-cot-trong-excel\/","title":{"rendered":"B\u1ecf t\u00fai ngay 2 c\u00e1ch \u0111\u01a1n gi\u1ea3n \u0111\u1ec3 di chuy\u1ec3n c\u1ed9t trong excel"},"content":{"rendered":"\n\n<div class=\"kk-star-ratings kksr-auto kksr-align-left kksr-valign-top\"\n    data-payload='{&quot;align&quot;:&quot;left&quot;,&quot;id&quot;:&quot;11921&quot;,&quot;slug&quot;:&quot;default&quot;,&quot;valign&quot;:&quot;top&quot;,&quot;ignore&quot;:&quot;&quot;,&quot;reference&quot;:&quot;auto&quot;,&quot;class&quot;:&quot;&quot;,&quot;count&quot;:&quot;4&quot;,&quot;legendonly&quot;:&quot;&quot;,&quot;readonly&quot;:&quot;&quot;,&quot;score&quot;:&quot;5&quot;,&quot;starsonly&quot;:&quot;&quot;,&quot;best&quot;:&quot;5&quot;,&quot;gap&quot;:&quot;5&quot;,&quot;greet&quot;:&quot;Rate this post&quot;,&quot;legend&quot;:&quot;5\\\/5 - (4 b\u00ecnh ch\u1ecdn)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;B\u1ecf t\u00fai ngay 2 c\u00e1ch \u0111\u01a1n gi\u1ea3n \u0111\u1ec3 di chuy\u1ec3n c\u1ed9t trong excel&quot;,&quot;width&quot;:&quot;142.5&quot;,&quot;_legend&quot;:&quot;{score}\\\/{best} - ({count} {votes})&quot;,&quot;font_factor&quot;:&quot;1.25&quot;}'>\n            \n<div class=\"kksr-stars\">\n    \n<div class=\"kksr-stars-inactive\">\n            <div class=\"kksr-star\" data-star=\"1\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"2\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"3\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"4\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"5\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n    \n<div class=\"kksr-stars-active\" style=\"width: 142.5px;\">\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n<\/div>\n                \n\n<div class=\"kksr-legend\" style=\"font-size: 19.2px;\">\n            5\/5 - (4 b\u00ecnh ch\u1ecdn)    <\/div>\n    <\/div>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"font-weight: 400\">Khi nh\u1eadp th\u00f4ng tin h\u00e0ng, c\u1ed9t trong b\u1ea3ng t\u00ednh excel ch\u1eafc h\u1eb3n s\u1ebd c\u00f3 \u0111\u00f4i l\u1ea7n v\u00f4 t\u00ecnh nh\u1eadp nh\u1ea7m d\u1eef li\u1ec7u v\u1edbi nhau. Nh\u01b0ng kh\u00f4ng bi\u1ebft ph\u1ea3i s\u1eeda l\u1ea1i nh\u01b0 th\u1ebf n\u00e0o n\u00ean \u0111\u00e0nh x\u00f3a \u0111i nh\u1eadp l\u1ea1i. \u0110i\u1ec1u n\u00e0y g\u00e2y cho b\u1ea1n c\u1ea3m x\u00fac b\u1ef1c t\u1ee9c kh\u00f3 ch\u1ecbu v\u00e0 t\u1ed1n r\u1ea5t th\u1eddi gian \u0111\u00fang kh\u00f4ng n\u00e0o. V\u1eady \u0111\u1ec3 x\u1eed l\u00fd t\u00ecnh tr\u1ea1ng n\u00e0y, b\u1ea1n h\u00e3y thu\u1ed9c l\u00f2ng ngay 2 c\u00e1ch \u0111\u01a1n gi\u1ea3n d\u01b0\u1edbi \u0111\u00e2y \u0111\u1ec3 <\/span><a href=\"https:\/\/teky.edu.vn\/blog\/\"><b>di chuy\u1ec3n c\u1ed9t trong excel<\/b><\/a><span style=\"font-weight: 400\"> m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng nh\u00e9.<\/span><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_76 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">N\u1ed9i dung <\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" 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: #999;color:#999\" 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><\/span><\/a><\/span><\/div>\n<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:\/\/teky.edu.vn\/blog\/di-chuyen-cot-trong-excel\/#Di_chuyen_mot_cot_trong_excel\" >Di chuy\u1ec3n m\u1ed9t c\u1ed9t trong excel<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/teky.edu.vn\/blog\/di-chuyen-cot-trong-excel\/#Di_chuyen_bang_cach_keo_tha_chuot\" >Di chuy\u1ec3n b\u1eb1ng c\u00e1ch k\u00e9o th\u1ea3 chu\u1ed9t<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/teky.edu.vn\/blog\/di-chuyen-cot-trong-excel\/#Di_chuyen_bang_cach_cat_dan\" >Di chuy\u1ec3n b\u1eb1ng c\u00e1ch c\u1eaft, d\u00e1n\u00a0<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/teky.edu.vn\/blog\/di-chuyen-cot-trong-excel\/#Di_chuyen_nhieu_cot_trong_Excel\" >Di chuy\u1ec3n nhi\u1ec1u c\u1ed9t trong Excel<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/teky.edu.vn\/blog\/di-chuyen-cot-trong-excel\/#Keo_tha_nhieu_cot_bang_cach_su_dung_chuot\" >K\u00e9o th\u1ea3 nhi\u1ec1u c\u1ed9t b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng chu\u1ed9t<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/teky.edu.vn\/blog\/di-chuyen-cot-trong-excel\/#Sao_chep_xoa_va_dan_cac_cot_trong_excel\" >Sao ch\u00e9p, x\u00f3a v\u00e0 d\u00e1n c\u00e1c c\u1ed9t trong excel<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Di_chuyen_mot_cot_trong_excel\"><\/span><span style=\"font-weight: 400\">Di chuy\u1ec3n m\u1ed9t c\u1ed9t trong excel<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"Di_chuyen_bang_cach_keo_tha_chuot\"><\/span><span style=\"font-weight: 400\">Di chuy\u1ec3n b\u1eb1ng c\u00e1ch k\u00e9o th\u1ea3 chu\u1ed9t<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">Sau khi m\u1edf b\u1ea3ng t\u00ednh excel v\u00e0 x\u00e1c \u0111\u1ecbnh \u0111\u01b0\u1ee3c c\u1ed9t mu\u1ed1n di chuy\u1ec3n. B\u1ea1n \u0111\u01b0a con chu\u1ed9t l\u00ean v\u1ecb tr\u00ed \u1edf \u0111\u1ea7u c\u1ed9t \u0111\u1ebfn khi th\u1ea5y m\u0169i t\u00ean \u0111en tr\u1ecf xu\u1ed1ng. Sau \u0111\u00f3 click chu\u1ed9t, v\u1eady l\u00e0 c\u1ed9t c\u1ea7n di chuy\u1ec3n \u0111\u00e3 \u0111\u01b0\u1ee3c b\u00f4i \u0111en.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11935 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/14-2.jpg\" alt=\"\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/14-2.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/14-2-400x267.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/14-2-272x182.jpg 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p><span style=\"font-weight: 400\">Ti\u1ebfp \u0111\u00f3, b\u1ea1n di chuy\u1ec3n chu\u1ed9t \u0111\u1ebfn v\u1ecb tr\u00ed b\u00ean c\u1ea1nh c\u1ed9t \u0111\u00e3 \u0111\u01b0\u1ee3c b\u00f4i \u0111en. B\u1ea1n c\u1ea7n \u0111\u1eb7t chu\u1ed9t v\u00e0o c\u1ea1nh c\u1ee7a c\u1ed9t b\u00f4i \u0111en. Cho \u0111\u1ebfn khi chu\u1ed9t s\u1ebd bi\u1ebfn th\u00e0nh h\u00ecnh ch\u1eef th\u1eadp c\u00f3 b\u1ed1n m\u0169i t\u00ean nh\u01b0 h\u00ecnh d\u01b0\u1edbi l\u00e0 \u0111\u01b0\u1ee3c.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11933 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/12-2.jpg\" alt=\"\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/12-2.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/12-2-400x267.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/12-2-272x182.jpg 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p><span style=\"font-weight: 400\">B\u1ea5m gi\u1eef chu\u1ed9t v\u00e0 di chuy\u1ec3n c\u1ed9t t\u1edbi v\u1ecb tr\u00ed m\u00e0 b\u1ea1n mong mu\u1ed1n. <\/span><span style=\"font-weight: 400\">\u0110\u01b0\u1eddng vi\u1ec1n m\u00e0u xanh lam hi\u1ec3n th\u1ecb cho v\u1ecb tr\u00ed c\u1ed9t d\u1eef li\u1ec7u s\u1ebd \u0111\u01b0\u1ee3c chuy\u1ec3n \u0111\u1ebfn. Th\u1ea3 chu\u1ed9t ra khi b\u1ea1n \u0111\u00e3 di chuy\u1ec3n \u0111\u01b0\u1ee3c \u0111\u1ebfn v\u1ecb tr\u00ed th\u00edch h\u1ee3p.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11934 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/13-2.jpg\" alt=\"\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/13-2.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/13-2-400x267.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/13-2-272x182.jpg 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p><span style=\"font-weight: 400\">Sau khi di chuy\u1ec3n c\u1ed9t \u0111\u1ebfn v\u1ecb tr\u00ed m\u1edbi, v\u1ecb tr\u00ed c\u0169 s\u1ebd b\u1ecb tr\u1ed1ng. Do v\u1eady ch\u00fang ta c\u1ea7n x\u00f3a kho\u1ea3ng tr\u1ed1ng n\u00e0y \u0111i. \u0110\u1ec3 lo\u1ea1i b\u1ecf kho\u1ea3ng c\u00e1ch c\u1ed9t n\u00e0y. Ch\u00fang ta ch\u1ec9 c\u1ea7n b\u00f4i \u0111en c\u1ed9t nh\u01b0 c\u00e1c thao t\u00e1c \u0111\u00e3 h\u01b0\u1edbng d\u1eabn \u1edf l\u00fac \u0111\u1ea7u, sau \u0111\u00f3, \u0111\u1ec3 con tr\u1ecf chu\u1ed9t v\u00e0o m\u1ea3ng \u0111\u01b0\u1ee3c b\u00f4i \u0111en, click chu\u1ed9t ph\u1ea3i r\u1ed3i ch\u1ecdn <\/span><i><span style=\"font-weight: 400\">Delete<\/span><\/i><span style=\"font-weight: 400\"> trong thanh t\u00f9y ch\u1ecdn v\u1eeba hi\u1ec3n th\u1ecb. V\u1eady l\u00e0 kho\u1ea3ng tr\u1ed1ng \u0111\u00e3 \u0111\u01b0\u1ee3c lo\u1ea1i b\u1ecf.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11932 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/11-3.jpg\" alt=\"\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/11-3.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/11-3-400x267.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/11-3-272x182.jpg 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Di_chuyen_bang_cach_cat_dan\"><\/span><span style=\"font-weight: 400\">Di chuy\u1ec3n b\u1eb1ng c\u00e1ch c\u1eaft, d\u00e1n\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">\u0110\u1ea7u ti\u00ean, ch\u00fang ta v\u1eabn b\u00f4i \u0111en c\u1ed9t c\u1ea7n di chuy\u1ec3n nh\u01b0 \u0111\u00e3 h\u01b0\u1edbng d\u1eabn \u1edf c\u00e1ch 1.\u00a0<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11928 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/7-13.jpg\" alt=\"\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/7-13.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/7-13-400x267.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/7-13-272x182.jpg 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p><span style=\"font-weight: 400\">Sau \u0111\u00f3, click chu\u1ed9t ph\u1ea3i trong ph\u1ea7n \u0111\u01b0\u1ee3c b\u00f4i \u0111en, trong b\u1ea3ng t\u00f9y ch\u1ecdn hi\u1ec3n th\u1ecb click ch\u1ecdn <\/span><i><span style=\"font-weight: 400\">Cut, <\/span><\/i><span style=\"font-weight: 400\">ho\u1eb7c b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 d\u00f9ng t\u1ed5 h\u1ee3p ph\u00edm Ctrl + X \u0111\u1ec3 th\u1ef1c hi\u1ec7n ch\u1ee9c n\u0103ng t\u01b0\u01a1ng t\u1ef1.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11930 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/9-6.jpg\" alt=\"\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/9-6.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/9-6-400x267.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/9-6-272x182.jpg 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p><span style=\"font-weight: 400\">Ti\u1ebfp \u0111\u1ebfn, b\u00f4i \u0111en c\u1ed9t v\u1ecb tr\u00ed b\u1ea1n mu\u1ed1n di chuy\u1ec3n d\u1eef li\u1ec7u t\u1edbi b\u1eb1ng c\u00e1ch t\u01b0\u01a1ng t\u1ef1 \u1edf tr\u00ean. L\u01b0u \u00fd c\u1ed9t m\u1edbi b\u1ea1n mu\u1ed1n di chuy\u1ec3n \u0111\u1ebfn s\u1ebd n\u1eb1m \u1edf b\u00ean tr\u00e1i c\u1ee7a v\u1ecb tr\u00ed d\u1eef li\u1ec7u c\u0169. N\u1ebfu v\u1ecb tr\u00ed \u0111\u01b0\u1ee3c \u0111\u00e1nh d\u1ea5u b\u1ea1n mu\u1ed1n di chuy\u1ec3n \u0111\u00e3 ch\u1ee9a d\u1eef li\u1ec7u.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Click chu\u1ed9t ph\u1ea3i v\u00e0o m\u1ea3ng \u0111\u01b0\u1ee3c b\u00f4i \u0111en, r\u1ed3i ch\u1ecdn h\u00e0ng <\/span><i><span style=\"font-weight: 400\">Insert Cut Cells<\/span><\/i><span style=\"font-weight: 400\"> trong h\u1ed9p t\u00f9y ch\u1ecdn xu\u1ea5t hi\u1ec7n.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11929 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/8-9.jpg\" alt=\"\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/8-9.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/8-9-400x267.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/8-9-272x182.jpg 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p><span style=\"font-weight: 400\">Cu\u1ed1i c\u00f9ng, c\u1ed9t s\u1ebd \u0111\u01b0\u1ee3c di chuy\u1ec3n \u0111\u1ebfn v\u1ecb tr\u00ed m\u00e0 b\u1ea1n mong mu\u1ed1n. K\u1ebft qu\u1ea3 sau khi ho\u00e0n th\u00e0nh c\u00e1c b\u01b0\u1edbc <\/span><b>di chuy\u1ec3n c\u1ed9t trong excel<\/b><span style=\"font-weight: 400\"> \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb nh\u01b0 h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11931 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/10-4.jpg\" alt=\"\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/10-4.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/10-4-400x267.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/10-4-272x182.jpg 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p>&gt;&gt;&gt; Tham kh\u1ea3o th\u00eam: <a href=\"https:\/\/teky.edu.vn\/blog\/cach-doi-cot-trong-excel\/\"><em><strong><span style=\"color: #0000ff\">C\u00e1ch \u0111\u1ed5i c\u1ed9t trong Excel<\/span><\/strong><\/em><\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Di_chuyen_nhieu_cot_trong_Excel\"><\/span><span style=\"font-weight: 400\">Di chuy\u1ec3n nhi\u1ec1u c\u1ed9t trong Excel<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">\u0110\u1ed1i v\u1edbi c\u00e1c <\/span><b>c\u00e1ch di chuy\u1ec3n c\u1ed9t trong excel<\/b><span style=\"font-weight: 400\"> \u0111\u01b0\u1ee3c gi\u1edbi thi\u1ec7u \u1edf tr\u00ean, b\u1ea1n s\u1ebd ch\u1ec9 \u00e1p d\u1ee5ng cho di chuy\u1ec3n m\u1ed9t c\u1ed9t ho\u1eb7c di chuy\u1ec3n nhi\u1ec1u c\u1ed9t li\u1ec1n k\u1ec1 nhau. <\/span><\/p>\n<p><span style=\"font-weight: 400\">C\u00f2n n\u1ebfu b\u1ea1n thao t\u00e1c t\u01b0\u01a1ng t\u1ef1 tr\u00ean nhi\u1ec1u c\u1ed9t kh\u00f4ng li\u1ec1n k\u1ec1, b\u1ea1n s\u1ebd g\u1eb7p l\u1ed7i: <\/span><i><span style=\"font-weight: 400\">The command you chose cannot be performed with multiple selections<\/span><\/i><span style=\"font-weight: 400\">. Ngh\u0129a l\u00e0: l\u1ec7nh b\u1ea1n y\u00eau c\u1ea7u kh\u00f4ng th\u1ec3 th\u1ef1c hi\u1ec7n v\u1edbi nhi\u1ec1u c\u1ed9t \u0111\u01b0\u1ee3c ch\u1ecdn. <\/span><\/p>\n<p><span style=\"font-weight: 400\">V\u00e0 b\u1ea1n s\u1ebd ph\u1ea3i x\u00f3a c\u00e1c c\u1ed9t \u0111i v\u00e0 nh\u1eadp l\u1ea1i t\u1eeb \u0111\u1ea7u, \u0111i\u1ec1u n\u00e0y r\u1ea5t t\u1ed1n th\u1eddi gian. Nh\u01b0ng \u0111\u1ea5y l\u00e0 trong tr\u01b0\u1eddng h\u1ee3p b\u1ea1n ch\u01b0a \u0111\u1ecdc \u0111\u01b0\u1ee3c b\u00e0i vi\u1ebft n\u00e0y th\u00f4i. C\u00f2n gi\u1edd h\u00e3y thu\u1ed9c l\u00f2ng 2 ngay c\u00e1ch d\u01b0\u1edbi \u0111\u00e2y \u0111\u1ec3 x\u1eed l\u00fd ch\u00fang trong v\u00f2ng m\u1ed9t n\u1ed1t nh\u1ea1c nh\u00e9.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Hai c\u00e1ch \u0111\u01a1n gi\u1ea3n:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">K\u00e9o th\u1ea3 nhi\u1ec1u c\u1ed9t b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng chu\u1ed9t.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Sao ch\u00e9p, x\u00f3a v\u00e0 d\u00e1n c\u00e1c c\u1ed9t trong excel (c\u00f3 th\u1ec3 di chuy\u1ec3n nhi\u1ec1u c\u1ed9t m\u1ed9t l\u00fac).<\/span><\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"Keo_tha_nhieu_cot_bang_cach_su_dung_chuot\"><\/span><span style=\"font-weight: 400\">K\u00e9o th\u1ea3 nhi\u1ec1u c\u1ed9t b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng chu\u1ed9t<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">\u0110\u1ea7u ti\u00ean, ch\u1ecdn c\u1ed9t m\u00e0 b\u1ea1n mu\u1ed1n di chuy\u1ec3n. Ti\u1ebfp \u0111\u1ebfn di chuy\u1ec3n con tr\u1ecf chu\u1ed9t \u0111\u1ebfn c\u1ea1nh ph\u1ea7n \u0111\u01b0\u1ee3c ch\u1ecdn. Cho \u0111\u1ebfn khi th\u1ea5y xu\u1ea5t hi\u1ec7n d\u1ea5u m\u0169i t\u00ean b\u1ed1n chi\u1ec1u. Sau \u0111\u00f3, vi\u1ec7c b\u1ea1n c\u1ea7n l\u00e0m ch\u1ec9\u00a0 l\u00e0 nh\u1ea5n gi\u1eef <\/span><i><span style=\"font-weight: 400\">Shift <\/span><\/i><span style=\"font-weight: 400\">v\u00e0 d\u00f9ng chu\u1ed9t di chuy\u1ec3n, k\u00e9o c\u1ed9t \u0111\u00f3 sang v\u1ecb tr\u00ed m\u1edbi mu\u1ed1n chuy\u1ec3n \u0111\u1ebfn.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400\">Ch\u00fa \u00fd:\u00a0<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">B\u1ea1n kh\u00f4ng th\u1ec3 k\u00e9o v\u00e0 th\u1ea3 c\u00e1c c\u1ed9t ho\u1eb7c h\u00e0ng li\u1ec1n k\u1ec1 trong b\u1ea3ng t\u00ednh Excel, ngay c\u1ea3 trong Excel 2013.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Ph\u01b0\u01a1ng ph\u00e1p k\u00e9o th\u1ea3 n\u00e0y ch\u1ec9 ho\u1ea1t \u0111\u1ed9ng trong Excel 2013, 2010, 2007. V\u00e0 c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 di chuy\u1ec3n c\u00e1c h\u00e0ng.<\/span><\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"Sao_chep_xoa_va_dan_cac_cot_trong_excel\"><\/span><span style=\"font-weight: 400\">Sao ch\u00e9p, x\u00f3a v\u00e0 d\u00e1n c\u00e1c c\u1ed9t trong excel<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><b>B\u01b0\u1edbc 1<\/b><span style=\"font-weight: 400\">: B\u00f4i \u0111en c\u00e1c c\u1ed9t m\u00e0 b\u1ea1n mu\u1ed1n di chuy\u1ec3n b\u1eb1ng c\u00e1ch k\u00e9o chu\u1ed9t. Ngo\u00e0i ra, b\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn nhi\u1ec1u c\u1ed9t m\u1ed9t c\u00e1ch \u0111\u01a1n gi\u1ea3n b\u1eb1ng c\u00e1ch nh\u1ea5n gi\u1eef ph\u00edm <\/span><b>Ctrl.<\/b><span style=\"font-weight: 400\"> \u0110\u1ed3ng th\u1eddi d\u00f9ng chu\u1ed9t click ch\u1ecdn v\u00e0o c\u00e1c c\u1ed9t m\u00e0 b\u1ea1n mu\u1ed1n di chuy\u1ec3n.<\/span><\/p>\n<p><span style=\"font-weight: 400\">\u1ede v\u00ed d\u1ee5 n\u00e0y, c\u00e1c c\u1ed9t mu\u1ed1n di chuy\u1ec3n \u0111\u00e3 \u0111\u01b0\u1ee3c b\u00f4i \u0111en l\u00e0 <\/span><i><span style=\"font-weight: 400\">Nh\u00f3m<\/span><\/i><span style=\"font-weight: 400\"> v\u00e0 <\/span><i><span style=\"font-weight: 400\">Nhi\u1ec7m v\u1ee5<\/span><\/i><span style=\"font-weight: 400\">. Ta s\u1ebd di chuy\u1ec3n hai c\u1ed9t n\u00e0y t\u1edbi b\u00ean tr\u00e1i c\u1ee7a c\u1ed9t <\/span><i><span style=\"font-weight: 400\">H\u1ecd v\u00e0 t\u00ean.<\/span><\/i><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11927 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/6-13.jpg\" alt=\"\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/6-13.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/6-13-400x267.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/6-13-272x182.jpg 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p><b>B\u01b0\u1edbc 2:<\/b><span style=\"font-weight: 400\"> Sau \u0111\u00f3, nh\u1ea5n <\/span><b>Ctrl + C<\/b><span style=\"font-weight: 400\"> \u0111\u1ec3 copy ho\u1eb7c b\u1ea1n c\u00f3 th\u1ec3 copy b\u1eb1ng c\u00e1ch di chuy\u1ec3n chu\u1ed9t v\u00e0o v\u00f9ng b\u00f4i \u0111en \u0111\u00e3 ch\u1ecdn, nh\u1ea5n chu\u1ed9t ph\u1ea3i ch\u1ecdn <\/span><b>Copy<\/b><span style=\"font-weight: 400\"> \u1edf thanh c\u00f4ng c\u1ee5 hi\u1ec7n ra \u0111\u1ec3 th\u1ef1c hi\u1ec7n ch\u1ee9c n\u0103ng t\u01b0\u01a1ng t\u1ef1.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11926 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/5-12.jpg\" alt=\"\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/5-12.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/5-12-400x267.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/5-12-272x182.jpg 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p><b>B\u01b0\u1edbc 3:<\/b><span style=\"font-weight: 400\"> Di chuy\u1ec3n chu\u1ed9t \u0111\u1ebfn \u0111\u1ea7u c\u1ed9t n\u1eb1m tr\u01b0\u1edbc v\u1ecb tr\u00ed b\u1ea1n mu\u1ed1n ch\u00e8n c\u1ed9t v\u1eeba sao ch\u00e9p \u0111\u1ec3 b\u00f4i \u0111en. Sau \u0111\u00f3, trong v\u00f9ng \u0111\u01b0\u1ee3c b\u00f4i \u0111en, b\u1ea1n click chu\u1ed9t ph\u1ea3i, ti\u1ebfp \u0111\u00f3 ch\u1ecdn <\/span><b>Insert Copied Cells<\/b><span style=\"font-weight: 400\"> trong thanh t\u1ef1 ch\u1ecdn hi\u1ec7n ra (Ho\u1eb7c b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n ch\u1ee9c n\u0103ng t\u01b0\u01a1ng t\u1ef1 b\u1eb1ng c\u00e1ch nh\u1ea5n <\/span><b>Ctrl + d\u1ea5u c\u1ed9ng \u201c+\u201d<\/b><span style=\"font-weight: 400\">).<\/span><\/p>\n<p><span style=\"font-weight: 400\">\u1ede v\u00ed d\u1ee5 n\u00e0y, c\u1ed9t <\/span><i><span style=\"font-weight: 400\">H\u1ecd v\u00e0 t\u00ean<\/span><\/i><span style=\"font-weight: 400\"> \u0111\u00e3 \u0111\u01b0\u1ee3c b\u00f4i \u0111en nh\u01b0 h\u00ecnh d\u01b0\u1edbi, n\u1eb1m b\u00ean ph\u1ea3i v\u1ecb tr\u00ed m\u00e0 b\u1ea1n mu\u1ed1n di chuy\u1ec3n c\u1ed9t m\u1edbi \u0111\u1ebfn.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11924 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/3-15.jpg\" alt=\"\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/3-15.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/3-15-400x267.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/3-15-272x182.jpg 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p><b>B\u01b0\u1edbc 4<\/b><span style=\"font-weight: 400\">: Khi th\u1ea5y h\u1ed9p tho\u1ea1i hi\u1ec7n ra v\u00e0 b\u1ea1n s\u1ebd click v\u00e0o \u00f4 tr\u00f2n \u0111\u1ec3 ch\u1ecdn v\u1ecb tr\u00ed c\u00e1c c\u1ed9t s\u1ebd xu\u1ea5t hi\u1ec7n: B\u00ean tr\u00e1i c\u1ed9t b\u1ea1n ch\u1ecdn (<\/span><b>Shift Cells Left<\/b><span style=\"font-weight: 400\">) ho\u1eb7c b\u00ean ph\u1ea3i (<\/span><b>Shift Cells Right<\/b><span style=\"font-weight: 400\">) c\u1ed9t b\u1ea1n ch\u1ecdn.<\/span><\/p>\n<p><b>B\u01b0\u1edbc 5:<\/b><span style=\"font-weight: 400\"> Sau khi ch\u1ecdn v\u1ecb tr\u00ed, c\u00e1c c\u1ed9t s\u1ebd \u0111\u01b0\u1ee3c di chuy\u1ec3n \u0111\u1ebfn v\u1ecb tr\u00ed m\u00e0 b\u1ea1n mong mu\u1ed1n b\u00e1n \u0111\u1ea7u. B\u00e2y gi\u1edd, b\u1ea1n ch\u1ec9 c\u1ea7n x\u00f3a c\u00e1c c\u1ed9t g\u1ed1c \u1edf v\u1ecb tr\u00ed c\u0169 m\u00e0 b\u1ea1n v\u1eeba di chuy\u1ec3n \u0111i b\u1eb1ng c\u00e1c thao t\u00e1c quen thu\u1ed9c. H\u00e3y b\u00f4i \u0111en c\u00e1c c\u1ed9t c\u1ea7n x\u00f3a sau \u0111\u00f3\u00a0 click chu\u1ed9t ph\u1ea3i trong khu v\u1ef1c b\u00f4i \u0111en ch\u1ecdn <\/span><b>Delete <\/b><span style=\"font-weight: 400\">\u1edf thanh t\u00f9y ch\u1ecdn hi\u1ec7n ra.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11925 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/4-14.jpg\" alt=\"\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/4-14.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/4-14-400x267.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/4-14-272x182.jpg 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p><span style=\"font-weight: 400\">Sau khi th\u1ef1c hi\u1ec7n xong t\u1ea5t c\u1ea3 c\u00e1c b\u01b0\u1edbc, ta \u0111\u00e3 di chuy\u1ec3n th\u00e0nh c\u00f4ng c\u00e1c c\u1ed9t \u0111\u1ebfn v\u1ecb tr\u00ed mong mu\u1ed1n. K\u1ebft qu\u1ea3 trong v\u00ed d\u1ee5 \u0111\u01b0\u1ee3c th\u1ec3 hi\u1ec7n \u1edf h\u00ecnh d\u01b0\u1edbi:<\/span><span style=\"font-weight: 400\"><br \/>\n<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11922 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/1-15.jpg\" alt=\"\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/1-15.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/1-15-400x267.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/1-15-272x182.jpg 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p><span style=\"font-weight: 400\">Hi v\u1ecdng r\u1eb1ng nh\u1eefng <\/span><b>c\u00e1ch di chuy\u1ec3n c\u1ed9t trong excel<\/b><span style=\"font-weight: 400\"> \u0111\u01a1n gi\u1ea3n m\u00e0 ch\u00fang m\u00ecnh gi\u1edbi thi\u1ec7u tr\u00ean \u0111\u00e2y. \u0110\u1ec3 c\u00f3 th\u1ec3 ph\u1ea7n n\u00e0o gi\u00fap b\u1ea1n thao t\u00e1c nhanh v\u00e0 d\u1ec5 d\u00e0ng h\u01a1n. B\u1ea1n h\u00e3y th\u1ef1c hi\u1ec7n l\u1ea1i nhi\u1ec1u l\u1ea7n \u0111\u1ec3 ghi nh\u1edb, th\u00e0nh th\u1ee5c h\u01a1n.\u00a0<\/span><\/p>\n<p>&gt;&gt;&gt; Tham kh\u1ea3o th\u00eam: <a href=\"https:\/\/teky.edu.vn\/blog\/cach-them-cot-trong-excel\/\"><em><strong><span style=\"color: #0000ff\">C\u00e1ch th\u00eam c\u1ed9t trong Excel<\/span><\/strong><\/em><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; &nbsp; Khi nh\u1eadp th\u00f4ng tin h\u00e0ng, c\u1ed9t trong b\u1ea3ng t\u00ednh excel ch\u1eafc h\u1eb3n s\u1ebd c\u00f3 \u0111\u00f4i l\u1ea7n v\u00f4 t\u00ecnh nh\u1eadp nh\u1ea7m d\u1eef li\u1ec7u v\u1edbi nhau. Nh\u01b0ng kh\u00f4ng bi\u1ebft ph\u1ea3i s\u1eeda l\u1ea1i nh\u01b0 th\u1ebf n\u00e0o n\u00ean \u0111\u00e0nh x\u00f3a \u0111i nh\u1eadp l\u1ea1i. \u0110i\u1ec1u n\u00e0y g\u00e2y cho b\u1ea1n c\u1ea3m x\u00fac b\u1ef1c t\u1ee9c kh\u00f3 ch\u1ecbu v\u00e0 t\u1ed1n r\u1ea5t &hellip;<\/p>\n","protected":false},"author":26,"featured_media":11923,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[173],"tags":[],"class_list":["post-11921","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v20.9 (Yoast SEO v26.0) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>B\u1ecf t\u00fai ngay 2 c\u00e1ch \u0111\u01a1n gi\u1ea3n \u0111\u1ec3 di chuy\u1ec3n c\u1ed9t trong excel<\/title>\n<meta name=\"description\" content=\"B\u1ecf t\u00fai ngay 2 c\u00e1ch \u0111\u01a1n gi\u1ea3n \u0111\u1ec3 di chuy\u1ec3n c\u1ed9t trong excel d\u01b0\u1edbi b\u00e0i vi\u1ebft n\u00e0y nh\u00e9.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/teky.edu.vn\/blog\/di-chuyen-cot-trong-excel\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"B\u1ecf t\u00fai ngay 2 c\u00e1ch \u0111\u01a1n gi\u1ea3n \u0111\u1ec3 di chuy\u1ec3n c\u1ed9t trong excel\" \/>\n<meta property=\"og:description\" content=\"B\u1ecf t\u00fai ngay 2 c\u00e1ch \u0111\u01a1n gi\u1ea3n \u0111\u1ec3 di chuy\u1ec3n c\u1ed9t trong excel d\u01b0\u1edbi b\u00e0i vi\u1ebft n\u00e0y nh\u00e9.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/teky.edu.vn\/blog\/di-chuyen-cot-trong-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/TekyAcademy\" \/>\n<meta property=\"article:published_time\" content=\"2022-03-20T17:33:42+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/2-14.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"600\" \/>\n\t<meta property=\"og:image:height\" content=\"400\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"H\u1eb1ng L\u00ea\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SteamTeky\" \/>\n<meta name=\"twitter:site\" content=\"@SteamTeky\" \/>\n<meta name=\"twitter:label1\" content=\"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi\" \/>\n\t<meta name=\"twitter:data1\" content=\"H\u1eb1ng L\u00ea\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 ph\u00fat\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/di-chuyen-cot-trong-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/di-chuyen-cot-trong-excel\/\"},\"author\":{\"name\":\"H\u1eb1ng L\u00ea\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/aba2a2e5a9eb4e0b390280d28d910d8b\"},\"headline\":\"B\u1ecf t\u00fai ngay 2 c\u00e1ch \u0111\u01a1n gi\u1ea3n \u0111\u1ec3 di chuy\u1ec3n c\u1ed9t trong excel\",\"datePublished\":\"2022-03-20T17:33:42+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/di-chuyen-cot-trong-excel\/\"},\"wordCount\":1814,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/di-chuyen-cot-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/2-14.jpg\",\"articleSection\":[\"T\u1ef1 h\u1ecdc Excel\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/di-chuyen-cot-trong-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/di-chuyen-cot-trong-excel\/\",\"url\":\"https:\/\/teky.edu.vn\/blog\/di-chuyen-cot-trong-excel\/\",\"name\":\"B\u1ecf t\u00fai ngay 2 c\u00e1ch \u0111\u01a1n gi\u1ea3n \u0111\u1ec3 di chuy\u1ec3n c\u1ed9t trong excel\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/di-chuyen-cot-trong-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/di-chuyen-cot-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/2-14.jpg\",\"datePublished\":\"2022-03-20T17:33:42+00:00\",\"description\":\"B\u1ecf t\u00fai ngay 2 c\u00e1ch \u0111\u01a1n gi\u1ea3n \u0111\u1ec3 di chuy\u1ec3n c\u1ed9t trong excel d\u01b0\u1edbi b\u00e0i vi\u1ebft n\u00e0y nh\u00e9.\",\"breadcrumb\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/di-chuyen-cot-trong-excel\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/di-chuyen-cot-trong-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/di-chuyen-cot-trong-excel\/#primaryimage\",\"url\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/2-14.jpg\",\"contentUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/2-14.jpg\",\"width\":600,\"height\":400},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/di-chuyen-cot-trong-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"T\u1ef1 h\u1ecdc Excel\",\"item\":\"https:\/\/teky.edu.vn\/blog\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"B\u1ecf t\u00fai ngay 2 c\u00e1ch \u0111\u01a1n gi\u1ea3n \u0111\u1ec3 di chuy\u1ec3n c\u1ed9t trong excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#website\",\"url\":\"https:\/\/teky.edu.vn\/blog\/\",\"name\":\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\",\"description\":\"Tr\u1ebb em c\u1ea7n h\u1ecdc l\u1eadp tr\u00ecnh\",\"publisher\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/teky.edu.vn\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"vi\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\",\"name\":\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\",\"url\":\"https:\/\/teky.edu.vn\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png\",\"contentUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png\",\"width\":495,\"height\":234,\"caption\":\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/TekyAcademy\",\"https:\/\/x.com\/SteamTeky\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/aba2a2e5a9eb4e0b390280d28d910d8b\",\"name\":\"H\u1eb1ng L\u00ea\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/d5cea52295ac99d8bda76636bd17e61d627a386d59def4d7f934bd3dace7b098?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/d5cea52295ac99d8bda76636bd17e61d627a386d59def4d7f934bd3dace7b098?s=96&d=mm&r=g\",\"caption\":\"H\u1eb1ng L\u00ea\"},\"url\":\"https:\/\/teky.edu.vn\/blog\/author\/lehang\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"B\u1ecf t\u00fai ngay 2 c\u00e1ch \u0111\u01a1n gi\u1ea3n \u0111\u1ec3 di chuy\u1ec3n c\u1ed9t trong excel","description":"B\u1ecf t\u00fai ngay 2 c\u00e1ch \u0111\u01a1n gi\u1ea3n \u0111\u1ec3 di chuy\u1ec3n c\u1ed9t trong excel d\u01b0\u1edbi b\u00e0i vi\u1ebft n\u00e0y nh\u00e9.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/teky.edu.vn\/blog\/di-chuyen-cot-trong-excel\/","og_locale":"vi_VN","og_type":"article","og_title":"B\u1ecf t\u00fai ngay 2 c\u00e1ch \u0111\u01a1n gi\u1ea3n \u0111\u1ec3 di chuy\u1ec3n c\u1ed9t trong excel","og_description":"B\u1ecf t\u00fai ngay 2 c\u00e1ch \u0111\u01a1n gi\u1ea3n \u0111\u1ec3 di chuy\u1ec3n c\u1ed9t trong excel d\u01b0\u1edbi b\u00e0i vi\u1ebft n\u00e0y nh\u00e9.","og_url":"https:\/\/teky.edu.vn\/blog\/di-chuyen-cot-trong-excel\/","og_site_name":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7","article_publisher":"https:\/\/www.facebook.com\/TekyAcademy","article_published_time":"2022-03-20T17:33:42+00:00","og_image":[{"width":600,"height":400,"url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/2-14.jpg","type":"image\/jpeg"}],"author":"H\u1eb1ng L\u00ea","twitter_card":"summary_large_image","twitter_creator":"@SteamTeky","twitter_site":"@SteamTeky","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"H\u1eb1ng L\u00ea","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"8 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/teky.edu.vn\/blog\/di-chuyen-cot-trong-excel\/#article","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/di-chuyen-cot-trong-excel\/"},"author":{"name":"H\u1eb1ng L\u00ea","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/aba2a2e5a9eb4e0b390280d28d910d8b"},"headline":"B\u1ecf t\u00fai ngay 2 c\u00e1ch \u0111\u01a1n gi\u1ea3n \u0111\u1ec3 di chuy\u1ec3n c\u1ed9t trong excel","datePublished":"2022-03-20T17:33:42+00:00","mainEntityOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/di-chuyen-cot-trong-excel\/"},"wordCount":1814,"commentCount":0,"publisher":{"@id":"https:\/\/teky.edu.vn\/blog\/#organization"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/di-chuyen-cot-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/2-14.jpg","articleSection":["T\u1ef1 h\u1ecdc Excel"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/teky.edu.vn\/blog\/di-chuyen-cot-trong-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/teky.edu.vn\/blog\/di-chuyen-cot-trong-excel\/","url":"https:\/\/teky.edu.vn\/blog\/di-chuyen-cot-trong-excel\/","name":"B\u1ecf t\u00fai ngay 2 c\u00e1ch \u0111\u01a1n gi\u1ea3n \u0111\u1ec3 di chuy\u1ec3n c\u1ed9t trong excel","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/di-chuyen-cot-trong-excel\/#primaryimage"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/di-chuyen-cot-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/2-14.jpg","datePublished":"2022-03-20T17:33:42+00:00","description":"B\u1ecf t\u00fai ngay 2 c\u00e1ch \u0111\u01a1n gi\u1ea3n \u0111\u1ec3 di chuy\u1ec3n c\u1ed9t trong excel d\u01b0\u1edbi b\u00e0i vi\u1ebft n\u00e0y nh\u00e9.","breadcrumb":{"@id":"https:\/\/teky.edu.vn\/blog\/di-chuyen-cot-trong-excel\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/teky.edu.vn\/blog\/di-chuyen-cot-trong-excel\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/di-chuyen-cot-trong-excel\/#primaryimage","url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/2-14.jpg","contentUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/2-14.jpg","width":600,"height":400},{"@type":"BreadcrumbList","@id":"https:\/\/teky.edu.vn\/blog\/di-chuyen-cot-trong-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"T\u1ef1 h\u1ecdc Excel","item":"https:\/\/teky.edu.vn\/blog\/excel\/"},{"@type":"ListItem","position":2,"name":"B\u1ecf t\u00fai ngay 2 c\u00e1ch \u0111\u01a1n gi\u1ea3n \u0111\u1ec3 di chuy\u1ec3n c\u1ed9t trong excel"}]},{"@type":"WebSite","@id":"https:\/\/teky.edu.vn\/blog\/#website","url":"https:\/\/teky.edu.vn\/blog\/","name":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7","description":"Tr\u1ebb em c\u1ea7n h\u1ecdc l\u1eadp tr\u00ecnh","publisher":{"@id":"https:\/\/teky.edu.vn\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/teky.edu.vn\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"vi"},{"@type":"Organization","@id":"https:\/\/teky.edu.vn\/blog\/#organization","name":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7","url":"https:\/\/teky.edu.vn\/blog\/","logo":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png","contentUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png","width":495,"height":234,"caption":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/TekyAcademy","https:\/\/x.com\/SteamTeky"]},{"@type":"Person","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/aba2a2e5a9eb4e0b390280d28d910d8b","name":"H\u1eb1ng L\u00ea","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/d5cea52295ac99d8bda76636bd17e61d627a386d59def4d7f934bd3dace7b098?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/d5cea52295ac99d8bda76636bd17e61d627a386d59def4d7f934bd3dace7b098?s=96&d=mm&r=g","caption":"H\u1eb1ng L\u00ea"},"url":"https:\/\/teky.edu.vn\/blog\/author\/lehang\/"}]}},"_links":{"self":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/11921","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/users\/26"}],"replies":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/comments?post=11921"}],"version-history":[{"count":0,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/11921\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media\/11923"}],"wp:attachment":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media?parent=11921"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/categories?post=11921"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/tags?post=11921"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}