{"id":27845,"date":"2022-04-12T14:52:52","date_gmt":"2022-04-12T07:52:52","guid":{"rendered":"https:\/\/divineshop.vn\/tin-tuc\/?p=27845"},"modified":"2022-04-12T14:52:52","modified_gmt":"2022-04-12T07:52:52","slug":"cach-tao-list-trong-excel-ma-dan-van-phong-nao-cung-nen-biet","status":"publish","type":"post","link":"https:\/\/divineshop.vn\/tin-tuc\/cach-tao-list-trong-excel-ma-dan-van-phong-nao-cung-nen-biet\/","title":{"rendered":"C\u00e1ch t\u1ea1o List trong Excel m\u00e0 d\u00e2n v\u0103n ph\u00f2ng n\u00e0o c\u0169ng n\u00ean bi\u1ebft!"},"content":{"rendered":"<div class=\"content-inner\">\n<p><strong>T\u1ea1o list trong Excel cho ph\u00e9p ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 ch\u1ecdn d\u1eef li\u1ec7u \u0111\u1ec3 nh\u1eadp v\u00e0o \u00f4 theo danh s\u00e1ch \u0111\u00e3 \u0111\u01b0\u1ee3c c\u00e0i \u0111\u1eb7t t\u1eeb tr\u01b0\u1edbc, gi\u00fap d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c tr\u00ecnh b\u00e0y nh\u1ea5t qu\u00e1n v\u00e0 d\u1ec5 d\u00e0ng l\u1ecdc ra d\u1eef li\u1ec7u c\u00e1c c\u1ed9t d\u1ef1a tr\u00ean m\u1ed7i m\u1ee5c trong danh s\u00e1ch.<\/strong><\/p>\n<p>H\u00e3y tham kh\u1ea3o ngay b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y \u0111\u1ec3 s\u1edbm tr\u1edf th\u00e0nh cao th\u1ee7 Excel trong h\u1ecdc t\u1eadp v\u00e0 c\u00f4ng vi\u1ec7c c\u00e1c b\u1ea1n nh\u00e9!<img loading=\"lazy\" class=\"aligncenter size-full wp-image-552298\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/cach-tao-list-trong-excel-ma-dan-van-phong-nao-cung-nen-biet_6233f8abe1d8d.jpeg\" alt=\"\" width=\"1024\" height=\"576\" \/><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_17 counter-hierarchy counter-decimal ez-toc-grey\">\n<h2><span class=\"ez-toc-section\" id=\"Drop_List_la_gi_Su_dung_Drop_List_khi_nao\"><\/span><span id=\"Drop_List_la_gi_Su_dung_Drop_List_khi_nao\" class=\"ez-toc-section\"><\/span><strong><span style=\"font-size: 18pt\">Drop List l\u00e0 g\u00ec? S\u1eed d\u1ee5ng Drop List khi n\u00e0o?<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Drop List hay danh s\u00e1ch th\u1ea3 xu\u1ed1ng l\u00e0 <strong>ki\u1ec3u \u0111\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng v\u1edbi nhi\u1ec1u m\u1ee5c \u0111\u00edch ti\u1ec7n l\u1ee3i v\u00e0 h\u1eefu d\u1ee5ng<\/strong> nh\u01b0 sau:<\/p>\n<ul>\n<li>T\u1ea1o c\u00e1c danh m\u1ee5c c\u1ea7n nh\u1eadp v\u00e0o \u00f4 tr\u1ed1ng nhanh ch\u00f3ng.<\/li>\n<li>Ph\u00f9 h\u1ee3p cho c\u00e1c \u0111\u1ecba \u0111i\u1ec3m c\u1ea7n l\u1ea5y th\u00f4ng tin c\u00e1 nh\u00e2n v\u1edbi s\u1ed1 l\u01b0\u1ee3ng l\u1edbn.<\/li>\n<li>Gi\u00fap th\u1ef1c hi\u1ec7n khai b\u00e1o, ch\u1ea5m c\u00f4ng d\u1ec5 d\u00e0ng h\u01a1n t\u1ea1i c\u00e1c c\u01a1 quan, \u0111o\u00e0n th\u1ec3,\u2026<\/li>\n<li>Qu\u1ea3n l\u00fd chuy\u1ec7n kinh doanh th\u00f4ng qua Drop List c\u0169ng r\u1ea5t ti\u1ec7n l\u1ee3i.<\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"Cach_tao_Drop_List_trong_Excel_bang_Data_Validation\"><\/span><span id=\"Cach_tao_Drop_List_trong_Excel_bang_Data_Validation\" class=\"ez-toc-section\"><\/span><strong style=\"color: #1d1f20;font-size: 1.953em\"><span style=\"font-size: 18pt\">C\u00e1ch t\u1ea1o Drop List trong Excel b\u1eb1ng Data Validation<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><strong>B\u01b0\u1edbc 1:\u00a0<\/strong>M\u1edf\u00a0<strong>file Excel<\/strong> <strong>=&gt;<\/strong> Ch\u1ecdn\u00a0<strong>\u00f4 mu\u1ed1n t\u1ea1o Drop List<\/strong> <strong>=&gt;<\/strong> Ch\u1ecdn\u00a0<strong>th\u1ebb Data<\/strong> <strong>=&gt;<\/strong> Ch\u1ecdn\u00a0<strong>Data Validation.<\/strong><img loading=\"lazy\" class=\"aligncenter wp-image-551706 size-full\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/cach-tao-list-trong-excel-ma-dan-van-phong-nao-cung-nen-biet_6233f8ac7e038.gif\" alt=\"C\u00e1ch t\u1ea1o Drop List trong Excel b\u1eb1ng Data Validation - b\u01b0\u1edbc 1\" width=\"1440\" height=\"810\" \/><strong>B\u01b0\u1edbc 2<\/strong>: Ch\u1ecdn\u00a0<strong>tab Settings<\/strong> <strong>=&gt; <\/strong>Ch\u1ecdn\u00a0<strong>List <\/strong>trong\u00a0m\u1ee5c Allow.<img loading=\"lazy\" class=\"aligncenter size-full wp-image-551774\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/cach-tao-list-trong-excel-ma-dan-van-phong-nao-cung-nen-biet_6233f8adda47f.png\" alt=\"\" width=\"1920\" height=\"1029\" \/><strong>B\u01b0\u1edbc 3<\/strong>: \u0110i \u0111\u1ebfn <strong>m\u1ee5c Sources<\/strong> <strong>=&gt;<\/strong> <strong>K\u00e9o ch\u1ecdn c\u00e1c \u00f4 b\u1ea1n mu\u1ed1n l\u1eadp Drop List\u00a0=&gt;<\/strong> Nh\u1ea5n\u00a0<strong>OK<\/strong>\u00a0\u0111\u1ec3\u00a0<strong>t\u1ea1o Drop List trong Excel<\/strong>.<img loading=\"lazy\" class=\"aligncenter wp-image-551790 size-full\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/cach-tao-list-trong-excel-ma-dan-van-phong-nao-cung-nen-biet_6233f8b08f257.png\" alt=\"C\u00e1ch t\u1ea1o Drop List trong Excel b\u1eb1ng Data Validation - b\u01b0\u1edbc 3\" width=\"1920\" height=\"1030\" \/><strong>B\u01b0\u1edbc 4<\/strong>: K\u1ebft qu\u1ea3 thu v\u1ec1 s\u1ebd nh\u01b0 d\u01b0\u1edbi \u0111\u00e2y.<img loading=\"lazy\" class=\"aligncenter wp-image-551794 size-full\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/cach-tao-list-trong-excel-ma-dan-van-phong-nao-cung-nen-biet_6233f8b319dfc.png\" alt=\"C\u00e1ch t\u1ea1o Drop List trong Excel b\u1eb1ng Data Validation - b\u01b0\u1edbc 4\" width=\"1920\" height=\"1030\" \/><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Tao_List_Box_trong_Excel_co_phu_thuoc_vao_1_list_khac\"><\/span><span id=\"Tao_List_Box_trong_Excel_co_phu_thuoc_vao_1_list_khac\" class=\"ez-toc-section\"><\/span><strong><span style=\"font-size: 18pt\">T\u1ea1o List Box trong Excel c\u00f3 ph\u1ee5 thu\u1ed9c v\u00e0o 1 list kh\u00e1c<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>C\u00e1ch n\u00e0y s\u1ebd gi\u00fap b\u1ea1n c\u00f3 th\u1ec3 l\u1ea5y ra danh s\u00e1ch c\u00f3 li\u00ean quan \u0111\u1ebfn c\u00e1c t\u1eeb \u0111\u01b0\u1ee3c nh\u1eadp \u1edf 1 list kh\u00e1c.<\/p>\n<p><strong>B\u01b0\u1edbc 1<\/strong>: Th\u1ef1c hi\u1ec7n nh\u1eadp li\u1ec7u c\u00e1c d\u1eef li\u1ec7u c\u00f3 li\u00ean quan v\u1edbi nhau nh\u01b0 b\u00ean d\u01b0\u1edbi.<img loading=\"lazy\" class=\"aligncenter wp-image-551800 size-full\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/cach-tao-list-trong-excel-ma-dan-van-phong-nao-cung-nen-biet_6233f8b601bef.png\" alt=\"T\u1ea1o List Box c\u00f3 ph\u1ee5 thu\u1ed9c v\u00e0o 1 list kh\u00e1c - b\u01b0\u1edbc 1\" width=\"1920\" height=\"1031\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 2<\/strong>: Th\u1ef1c hi\u1ec7n c\u00e1c b\u01b0\u1edbc \u0111\u1eb7t t\u00ean cho c\u00e1c T\u1ec9nh nh\u01b0 sau:<\/p>\n<p><strong>T\u00f4 ch\u1ecdn<\/strong> d\u00e3y \u00f4 l\u00e0 th\u00e0nh ph\u1ed1 c\u1ee7a 1 t\u1ec9nh b\u1ea5t k\u1ef3 <strong>=&gt;<\/strong> Nh\u1ea5p <strong>chu\u1ed9t ph\u1ea3i<\/strong> <strong>=&gt;<\/strong> Ch\u1ecdn\u00a0<strong>Define Name<\/strong> <strong>=&gt;<\/strong> \u1ede h\u1ed9p tho\u1ea1i hi\u1ec7n l\u00ean\u00a0<strong>nh\u1eadp t\u00ean c\u1ee7a c\u00e1c t\u1ec9nh t\u01b0\u01a1ng \u1ee9ng<\/strong>:<img loading=\"lazy\" class=\"aligncenter wp-image-551801 size-full\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/cach-tao-list-trong-excel-ma-dan-van-phong-nao-cung-nen-biet_6233f8b9df372.png\" alt=\"T\u1ea1o List Box c\u00f3 ph\u1ee5 thu\u1ed9c v\u00e0o 1 list kh\u00e1c - b\u01b0\u1edbc 2\" width=\"1920\" height=\"1028\" \/>\u1ede h\u1ed9p tho\u1ea1i hi\u1ec7n l\u00ean\u00a0<strong>nh\u1eadp t\u00ean c\u1ee7a c\u00e1c t\u1ec9nh t\u01b0\u01a1ng \u1ee9ng<\/strong>:<\/p>\n<p><strong>L\u01b0u \u00fd:<\/strong>\u00a0T\u00ean c\u1ee7a c\u00e1c\u00a0<strong>T\u1ec9nh<\/strong>\u00a0\u0111\u01b0\u1ee3c \u0111\u1eb7t ph\u1ea3i gi\u1ed1ng v\u1edbi t\u00ean c\u1ee7a\u00a0<strong>T\u1ec9nh \u0111\u00e3 nh\u1eadp<\/strong> +\u00a0<strong>kh\u00f4ng c\u00f3 kho\u1ea3ng tr\u1eafng<\/strong>.<\/p>\n<p><strong>V\u00ed d\u1ee5:<\/strong><\/p>\n<p><strong>T\u00f4 ch\u1ecdn t\u1eeb B1 \u0111\u1ebfn B7<\/strong>: \u0110\u1eb7t t\u00ean Qu\u1ea3ngNinh.<\/p>\n<p><strong>T\u00f4<\/strong><b> ch\u1ecdn t\u1eeb C1 \u0111\u1ebfn C5:<\/b>\u00a0\u0110\u1eb7t t\u00ean\u00a0H\u1ea3iPh\u00f2ng.<\/p>\n<p><strong>T\u00f4<\/strong><b> ch\u1ecdn t\u1eeb D1 \u0111\u1ebfn D7:<\/b>\u00a0\u0110\u1eb7t t\u00ean Th\u00e1iB\u00ecnh.<img loading=\"lazy\" class=\"aligncenter size-full wp-image-551802\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/cach-tao-list-trong-excel-ma-dan-van-phong-nao-cung-nen-biet_6233f8bdc2cd1.png\" alt=\"\" width=\"1920\" height=\"1029\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 3:<\/strong>\u00a0Ch\u1ecdn\u00a0<strong>\u00f4 c\u1ea7n \u0111\u1eb7t Drop List<\/strong> <strong>=&gt;<\/strong> Ch\u1ecdn\u00a0<strong>th\u1ebb Data<\/strong> <strong>=&gt;<\/strong> Nh\u1ea5n ch\u1ecdn\u00a0<strong>Data Validation<\/strong>.<img loading=\"lazy\" class=\"aligncenter wp-image-551814 size-full\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/cach-tao-list-trong-excel-ma-dan-van-phong-nao-cung-nen-biet_6233f8c0ac81b.png\" alt=\"T\u1ea1o List Box c\u00f3 ph\u1ee5 thu\u1ed9c v\u00e0o 1 list kh\u00e1c - b\u01b0\u1edbc 3\" width=\"1920\" height=\"1028\" \/><strong>B\u01b0\u1edbc 4:<\/strong> \u1ede h\u1ed9p tho\u1ea1i hi\u1ec7n l\u00ean <strong>=&gt;<\/strong> Ch\u1ecdn<strong>\u00a0Setting<\/strong> <strong>=&gt;<\/strong> \u0110i \u0111\u1ebfn\u00a0<strong>m\u1ee5c Allow<\/strong> <strong>=&gt;<\/strong> Nh\u1ea5n ch\u1ecdn <strong>List<\/strong>.<\/p>\n<p>\u1ede <strong>ph\u1ea7n Source<\/strong>\u00a0b\u1ea1n nh\u1eadp c\u00f4ng th\u1ee9c sau:<strong> =INDIRECT(SUBSTITUTE(C11;\u201d \u201c;\u201d\u201d))<\/strong> =&gt; Nh\u1ea5n\u00a0<strong>OK<\/strong>.<\/p>\n<p><strong>Gi\u1ea3i th\u00edch h\u00e0m:<\/strong><strong>SUBSTITUTE(C11;\u201d \u201c;\u201d\u201d): <\/strong>D\u1eef li\u1ec7u \u0111\u01b0\u1ee3c l\u1ea5y \u1edf \u00f4 C11 sau \u0111\u00f3 b\u1ecf \u0111i d\u1ea5u c\u00e1ch \u1edf gi\u1eefa \u0111\u1ec3 \u0111\u00fang v\u1edbi t\u00ean b\u1ea1n \u0111\u00e3 th\u1ef1c hi\u1ec7n \u0111\u1eb7t \u1edf b\u01b0\u1edbc 2.<\/p>\n<p><strong>H\u00e0m INDIRECT:<\/strong> C\u00f3 vai tr\u00f2 gi\u00e1n ti\u1ebfp l\u1ea5y c\u00e1c d\u00e3y \u00f4 c\u00f3 ch\u1ee9a T\u1ec9nh \u0111\u00e3 \u0111\u1eb7t t\u00ean b\u00ean tr\u00ean th\u00edch h\u1ee3p v\u1edbi T\u1ec9nh \u0111\u01b0\u1ee3c nh\u1eadp trong b\u1ea3ng b\u00ean d\u01b0\u1edbi.<img loading=\"lazy\" class=\"aligncenter wp-image-551820 size-full\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/cach-tao-list-trong-excel-ma-dan-van-phong-nao-cung-nen-biet_6233f8c381c25.png\" alt=\"T\u1ea1o List Box c\u00f3 ph\u1ee5 thu\u1ed9c v\u00e0o 1 list kh\u00e1c - b\u01b0\u1edbc 4\" width=\"1920\" height=\"1029\" \/><strong>B\u01b0\u1edbc 5<\/strong>:\u00a0V\u00e0 \u0111\u00e2y l\u00e0 danh s\u00e1ch th\u1ea3 xu\u1ed1ng c\u00f3 ph\u1ee5 thu\u1ed9c 1 danh s\u00e1ch kh\u00e1c \u0111\u00e3 \u0111\u01b0\u1ee3c t\u1ea1o.<img loading=\"lazy\" class=\"aligncenter wp-image-551831 size-full\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/cach-tao-list-trong-excel-ma-dan-van-phong-nao-cung-nen-biet_6233f8c61ddf8.png\" alt=\"T\u1ea1o List Box c\u00f3 ph\u1ee5 thu\u1ed9c v\u00e0o 1 list kh\u00e1c - b\u01b0\u1edbc 5\" width=\"1920\" height=\"1029\" \/><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cach_xoa_Drop_List_trong_Excel\"><\/span><span id=\"Cach_xoa_Drop_List_trong_Excel\" class=\"ez-toc-section\"><\/span><span style=\"font-size: 18pt\"><strong>C\u00e1ch x\u00f3a Drop List trong Excel<\/strong><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><strong>B\u01b0\u1edbc 1:\u00a0<\/strong>Ch\u1ecdn\u00a0<strong>\u00f4 \u0111\u00e3 \u0111\u1ecbnh d\u1ea1ng Drop List<\/strong> <strong>=&gt;<\/strong> Ch\u1ecdn\u00a0<strong>th\u1ebb Home<\/strong>.<img loading=\"lazy\" class=\"aligncenter wp-image-551832 size-full\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/cach-tao-list-trong-excel-ma-dan-van-phong-nao-cung-nen-biet_6233f8c8c8449.png\" alt=\"\" width=\"1920\" height=\"1030\" \/><strong>B\u01b0\u1edbc 2<\/strong>: T\u1ea1i<strong>\u00a0Editing<\/strong> <strong>=&gt;<\/strong> Nh\u1ea5n v\u00e0o\u00a0<strong>Clear<\/strong> <strong>=&gt;<\/strong> Ch\u1ecdn\u00a0<strong>Clear All<\/strong>\u00a0\u0111\u1ec3\u00a0x\u00f3a Drop List trong Excel.<img loading=\"lazy\" class=\"aligncenter wp-image-551833 size-full\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/cach-tao-list-trong-excel-ma-dan-van-phong-nao-cung-nen-biet_6233f8cbadad5.png\" alt=\"\" width=\"1920\" height=\"1031\" \/><span style=\"font-size: 18pt\"><strong>T\u1ea1m k\u1ebft v\u1ec1 t\u1ea1o List trong Excel<\/strong><\/span><\/p>\n<p>Tr\u00ean \u0111\u00e2y l\u00e0 <strong>c\u00e1c c\u00e1ch c\u00f3 th\u1ec3 gi\u00fap b\u1ea1n t\u1ea1o Drop List trong Excel<\/strong> m\u00e0 Divine Shop chia s\u1ebb \u0111\u1ebfn m\u1ecdi ng\u01b0\u1eddi. N\u1ebfu th\u1ea5y b\u00e0i vi\u1ebft h\u1eefu \u00edch, h\u00e3y chia s\u1ebb n\u00f3 \u0111\u1ebfn b\u1ea1n b\u00e8 v\u00e0 ng\u01b0\u1eddi th\u00e2n c\u00e1c b\u1ea1n nh\u00e9. Ch\u00fac b\u1ea1n th\u00e0nh c\u00f4ng!<\/p>\n<\/div>\n<\/div>\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/divineshop.vn\/search?q=netflix\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" width=\"728\" height=\"240\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2025\/11\/Netflix.png\" alt=\"\" class=\"wp-image-284289\" srcset=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2025\/11\/Netflix.png 728w, https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2025\/11\/Netflix-300x99.png 300w, https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2025\/11\/Netflix-150x49.png 150w, https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2025\/11\/Netflix-696x229.png 696w\" sizes=\"(max-width: 728px) 100vw, 728px\" \/><\/a><\/figure>\n\n\n\n<!--nextpage-->\n","protected":false},"excerpt":{"rendered":"<p>T\u1ea1o list trong Excel cho ph\u00e9p ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 ch\u1ecdn d\u1eef li\u1ec7u \u0111\u1ec3 nh\u1eadp v\u00e0o \u00f4 theo danh s\u00e1ch \u0111\u00e3 \u0111\u01b0\u1ee3c c\u00e0i \u0111\u1eb7t t\u1eeb tr\u01b0\u1edbc, gi\u00fap d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c tr\u00ecnh b\u00e0y nh\u1ea5t qu\u00e1n v\u00e0 d\u1ec5 d\u00e0ng l\u1ecdc ra d\u1eef li\u1ec7u c\u00e1c c\u1ed9t d\u1ef1a tr\u00ean m\u1ed7i m\u1ee5c trong danh s\u00e1ch. H\u00e3y tham kh\u1ea3o ngay b\u00e0i [&hellip;]<\/p>\n","protected":false},"author":12,"featured_media":27846,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false},"categories":[257,148],"tags":[238],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v18.1 (Yoast SEO v18.2) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<meta name=\"description\" content=\"T\u1ea1o list trong Excel cho ph\u00e9p ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 ch\u1ecdn d\u1eef li\u1ec7u \u0111\u1ec3 nh\u1eadp v\u00e0o \u00f4 theo danh s\u00e1ch \u0111\u00e3 \u0111\u01b0\u1ee3c c\u00e0i \u0111\u1eb7t t\u1eeb tr\u01b0\u1edbc, gi\u00fap d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c tr\u00ecnh b\u00e0y nh\u1ea5t qu\u00e1n\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/divineshop.vn\/tin-tuc\/cach-tao-list-trong-excel-ma-dan-van-phong-nao-cung-nen-biet\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"C\u00e1ch t\u1ea1o List trong Excel m\u00e0 d\u00e2n v\u0103n ph\u00f2ng n\u00e0o c\u0169ng n\u00ean bi\u1ebft!\" \/>\n<meta property=\"og:description\" content=\"T\u1ea1o list trong Excel cho ph\u00e9p ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 ch\u1ecdn d\u1eef li\u1ec7u \u0111\u1ec3 nh\u1eadp v\u00e0o \u00f4 theo danh s\u00e1ch \u0111\u00e3 \u0111\u01b0\u1ee3c c\u00e0i \u0111\u1eb7t t\u1eeb tr\u01b0\u1edbc, gi\u00fap d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c tr\u00ecnh b\u00e0y nh\u1ea5t qu\u00e1n\" \/>\n<meta property=\"og:url\" content=\"https:\/\/divineshop.vn\/tin-tuc\/cach-tao-list-trong-excel-ma-dan-van-phong-nao-cung-nen-biet\/\" \/>\n<meta property=\"og:site_name\" content=\"Divine News\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/divineshop.vn\" \/>\n<meta property=\"article:published_time\" content=\"2022-04-12T07:52:52+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/cach-tao-list-trong-excel-ma-dan-van-phong-nao-cung-nen-biet_6233f8a57bf0f.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"1080\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"CTV\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 ph\u00fat\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#organization\",\"name\":\"Divine News\",\"url\":\"https:\/\/divineshop.vn\/tin-tuc\/\",\"sameAs\":[\"https:\/\/www.facebook.com\/divineshop.vn\",\"https:\/\/www.instagram.com\/divineshop.game\/\",\"https:\/\/www.youtube.com\/DivineTVN\"],\"logo\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#logo\",\"inLanguage\":\"vi\",\"url\":\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/Avatar.jpg\",\"contentUrl\":\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/Avatar.jpg\",\"width\":960,\"height\":960,\"caption\":\"Divine News\"},\"image\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#logo\"}},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#website\",\"url\":\"https:\/\/divineshop.vn\/tin-tuc\/\",\"name\":\"Divine News\",\"description\":\"Tin hay m\u1ed7i ng\u00e0y\",\"publisher\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/divineshop.vn\/tin-tuc\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"vi\"},{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/cach-tao-list-trong-excel-ma-dan-van-phong-nao-cung-nen-biet\/#primaryimage\",\"inLanguage\":\"vi\",\"url\":\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/cach-tao-list-trong-excel-ma-dan-van-phong-nao-cung-nen-biet_6233f8a57bf0f.png\",\"contentUrl\":\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/cach-tao-list-trong-excel-ma-dan-van-phong-nao-cung-nen-biet_6233f8a57bf0f.png\",\"width\":1920,\"height\":1080},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/cach-tao-list-trong-excel-ma-dan-van-phong-nao-cung-nen-biet\/#webpage\",\"url\":\"https:\/\/divineshop.vn\/tin-tuc\/cach-tao-list-trong-excel-ma-dan-van-phong-nao-cung-nen-biet\/\",\"name\":\"C\u00e1ch t\u1ea1o List trong Excel m\u00e0 d\u00e2n v\u0103n ph\u00f2ng n\u00e0o c\u0169ng n\u00ean bi\u1ebft! - Divine News\",\"isPartOf\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/cach-tao-list-trong-excel-ma-dan-van-phong-nao-cung-nen-biet\/#primaryimage\"},\"datePublished\":\"2022-04-12T07:52:52+00:00\",\"dateModified\":\"2022-04-12T07:52:52+00:00\",\"description\":\"T\u1ea1o list trong Excel cho ph\u00e9p ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 ch\u1ecdn d\u1eef li\u1ec7u \u0111\u1ec3 nh\u1eadp v\u00e0o \u00f4 theo danh s\u00e1ch \u0111\u00e3 \u0111\u01b0\u1ee3c c\u00e0i \u0111\u1eb7t t\u1eeb tr\u01b0\u1edbc, gi\u00fap d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c tr\u00ecnh b\u00e0y nh\u1ea5t qu\u00e1n\",\"breadcrumb\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/cach-tao-list-trong-excel-ma-dan-van-phong-nao-cung-nen-biet\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/divineshop.vn\/tin-tuc\/cach-tao-list-trong-excel-ma-dan-van-phong-nao-cung-nen-biet\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/cach-tao-list-trong-excel-ma-dan-van-phong-nao-cung-nen-biet\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/divineshop.vn\/tin-tuc\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"C\u00e1ch t\u1ea1o List trong Excel m\u00e0 d\u00e2n v\u0103n ph\u00f2ng n\u00e0o c\u0169ng n\u00ean bi\u1ebft!\"}]},{\"@type\":\"Article\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/cach-tao-list-trong-excel-ma-dan-van-phong-nao-cung-nen-biet\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/cach-tao-list-trong-excel-ma-dan-van-phong-nao-cung-nen-biet\/#webpage\"},\"author\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#\/schema\/person\/ab675a5edaf3a6c9f037d16aa192413a\"},\"headline\":\"C\u00e1ch t\u1ea1o List trong Excel m\u00e0 d\u00e2n v\u0103n ph\u00f2ng n\u00e0o c\u0169ng n\u00ean bi\u1ebft!\",\"datePublished\":\"2022-04-12T07:52:52+00:00\",\"dateModified\":\"2022-04-12T07:52:52+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/cach-tao-list-trong-excel-ma-dan-van-phong-nao-cung-nen-biet\/#webpage\"},\"wordCount\":901,\"publisher\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#organization\"},\"image\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/cach-tao-list-trong-excel-ma-dan-van-phong-nao-cung-nen-biet\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/cach-tao-list-trong-excel-ma-dan-van-phong-nao-cung-nen-biet_6233f8a57bf0f.png\",\"keywords\":[\"Microsoft Excel\"],\"articleSection\":[\"Ki\u1ebfn th\u1ee9c\",\"M\u1eb8O HAY\"],\"inLanguage\":\"vi\",\"copyrightYear\":\"2022\",\"copyrightHolder\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#organization\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#\/schema\/person\/ab675a5edaf3a6c9f037d16aa192413a\",\"name\":\"CTV\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#personlogo\",\"inLanguage\":\"vi\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/99e99dbd029810d7d24fba0cc828c79b?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/99e99dbd029810d7d24fba0cc828c79b?s=96&d=mm&r=g\",\"caption\":\"CTV\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"description":"T\u1ea1o list trong Excel cho ph\u00e9p ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 ch\u1ecdn d\u1eef li\u1ec7u \u0111\u1ec3 nh\u1eadp v\u00e0o \u00f4 theo danh s\u00e1ch \u0111\u00e3 \u0111\u01b0\u1ee3c c\u00e0i \u0111\u1eb7t t\u1eeb tr\u01b0\u1edbc, gi\u00fap d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c tr\u00ecnh b\u00e0y nh\u1ea5t qu\u00e1n","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:\/\/divineshop.vn\/tin-tuc\/cach-tao-list-trong-excel-ma-dan-van-phong-nao-cung-nen-biet\/","og_locale":"vi_VN","og_type":"article","og_title":"C\u00e1ch t\u1ea1o List trong Excel m\u00e0 d\u00e2n v\u0103n ph\u00f2ng n\u00e0o c\u0169ng n\u00ean bi\u1ebft!","og_description":"T\u1ea1o list trong Excel cho ph\u00e9p ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 ch\u1ecdn d\u1eef li\u1ec7u \u0111\u1ec3 nh\u1eadp v\u00e0o \u00f4 theo danh s\u00e1ch \u0111\u00e3 \u0111\u01b0\u1ee3c c\u00e0i \u0111\u1eb7t t\u1eeb tr\u01b0\u1edbc, gi\u00fap d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c tr\u00ecnh b\u00e0y nh\u1ea5t qu\u00e1n","og_url":"https:\/\/divineshop.vn\/tin-tuc\/cach-tao-list-trong-excel-ma-dan-van-phong-nao-cung-nen-biet\/","og_site_name":"Divine News","article_publisher":"https:\/\/www.facebook.com\/divineshop.vn","article_published_time":"2022-04-12T07:52:52+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/cach-tao-list-trong-excel-ma-dan-van-phong-nao-cung-nen-biet_6233f8a57bf0f.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_misc":{"Written by":"CTV","Est. reading time":"6 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Organization","@id":"https:\/\/divineshop.vn\/tin-tuc\/#organization","name":"Divine News","url":"https:\/\/divineshop.vn\/tin-tuc\/","sameAs":["https:\/\/www.facebook.com\/divineshop.vn","https:\/\/www.instagram.com\/divineshop.game\/","https:\/\/www.youtube.com\/DivineTVN"],"logo":{"@type":"ImageObject","@id":"https:\/\/divineshop.vn\/tin-tuc\/#logo","inLanguage":"vi","url":"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/Avatar.jpg","contentUrl":"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/Avatar.jpg","width":960,"height":960,"caption":"Divine News"},"image":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/#logo"}},{"@type":"WebSite","@id":"https:\/\/divineshop.vn\/tin-tuc\/#website","url":"https:\/\/divineshop.vn\/tin-tuc\/","name":"Divine News","description":"Tin hay m\u1ed7i ng\u00e0y","publisher":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/divineshop.vn\/tin-tuc\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"vi"},{"@type":"ImageObject","@id":"https:\/\/divineshop.vn\/tin-tuc\/cach-tao-list-trong-excel-ma-dan-van-phong-nao-cung-nen-biet\/#primaryimage","inLanguage":"vi","url":"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/cach-tao-list-trong-excel-ma-dan-van-phong-nao-cung-nen-biet_6233f8a57bf0f.png","contentUrl":"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/cach-tao-list-trong-excel-ma-dan-van-phong-nao-cung-nen-biet_6233f8a57bf0f.png","width":1920,"height":1080},{"@type":"WebPage","@id":"https:\/\/divineshop.vn\/tin-tuc\/cach-tao-list-trong-excel-ma-dan-van-phong-nao-cung-nen-biet\/#webpage","url":"https:\/\/divineshop.vn\/tin-tuc\/cach-tao-list-trong-excel-ma-dan-van-phong-nao-cung-nen-biet\/","name":"C\u00e1ch t\u1ea1o List trong Excel m\u00e0 d\u00e2n v\u0103n ph\u00f2ng n\u00e0o c\u0169ng n\u00ean bi\u1ebft! - Divine News","isPartOf":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/#website"},"primaryImageOfPage":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/cach-tao-list-trong-excel-ma-dan-van-phong-nao-cung-nen-biet\/#primaryimage"},"datePublished":"2022-04-12T07:52:52+00:00","dateModified":"2022-04-12T07:52:52+00:00","description":"T\u1ea1o list trong Excel cho ph\u00e9p ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 ch\u1ecdn d\u1eef li\u1ec7u \u0111\u1ec3 nh\u1eadp v\u00e0o \u00f4 theo danh s\u00e1ch \u0111\u00e3 \u0111\u01b0\u1ee3c c\u00e0i \u0111\u1eb7t t\u1eeb tr\u01b0\u1edbc, gi\u00fap d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c tr\u00ecnh b\u00e0y nh\u1ea5t qu\u00e1n","breadcrumb":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/cach-tao-list-trong-excel-ma-dan-van-phong-nao-cung-nen-biet\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/divineshop.vn\/tin-tuc\/cach-tao-list-trong-excel-ma-dan-van-phong-nao-cung-nen-biet\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/divineshop.vn\/tin-tuc\/cach-tao-list-trong-excel-ma-dan-van-phong-nao-cung-nen-biet\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/divineshop.vn\/tin-tuc\/"},{"@type":"ListItem","position":2,"name":"C\u00e1ch t\u1ea1o List trong Excel m\u00e0 d\u00e2n v\u0103n ph\u00f2ng n\u00e0o c\u0169ng n\u00ean bi\u1ebft!"}]},{"@type":"Article","@id":"https:\/\/divineshop.vn\/tin-tuc\/cach-tao-list-trong-excel-ma-dan-van-phong-nao-cung-nen-biet\/#article","isPartOf":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/cach-tao-list-trong-excel-ma-dan-van-phong-nao-cung-nen-biet\/#webpage"},"author":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/#\/schema\/person\/ab675a5edaf3a6c9f037d16aa192413a"},"headline":"C\u00e1ch t\u1ea1o List trong Excel m\u00e0 d\u00e2n v\u0103n ph\u00f2ng n\u00e0o c\u0169ng n\u00ean bi\u1ebft!","datePublished":"2022-04-12T07:52:52+00:00","dateModified":"2022-04-12T07:52:52+00:00","mainEntityOfPage":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/cach-tao-list-trong-excel-ma-dan-van-phong-nao-cung-nen-biet\/#webpage"},"wordCount":901,"publisher":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/#organization"},"image":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/cach-tao-list-trong-excel-ma-dan-van-phong-nao-cung-nen-biet\/#primaryimage"},"thumbnailUrl":"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/cach-tao-list-trong-excel-ma-dan-van-phong-nao-cung-nen-biet_6233f8a57bf0f.png","keywords":["Microsoft Excel"],"articleSection":["Ki\u1ebfn th\u1ee9c","M\u1eb8O HAY"],"inLanguage":"vi","copyrightYear":"2022","copyrightHolder":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/#organization"}},{"@type":"Person","@id":"https:\/\/divineshop.vn\/tin-tuc\/#\/schema\/person\/ab675a5edaf3a6c9f037d16aa192413a","name":"CTV","image":{"@type":"ImageObject","@id":"https:\/\/divineshop.vn\/tin-tuc\/#personlogo","inLanguage":"vi","url":"https:\/\/secure.gravatar.com\/avatar\/99e99dbd029810d7d24fba0cc828c79b?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/99e99dbd029810d7d24fba0cc828c79b?s=96&d=mm&r=g","caption":"CTV"}}]}},"_links":{"self":[{"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/27845"}],"collection":[{"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/users\/12"}],"replies":[{"embeddable":true,"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/comments?post=27845"}],"version-history":[{"count":2,"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/27845\/revisions"}],"predecessor-version":[{"id":71925,"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/27845\/revisions\/71925"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/media\/27846"}],"wp:attachment":[{"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/media?parent=27845"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/categories?post=27845"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/tags?post=27845"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}