{"id":11622,"date":"2025-01-15T04:36:13","date_gmt":"2025-01-15T04:36:13","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/cach-tao-va-dien-danh-sach-tuy-chon-moi-trong-excel\/"},"modified":"2025-01-15T04:36:13","modified_gmt":"2025-01-15T04:36:13","slug":"cach-tao-va-dien-danh-sach-tuy-chon-moi-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/cach-tao-va-dien-danh-sach-tuy-chon-moi-trong-excel\/","title":{"rendered":"C\u00e1ch t\u1ea1o v\u00e0 \u0111i\u1ec1n danh s\u00e1ch t\u00f9y ch\u1ecdn m\u1edbi trong Excel"},"content":{"rendered":"
\n

Trong b\u00e0i vi\u1ebft n\u00e0y, H\u1ecdc Excel Online<\/strong><\/a> s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch s\u1eed d\u1ee5ng danh s\u00e1ch t\u00f9y ch\u1ecdn \u2013 t\u1ea1o list trong excel<\/strong><\/a> v\u00e0 kh\u00f4ng c\u1ea7n g\u00f5 l\u1ea1i c\u00e1c n\u1ed9i dung tr\u00f9ng l\u1eb7p.<\/p>\n

C\u00e1ch t\u1ea1o danh s\u00e1ch t\u00f9y ch\u1ecdn m\u1edbi b\u1eb1ng Custom Lists.<\/strong><\/h2>\n

B\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng t\u00ednh n\u0103ng\u00a0Custom Lists\u00a0<\/strong><\/em>\u0111\u1ec3 t\u1ea1o danh s\u00e1ch t\u00f9y ch\u1ecdn, sau \u0111\u00f3 t\u1ea1o danh s\u00e1ch theo chi\u1ec1u d\u1ecdc hay chi\u1ec1u ngang theo \u00fd mu\u1ed1n c\u1ee7a b\u1ea1n.<\/p>\n

1. Nh\u1ea5p\u00a0File > Options\u00a0<\/strong><\/em>\u0111\u1ec3 m\u1edf h\u1ed9p tho\u1ea1i\u00a0Excel Options<\/strong><\/em>.<\/p>\n

2. Trong h\u1ed9p tho\u1ea1i Excel Options<\/strong><\/em>, nh\u1ea5p n\u00fat Advanced\u00a0<\/strong><\/em>\u1edf b\u1ea3ng b\u00ean tr\u00e1i, k\u00e9o xu\u1ed1ng ph\u1ea7n General<\/strong><\/em>\u00a0v\u00e0 nh\u1ea5n n\u00fat\u00a0Edit Custom List<\/strong><\/em>.<\/strong><\/p>\n

Ch\u00fa \u00fd.\u00a0<\/strong>N\u1ebfu b\u1ea1n \u0111ang s\u1eed d\u1ee5ng Excel 2007, nh\u1ea5p Office Button > Excel Options > Popular<\/strong><\/em>, sau \u0111\u00f3 b\u1ea1n s\u1ebd nh\u00ecn th\u1ea5y n\u00fat Edit Custom Lists<\/strong><\/em>\u00a0trong ph\u1ea7n Top options for working with Excel<\/strong><\/em>.<\/p>\n

<\/p>\n

3. Trong h\u1ed9p tho\u1ea1i\u00a0Options<\/strong><\/em>, ch\u1ecdn NEW LIST<\/strong><\/em>\u00a0trong h\u1ed9p Custom lists<\/strong><\/em>, g\u00f5 m\u1ed7i l\u1ef1a ch\u1ecdn v\u00e0o danh s\u00e1ch trong h\u1ed9p List entries<\/strong><\/em>, nh\u1ea5p n\u00fat Add<\/strong><\/em>.<\/p>\n

Ch\u00fa \u00fd.<\/strong><\/p>\n

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

(1) B\u1ea1n c\u1ea7n g\u00f5 danh s\u00e1ch c\u00e1c gi\u00e1 tr\u1ecb \u0111\u01b0\u1ee3c ph\u00e2n bi\u1ec7t b\u1edfi n\u00fat Enter ho\u1eb7c d\u1ea5u ph\u1ea9y.<\/p>\n

(2) N\u1ebfu c\u00e1c gi\u00e1 tr\u1ecb t\u1ed3n t\u1ea1i trong b\u1ea3ng t\u00ednh hi\u1ec7n t\u1ea1i, b\u1ea1n c\u00f3 th\u1ec3 nh\u1ea5p n\u00fat Browse\u00a0<\/strong><\/em>\u0111\u1eb1ng sau h\u1ed9p Import list from cells\u00a0<\/strong><\/em>\u0111\u1ec3 ch\u1ecdn c\u00e1c \u00f4 t\u00ednh, sau \u0111\u00f3 nh\u1ea5n n\u00fat Import<\/strong><\/em>.<\/p>\n

4. Nh\u1ea5n n\u00fat OK trong t\u1ea5t c\u1ea3 c\u00e1c h\u1ed9p tho\u1ea1i. Danh s\u00e1ch t\u00f9y ch\u1ecdn \u0111\u01b0\u1ee3c t\u1ea1o. Khi b\u1ea1n nh\u1eadp gi\u00e1 tr\u1ecb \u0111\u1ea7u ti\u00ean c\u1ee7a danh s\u00e1ch, sau \u0111\u00f3 sao ch\u00e9p sang c\u00e1c \u00f4 t\u00ednh theo \u00fd mu\u1ed1n, c\u00e1c gi\u00e1 tr\u1ecb trong danh s\u00e1ch s\u1ebd \u0111\u01b0\u1ee3c \u0111i\u1ec1n v\u00e0o c\u00e1c \u00f4 theo th\u1ee9 t\u1ef1. B\u1ea1n c\u00f3 th\u1ec3 \u0111i\u1ec1n theo chi\u1ec1u d\u1ecdc ho\u1eb7c chi\u1ec1u ngang.<\/p>\n

<\/p>\n

\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":11623,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-11622","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\/11622","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=11622"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/11622\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/11623"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=11622"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=11622"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=11622"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}