{"id":392632,"date":"2023-06-08T16:45:00","date_gmt":"2023-06-08T09:45:00","guid":{"rendered":"https:\/\/muaban.net\/blog\/?p=392632"},"modified":"2023-10-18T09:35:06","modified_gmt":"2023-10-18T02:35:06","slug":"cach-tao-lua-chon-trong-google-sheet","status":"publish","type":"post","link":"https:\/\/muaban.net\/blog\/cach-tao-lua-chon-trong-google-sheet-392632\/","title":{"rendered":"[Video] C\u00e1ch T\u1ea1o L\u1ef1a Ch\u1ecdn Trong Google Sheet Nhanh Ch\u00f3ng, D\u1ec5 L\u00e0m"},"content":{"rendered":"<span class=\"span-reading-time rt-reading-time\" style=\"display: block;\"><span class=\"rt-label rt-prefix\">Th\u1eddi gian \u0111\u1ecdc:<\/span> <span class=\"rt-time\"> 6<\/span> <span class=\"rt-label rt-postfix\">ph\u00fat<\/span><\/span>\r\n<h2 style=\"text-align: justify;\"><em>B\u1ea1n \u0111ang c\u1ea7n t\u1ea1o m\u1ed9t danh s\u00e1ch l\u1ef1a ch\u1ecdn trong Google Sheet? B\u1ea1n \u0111ang loay hoay ch\u01b0a bi\u1ebft <strong>c\u00e1ch t\u1ea1o l\u1ef1a ch\u1ecdn trong Google Sheet<\/strong> nh\u01b0 th\u1ebf n\u00e0o cho \u0111\u00fang? V\u1eady th\u00ec b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y s\u1ebd h\u01b0\u1edbng d\u1eabn th\u1eadt chi ti\u1ebft, gi\u00fap b\u1ea1n \u1ee9ng d\u1ee5ng \u0111\u01b0\u1ee3c ngay v\u00e0o c\u00f4ng vi\u1ec7c. \u0110\u1eebng b\u1ecf qua nh\u00e9!<\/em><\/h2>\r\n<p><iframe loading=\"lazy\" src=\"https:\/\/drive.google.com\/file\/d\/1RUNNJQNHQSEdYkQEsKKL5bZoZCLOYsiK\/preview\" width=\"100%\" height=\"480px\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\r\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_75 counter-hierarchy ez-toc-counter ez-toc-light-blue ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">M\u1ee5c l\u1ee5c<\/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-3'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/muaban.net\/blog\/cach-tao-lua-chon-trong-google-sheet-392632\/#1-cach-tao-lua-chon-drop-list-khi-co-san-du-lieu\" >1. C\u00e1ch t\u1ea1o l\u1ef1a ch\u1ecdn (drop-list) khi c\u00f3 s\u1eb5n d\u1eef li\u1ec7u<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/muaban.net\/blog\/cach-tao-lua-chon-trong-google-sheet-392632\/#2-cach-tao-danh-sach-lua-chon-drop-list-bang-cach-nhap-thu-cong\" >2. C\u00e1ch t\u1ea1o danh s\u00e1ch l\u1ef1a ch\u1ecdn (drop-list) b\u1eb1ng c\u00e1ch nh\u1eadp th\u1ee7 c\u00f4ng<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/muaban.net\/blog\/cach-tao-lua-chon-trong-google-sheet-392632\/#3-cach-tao-danh-sach-lua-chon-drop-list-co-mau\" >3. C\u00e1ch t\u1ea1o danh s\u00e1ch l\u1ef1a ch\u1ecdn (drop-list) c\u00f3 m\u00e0u<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/muaban.net\/blog\/cach-tao-lua-chon-trong-google-sheet-392632\/#4-cach-xoa-danh-sach-lua-chon-drop-list\" >4. C\u00e1ch xo\u00e1 danh s\u00e1ch l\u1ef1a ch\u1ecdn (drop-list)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/muaban.net\/blog\/cach-tao-lua-chon-trong-google-sheet-392632\/#5-nhung-uu-diem-khi-tao-danh-sach-lua-chon-trong-google-sheet\" >5. Nh\u1eefng \u01b0u \u0111i\u1ec3m khi t\u1ea1o danh s\u00e1ch l\u1ef1a ch\u1ecdn trong Google Sheet<\/a><\/li><\/ul><\/nav><\/div>\n<h3><span class=\"ez-toc-section\" id=\"1-cach-tao-lua-chon-drop-list-khi-co-san-du-lieu\"><\/span><strong><span style=\"color: initial;\">1. C\u00e1ch t\u1ea1o l\u1ef1a ch\u1ecdn (drop-list) khi c\u00f3 s\u1eb5n d\u1eef li\u1ec7u<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\r\n<p>Khi b\u1ea1n c\u00f3 s\u1eb5n m\u1ed9t danh s\u00e1ch d\u1eef li\u1ec7u d\u00e0i c\u1ea7n t\u1ea1o danh s\u00e1ch l\u1ef1a ch\u1ecdn trong <a href=\"https:\/\/vi.wikipedia.org\/wiki\/Google_Sheets\" target=\"_blank\" rel=\"nofollow noopener\">Google Sheets <\/a>\u00a0th\u00ec \u0111\u1eebng b\u1ecf qua nh\u1eefng 6 b\u01b0\u1edbc chi ti\u1ebft d\u01b0\u1edbi \u0111\u00e2y:<\/p>\r\n<p><strong>B\u01b0\u1edbc 1: <\/strong>Qu\u00e9t kh\u1ed1i v\u00f9ng c\u1ea7n t\u1ea1o danh s\u00e1ch l\u1ef1a ch\u1ecdn.<\/p>\r\n<figure id=\"attachment_393151\" aria-describedby=\"caption-attachment-393151\" style=\"width: 800px\" class=\"wp-caption alignnone\"><img decoding=\"async\" class=\"wp-image-393151 size-full\" src=\"https:\/\/blogcdn.muaban.net\/wp-content\/uploads\/2023\/06\/07145831\/cach-tao-lua-chon-trong-google-sheet-1.jpg\" alt=\"C\u00e1ch t\u1ea1o danh s\u00e1ch l\u1ef1a ch\u1ecdn (drop-list) khi c\u00f3 s\u1eb5n d\u1eef li\u1ec7u\" width=\"800\" height=\"450\" title=\"\" srcset=\"https:\/\/blogcdn.muaban.net\/wp-content\/uploads\/2023\/06\/07145831\/cach-tao-lua-chon-trong-google-sheet-1.jpg 800w, https:\/\/blogcdn.muaban.net\/wp-content\/uploads\/2023\/06\/07145831\/cach-tao-lua-chon-trong-google-sheet-1-768x432.jpg 768w, https:\/\/blogcdn.muaban.net\/wp-content\/uploads\/2023\/06\/07145831\/cach-tao-lua-chon-trong-google-sheet-1-696x392.jpg 696w, https:\/\/blogcdn.muaban.net\/wp-content\/uploads\/2023\/06\/07145831\/cach-tao-lua-chon-trong-google-sheet-1-150x84.jpg 150w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><figcaption id=\"caption-attachment-393151\" class=\"wp-caption-text\">C\u00e1ch t\u1ea1o l\u1ef1a ch\u1ecdn trong Google Sheet (drop-list) khi c\u00f3 s\u1eb5n d\u1eef li\u1ec7u &#8211; B\u01b0\u1edbc 1<\/figcaption><\/figure>\r\n<p><strong>B\u01b0\u1edbc 2:\u00a0<\/strong>Ch\u1ecdn <strong>Data<\/strong> =&gt; <strong>Data validation<\/strong><\/p>\r\n<figure id=\"attachment_393153\" aria-describedby=\"caption-attachment-393153\" style=\"width: 800px\" class=\"wp-caption alignnone\"><img decoding=\"async\" class=\"wp-image-393153 size-full\" src=\"https:\/\/blogcdn.muaban.net\/wp-content\/uploads\/2023\/06\/07145842\/cach-tao-lua-chon-trong-google-sheet-3.jpg\" alt=\"C\u00e1ch t\u1ea1o danh s\u00e1ch l\u1ef1a ch\u1ecdn (drop-list) khi c\u00f3 s\u1eb5n d\u1eef li\u1ec7u\" width=\"800\" height=\"450\" title=\"\" srcset=\"https:\/\/blogcdn.muaban.net\/wp-content\/uploads\/2023\/06\/07145842\/cach-tao-lua-chon-trong-google-sheet-3.jpg 800w, https:\/\/blogcdn.muaban.net\/wp-content\/uploads\/2023\/06\/07145842\/cach-tao-lua-chon-trong-google-sheet-3-768x432.jpg 768w, https:\/\/blogcdn.muaban.net\/wp-content\/uploads\/2023\/06\/07145842\/cach-tao-lua-chon-trong-google-sheet-3-696x392.jpg 696w, https:\/\/blogcdn.muaban.net\/wp-content\/uploads\/2023\/06\/07145842\/cach-tao-lua-chon-trong-google-sheet-3-150x84.jpg 150w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><figcaption id=\"caption-attachment-393153\" class=\"wp-caption-text\">C\u00e1ch t\u1ea1o l\u1ef1a ch\u1ecdn trong Google Sheet (drop-list) khi c\u00f3 s\u1eb5n d\u1eef li\u1ec7u &#8211; B\u01b0\u1edbc 2<\/figcaption><\/figure>\r\n<p><strong>B\u01b0\u1edbc 3:\u00a0<\/strong>Khi h\u1ed9p tho\u1ea1i nh\u01b0 b\u00ean d\u01b0\u1edbi xu\u1ea5t hi\u1ec7n, ch\u1ecdn +<strong>Add rule<\/strong><\/p>\r\n<figure id=\"attachment_393154\" aria-describedby=\"caption-attachment-393154\" style=\"width: 800px\" class=\"wp-caption alignnone\"><img decoding=\"async\" class=\"wp-image-393154 size-full\" src=\"https:\/\/blogcdn.muaban.net\/wp-content\/uploads\/2023\/06\/07145848\/cach-tao-lua-chon-trong-google-sheet-4.jpg\" alt=\"C\u00e1ch t\u1ea1o danh s\u00e1ch l\u1ef1a ch\u1ecdn (drop-list) khi c\u00f3 s\u1eb5n d\u1eef li\u1ec7u\" width=\"800\" height=\"450\" title=\"\" srcset=\"https:\/\/blogcdn.muaban.net\/wp-content\/uploads\/2023\/06\/07145848\/cach-tao-lua-chon-trong-google-sheet-4.jpg 800w, https:\/\/blogcdn.muaban.net\/wp-content\/uploads\/2023\/06\/07145848\/cach-tao-lua-chon-trong-google-sheet-4-768x432.jpg 768w, https:\/\/blogcdn.muaban.net\/wp-content\/uploads\/2023\/06\/07145848\/cach-tao-lua-chon-trong-google-sheet-4-696x392.jpg 696w, https:\/\/blogcdn.muaban.net\/wp-content\/uploads\/2023\/06\/07145848\/cach-tao-lua-chon-trong-google-sheet-4-150x84.jpg 150w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><figcaption id=\"caption-attachment-393154\" class=\"wp-caption-text\">C\u00e1ch t\u1ea1o l\u1ef1a ch\u1ecdn trong Google Sheet (drop-list) khi c\u00f3 s\u1eb5n d\u1eef li\u1ec7u &#8211; B\u01b0\u1edbc 3<\/figcaption><\/figure>\r\n<p><strong>B\u01b0\u1edbc 4:\u00a0<\/strong>Trong h\u1ed9p tho\u1ea1i t\u00f9y ch\u1ec9nh, b\u1ea1n ch\u1ecdn <strong>Dropdown (from a range)<\/strong> nh\u01b0 h\u00ecnh b\u00ean d\u01b0\u1edbi:<\/p>\r\n<figure id=\"attachment_393156\" aria-describedby=\"caption-attachment-393156\" style=\"width: 800px\" class=\"wp-caption alignnone\"><img decoding=\"async\" class=\"wp-image-393156 size-full\" src=\"https:\/\/blogcdn.muaban.net\/wp-content\/uploads\/2023\/06\/07145854\/cach-tao-lua-chon-trong-google-sheet-5.jpg\" alt=\"C\u00e1ch t\u1ea1o danh s\u00e1ch l\u1ef1a ch\u1ecdn (drop-list) khi c\u00f3 s\u1eb5n d\u1eef li\u1ec7u\" width=\"800\" height=\"450\" title=\"\" srcset=\"https:\/\/blogcdn.muaban.net\/wp-content\/uploads\/2023\/06\/07145854\/cach-tao-lua-chon-trong-google-sheet-5.jpg 800w, https:\/\/blogcdn.muaban.net\/wp-content\/uploads\/2023\/06\/07145854\/cach-tao-lua-chon-trong-google-sheet-5-768x432.jpg 768w, https:\/\/blogcdn.muaban.net\/wp-content\/uploads\/2023\/06\/07145854\/cach-tao-lua-chon-trong-google-sheet-5-696x392.jpg 696w, https:\/\/blogcdn.muaban.net\/wp-content\/uploads\/2023\/06\/07145854\/cach-tao-lua-chon-trong-google-sheet-5-150x84.jpg 150w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><figcaption id=\"caption-attachment-393156\" class=\"wp-caption-text\">C\u00e1ch t\u1ea1o l\u1ef1a ch\u1ecdn trong Google Sheet (drop-list) khi c\u00f3 s\u1eb5n d\u1eef li\u1ec7u &#8211; B\u01b0\u1edbc 4<\/figcaption><\/figure>\r\n<p><strong>B\u01b0\u1edbc 5:\u00a0<\/strong>Ch\u1ecdn bi\u1ec3u t\u01b0\u1ee3ng <strong>\u00f4 vu\u00f4ng<\/strong> nh\u01b0 h\u00ecnh b\u00ean d\u01b0\u1edbi. Sau khi h\u1ed9p tho\u1ea1i &#8220;<strong>Select a data range<\/strong>&#8221; xu\u1ea5t hi\u1ec7n, b\u1ea1n <strong>qu\u00e9t kh\u1ed1i v\u00f9ng d\u1eef li\u1ec7u<\/strong> d\u00f9ng \u0111\u1ec3 t\u1ea1o danh s\u00e1ch r\u1ed3i b\u1ea5m <strong>OK<\/strong>. <em>Gi\u1ea3 s\u1eed trong v\u00ed d\u1ee5 c\u1ee7a Mua B\u00e1n l\u00e0 danh s\u00e1ch c\u00e1c t\u1ec9nh th\u00e0nh.<\/em><\/p>\r\n<figure id=\"attachment_393157\" aria-describedby=\"caption-attachment-393157\" style=\"width: 800px\" class=\"wp-caption alignnone\"><img decoding=\"async\" class=\"wp-image-393157 size-full\" src=\"https:\/\/blogcdn.muaban.net\/wp-content\/uploads\/2023\/06\/07145900\/cach-tao-lua-chon-trong-google-sheet-6.jpg\" alt=\"C\u00e1ch t\u1ea1o danh s\u00e1ch l\u1ef1a ch\u1ecdn (drop-list) khi c\u00f3 s\u1eb5n d\u1eef li\u1ec7u\" width=\"800\" height=\"450\" title=\"\" srcset=\"https:\/\/blogcdn.muaban.net\/wp-content\/uploads\/2023\/06\/07145900\/cach-tao-lua-chon-trong-google-sheet-6.jpg 800w, https:\/\/blogcdn.muaban.net\/wp-content\/uploads\/2023\/06\/07145900\/cach-tao-lua-chon-trong-google-sheet-6-768x432.jpg 768w, https:\/\/blogcdn.muaban.net\/wp-content\/uploads\/2023\/06\/07145900\/cach-tao-lua-chon-trong-google-sheet-6-696x392.jpg 696w, https:\/\/blogcdn.muaban.net\/wp-content\/uploads\/2023\/06\/07145900\/cach-tao-lua-chon-trong-google-sheet-6-150x84.jpg 150w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><figcaption id=\"caption-attachment-393157\" class=\"wp-caption-text\">C\u00e1ch t\u1ea1o l\u1ef1a ch\u1ecdn trong Google Sheet (drop-list) khi c\u00f3 s\u1eb5n d\u1eef li\u1ec7u &#8211; b\u01b0\u1edbc 5<\/figcaption><\/figure>\r\n<p><strong>L\u01b0u \u00fd:<\/strong><em> N\u1ebfu danh s\u00e1ch l\u1ef1a ch\u1ecdn n\u1eb1m \u1edf m\u1ed9t Sheet kh\u00e1c th\u00ec b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 b\u1ea5m sang Sheet kh\u00e1c \u0111\u1ec3 qu\u00e9t kh\u1ed1i v\u00f9ng danh s\u00e1ch l\u1ef1a ch\u1ecdn.<\/em><\/p>\r\n<p><strong>B\u01b0\u1edbc 6:\u00a0<\/strong>Cu\u1ed1i c\u00f9ng, h\u1ed9p tho\u1ea1i ban \u0111\u1ea7u s\u1ebd t\u1ef1 \u0111i\u1ec1n danh s\u00e1ch l\u1ef1a ch\u1ecdn nh\u01b0 h\u00ecnh b\u00ean d\u01b0\u1edbi, b\u1ea5m <strong>Done<\/strong> \u0111\u1ec3 ho\u00e0n th\u00e0nh.<\/p>\r\n<figure id=\"attachment_393152\" aria-describedby=\"caption-attachment-393152\" style=\"width: 800px\" class=\"wp-caption alignnone\"><img decoding=\"async\" class=\"size-full wp-image-393152\" src=\"https:\/\/blogcdn.muaban.net\/wp-content\/uploads\/2023\/06\/07145837\/cach-tao-lua-chon-trong-google-sheet-2.jpg\" alt=\"C\u00e1ch t\u1ea1o danh s\u00e1ch l\u1ef1a ch\u1ecdn (drop-list) khi c\u00f3 s\u1eb5n d\u1eef li\u1ec7u\" width=\"800\" height=\"450\" title=\"\" srcset=\"https:\/\/blogcdn.muaban.net\/wp-content\/uploads\/2023\/06\/07145837\/cach-tao-lua-chon-trong-google-sheet-2.jpg 800w, https:\/\/blogcdn.muaban.net\/wp-content\/uploads\/2023\/06\/07145837\/cach-tao-lua-chon-trong-google-sheet-2-768x432.jpg 768w, https:\/\/blogcdn.muaban.net\/wp-content\/uploads\/2023\/06\/07145837\/cach-tao-lua-chon-trong-google-sheet-2-696x392.jpg 696w, https:\/\/blogcdn.muaban.net\/wp-content\/uploads\/2023\/06\/07145837\/cach-tao-lua-chon-trong-google-sheet-2-150x84.jpg 150w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><figcaption id=\"caption-attachment-393152\" class=\"wp-caption-text\">C\u00e1ch t\u1ea1o danh s\u00e1ch l\u1ef1a ch\u1ecdn (drop-list) khi c\u00f3 s\u1eb5n d\u1eef li\u1ec7u &#8211; B\u01b0\u1edbc 6<\/figcaption><\/figure>\r\n<h3><span class=\"ez-toc-section\" id=\"2-cach-tao-danh-sach-lua-chon-drop-list-bang-cach-nhap-thu-cong\"><\/span><strong>2. C\u00e1ch t\u1ea1o danh s\u00e1ch l\u1ef1a ch\u1ecdn (drop-list) b\u1eb1ng c\u00e1ch nh\u1eadp th\u1ee7 c\u00f4ng<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\r\n<p>V\u1edbi nh\u1eefng danh s\u00e1ch l\u1ef1a ch\u1ecdn kh\u00f4ng qu\u00e1 d\u00e0i, t\u1eeb 1 &#8211; 5 l\u1ef1a ch\u1ecdn, b\u1ea1n n\u00ean d\u00f9ng c\u00e1ch \u0111i\u1ec1n th\u1ee7 c\u00f4ng d\u01b0\u1edbi \u0111\u00e2y s\u1ebd nhanh h\u01a1n.<\/p>\r\n<p><strong>B\u01b0\u1edbc 1:<\/strong> B\u1ea1n <strong>qu\u00e9t kh\u1ed1i v\u00f9ng c\u1ea7n t\u1ea1o danh s\u00e1ch l\u1ef1a ch\u1ecdn<\/strong> tr\u00ean Google Sheet. Sau \u0111\u00f3 ch\u1ecdn <strong>Data<\/strong> =&gt; <strong>Data Validation<\/strong><\/p>\r\n<figure id=\"attachment_393158\" aria-describedby=\"caption-attachment-393158\" style=\"width: 800px\" class=\"wp-caption alignnone\"><img decoding=\"async\" class=\"size-full wp-image-393158\" src=\"https:\/\/blogcdn.muaban.net\/wp-content\/uploads\/2023\/06\/07145906\/cach-tao-lua-chon-trong-google-sheet-7.jpg\" alt=\"C\u00e1ch t\u1ea1o danh s\u00e1ch l\u1ef1a ch\u1ecdn (drop-list) b\u1eb1ng c\u00e1ch nh\u1eadp th\u1ee7 c\u00f4ng\" width=\"800\" height=\"450\" title=\"\" srcset=\"https:\/\/blogcdn.muaban.net\/wp-content\/uploads\/2023\/06\/07145906\/cach-tao-lua-chon-trong-google-sheet-7.jpg 800w, https:\/\/blogcdn.muaban.net\/wp-content\/uploads\/2023\/06\/07145906\/cach-tao-lua-chon-trong-google-sheet-7-768x432.jpg 768w, https:\/\/blogcdn.muaban.net\/wp-content\/uploads\/2023\/06\/07145906\/cach-tao-lua-chon-trong-google-sheet-7-696x392.jpg 696w, https:\/\/blogcdn.muaban.net\/wp-content\/uploads\/2023\/06\/07145906\/cach-tao-lua-chon-trong-google-sheet-7-150x84.jpg 150w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><figcaption id=\"caption-attachment-393158\" class=\"wp-caption-text\">C\u00e1ch t\u1ea1o danh s\u00e1ch l\u1ef1a ch\u1ecdn (drop-list) b\u1eb1ng c\u00e1ch nh\u1eadp th\u1ee7 c\u00f4ng &#8211; b\u01b0\u1edbc 1<\/figcaption><\/figure>\r\n<p><strong>B\u01b0\u1edbc 2:<\/strong> Khi h\u1ed9p tho\u1ea1i nh\u01b0 h\u00ecnh b\u00ean d\u01b0\u1edbi xu\u1ea5t hi\u1ec7n, ch\u1ecdn + <strong>Add rule<\/strong><\/p>\r\n<figure id=\"attachment_393159\" aria-describedby=\"caption-attachment-393159\" style=\"width: 800px\" class=\"wp-caption alignnone\"><img decoding=\"async\" class=\"size-full wp-image-393159\" src=\"https:\/\/blogcdn.muaban.net\/wp-content\/uploads\/2023\/06\/07145912\/cach-tao-lua-chon-trong-google-sheet-8.jpg\" alt=\"C\u00e1ch t\u1ea1o danh s\u00e1ch l\u1ef1a ch\u1ecdn (drop-list) b\u1eb1ng c\u00e1ch nh\u1eadp th\u1ee7 c\u00f4ng\" width=\"800\" height=\"450\" title=\"\" srcset=\"https:\/\/blogcdn.muaban.net\/wp-content\/uploads\/2023\/06\/07145912\/cach-tao-lua-chon-trong-google-sheet-8.jpg 800w, https:\/\/blogcdn.muaban.net\/wp-content\/uploads\/2023\/06\/07145912\/cach-tao-lua-chon-trong-google-sheet-8-768x432.jpg 768w, https:\/\/blogcdn.muaban.net\/wp-content\/uploads\/2023\/06\/07145912\/cach-tao-lua-chon-trong-google-sheet-8-696x392.jpg 696w, https:\/\/blogcdn.muaban.net\/wp-content\/uploads\/2023\/06\/07145912\/cach-tao-lua-chon-trong-google-sheet-8-150x84.jpg 150w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><figcaption id=\"caption-attachment-393159\" class=\"wp-caption-text\">C\u00e1ch t\u1ea1o danh s\u00e1ch l\u1ef1a ch\u1ecdn (drop-list) b\u1eb1ng c\u00e1ch nh\u1eadp th\u1ee7 c\u00f4ng &#8211; B\u01b0\u1edbc 2<\/figcaption><\/figure>\r\n<p><strong>B\u01b0\u1edbc 3:<\/strong> B\u1ea1n <strong>\u0111i\u1ec1n c\u00e1c l\u1ef1a ch\u1ecdn t\u00f9y \u00fd<\/strong> v\u00e0o c\u00e1c \u00f4 nh\u01b0 h\u00ecnh b\u00ean d\u01b0\u1edbi. Sau \u0111\u00f3 b\u1ea5m <strong>Done<\/strong> \u0111\u1ec3 ho\u00e0n th\u00e0nh<\/p>\r\n<figure id=\"attachment_393160\" aria-describedby=\"caption-attachment-393160\" style=\"width: 800px\" class=\"wp-caption alignnone\"><img decoding=\"async\" class=\"size-full wp-image-393160\" src=\"https:\/\/blogcdn.muaban.net\/wp-content\/uploads\/2023\/06\/07145917\/cach-tao-lua-chon-trong-google-sheet-9.jpg\" alt=\"C\u00e1ch t\u1ea1o danh s\u00e1ch l\u1ef1a ch\u1ecdn (drop-list) b\u1eb1ng c\u00e1ch nh\u1eadp th\u1ee7 c\u00f4ng\" width=\"800\" height=\"450\" title=\"\" srcset=\"https:\/\/blogcdn.muaban.net\/wp-content\/uploads\/2023\/06\/07145917\/cach-tao-lua-chon-trong-google-sheet-9.jpg 800w, https:\/\/blogcdn.muaban.net\/wp-content\/uploads\/2023\/06\/07145917\/cach-tao-lua-chon-trong-google-sheet-9-768x432.jpg 768w, https:\/\/blogcdn.muaban.net\/wp-content\/uploads\/2023\/06\/07145917\/cach-tao-lua-chon-trong-google-sheet-9-696x392.jpg 696w, https:\/\/blogcdn.muaban.net\/wp-content\/uploads\/2023\/06\/07145917\/cach-tao-lua-chon-trong-google-sheet-9-150x84.jpg 150w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><figcaption id=\"caption-attachment-393160\" class=\"wp-caption-text\">C\u00e1ch t\u1ea1o danh s\u00e1ch l\u1ef1a ch\u1ecdn (drop-list) b\u1eb1ng c\u00e1ch nh\u1eadp th\u1ee7 c\u00f4ng &#8211; b\u01b0\u1edbc 3<\/figcaption><\/figure>\r\n<p><strong>L\u01b0u \u00fd quan tr\u1ecdng:<\/strong> <em>Lo\u1ea1t danh s\u00e1ch l\u1ef1a ch\u1ecdn <strong>kh\u00f4ng \u0111\u01b0\u1ee3c c\u00f3 l\u1ef1a ch\u1ecdn n\u00e0o tr\u00f9ng nhau<\/strong>. V\u00ed d\u1ee5 trong danh s\u00e1ch \u0111\u00e3 c\u00f3 l\u1ef1a ch\u1ecdn &#8220;TP.HCM&#8221; r\u1ed3i, n\u1ebfu b\u1ea1n t\u1ea1o th\u00eam m\u1ed9t l\u1ef1a ch\u1ecdn &#8220;TP.HCM&#8221; th\u00ec Google Sheet s\u1ebd kh\u00f4ng ch\u1ea5p nh\u1eadn. V\u1eady n\u00ean khi b\u1ea1n l\u01b0u danh s\u00e1ch l\u1ef1a ch\u1ecdn b\u1ecb l\u1ed7i, h\u00e3y ki\u1ec3m tra danh s\u00e1ch l\u1ef1a ch\u1ecdn c\u00f3 b\u1ecb tr\u00f9ng kh\u00f4ng nh\u00e9.<\/em><\/p>\r\n<p><strong>C\u00f3 th\u1ec3 b\u1ea1n quan t\u00e2m:<a href=\"https:\/\/muaban.net\/blog\/3-cach-gian-dong-trong-excel-chi-tiet-362520\/\" target=\"_blank\" rel=\"noopener\"> [VIDEO] 3 c\u00e1ch gi\u00e3n d\u00f2ng trong Excel chi ti\u1ebft nh\u1ea5t<\/a><\/strong><\/p>\r\n<p><strong>Ngo\u00e0i ra, b\u1ea1n c\u00f3 nhu c\u1ea7u t\u00ecm vi\u1ec7c l\u00e0m th\u00ec c\u00f3 th\u1ec3 truy c\u1eadp v\u00e0o website Muaban.net \u0111\u1ec3 \u1ee9ng tuy\u1ec3n h\u00e0ng ngh\u00ecn \u0111\u1ea7u vi\u1ec7c kh\u00e1c nhau, ho\u0103\u0323c truy c\u00e2\u0323p ta\u0323i \u0111\u00e2y:<\/strong><\/p>\r\n<p><span data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;\t\t&lt;div class=&quot;lsst-dbs-api &quot;&gt;\n\t    \t&lt;div class=&quot;lists-type lists-type-2 columns-2&quot; &gt;\n\t    \t\t&lt;div class=&quot;items-api-wp items-6a276a0c64c0a&quot;&gt;\n\t    \t\t\t\t    \t\t&lt;\/div&gt;\n\t    \t&lt;\/div&gt;\n\t    &lt;\/div&gt;\n\t\t&quot;}\" data-sheets-userformat=\"{&quot;2&quot;:4156,&quot;5&quot;:{&quot;1&quot;:[{&quot;1&quot;:2,&quot;2&quot;:0,&quot;5&quot;:{&quot;1&quot;:2,&quot;2&quot;:0}},{&quot;1&quot;:0,&quot;2&quot;:0,&quot;3&quot;:3},{&quot;1&quot;:1,&quot;2&quot;:0,&quot;4&quot;:1}]},&quot;6&quot;:{&quot;1&quot;:[{&quot;1&quot;:2,&quot;2&quot;:0,&quot;5&quot;:{&quot;1&quot;:2,&quot;2&quot;:0}},{&quot;1&quot;:0,&quot;2&quot;:0,&quot;3&quot;:3},{&quot;1&quot;:1,&quot;2&quot;:0,&quot;4&quot;:1}]},&quot;7&quot;:{&quot;1&quot;:[{&quot;1&quot;:2,&quot;2&quot;:0,&quot;5&quot;:{&quot;1&quot;:2,&quot;2&quot;:0}},{&quot;1&quot;:0,&quot;2&quot;:0,&quot;3&quot;:3},{&quot;1&quot;:1,&quot;2&quot;:0,&quot;4&quot;:1}]},&quot;8&quot;:{&quot;1&quot;:[{&quot;1&quot;:2,&quot;2&quot;:0,&quot;5&quot;:{&quot;1&quot;:2,&quot;2&quot;:0}},{&quot;1&quot;:0,&quot;2&quot;:0,&quot;3&quot;:3},{&quot;1&quot;:1,&quot;2&quot;:0,&quot;4&quot;:1}]},&quot;15&quot;:&quot;Times New Roman&quot;}\">\t\t<div class=\"lsst-dbs-api lsst-slide\">\n\t    \t<div class=\"lists-type lists-type-2 columns-2\" >\n\t    \t\t<div class=\"items-api-wp items-6a276a0c6db95\">\n\t    \t\t\t\t    \t\t<\/div>\n\t    \t<\/div>\n\t    <\/div>\n\t\t\t\t\t<script>\n\t\t\t\tjQuery(document).ready(function($){\n\t\t\t\t\t$('.items-6a276a0c6db95').imagesLoaded( function() {\n\n\n\t\t\t\t\t\t$('.items-6a276a0c6db95').slick({\n\t\t\t\t\t\t\tdots: false,\n\t\t\t\t\t\t\tarrows: true,\n\t\t\t\t\t\t\tinfinite: false,\n\t\t\t\t\t\t\tspeed: 300,\n\t\t\t\t\t\t\tslidesToShow: 4,\n\t\t\t\t\t\t\tslidesToScroll: 1,\n\t\t\t\t\t\t\tresponsive: [\n\t\t\t\t\t\t\t{\n\t\t\t\t\t\t\t\tbreakpoint: 1024,\n\t\t\t\t\t\t\t\tsettings: {\n\t\t\t\t\t\t\t\t\tslidesToShow: 4,\n\t\t\t\t\t\t\t\t}\n\t\t\t\t\t\t\t},\n\t\t\t\t\t\t\t{\n\t\t\t\t\t\t\t\tbreakpoint: 768,\n\t\t\t\t\t\t\t\tsettings: {\n\t\t\t\t\t\t\t\t\tslidesToShow: 2.3,\n\t\t\t\t\t\t\t\t}\n\t\t\t\t\t\t\t},\n\t\t\t\t\t\t\t{\n\t\t\t\t\t\t\t\tbreakpoint: 480,\n\t\t\t\t\t\t\t\tsettings: {\n\t\t\t\t\t\t\t\t\tslidesToShow: 1.5,\n\t\t\t\t\t\t\t\t}\n\t\t\t\t\t\t\t}\n\t\t\t\t\t\t\t]\n\t\t\t\t\t\t});\n\t\t\t\t\t\tvar maxheight = 0;\n\t\t\t\t\t\t$('.items-6a276a0c6db95 .item-api-news').each(function () {\n\t\t\t\t\t\t\tmaxheight = ($(this).height() > maxheight ? $(this).height() : maxheight); \n\t\t\t\t\t\t});\n\n\t\t\t\t\t\t$('.items-6a276a0c6db95 .item-api-news').height(maxheight);\n\t\t\t\t\t});\n\t\t\t\t});\n\t\t\t<\/script>\n\t\t<\/span><\/p>\r\n<h3><span class=\"ez-toc-section\" id=\"3-cach-tao-danh-sach-lua-chon-drop-list-co-mau\"><\/span><strong>3. C\u00e1ch t\u1ea1o danh s\u00e1ch l\u1ef1a ch\u1ecdn (drop-list) c\u00f3 m\u00e0u<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\r\n<p>Sau khi t\u1ea1o \u0111\u01b0\u1ee3c danh s\u00e1ch l\u1ef1a ch\u1ecdn nh\u01b0 2 c\u00e1ch Mua B\u00e1n \u0111\u00e3 h\u01b0\u1edbng d\u1eabn ph\u00eda tr\u00ean. \u0110\u1ec3 t\u1eebng l\u1ef1a ch\u1ecdn \u0111\u01b0\u1ee3c t\u00f4 nh\u1eefng m\u00e0u kh\u00e1c nhau, b\u1ea1n l\u00e0m theo 2 b\u01b0\u1edbc \u0111\u01a1n gi\u1ea3n sau:<\/p>\r\n<p>B\u01b0\u1edbc 1:<strong> Qu\u00e9t kh\u1ed1i<\/strong> v\u00f9ng c\u1ea7n t\u00f4 m\u00e0u d\u1eef li\u1ec7u. Sau \u0111\u00f3 <strong>nh\u00e1y chu\u1ed9t ph\u1ea3i<\/strong>, ch\u1ecdn <strong>View more cell actions<\/strong> =&gt; <strong>Conditional formatting<\/strong><\/p>\r\n<figure id=\"attachment_393161\" aria-describedby=\"caption-attachment-393161\" style=\"width: 800px\" class=\"wp-caption alignnone\"><img decoding=\"async\" class=\"size-full wp-image-393161\" src=\"https:\/\/blogcdn.muaban.net\/wp-content\/uploads\/2023\/06\/07145923\/cach-tao-lua-chon-trong-google-sheet-10.jpg\" alt=\"C\u00e1ch t\u1ea1o danh s\u00e1ch l\u1ef1a ch\u1ecdn (drop-list) c\u00f3 m\u00e0u\" width=\"800\" height=\"450\" title=\"\" srcset=\"https:\/\/blogcdn.muaban.net\/wp-content\/uploads\/2023\/06\/07145923\/cach-tao-lua-chon-trong-google-sheet-10.jpg 800w, https:\/\/blogcdn.muaban.net\/wp-content\/uploads\/2023\/06\/07145923\/cach-tao-lua-chon-trong-google-sheet-10-768x432.jpg 768w, https:\/\/blogcdn.muaban.net\/wp-content\/uploads\/2023\/06\/07145923\/cach-tao-lua-chon-trong-google-sheet-10-696x392.jpg 696w, https:\/\/blogcdn.muaban.net\/wp-content\/uploads\/2023\/06\/07145923\/cach-tao-lua-chon-trong-google-sheet-10-150x84.jpg 150w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><figcaption id=\"caption-attachment-393161\" class=\"wp-caption-text\">C\u00e1ch t\u1ea1o danh s\u00e1ch l\u1ef1a ch\u1ecdn (drop-list) c\u00f3 m\u00e0u &#8211; B\u01b0\u1edbc 1<\/figcaption><\/figure>\r\n<p>B\u01b0\u1edbc 2: Ch\u1ecdn <strong>Text contains<\/strong> v\u00e0 <strong>\u0111i\u1ec1n n\u1ed9i dung c\u1ea7n t\u00f4 m\u00e0u<\/strong> \u1edf \u00f4 b\u00ean d\u01b0\u1edbi (nh\u01b0 h\u00ecnh). Ch\u1ecdn m\u00e0u s\u1eafc t\u00f9y th\u00edch t\u1ea1i <strong>bi\u1ec3u t\u01b0\u1ee3ng th\u00f9ng s\u01a1n<\/strong>. Sau \u0111\u00f3 b\u1ea5m <strong>Done<\/strong> \u0111\u1ec3 ho\u00e0n th\u00e0nh.<\/p>\r\n<figure id=\"attachment_393162\" aria-describedby=\"caption-attachment-393162\" style=\"width: 800px\" class=\"wp-caption alignnone\"><img decoding=\"async\" class=\"size-full wp-image-393162\" src=\"https:\/\/blogcdn.muaban.net\/wp-content\/uploads\/2023\/06\/07145928\/cach-tao-lua-chon-trong-google-sheet-11.jpg\" alt=\"C\u00e1ch t\u1ea1o danh s\u00e1ch l\u1ef1a ch\u1ecdn (drop-list) c\u00f3 m\u00e0u\" width=\"800\" height=\"450\" title=\"\" srcset=\"https:\/\/blogcdn.muaban.net\/wp-content\/uploads\/2023\/06\/07145928\/cach-tao-lua-chon-trong-google-sheet-11.jpg 800w, https:\/\/blogcdn.muaban.net\/wp-content\/uploads\/2023\/06\/07145928\/cach-tao-lua-chon-trong-google-sheet-11-768x432.jpg 768w, https:\/\/blogcdn.muaban.net\/wp-content\/uploads\/2023\/06\/07145928\/cach-tao-lua-chon-trong-google-sheet-11-696x392.jpg 696w, https:\/\/blogcdn.muaban.net\/wp-content\/uploads\/2023\/06\/07145928\/cach-tao-lua-chon-trong-google-sheet-11-150x84.jpg 150w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><figcaption id=\"caption-attachment-393162\" class=\"wp-caption-text\">C\u00e1ch t\u1ea1o danh s\u00e1ch l\u1ef1a ch\u1ecdn (drop-list) c\u00f3 m\u00e0u &#8211; B\u01b0\u1edbc 2<\/figcaption><\/figure>\r\n<h3><span class=\"ez-toc-section\" id=\"4-cach-xoa-danh-sach-lua-chon-drop-list\"><\/span><strong>4. C\u00e1ch xo\u00e1 danh s\u00e1ch l\u1ef1a ch\u1ecdn (drop-list)<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\r\n<p>B\u1ea1n t\u1ea1o danh s\u00e1ch l\u1ef1a ch\u1ecdn nh\u1ea7m v\u00e0 c\u1ea7n x\u00f3a \u0111\u1ec3 l\u00e0m l\u1ea1i? R\u1ea5t \u0111\u01a1n gi\u1ea3n ch\u1ec9 v\u1edbi 3 b\u01b0\u1edbc sau \u0111\u00e2y:<\/p>\r\n<p><strong>B\u01b0\u1edbc 1:<\/strong> <strong>Qu\u00e9t kh\u1ed1i<\/strong> v\u00f9ng d\u1eef li\u1ec7u c\u1ea7n x\u00f3a danh s\u00e1ch l\u1ef1a ch\u1ecdn.<\/p>\r\n<p><strong>B\u01b0\u1edbc 2:<\/strong> Ch\u1ecdn <strong>Data<\/strong> =&gt; <strong>Data validation<\/strong><\/p>\r\n<figure id=\"attachment_393163\" aria-describedby=\"caption-attachment-393163\" style=\"width: 800px\" class=\"wp-caption alignnone\"><img decoding=\"async\" class=\"size-full wp-image-393163\" src=\"https:\/\/blogcdn.muaban.net\/wp-content\/uploads\/2023\/06\/07145934\/cach-tao-lua-chon-trong-google-sheet-12.jpg\" alt=\"C\u00e1ch xo\u00e1 danh s\u00e1ch l\u1ef1a ch\u1ecdn (drop-list)\" width=\"800\" height=\"450\" title=\"\" srcset=\"https:\/\/blogcdn.muaban.net\/wp-content\/uploads\/2023\/06\/07145934\/cach-tao-lua-chon-trong-google-sheet-12.jpg 800w, https:\/\/blogcdn.muaban.net\/wp-content\/uploads\/2023\/06\/07145934\/cach-tao-lua-chon-trong-google-sheet-12-768x432.jpg 768w, https:\/\/blogcdn.muaban.net\/wp-content\/uploads\/2023\/06\/07145934\/cach-tao-lua-chon-trong-google-sheet-12-696x392.jpg 696w, https:\/\/blogcdn.muaban.net\/wp-content\/uploads\/2023\/06\/07145934\/cach-tao-lua-chon-trong-google-sheet-12-150x84.jpg 150w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><figcaption id=\"caption-attachment-393163\" class=\"wp-caption-text\">C\u00e1ch xo\u00e1 danh s\u00e1ch l\u1ef1a ch\u1ecdn (drop-list) &#8211; B\u01b0\u1edbc 1 &#8211; 2<\/figcaption><\/figure>\r\n<p>B\u01b0\u1edbc 3: Ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u c\u1ea7n x\u00f3a danh s\u00e1ch l\u1ef1a ch\u1ecdn<em> (nh\u01b0 v\u00ed d\u1ee5 c\u1ee7a Mua B\u00e1n l\u00e0 v\u00f9ng B2:B7)<\/em>. Sau \u0111\u00f3 b\u1ea5m v\u1ea3o bi\u1ec3u t\u01b0\u1ee3ng <strong>Th\u00f9ng r\u00e1c<\/strong> \u0111\u1ec3 x\u00f3a.<\/p>\r\n<figure id=\"attachment_393164\" aria-describedby=\"caption-attachment-393164\" style=\"width: 800px\" class=\"wp-caption alignnone\"><img decoding=\"async\" class=\"size-full wp-image-393164\" src=\"https:\/\/blogcdn.muaban.net\/wp-content\/uploads\/2023\/06\/07145939\/cach-tao-lua-chon-trong-google-sheet-13.jpg\" alt=\"C\u00e1ch xo\u00e1 danh s\u00e1ch l\u1ef1a ch\u1ecdn (drop-list)\" width=\"800\" height=\"450\" title=\"\" srcset=\"https:\/\/blogcdn.muaban.net\/wp-content\/uploads\/2023\/06\/07145939\/cach-tao-lua-chon-trong-google-sheet-13.jpg 800w, https:\/\/blogcdn.muaban.net\/wp-content\/uploads\/2023\/06\/07145939\/cach-tao-lua-chon-trong-google-sheet-13-768x432.jpg 768w, https:\/\/blogcdn.muaban.net\/wp-content\/uploads\/2023\/06\/07145939\/cach-tao-lua-chon-trong-google-sheet-13-696x392.jpg 696w, https:\/\/blogcdn.muaban.net\/wp-content\/uploads\/2023\/06\/07145939\/cach-tao-lua-chon-trong-google-sheet-13-150x84.jpg 150w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><figcaption id=\"caption-attachment-393164\" class=\"wp-caption-text\">C\u00e1ch xo\u00e1 danh s\u00e1ch l\u1ef1a ch\u1ecdn (drop-list) &#8211; b\u01b0\u1edbc 3<\/figcaption><\/figure>\r\n<h3><span class=\"ez-toc-section\" id=\"5-nhung-uu-diem-khi-tao-danh-sach-lua-chon-trong-google-sheet\"><\/span><strong>5. Nh\u1eefng \u01b0u \u0111i\u1ec3m khi t\u1ea1o danh s\u00e1ch l\u1ef1a ch\u1ecdn trong Google Sheet<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\r\n<ul>\r\n<li><strong>Gi\u00fap ti\u1ebft ki\u1ec7m th\u1eddi gian v\u00e0 gi\u1ea3m c\u00e1c l\u1ed7i nh\u1eadp li\u1ec7u<\/strong>: Khi s\u1eed d\u1ee5ng Drop-list, ng\u01b0\u1eddi d\u00f9ng ch\u1ec9 c\u1ea7n th\u1ef1c hi\u1ec7n thao t\u00e1c ch\u1ecdn, c\u1ef1c k\u1ef3 ti\u1ebft ki\u1ec7m th\u1eddi gian v\u00e0 gi\u1ea3m thi\u1ec3u nh\u1eefng sai s\u00f3t trong qu\u00e1 tr\u00ecnh nh\u1eadp li\u1ec7u.<\/li>\r\n<li><strong>D\u1ec5 d\u00e0ng qu\u1ea3n l\u00fd, c\u1eadp nh\u1eadt d\u1eef li\u1ec7u<\/strong>: Khi b\u1ea1n c\u1ea7n thay \u0111\u1ed5i ho\u1eb7c c\u1eadp nh\u1eadt danh s\u00e1ch l\u1ef1a ch\u1ecdn, b\u1ea1n ch\u1ec9 c\u1ea7n s\u1eeda danh s\u00e1ch ban \u0111\u1ea7u l\u00e0 t\u1ea5t c\u1ea3 danh s\u00e1ch l\u1ef1a ch\u1ecdn s\u1ebd \u0111\u01b0\u1ee3c thay \u0111\u1ed5i nhanh ch\u00f3ng.<\/li>\r\n<li><strong>T\u00ednh tr\u1ef1c quan<\/strong>: Drop-list gi\u00fap tr\u00ecnh b\u00e0y d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch r\u1ea5t tr\u1ef1c quan, gi\u00fap ng\u01b0\u1eddi d\u00f9ng d\u1ec5 d\u00e0ng s\u1eed d\u1ee5ng h\u01a1n, gi\u00fap Sheet l\u00e0m vi\u1ec7c tr\u00f4ng ngay ng\u1eafn v\u00e0 th\u1ea9m m\u1ef9.<\/li>\r\n<\/ul>\r\n<figure id=\"attachment_393165\" aria-describedby=\"caption-attachment-393165\" style=\"width: 800px\" class=\"wp-caption alignnone\"><img decoding=\"async\" class=\"size-full wp-image-393165\" src=\"https:\/\/blogcdn.muaban.net\/wp-content\/uploads\/2023\/06\/07145945\/cach-tao-lua-chon-trong-google-sheet-14.jpg\" alt=\"Nh\u1eefng \u01b0u \u0111i\u1ec3m khi t\u1ea1o danh s\u00e1ch l\u1ef1a ch\u1ecdn trong Google Sheet\" width=\"800\" height=\"450\" title=\"\" srcset=\"https:\/\/blogcdn.muaban.net\/wp-content\/uploads\/2023\/06\/07145945\/cach-tao-lua-chon-trong-google-sheet-14.jpg 800w, https:\/\/blogcdn.muaban.net\/wp-content\/uploads\/2023\/06\/07145945\/cach-tao-lua-chon-trong-google-sheet-14-768x432.jpg 768w, https:\/\/blogcdn.muaban.net\/wp-content\/uploads\/2023\/06\/07145945\/cach-tao-lua-chon-trong-google-sheet-14-696x392.jpg 696w, https:\/\/blogcdn.muaban.net\/wp-content\/uploads\/2023\/06\/07145945\/cach-tao-lua-chon-trong-google-sheet-14-150x84.jpg 150w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><figcaption id=\"caption-attachment-393165\" class=\"wp-caption-text\">Nh\u1eefng \u01b0u \u0111i\u1ec3m khi t\u1ea1o danh s\u00e1ch l\u1ef1a ch\u1ecdn trong Google Sheet<\/figcaption><\/figure>\r\n<p><em>Tr\u00ean \u0111\u00e2y l\u00e0 nh\u1eefng<a href=\"https:\/\/muaban.net\/blog\/cach-tao-lua-chon-trong-google-sheet-392632\/\" target=\"_blank\" rel=\"noopener\"><strong> c\u00e1ch t\u1ea1o l\u1ef1a ch\u1ecdn trong Google Sheet<\/strong><\/a> v\u00e0 t\u00f4 m\u00e0u l\u1ef1a ch\u1ecdn c\u1ef1c d\u1ec5 d\u00e0ng. Mong r\u1eb1ng sau b\u00e0i vi\u1ebft b\u1ea1n s\u1ebd t\u1ea1o \u0111\u01b0\u1ee3c m\u1ed9t trang t\u00ednh \u0111\u1eb9p m\u1eaft, chuy\u00ean nghi\u1ec7p c\u1ee7a ri\u00eang m\u00ecnh. Xem th\u00eam nhi\u1ec1u h\u01b0\u1edbng d\u1eadn thao t\u00e1c tr\u00ean Google Sheet, Excel, Word,&#8230; t\u1ea1i trang Blog c\u1ee7a <a href=\"http:\/\/muaban.net\" target=\"_blank\" rel=\"noopener\"><strong>Muaban.net<\/strong> <\/a>nh\u00e9! B\u00ean c\u1ea1nh nh\u1eefng m\u1eb9o v\u1eb7t tin h\u1ecdc v\u0103n ph\u00f2ng, Muaban.net c\u0169ng cung c\u1ea5p nh\u1eefng tin <a href=\"https:\/\/muaban.net\/bat-dong-san\" target=\"_blank\" rel=\"noopener\">mua b\u00e1n nh\u00e0 \u0111\u1ea5t<\/a>, <a href=\"https:\/\/muaban.net\/viec-lam\/viec-tim-nguoi\" target=\"_blank\" rel=\"noopener\">vi\u1ec7c l\u00e0m<\/a> m\u1edbi nh\u1ea5t cho b\u1ea1n tham kh\u1ea3o!<\/em><\/p>\r\n<p><strong>Xem th\u00eam: <\/strong><\/p>\r\n<ul>\r\n<li><strong><a href=\"https:\/\/muaban.net\/blog\/cach-tao-bang-trong-excel-390834\/\" target=\"_blank\" rel=\"noopener\" class=\"broken_link\">3 c\u00e1ch t\u1ea1o b\u1ea3ng trong Excel d\u1ec5 l\u00e0m v\u00e0 c\u1ef1c hi\u1ec7u qu\u1ea3<\/a><\/strong><\/li>\r\n<li><a href=\"https:\/\/muaban.net\/blog\/cach-co-dinh-cot-trong-excel-391279\/\" target=\"_blank\" rel=\"noopener\"><strong>C\u00e1ch c\u1ed1 \u0111\u1ecbnh c\u1ed9t trong Excel c\u1ef1c \u0111\u01a1n gi\u1ea3n v\u00e0 chi ti\u1ebft<\/strong><\/a><\/li>\r\n<\/ul>\r\n","protected":false},"excerpt":{"rendered":"<p><span class=\"span-reading-time rt-reading-time\" style=\"display: block;\"><span class=\"rt-label rt-prefix\">Th\u1eddi gian \u0111\u1ecdc:<\/span> <span class=\"rt-time\"> 6<\/span> <span class=\"rt-label rt-postfix\">ph\u00fat<\/span><\/span>B\u1ea1n \u0111ang c\u1ea7n t\u1ea1o m\u1ed9t danh s\u00e1ch l\u1ef1a ch\u1ecdn trong Google Sheet? B\u1ea1n \u0111ang loay hoay ch\u01b0a bi\u1ebft c\u00e1ch t\u1ea1o l\u1ef1a ch\u1ecdn trong Google Sheet nh\u01b0 th\u1ebf n\u00e0o cho \u0111\u00fang? V\u1eady th\u00ec b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y s\u1ebd h\u01b0\u1edbng d\u1eabn th\u1eadt chi ti\u1ebft, gi\u00fap b\u1ea1n \u1ee9ng d\u1ee5ng \u0111\u01b0\u1ee3c ngay v\u00e0o c\u00f4ng vi\u1ec7c. \u0110\u1eebng b\u1ecf qua nh\u00e9! [&hellip;]<\/p>\n","protected":false},"author":220,"featured_media":393150,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"ub_ctt_via":"","_lmt_disableupdate":"","_lmt_disable":"","footnotes":""},"categories":[27],"tags":[],"class_list":{"0":"post-392632","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-khac"},"featured_image_src":"https:\/\/blogcdn.muaban.net\/wp-content\/uploads\/2023\/06\/07145825\/cach-tao-lua-chon-trong-google-sheet.jpg","author_info":{"display_name":"H\u01b0\u01a1ng Nguy\u1ec5n","author_link":"https:\/\/muaban.net\/blog\/tac-gia\/xuanhuong-nguyen\/"},"acf":[],"modified_by":"Tr\u1ea7n \u00c1nh Tuy\u1ebft","_links":{"self":[{"href":"https:\/\/muaban.net\/blog\/wp-json\/wp\/v2\/posts\/392632","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/muaban.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/muaban.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/muaban.net\/blog\/wp-json\/wp\/v2\/users\/220"}],"replies":[{"embeddable":true,"href":"https:\/\/muaban.net\/blog\/wp-json\/wp\/v2\/comments?post=392632"}],"version-history":[{"count":0,"href":"https:\/\/muaban.net\/blog\/wp-json\/wp\/v2\/posts\/392632\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/muaban.net\/blog\/wp-json\/wp\/v2\/media\/393150"}],"wp:attachment":[{"href":"https:\/\/muaban.net\/blog\/wp-json\/wp\/v2\/media?parent=392632"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/muaban.net\/blog\/wp-json\/wp\/v2\/categories?post=392632"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/muaban.net\/blog\/wp-json\/wp\/v2\/tags?post=392632"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}