{"id":6593,"date":"2024-12-21T15:40:37","date_gmt":"2024-12-21T15:40:37","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/chuyen-hang-thanh-cot-trong-excel\/"},"modified":"2024-12-21T15:40:37","modified_gmt":"2024-12-21T15:40:37","slug":"chuyen-hang-thanh-cot-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/chuyen-hang-thanh-cot-trong-excel\/","title":{"rendered":"Chuy\u1ec3n h\u00e0ng th\u00e0nh c\u1ed9t trong Excel"},"content":{"rendered":"
\n

\u0110\u00f4i khi, b\u1ea1n c\u1ea7n thay \u0111\u1ed5i h\u00e0ng th\u00e0nh c\u1ed9t ho\u1eb7c ng\u01b0\u1ee3c l\u1ea1i. Trong b\u00e0i vi\u1ebft n\u00e0y, H\u1ecdc Excel Online s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n m\u1ed9t v\u00e0i th\u1ee7 thu\u1eadt quen thu\u1ed9c \u0111\u1ec3 chuy\u1ec3n \u0111\u1ed5i ho\u1eb7c thay \u0111\u1ed5i h\u00e0ng th\u00e0nh c\u1ed9t v\u00e0 ng\u01b0\u1ee3c l\u1ea1i trong Excel.<\/p>\n

Thay \u0111\u1ed5i m\u1ed9t h\u00e0ng th\u00e0nh c\u1ed9t trong Excel<\/strong><\/p>\n

Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 m\u1ed9t d\u1eef li\u1ec7u h\u00e0ng nh\u01b0 h\u00ecnh sau v\u00e0 c\u1ea7n chuy\u1ec3n sang c\u1ed9t:<\/p>\n

\"doc-change-row-column-2\"<\/p>\n

\u0110\u1ea7u ti\u00ean, ch\u1ecdn v\u00e0 sao ch\u00e9p h\u00e0ng, sau \u0111\u00f3 ch\u1ecdn m\u1ed9t \u00f4 t\u00ednh m\u00e0 b\u1ea1n mu\u1ed1n d\u00e1n d\u1eef li\u1ec7u, nh\u1ea5p ph\u1ea3i v\u00e0 ch\u1ecdn d\u00e1n d\u1eef li\u1ec7u b\u1eb1ng l\u1ec7nh\u00a0Transpose\u00a0<\/strong><\/em>trong\u00a0Paste Options<\/strong><\/em>. H\u00e0ng \u0111\u00f3 s\u1ebd \u0111\u01b0\u1ee3c thay \u0111\u1ed5i th\u00e0nh c\u1ed9t nh\u01b0 sau:<\/p>\n

<\/p>\n

B\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn l\u1ec7nh\u00a0Transpose\u00a0<\/strong><\/em>t\u1eeb danh s\u00e1ch t\u00f9y ch\u1ecdn khi nh\u1ea5p ph\u1ea3i v\u00e0o \u00f4 t\u00ednh:<\/p>\n

<\/p>\n

\n
\n
\n
\n<\/a>\n<\/div>\n<\/div>\n
\n
\n
\n
\n<\/a>\n<\/div>\n<\/div>\n

Thay \u0111\u1ed5i nhi\u1ec1u h\u00e0ng th\u00e0nh c\u1ed9t trong Excel<\/strong><\/p>\n

Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 nhi\u1ec1u h\u00e0ng c\u1ea7n chuy\u1ec3n \u0111\u1ed5i nh\u01b0 trong h\u00ecnh sau:<\/p>\n

<\/p>\n

B\u1eb1ng l\u1ec7nh\u00a0Transpose\u00a0<\/strong><\/em>trong\u00a0Paste Options<\/strong><\/em>, b\u1ea1n d\u1ec5 d\u00e0ng thay \u0111\u1ed5i nhi\u1ec1u h\u00e0ng th\u00e0nh c\u1ed9t:<\/p>\n

<\/p>\n

C\u00e1c b\u01b0\u1edbc:<\/strong><\/p>\n

1. Ch\u1ecdn v\u00e0 sao ch\u00e9p nhi\u1ec1u h\u00e0ng.<\/p>\n

2. Ch\u1ecdn \u00f4 t\u00ednh b\u1ea1n mu\u1ed1n d\u00e1n v\u00e0 nh\u1ea5p ph\u1ea3i v\u00e0o n\u00f3.<\/p>\n

3. S\u1eed d\u1ee5ng l\u1ec7nh\u00a0Transpose\u00a0<\/strong><\/em>\u0111\u1ec3 d\u00e1n.<\/p>\n

Thay \u0111\u1ed5i m\u1ed9t c\u1ed9t th\u00e0nh h\u00e0ng trong Excel<\/strong><\/p>\n

N\u1ebfu b\u1ea1n mu\u1ed1n thay \u0111\u1ed5i d\u1eef li\u1ec7u c\u1ed9t th\u00e0nh h\u00e0ng nh\u01b0 trong h\u00ecnh sau:<\/p>\n

<\/p>\n

B\u1eb1ng l\u1ec7nh\u00a0Transpose<\/strong><\/em>, b\u1ea1n c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng th\u1ef1c hi\u1ec7n \u0111i\u1ec1u \u0111\u00f3:<\/p>\n

<\/p>\n

C\u00e1c b\u01b0\u1edbc:<\/strong><\/p>\n

1. Ch\u1ecdn v\u00e0 sao ch\u00e9p c\u1ed9t c\u1ea7n chuy\u1ec3n \u0111\u1ed5i.<\/p>\n

2. Ch\u1ecdn \u00f4 t\u00ednh b\u1ea1n mu\u1ed1n d\u00e1n v\u00e0 nh\u1ea5p ph\u1ea3i v\u00e0o n\u00f3.<\/p>\n

3. S\u1eed d\u1ee5ng l\u1ec7nh\u00a0Transpose\u00a0<\/strong><\/em>\u0111\u1ec3 d\u00e1n.<\/p>\n

Thay \u0111\u1ed5i nhi\u1ec1u c\u1ed9t th\u00e0nh h\u00e0ng trong Excel<\/strong><\/p>\n

\u0110\u1ec3 thay \u0111\u1ed5i nhi\u1ec1u c\u1ed9t th\u00e0nh h\u00e0ng nh\u01b0 trong h\u00ecnh sau:<\/p>\n

<\/p>\n

B\u1eb1ng l\u1ec7nh\u00a0Transpose<\/strong><\/em>, b\u1ea1n c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng th\u1ef1c hi\u1ec7n \u0111i\u1ec1u \u0111\u00f3:<\/p>\n

<\/p>\n

C\u00e1c b\u01b0\u1edbc:<\/strong><\/p>\n

1. Ch\u1ecdn v\u00e0 sao ch\u00e9p nhi\u1ec1u c\u1ed9t.<\/p>\n

2. Ch\u1ecdn \u00f4 t\u00ednh b\u1ea1n mu\u1ed1n d\u00e1n v\u00e0 nh\u1ea5p ph\u1ea3i v\u00e0o n\u00f3.<\/p>\n

3. S\u1eed d\u1ee5ng l\u1ec7nh\u00a0Transpose\u00a0<\/strong><\/em>\u0111\u1ec3 d\u00e1n.<\/p>\n<\/div>\n

\n

Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n

T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0\ud83d\udcd6<\/span><\/a><\/p>\n

H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n

HKD H\u1ecdc Excel Online
S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n

\n

\u00a9 document.currentScript.insertAdjacentHTML(‘afterend’, ” + new Intl.DateTimeFormat(document.documentElement.lang, {year: ‘numeric’}).format() + ”); H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

\n
\n
\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":6594,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-6593","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-nang-cao"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/6593","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=6593"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/6593\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/6594"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=6593"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=6593"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=6593"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}