{"id":11794,"date":"2025-01-15T05:06:27","date_gmt":"2025-01-15T05:06:27","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/cach-chuyen-doi-vung-du-lieu-thanh-bang-va-nguoc-lai-trong-excel\/"},"modified":"2025-01-15T05:06:27","modified_gmt":"2025-01-15T05:06:27","slug":"cach-chuyen-doi-vung-du-lieu-thanh-bang-va-nguoc-lai-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/cach-chuyen-doi-vung-du-lieu-thanh-bang-va-nguoc-lai-trong-excel\/","title":{"rendered":"C\u00e1ch chuy\u1ec3n \u0111\u1ed5i v\u00f9ng d\u1eef li\u1ec7u th\u00e0nh b\u1ea3ng v\u00e0 ng\u01b0\u1ee3c l\u1ea1i trong Excel"},"content":{"rendered":"
\n

Trong b\u00e0i vi\u1ebft n\u00e0y, H\u1ecdc Excel Online s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n c\u00e1ch chuy\u1ec3n \u0111\u1ed5i v\u00f9ng d\u1eef li\u1ec7u th\u00e0nh b\u1ea3ng v\u00e0 ng\u01b0\u1ee3c l\u1ea1i trong Excel.<\/p>\n

Chuy\u1ec3n \u0111\u1ed5i v\u00f9ng d\u1eef li\u1ec7u th\u00e0nh b\u1ea3ng trong Excel<\/strong><\/p>\n

\u0110\u1ec3 chuy\u1ec3n \u0111\u1ed5i v\u00f9ng d\u1eef li\u1ec7u th\u00e0nh b\u1ea3ng, h\u00e3y l\u00e0m nh\u01b0 sau:<\/p>\n

1. Ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u b\u1ea1n mu\u1ed1n chuy\u1ec3n \u0111\u1ed5i<\/p>\n

2. Nh\u1ea5p ch\u1ecdn Insert > Table<\/strong><\/em>, trong h\u1ed9p tho\u1ea1i Create Table<\/strong><\/em>, \u0111\u00e1nh d\u1ea5u ch\u1ecdn My table has headers<\/strong><\/em>\u00a0n\u1ebfu d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n c\u00f3 ti\u00eau \u0111\u1ec1.<\/p>\n

<\/a><\/p>\n

3. Nh\u1ea5n OK, v\u00e0 d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n \u0111\u00e3 \u0111\u01b0\u1ee3c chuy\u1ec3n \u0111\u1ed5i th\u00e0nh \u0111\u1ecbnh d\u1ea1ng b\u1ea3ng.<\/p>\n

<\/a><\/p>\n

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

M\u1eb9o.\u00a0<\/strong>Ngo\u00e0i nh\u1eefng c\u00e1ch tr\u00ean, b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 \u0111\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u th\u00e0nh d\u1ea1ng b\u1ea3ng bi\u1ec3u b\u1eb1ng ph\u01b0\u01a1ng ph\u00e1p d\u01b0\u1edbi \u0111\u00e2y.<\/p>\n

1. Ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u, sau \u0111\u00f3 nh\u1ea5p v\u00e0o Home > Format as Table<\/strong><\/em>, ch\u1ecdn m\u1ed9t ki\u1ec3u b\u1ea3ng b\u1ea1n th\u00edch t\u1eeb danh s\u00e1ch t\u00f9y ch\u1ecdn Format as Table<\/strong><\/em>.<\/p>\n

2. Trong h\u1ed9p tho\u1ea1i Format as Table<\/strong><\/em>, \u0111\u00e1nh d\u1ea5u ch\u1ecdn My table has headers\u00a0<\/strong><\/em>n\u1ebfu d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n c\u00f3 ti\u00eau \u0111\u1ec1, nh\u1ea5n OK \u0111\u1ec3 ho\u00e0n th\u00e0nh.<\/p>\n

Chuy\u1ec3n \u0111\u1ed5i b\u1ea3ng th\u00e0nh d\u1eef li\u1ec7u th\u00f4ng th\u01b0\u1eddng trong Excel<\/strong><\/p>\n

1. Ch\u1ecdn v\u00f9ng b\u1ea3ng bi\u1ec3u, nh\u1ea5p ph\u1ea3i v\u00e0 ch\u1ecdn Table > Convert to Range<\/strong><\/em>\u00a0t\u1eeb danh s\u00e1ch t\u00f9y ch\u1ecdn.<\/p>\n

<\/a><\/p>\n

M\u1eb9o.\u00a0<\/strong>B\u1ea1n c\u0169ng c\u00f3 th\u1ec3 ch\u1ecdn b\u1ea3ng, sau \u0111\u00f3 nh\u1ea5p v\u00e0o Design > Convert to Range<\/strong><\/em>.<\/p>\n

2. M\u1ed9t h\u1ed9p tho\u1ea1i hi\u1ec7n l\u00ean, nh\u1ea5n\u00a0Yes<\/strong><\/em>. B\u1ea3ng \u0111\u01b0\u1ee3c ch\u1ecdn s\u1ebd \u0111\u01b0\u1ee3c chuy\u1ec3n \u0111\u1ed5i th\u00e0nh d\u1eef li\u1ec7u th\u00f4ng th\u01b0\u1eddng.<\/p>\n

Ch\u00fa \u00fd.\u00a0<\/strong>Ph\u01b0\u01a1ng ph\u00e1p n\u00e0y ch\u1ec9 lo\u1ea1i b\u1ecf ki\u1ec3u \u0111\u1ecbnh d\u1ea1ng b\u1ea3ng, nh\u01b0ng v\u1eabn gi\u1eef m\u00e0u n\u1ec1n v\u00e0 m\u00e0u ch\u1eef c\u1ee7a b\u1ea3ng g\u1ed1c.<\/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":11795,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-11794","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\/11794","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=11794"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/11794\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/11795"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=11794"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=11794"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=11794"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}