{"id":43887,"date":"2026-11-11T09:11:13","date_gmt":"2026-11-11T02:11:13","guid":{"rendered":"https:\/\/f-techsolution.com\/?p=43887"},"modified":"2026-11-16T20:14:16","modified_gmt":"2026-11-16T13:14:16","slug":"microsoft-excel-data-validation","status":"publish","type":"post","link":"https:\/\/f-techsolution.com\/en\/blog\/microsoft-excel-data-validation\/","title":{"rendered":"Data Validation gi\u00fap gi\u1ea3m l\u1ed7i nh\u1eadp li\u1ec7u trong file Excel d\u00f9ng chung"},"content":{"rendered":"<h1><strong>Data Validation gi\u00fap gi\u1ea3m l\u1ed7i nh\u1eadp li\u1ec7u trong file Excel d\u00f9ng chung<\/strong><\/h1>\n<p><img fetchpriority=\"high\" decoding=\"async\" class=\"alignnone size-full wp-image-43888\" src=\"https:\/\/f-techsolution.com\/wp-content\/uploads\/2026\/11\/Excel-Data-Validation_-Giam-Loi-Nhap-Lieu.png\" alt=\"Microsoft Excel data validation\" width=\"1671\" height=\"941\" srcset=\"https:\/\/f-techsolution.com\/wp-content\/uploads\/2026\/11\/Excel-Data-Validation_-Giam-Loi-Nhap-Lieu.png 1671w, https:\/\/f-techsolution.com\/wp-content\/uploads\/2026\/11\/Excel-Data-Validation_-Giam-Loi-Nhap-Lieu-300x169.png 300w, https:\/\/f-techsolution.com\/wp-content\/uploads\/2026\/11\/Excel-Data-Validation_-Giam-Loi-Nhap-Lieu-1024x577.png 1024w, https:\/\/f-techsolution.com\/wp-content\/uploads\/2026\/11\/Excel-Data-Validation_-Giam-Loi-Nhap-Lieu-768x432.png 768w, https:\/\/f-techsolution.com\/wp-content\/uploads\/2026\/11\/Excel-Data-Validation_-Giam-Loi-Nhap-Lieu-1536x865.png 1536w, https:\/\/f-techsolution.com\/wp-content\/uploads\/2026\/11\/Excel-Data-Validation_-Giam-Loi-Nhap-Lieu-18x10.png 18w\" sizes=\"(max-width: 1671px) 100vw, 1671px\" \/><\/p>\n<p>Khi m\u1ed9t file Excel ch\u1ec9 do m\u1ed9t ng\u01b0\u1eddi s\u1eed d\u1ee5ng, l\u1ed7i nh\u1eadp li\u1ec7u th\u01b0\u1eddng c\u00f2n d\u1ec5 ph\u00e1t hi\u1ec7n v\u00e0 s\u1eeda l\u1ea1i. Nh\u01b0ng khi c\u00f9ng m\u1ed9t workbook \u0111\u01b0\u1ee3c nhi\u1ec1u nh\u00e2n vi\u00ean c\u1eadp nh\u1eadt m\u1ed7i ng\u00e0y, nh\u1eefng sai l\u1ec7ch nh\u1ecf nh\u01b0 g\u00f5 sai t\u00ean ph\u00f2ng ban, nh\u1eadp ng\u00e0y kh\u00f4ng \u0111\u00fang \u0111\u1ecbnh d\u1ea1ng, d\u00f9ng t\u1eeb vi\u1ebft t\u1eaft kh\u00e1c nhau ho\u1eb7c \u0111i\u1ec1n s\u1ed1 ngo\u00e0i ph\u1ea1m vi cho ph\u00e9p c\u00f3 th\u1ec3 nhanh ch\u00f3ng l\u00e0m d\u1eef li\u1ec7u m\u1ea5t t\u00ednh nh\u1ea5t qu\u00e1n.<\/p>\n<p>V\u00ed d\u1ee5, c\u00f9ng m\u1ed9t c\u1ed9t Department nh\u01b0ng ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 nh\u1eadp \u201cSales\u201d, \u201cSale\u201d, \u201cSALE\u201d ho\u1eb7c \u201cKinh doanh\u201d. V\u1ec1 m\u1eb7t con ng\u01b0\u1eddi, nh\u1eefng gi\u00e1 tr\u1ecb n\u00e0y c\u00f3 th\u1ec3 mang c\u00f9ng m\u1ed9t \u00fd ngh\u0129a, nh\u01b0ng v\u1edbi Excel, PivotTable, Power Query hay c\u00f4ng th\u1ee9c t\u1ed5ng h\u1ee3p, \u0111\u00f3 l\u1ea1i l\u00e0 nh\u1eefng gi\u00e1 tr\u1ecb kh\u00e1c nhau. Khi s\u1ed1 l\u01b0\u1ee3ng d\u1eef li\u1ec7u t\u0103ng l\u00ean, vi\u1ec7c l\u00e0m s\u1ea1ch c\u00e1c l\u1ed7i nh\u01b0 v\u1eady c\u00f3 th\u1ec3 t\u1ed1n nhi\u1ec1u th\u1eddi gian h\u01a1n r\u1ea5t nhi\u1ec1u so v\u1edbi vi\u1ec7c ki\u1ec3m so\u00e1t ngay t\u1eeb l\u00fac nh\u1eadp.<\/p>\n<p>\u0110\u00e2y l\u00e0 l\u00fac <strong>Microsoft Excel Data Validation<\/strong> tr\u1edf n\u00ean h\u1eefu \u00edch. Microsoft m\u00f4 t\u1ea3 Data Validation l\u00e0 t\u00ednh n\u0103ng d\u00f9ng \u0111\u1ec3 gi\u1edbi h\u1ea1n lo\u1ea1i d\u1eef li\u1ec7u ho\u1eb7c gi\u00e1 tr\u1ecb m\u00e0 ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 nh\u1eadp v\u00e0o m\u1ed9t \u00f4, ch\u1eb3ng h\u1ea1n ch\u1ec9 cho ph\u00e9p s\u1ed1 nguy\u00ean, s\u1ed1 th\u1eadp ph\u00e2n, ng\u00e0y, th\u1eddi gian, \u0111\u1ed9 d\u00e0i v\u0103n b\u1ea3n ho\u1eb7c l\u1ef1a ch\u1ecdn t\u1eeb m\u1ed9t danh s\u00e1ch c\u00f3 s\u1eb5n.<\/p>\n<p>Trong doanh nghi\u1ec7p, Data Validation n\u00ean \u0111\u01b0\u1ee3c xem nh\u01b0 m\u1ed9t l\u1edbp ki\u1ec3m so\u00e1t d\u1eef li\u1ec7u \u0111\u1ea7u v\u00e0o. N\u00f3 kh\u00f4ng thay th\u1ebf ho\u00e0n to\u00e0n vi\u1ec7c ki\u1ec3m tra d\u1eef li\u1ec7u, nh\u01b0ng c\u00f3 th\u1ec3 gi\u1ea3m \u0111\u00e1ng k\u1ec3 c\u00e1c l\u1ed7i l\u1eb7p l\u1ea1i trong nh\u1eefng file \u0111\u01b0\u1ee3c nhi\u1ec1u ng\u01b0\u1eddi c\u1eadp nh\u1eadt.<\/p>\n<h2>Data Validation ho\u1ea1t \u0111\u1ed9ng nh\u01b0 th\u1ebf n\u00e0o?<\/h2>\n<p>Data Validation cho ph\u00e9p ng\u01b0\u1eddi thi\u1ebft k\u1ebf workbook \u0111\u1eb7t ra m\u1ed9t s\u1ed1 rule cho t\u1eebng \u00f4 ho\u1eb7c v\u00f9ng d\u1eef li\u1ec7u. Khi ng\u01b0\u1eddi d\u00f9ng nh\u1eadp gi\u00e1 tr\u1ecb kh\u00f4ng ph\u00f9 h\u1ee3p v\u1edbi rule \u0111\u00f3, Excel c\u00f3 th\u1ec3 c\u1ea3nh b\u00e1o ho\u1eb7c ng\u0103n kh\u00f4ng cho l\u01b0u gi\u00e1 tr\u1ecb.<\/p>\n<p>V\u00ed d\u1ee5, n\u1ebfu c\u1ed9t Status ch\u1ec9 n\u00ean c\u00f3 ba gi\u00e1 tr\u1ecb l\u00e0 \u201cOpen\u201d, \u201cIn Progress\u201d v\u00e0 \u201cClosed\u201d, ng\u01b0\u1eddi thi\u1ebft k\u1ebf file c\u00f3 th\u1ec3 t\u1ea1o m\u1ed9t dropdown list \u0111\u1ec3 ng\u01b0\u1eddi d\u00f9ng ch\u1ec9 c\u1ea7n ch\u1ecdn m\u1ed9t trong ba l\u1ef1a ch\u1ecdn. N\u1ebfu c\u1ed9t Quantity ch\u1ec9 \u0111\u01b0\u1ee3c nh\u1eadp s\u1ed1 nguy\u00ean t\u1eeb 1 \u0111\u1ebfn 100, Excel c\u00f3 th\u1ec3 t\u1eeb ch\u1ed1i c\u00e1c gi\u00e1 tr\u1ecb ngo\u00e0i kho\u1ea3ng n\u00e0y.<\/p>\n<p>Microsoft hi\u1ec7n h\u1ed7 tr\u1ee3 nhi\u1ec1u ki\u1ec3u Data Validation g\u1ed3m Whole Number, Decimal, List, Date, Time, Text Length v\u00e0 Custom formula. \u0110i\u1ec1u n\u00e0y gi\u00fap Data Validation ph\u00f9 h\u1ee3p v\u1edbi nhi\u1ec1u lo\u1ea1i d\u1eef li\u1ec7u doanh nghi\u1ec7p ch\u1ee9 kh\u00f4ng ch\u1ec9 ri\u00eang dropdown list.<\/p>\n<h2>Dropdown list l\u00e0 use case ph\u1ed5 bi\u1ebfn nh\u1ea5t<\/h2>\n<p>Dropdown list th\u01b0\u1eddng l\u00e0 c\u00e1ch \u0111\u01a1n gi\u1ea3n v\u00e0 hi\u1ec7u qu\u1ea3 nh\u1ea5t \u0111\u1ec3 gi\u1ea3m l\u1ed7i nh\u1eadp li\u1ec7u. Thay v\u00ec \u0111\u1ec3 m\u1ed7i ng\u01b0\u1eddi t\u1ef1 g\u00f5 t\u00ean Department, Status ho\u1eb7c Category, doanh nghi\u1ec7p c\u00f3 th\u1ec3 t\u1ea1o m\u1ed9t danh s\u00e1ch c\u00e1c gi\u00e1 tr\u1ecb h\u1ee3p l\u1ec7 \u0111\u1ec3 ng\u01b0\u1eddi d\u00f9ng ch\u1ecdn.<\/p>\n<p>V\u00ed d\u1ee5, trong m\u1ed9t file qu\u1ea3n l\u00fd y\u00eau c\u1ea7u n\u1ed9i b\u1ed9, c\u1ed9t Priority c\u00f3 th\u1ec3 ch\u1ec9 cho ph\u00e9p \u201cLow\u201d, \u201cMedium\u201d v\u00e0 \u201cHigh\u201d. C\u1ed9t Department c\u00f3 th\u1ec3 ch\u1ec9 cho ph\u00e9p \u201cSales\u201d, \u201cMarketing\u201d, \u201cFinance\u201d, \u201cHR\u201d v\u00e0 \u201cOperations\u201d.<\/p>\n<p>Microsoft cho bi\u1ebft dropdown list gi\u00fap ng\u01b0\u1eddi d\u00f9ng nh\u1eadp li\u1ec7u nhanh h\u01a1n v\u00e0 ch\u00ednh x\u00e1c h\u01a1n v\u00ec h\u1ecd ch\u1ecdn gi\u00e1 tr\u1ecb t\u1eeb m\u1ed9t danh s\u00e1ch \u0111\u01b0\u1ee3c \u0111\u1ecbnh ngh\u0129a s\u1eb5n thay v\u00ec t\u1ef1 nh\u1eadp.<\/p>\n<p>\u0110i\u1ec3m quan tr\u1ecdng l\u00e0 dropdown kh\u00f4ng ch\u1ec9 gi\u00fap file nh\u00ecn g\u1ecdn h\u01a1n m\u00e0 c\u00f2n chu\u1ea9n h\u00f3a d\u1eef li\u1ec7u ngay t\u1eeb ngu\u1ed3n. \u0110i\u1ec1u n\u00e0y \u0111\u1eb7c bi\u1ec7t c\u00f3 gi\u00e1 tr\u1ecb n\u1ebfu workbook sau \u0111\u00f3 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng cho PivotTable, dashboard ho\u1eb7c Power Query.<\/p>\n<h2>N\u00ean \u0111\u1eb7t ngu\u1ed3n dropdown trong Excel Table<\/h2>\n<p>M\u1ed9t trong nh\u1eefng l\u1ed7i th\u01b0\u1eddng g\u1eb7p l\u00e0 t\u1ea1o dropdown t\u1eeb m\u1ed9t v\u00f9ng c\u1ed1 \u0111\u1ecbnh nh\u01b0 <code>A1:A10<\/code>. Ban \u0111\u1ea7u c\u00e1ch n\u00e0y ho\u1ea1t \u0111\u1ed9ng t\u1ed1t, nh\u01b0ng khi c\u00f3 th\u00eam m\u1ed9t Department m\u1edbi \u1edf d\u00f2ng 11, dropdown kh\u00f4ng t\u1ef1 c\u1eadp nh\u1eadt n\u1ebfu range v\u1eabn d\u1eebng \u1edf d\u00f2ng 10.<\/p>\n<p>Microsoft khuy\u1ebfn ngh\u1ecb \u0111\u1eb7t ngu\u1ed3n dropdown trong m\u1ed9t <strong>Excel Table<\/strong>. Khi th\u00eam ho\u1eb7c x\u00f3a item trong Table, c\u00e1c dropdown d\u1ef1a tr\u00ean ngu\u1ed3n \u0111\u00f3 s\u1ebd t\u1ef1 \u0111\u1ed9ng c\u1eadp nh\u1eadt.<\/p>\n<p>V\u00ed d\u1ee5, doanh nghi\u1ec7p c\u00f3 Table t\u00ean <code>DepartmentList<\/code>. Khi th\u00eam m\u1ed9t ph\u00f2ng ban m\u1edbi v\u00e0o Table, c\u00e1c dropdown li\u00ean quan c\u0169ng \u0111\u01b0\u1ee3c c\u1eadp nh\u1eadt m\u00e0 kh\u00f4ng c\u1ea7n s\u1eeda Data Validation th\u1ee7 c\u00f4ng.<\/p>\n<p>\u0110\u00e2y l\u00e0 c\u00e1ch tri\u1ec3n khai t\u1ed1t h\u01a1n nhi\u1ec1u cho nh\u1eefng workbook \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng l\u00e2u d\u00e0i.<\/p>\n<h2>Data Validation gi\u00fap ki\u1ec3m so\u00e1t s\u1ed1<\/h2>\n<p>Kh\u00f4ng ph\u1ea3i m\u1ecdi c\u1ed9t \u0111\u1ec1u ph\u00f9 h\u1ee3p v\u1edbi dropdown. V\u1edbi nh\u1eefng tr\u01b0\u1eddng nh\u01b0 s\u1ed1 l\u01b0\u1ee3ng, ph\u1ea7n tr\u0103m, chi ph\u00ed ho\u1eb7c s\u1ed1 gi\u1edd, Data Validation c\u00f3 th\u1ec3 gi\u1edbi h\u1ea1n gi\u00e1 tr\u1ecb theo kho\u1ea3ng.<\/p>\n<p>V\u00ed d\u1ee5, c\u1ed9t Quantity ch\u1ec9 \u0111\u01b0\u1ee3c nh\u1eadp t\u1eeb 1 \u0111\u1ebfn 500. C\u1ed9t Discount ch\u1ec9 \u0111\u01b0\u1ee3c nh\u1eadp t\u1eeb 0% \u0111\u1ebfn 30%. C\u1ed9t Rating ch\u1ec9 \u0111\u01b0\u1ee3c nh\u1eadp s\u1ed1 nguy\u00ean t\u1eeb 1 \u0111\u1ebfn 5.<\/p>\n<p>Microsoft cho ph\u00e9p Data Validation ki\u1ec3m so\u00e1t Whole Number v\u00e0 Decimal, \u0111\u1ed3ng th\u1eddi h\u1ed7 tr\u1ee3 c\u00e1c \u0111i\u1ec1u ki\u1ec7n nh\u01b0 between, greater than, less than ho\u1eb7c equal to.<\/p>\n<p>\u0110i\u1ec1u n\u00e0y gi\u00fap ng\u0103n nh\u1eefng l\u1ed7i nh\u01b0 nh\u1eadp 5000 thay v\u00ec 500 ho\u1eb7c 80% thay v\u00ec 8%.<\/p>\n<h2>Gi\u1edbi h\u1ea1n ng\u00e0y c\u0169ng r\u1ea5t h\u1eefu \u00edch<\/h2>\n<p>Trong file qu\u1ea3n l\u00fd task ho\u1eb7c deadline, Data Validation c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 gi\u1edbi h\u1ea1n ng\u00e0y.<\/p>\n<p>V\u00ed d\u1ee5, doanh nghi\u1ec7p c\u00f3 th\u1ec3 y\u00eau c\u1ea7u Due Date kh\u00f4ng \u0111\u01b0\u1ee3c nh\u1ecf h\u01a1n ng\u00e0y hi\u1ec7n t\u1ea1i ho\u1eb7c kh\u00f4ng \u0111\u01b0\u1ee3c v\u01b0\u1ee3t qu\u00e1 90 ng\u00e0y. Microsoft h\u1ed7 tr\u1ee3 Date validation v\u00e0 cho ph\u00e9p s\u1eed d\u1ee5ng c\u1ea3 c\u00f4ng th\u1ee9c nh\u01b0 <code>=TODAY()<\/code> trong \u0111i\u1ec1u ki\u1ec7n.<\/p>\n<p>\u0110i\u1ec1u n\u00e0y ph\u00f9 h\u1ee3p v\u1edbi c\u00e1c file nh\u01b0 project tracker, approval log ho\u1eb7c k\u1ebf ho\u1ea1ch v\u1eadn h\u00e0nh.<\/p>\n<p>Tuy nhi\u00ean, kh\u00f4ng n\u00ean d\u00f9ng rule qu\u00e1 c\u1ee9ng n\u1ebfu business process c\u00f3 nhi\u1ec1u ngo\u1ea1i l\u1ec7. N\u1ebfu \u0111\u00f4i khi c\u1ea7n nh\u1eadp ng\u00e0y trong qu\u00e1 kh\u1ee9 \u0111\u1ec3 c\u1eadp nh\u1eadt historical data, rule c\u1ea7n \u0111\u01b0\u1ee3c thi\u1ebft k\u1ebf \u0111\u1ee7 linh ho\u1ea1t.<\/p>\n<h2>Text Length gi\u00fap ki\u1ec3m so\u00e1t m\u00e3 v\u00e0 \u0111\u1ecbnh d\u1ea1ng \u0111\u01a1n gi\u1ea3n<\/h2>\n<p>Data Validation c\u0169ng c\u00f3 th\u1ec3 gi\u1edbi h\u1ea1n \u0111\u1ed9 d\u00e0i v\u0103n b\u1ea3n. \u0110\u00e2y l\u00e0 m\u1ed9t t\u00ednh n\u0103ng h\u1eefu \u00edch v\u1edbi m\u00e3 nh\u00e2n vi\u00ean, m\u00e3 d\u1ef1 \u00e1n ho\u1eb7c code c\u00f3 chi\u1ec1u d\u00e0i c\u1ed1 \u0111\u1ecbnh.<\/p>\n<p>V\u00ed d\u1ee5, Employee ID lu\u00f4n c\u00f3 8 k\u00fd t\u1ef1. Ng\u01b0\u1eddi thi\u1ebft k\u1ebf c\u00f3 th\u1ec3 gi\u1edbi h\u1ea1n Text Length b\u1eb1ng 8 \u0111\u1ec3 gi\u1ea3m t\u00ecnh tr\u1ea1ng thi\u1ebfu ho\u1eb7c th\u1eeba k\u00fd t\u1ef1.<\/p>\n<p>Microsoft h\u1ed7 tr\u1ee3 Text Length validation v\u00e0 cho ph\u00e9p x\u00e1c \u0111\u1ecbnh s\u1ed1 k\u00fd t\u1ef1 t\u1ed1i \u0111a ho\u1eb7c \u0111i\u1ec1u ki\u1ec7n \u0111\u1ed9 d\u00e0i c\u1ee5 th\u1ec3.<\/p>\n<p>Tuy nhi\u00ean, n\u1ebfu format ph\u1ee9c t\u1ea1p h\u01a1n nh\u01b0 <code>EMP-000123<\/code>, c\u00f3 th\u1ec3 c\u1ea7n d\u00f9ng Custom formula thay v\u00ec ch\u1ec9 gi\u1edbi h\u1ea1n \u0111\u1ed9 d\u00e0i.<\/p>\n<h2>Custom formula gi\u00fap ki\u1ec3m so\u00e1t logic ph\u1ee9c t\u1ea1p h\u01a1n<\/h2>\n<p>Data Validation c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng Custom formula \u0111\u1ec3 ki\u1ec3m tra \u0111i\u1ec1u ki\u1ec7n n\u00e2ng cao.<\/p>\n<p>V\u00ed d\u1ee5, m\u1ed9t \u00f4 ch\u1ec9 \u0111\u01b0\u1ee3c nh\u1eadp n\u1ebfu m\u1ed9t \u00f4 kh\u00e1c \u0111\u00e3 c\u00f3 d\u1eef li\u1ec7u, ho\u1eb7c Employee ID ph\u1ea3i b\u1eaft \u0111\u1ea7u b\u1eb1ng m\u1ed9t ti\u1ec1n t\u1ed1 c\u1ee5 th\u1ec3.<\/p>\n<p>Microsoft cho ph\u00e9p d\u00f9ng c\u00f4ng th\u1ee9c trong Data Validation \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh gi\u00e1 tr\u1ecb n\u00e0o h\u1ee3p l\u1ec7.<\/p>\n<p>Tuy nhi\u00ean, Custom formula n\u00ean \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng c\u1ea9n th\u1eadn. N\u1ebfu c\u00f4ng th\u1ee9c qu\u00e1 ph\u1ee9c t\u1ea1p, ng\u01b0\u1eddi kh\u00e1c r\u1ea5t kh\u00f3 b\u1ea3o tr\u00ec workbook. Trong doanh nghi\u1ec7p, rule n\u00ean d\u1ec5 hi\u1ec3u \u0111\u1ee7 \u0111\u1ec3 ng\u01b0\u1eddi ti\u1ebfp qu\u1ea3n c\u00f3 th\u1ec3 x\u00e1c \u0111\u1ecbnh t\u1ea1i sao m\u1ed9t gi\u00e1 tr\u1ecb b\u1ecb t\u1eeb ch\u1ed1i.<\/p>\n<h2>Input Message gi\u00fap ng\u01b0\u1eddi d\u00f9ng bi\u1ebft ph\u1ea3i nh\u1eadp g\u00ec<\/h2>\n<p>M\u1ed9t file d\u00f9ng chung t\u1ed1t kh\u00f4ng n\u00ean ch\u1edd ng\u01b0\u1eddi d\u00f9ng nh\u1eadp sai r\u1ed3i m\u1edbi b\u00e1o l\u1ed7i.<\/p>\n<p>Excel cho ph\u00e9p hi\u1ec3n th\u1ecb <strong>Input Message<\/strong> khi ng\u01b0\u1eddi d\u00f9ng ch\u1ecdn m\u1ed9t \u00f4 c\u00f3 Data Validation. Message c\u00f3 th\u1ec3 gi\u1ea3i th\u00edch lo\u1ea1i d\u1eef li\u1ec7u c\u1ea7n nh\u1eadp.<\/p>\n<p>V\u00ed d\u1ee5, khi ng\u01b0\u1eddi d\u00f9ng ch\u1ecdn c\u1ed9t Employee ID, message c\u00f3 th\u1ec3 hi\u1ec3n th\u1ecb: \u201cNh\u1eadp m\u00e3 nh\u00e2n vi\u00ean g\u1ed3m 8 k\u00fd t\u1ef1\u201d.<\/p>\n<p>Khi ch\u1ecdn c\u1ed9t Approval Status, message c\u00f3 th\u1ec3 n\u00f3i: \u201cCh\u1ecdn m\u1ed9t trong c\u00e1c tr\u1ea1ng th\u00e1i c\u00f3 s\u1eb5n\u201d.<\/p>\n<p>Nh\u1eefng h\u01b0\u1edbng d\u1eabn ng\u1eafn nh\u01b0 v\u1eady gi\u00fap gi\u1ea3m s\u1ed1 l\u1ea7n user ph\u1ea3i h\u1ecfi ng\u01b0\u1eddi t\u1ea1o file v\u00e0 c\u0169ng gi\u00fap workbook d\u1ec5 s\u1eed d\u1ee5ng h\u01a1n v\u1edbi nh\u00e2n vi\u00ean m\u1edbi.<\/p>\n<h2>Error Alert n\u00ean \u0111\u01b0\u1ee3c thi\u1ebft k\u1ebf r\u00f5 r\u00e0ng<\/h2>\n<p>Khi ng\u01b0\u1eddi d\u00f9ng nh\u1eadp sai, Excel c\u00f3 th\u1ec3 hi\u1ec3n th\u1ecb Error Alert. Microsoft hi\u1ec7n h\u1ed7 tr\u1ee3 c\u00e1c ki\u1ec3u c\u1ea3nh b\u00e1o kh\u00e1c nhau, trong \u0111\u00f3 Stop bu\u1ed9c ng\u01b0\u1eddi d\u00f9ng s\u1eeda d\u1eef li\u1ec7u tr\u01b0\u1edbc khi ti\u1ebfp t\u1ee5c, c\u00f2n Warning ho\u1eb7c d\u1ea1ng c\u1ea3nh b\u00e1o nh\u1eb9 h\u01a1n c\u00f3 th\u1ec3 cho ph\u00e9p ng\u01b0\u1eddi d\u00f9ng ti\u1ebfp t\u1ee5c trong m\u1ed9t s\u1ed1 t\u00ecnh hu\u1ed1ng.<\/p>\n<p>N\u1ebfu d\u1eef li\u1ec7u b\u1eaft bu\u1ed9c ph\u1ea3i ch\u00ednh x\u00e1c, ch\u1eb3ng h\u1ea1n Status ho\u1eb7c Department, d\u00f9ng Stop th\u01b0\u1eddng h\u1ee3p l\u00fd h\u01a1n. N\u1ebfu ch\u1ec9 mu\u1ed1n c\u1ea3nh b\u00e1o nh\u01b0ng v\u1eabn cho ph\u00e9p ngo\u1ea1i l\u1ec7, Warning c\u00f3 th\u1ec3 ph\u00f9 h\u1ee3p.<\/p>\n<p>Error message c\u0169ng n\u00ean n\u00f3i r\u00f5 c\u1ea7n s\u1eeda g\u00ec. M\u1ed9t th\u00f4ng b\u00e1o \u201cInvalid value\u201d kh\u00f4ng h\u1eefu \u00edch b\u1eb1ng \u201cCh\u1ec9 \u0111\u01b0\u1ee3c nh\u1eadp s\u1ed1 l\u01b0\u1ee3ng t\u1eeb 1 \u0111\u1ebfn 500\u201d.<\/p>\n<h2>Data Validation kh\u00f4ng t\u1ef1 s\u1eeda d\u1eef li\u1ec7u c\u0169<\/h2>\n<p>M\u1ed9t \u0111i\u1ec1u d\u1ec5 hi\u1ec3u nh\u1ea7m l\u00e0 n\u1ebfu Data Validation \u0111\u01b0\u1ee3c \u00e1p d\u1ee5ng sau khi d\u1eef li\u1ec7u \u0111\u00e3 \u0111\u01b0\u1ee3c nh\u1eadp, Excel kh\u00f4ng t\u1ef1 \u0111\u1ed9ng s\u1eeda ho\u1eb7c c\u1ea3nh b\u00e1o to\u00e0n b\u1ed9 nh\u1eefng gi\u00e1 tr\u1ecb c\u0169 \u0111ang sai.<\/p>\n<p>Microsoft cho bi\u1ebft b\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng <strong>Circle Invalid Data<\/strong> \u0111\u1ec3 \u0111\u00e1nh d\u1ea5u nh\u1eefng \u00f4 hi\u1ec7n c\u00f3 kh\u00f4ng \u0111\u00e1p \u1ee9ng validation rule.<\/p>\n<p>\u0110i\u1ec1u n\u00e0y r\u1ea5t h\u1eefu \u00edch khi doanh nghi\u1ec7p \u0111ang chu\u1ea9n h\u00f3a m\u1ed9t workbook c\u0169. Sau khi th\u00eam Data Validation, n\u00ean ki\u1ec3m tra d\u1eef li\u1ec7u hi\u1ec7n t\u1ea1i tr\u01b0\u1edbc khi ti\u1ebfp t\u1ee5c s\u1eed d\u1ee5ng file.<\/p>\n<p>N\u1ebfu kh\u00f4ng, workbook c\u00f3 th\u1ec3 v\u1eeba c\u00f3 rule m\u1edbi v\u1eeba ch\u1ee9a d\u1eef li\u1ec7u l\u1ecbch s\u1eed kh\u00f4ng tu\u00e2n th\u1ee7 rule \u0111\u00f3.<\/p>\n<h2>L\u1ed7i ph\u1ed5 bi\u1ebfn nh\u1ea5t: copy-paste c\u00f3 th\u1ec3 v\u01b0\u1ee3t qua Data Validation<\/h2>\n<p>\u0110\u00e2y l\u00e0 m\u1ed9t \u0111i\u1ec3m r\u1ea5t quan tr\u1ecdng.<\/p>\n<p>Microsoft l\u01b0u \u00fd r\u1eb1ng Data Validation ch\u1ee7 y\u1ebfu ki\u1ec3m so\u00e1t d\u1eef li\u1ec7u khi ng\u01b0\u1eddi d\u00f9ng <strong>g\u00f5 tr\u1ef1c ti\u1ebfp<\/strong> v\u00e0o \u00f4. Khi d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c copy ho\u1eb7c fill, validation message c\u00f3 th\u1ec3 kh\u00f4ng xu\u1ea5t hi\u1ec7n theo c\u00e1ch ng\u01b0\u1eddi d\u00f9ng mong \u0111\u1ee3i.<\/p>\n<p>\u0110i\u1ec1u n\u00e0y c\u00f3 ngh\u0129a Data Validation kh\u00f4ng ph\u1ea3i l\u00e0 m\u1ed9t h\u00e0ng r\u00e0o tuy\u1ec7t \u0111\u1ed1i.<\/p>\n<p>V\u00ed d\u1ee5, c\u1ed9t Status c\u00f3 dropdown \u201cOpen\u201d, \u201cIn Progress\u201d v\u00e0 \u201cClosed\u201d. M\u1ed9t ng\u01b0\u1eddi c\u00f3 th\u1ec3 copy m\u1ed9t gi\u00e1 tr\u1ecb \u201cPending\u201d t\u1eeb m\u1ed9t \u00f4 kh\u00e1c v\u00e0 paste v\u00e0o v\u00f9ng \u0111\u00f3. Trong m\u1ed9t s\u1ed1 tr\u01b0\u1eddng h\u1ee3p, d\u1eef li\u1ec7u kh\u00f4ng h\u1ee3p l\u1ec7 v\u1eabn c\u00f3 th\u1ec3 xu\u1ea5t hi\u1ec7n.<\/p>\n<p>V\u00ec v\u1eady, v\u1edbi file quan tr\u1ecdng, doanh nghi\u1ec7p n\u00ean k\u1ebft h\u1ee3p Data Validation v\u1edbi review \u0111\u1ecbnh k\u1ef3, Conditional Formatting ho\u1eb7c c\u00e1c b\u01b0\u1edbc ki\u1ec3m tra d\u1eef li\u1ec7u kh\u00e1c.<\/p>\n<h2>Copy-paste c\u0169ng c\u00f3 th\u1ec3 l\u00e0m m\u1ea5t rule<\/h2>\n<p>N\u1ebfu ng\u01b0\u1eddi d\u00f9ng copy c\u1ea3 m\u1ed9t \u00f4 t\u1eeb v\u00f9ng kh\u00e1c v\u00e0 paste l\u00ean \u00f4 \u0111\u00e3 c\u00f3 Data Validation, validation rule c\u00f3 th\u1ec3 b\u1ecb thay th\u1ebf t\u00f9y c\u00e1ch paste.<\/p>\n<p>\u0110\u00e2y l\u00e0 m\u1ed9t l\u1ed7i r\u1ea5t th\u01b0\u1eddng g\u1eb7p trong file d\u00f9ng chung. Sau v\u00e0i th\u00e1ng, m\u1ed9t s\u1ed1 d\u00f2ng v\u1eabn c\u00f3 dropdown, nh\u01b0ng m\u1ed9t s\u1ed1 d\u00f2ng kh\u00e1c l\u1ea1i kh\u00f4ng c\u00f2n.<\/p>\n<p>\u0110\u1ec3 gi\u1ea3m r\u1ee7i ro, ng\u01b0\u1eddi d\u00f9ng n\u00ean h\u1ea1n ch\u1ebf paste to\u00e0n b\u1ed9 cell formatting v\u00e0o v\u00f9ng input. Khi c\u1ea7n, c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng Paste Values thay v\u00ec paste to\u00e0n b\u1ed9.<\/p>\n<p>V\u1edbi nh\u1eefng workbook c\u00f3 r\u1ee7i ro cao, worksheet protection c\u0169ng c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c c\u00e2n nh\u1eafc \u0111\u1ec3 h\u1ea1n ch\u1ebf vi\u1ec7c ng\u01b0\u1eddi d\u00f9ng v\u00f4 t\u00ecnh s\u1eeda c\u1ea5u tr\u00fac.<\/p>\n<h2>Excel Table gi\u00fap Data Validation d\u1ec5 qu\u1ea3n l\u00fd h\u01a1n<\/h2>\n<p>Data Validation v\u00e0 Excel Table th\u01b0\u1eddng n\u00ean \u0111\u01b0\u1ee3c thi\u1ebft k\u1ebf c\u00f9ng nhau.<\/p>\n<p>Table gi\u00fap d\u1eef li\u1ec7u c\u00f3 c\u1ea5u tr\u00fac, t\u1ef1 m\u1edf r\u1ed9ng khi th\u00eam row v\u00e0 h\u1ed7 tr\u1ee3 c\u00e1c t\u00ednh n\u0103ng kh\u00e1c nh\u01b0 Structured References, PivotTable v\u00e0 Power Query. V\u1edbi dropdown source, Microsoft c\u0169ng khuy\u1ebfn ngh\u1ecb s\u1eed d\u1ee5ng Table v\u00ec source list s\u1ebd t\u1ef1 c\u1eadp nh\u1eadt khi item thay \u0111\u1ed5i.<\/p>\n<p>V\u00ed d\u1ee5, m\u1ed9t file qu\u1ea3n l\u00fd t\u00e0i s\u1ea3n c\u00f3 th\u1ec3 c\u00f3 Table ch\u00ednh g\u1ed3m Asset ID, Category, Department v\u00e0 Status. C\u00e1c danh s\u00e1ch Category, Department v\u00e0 Status c\u00f3 th\u1ec3 n\u1eb1m trong m\u1ed9t sheet Config d\u01b0\u1edbi d\u1ea1ng Table ri\u00eang.<\/p>\n<p>Khi administrator th\u00eam m\u1ed9t Category m\u1edbi, dropdown c\u1ee7a ng\u01b0\u1eddi d\u00f9ng c\u0169ng \u0111\u01b0\u1ee3c c\u1eadp nh\u1eadt.<\/p>\n<p>C\u00e1ch t\u1ed5 ch\u1ee9c n\u00e0y ph\u00f9 h\u1ee3p v\u1edbi workbook d\u00f9ng l\u00e2u d\u00e0i h\u01a1n l\u00e0 nh\u1eadp tr\u1ef1c ti\u1ebfp c\u00e1c gi\u00e1 tr\u1ecb v\u00e0o Source box.<\/p>\n<h2>N\u00ean t\u00e1ch danh s\u00e1ch master kh\u1ecfi v\u00f9ng nh\u1eadp li\u1ec7u<\/h2>\n<p>M\u1ed9t thi\u1ebft k\u1ebf t\u1ed1t l\u00e0 t\u1ea1o m\u1ed9t sheet ri\u00eang nh\u01b0 <code>Config<\/code>, <code>Lists<\/code> ho\u1eb7c <code>MasterData<\/code> \u0111\u1ec3 l\u01b0u c\u00e1c gi\u00e1 tr\u1ecb h\u1ee3p l\u1ec7.<\/p>\n<p>V\u00ed d\u1ee5 sheet n\u00e0y c\u00f3 th\u1ec3 ch\u1ee9a danh s\u00e1ch Department, Status, Category v\u00e0 Location. Ng\u01b0\u1eddi d\u00f9ng th\u00f4ng th\u01b0\u1eddng kh\u00f4ng c\u1ea7n ch\u1ec9nh tr\u1ef1c ti\u1ebfp c\u00e1c danh s\u00e1ch n\u00e0y.<\/p>\n<p>Vi\u1ec7c t\u00e1ch master list gi\u00fap d\u1ec5 ki\u1ec3m so\u00e1t h\u01a1n v\u00e0 tr\u00e1nh tr\u01b0\u1eddng h\u1ee3p m\u1ed9t nh\u00e2n vi\u00ean v\u00f4 t\u00ecnh s\u1eeda m\u1ed9t item trong dropdown.<\/p>\n<p>N\u1ebfu c\u1ea7n, sheet n\u00e0y c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c \u1ea9n ho\u1eb7c b\u1ea3o v\u1ec7 sau khi c\u1ea5u h\u00ecnh xong.<\/p>\n<h2>Use case th\u1ef1c t\u1ebf: file qu\u1ea3n l\u00fd nh\u00e2n vi\u00ean<\/h2>\n<p>Gi\u1ea3 s\u1eed HR d\u00f9ng Excel \u0111\u1ec3 qu\u1ea3n l\u00fd danh s\u00e1ch nh\u00e2n vi\u00ean. C\u00e1c c\u1ed9t nh\u01b0 Department, Employment Type v\u00e0 Status r\u1ea5t ph\u00f9 h\u1ee3p v\u1edbi dropdown.<\/p>\n<p>N\u1ebfu kh\u00f4ng c\u00f3 Data Validation, HR c\u00f3 th\u1ec3 g\u1eb7p c\u00e1c gi\u00e1 tr\u1ecb nh\u01b0 \u201cFull time\u201d, \u201cFull-time\u201d, \u201cFT\u201d ho\u1eb7c \u201cPermanent\u201d. Khi l\u00e0m b\u00e1o c\u00e1o headcount, nh\u1eefng gi\u00e1 tr\u1ecb n\u00e0y s\u1ebd t\u1ea1o ra nhi\u1ec1u nh\u00f3m kh\u00e1c nhau.<\/p>\n<p>N\u1ebfu d\u00f9ng dropdown v\u1edbi m\u1ed9t b\u1ed9 gi\u00e1 tr\u1ecb chu\u1ea9n, d\u1eef li\u1ec7u s\u1ebd nh\u1ea5t qu\u00e1n h\u01a1n t\u1eeb \u0111\u1ea7u.<\/p>\n<p>C\u1ed9t Joining Date c\u00f3 th\u1ec3 d\u00f9ng Date validation, c\u00f2n Employee ID c\u00f3 th\u1ec3 d\u00f9ng Text Length ho\u1eb7c Custom formula.<\/p>\n<p>Nh\u1edd \u0111\u00f3, workbook d\u1ec5 ph\u00e2n t\u00edch h\u01a1n r\u1ea5t nhi\u1ec1u.<\/p>\n<h2>Use case th\u1ef1c t\u1ebf: expense tracking<\/h2>\n<p>Trong file Expense Tracking, Category c\u00f3 th\u1ec3 d\u00f9ng dropdown nh\u01b0 Travel, Office, Software, Marketing v\u00e0 Other.<\/p>\n<p>Amount c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c gi\u1edbi h\u1ea1n l\u00e0 s\u1ed1 d\u01b0\u01a1ng, c\u00f2n Expense Date c\u00f3 th\u1ec3 y\u00eau c\u1ea7u nh\u1eadp ng\u00e0y h\u1ee3p l\u1ec7.<\/p>\n<p>N\u1ebfu workflow ch\u1ec9 cho ph\u00e9p m\u1ed9t s\u1ed1 Currency nh\u1ea5t \u0111\u1ecbnh, c\u1ed9t Currency c\u0169ng c\u00f3 th\u1ec3 d\u00f9ng dropdown.<\/p>\n<p>Data Validation kh\u00f4ng thay th\u1ebf approval process, nh\u01b0ng n\u00f3 gi\u00fap d\u1eef li\u1ec7u tr\u01b0\u1edbc khi \u0111i v\u00e0o b\u01b0\u1edbc approval c\u00f3 c\u1ea5u tr\u00fac t\u1ed1t h\u01a1n.<\/p>\n<h2>Use case th\u1ef1c t\u1ebf: project tracker<\/h2>\n<p>Trong project tracker, Status v\u00e0 Priority l\u00e0 hai tr\u01b0\u1eddng r\u1ea5t ph\u00f9 h\u1ee3p v\u1edbi dropdown. Progress Percentage c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c gi\u1edbi h\u1ea1n t\u1eeb 0 \u0111\u1ebfn 100.<\/p>\n<p>Start Date v\u00e0 Due Date c\u0169ng c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c ki\u1ec3m so\u00e1t b\u1eb1ng Date validation ho\u1eb7c Custom formula n\u1ebfu doanh nghi\u1ec7p mu\u1ed1n Due Date kh\u00f4ng \u0111\u01b0\u1ee3c tr\u01b0\u1edbc Start Date.<\/p>\n<p>Nh\u1edd \u0111\u00f3, file d\u00f9ng chung c\u00f3 \u00edt l\u1ed7i logic h\u01a1n v\u00e0 dashboard ph\u00eda sau c\u0169ng \u0111\u00e1ng tin c\u1eady h\u01a1n.<\/p>\n<h2>L\u1ed7i th\u01b0\u1eddng g\u1eb7p: source dropdown d\u00f9ng v\u00f9ng c\u1ed1 \u0111\u1ecbnh<\/h2>\n<p>M\u1ed9t dropdown c\u00f3 source <code>=$A$2:$A$10<\/code> s\u1ebd kh\u00f4ng t\u1ef1 bi\u1ebft r\u1eb1ng sau n\u00e0y danh s\u00e1ch c\u00f3 th\u00eam d\u1eef li\u1ec7u \u1edf d\u00f2ng 11.<\/p>\n<p>Microsoft khuy\u1ebfn ngh\u1ecb d\u00f9ng Excel Table l\u00e0m ngu\u1ed3n \u0111\u1ec3 dropdown t\u1ef1 c\u1eadp nh\u1eadt khi th\u00eam ho\u1eb7c x\u00f3a item.<\/p>\n<p>N\u1ebfu workbook \u0111\u01b0\u1ee3c d\u00f9ng h\u1eb1ng ng\u00e0y, \u0111\u00e2y l\u00e0 m\u1ed9t thay \u0111\u1ed5i nh\u1ecf nh\u01b0ng gi\u00fap gi\u1ea3m r\u1ea5t nhi\u1ec1u maintenance v\u1ec1 l\u00e2u d\u00e0i.<\/p>\n<h2>L\u1ed7i th\u01b0\u1eddng g\u1eb7p: dropdown ch\u1ee9a kho\u1ea3ng tr\u1eafng ho\u1eb7c item g\u1ea7n gi\u1ed1ng nhau<\/h2>\n<p>N\u1ebfu master list c\u00f3 nh\u1eefng gi\u00e1 tr\u1ecb nh\u01b0 \u201cMarketing\u201d v\u00e0 \u201cMarketing \u201d v\u1edbi m\u1ed9t kho\u1ea3ng tr\u1eafng \u1edf cu\u1ed1i, ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 nh\u00ecn th\u1ea5y ch\u00fang nh\u01b0 c\u00f9ng m\u1ed9t item nh\u01b0ng Excel l\u1ea1i coi l\u00e0 hai gi\u00e1 tr\u1ecb kh\u00e1c nhau.<\/p>\n<p>T\u01b0\u01a1ng t\u1ef1, \u201cIn Progress\u201d v\u00e0 \u201cIn-Progress\u201d c\u00f3 th\u1ec3 t\u1ea1o ra hai nh\u00f3m khi t\u1ed5ng h\u1ee3p.<\/p>\n<p>V\u00ec v\u1eady, Data Validation ch\u1ec9 t\u1ed1t khi master data ph\u00eda sau c\u0169ng \u0111\u01b0\u1ee3c chu\u1ea9n h\u00f3a.<\/p>\n<p>Administrator n\u00ean review danh s\u00e1ch ngu\u1ed3n tr\u01b0\u1edbc khi \u0111\u01b0a v\u00e0o s\u1eed d\u1ee5ng.<\/p>\n<h2>L\u1ed7i th\u01b0\u1eddng g\u1eb7p: d\u00f9ng qu\u00e1 nhi\u1ec1u dropdown<\/h2>\n<p>Kh\u00f4ng ph\u1ea3i m\u1ecdi c\u1ed9t \u0111\u1ec1u c\u1ea7n Data Validation.<\/p>\n<p>N\u1ebfu m\u1ed9t c\u1ed9t l\u00e0 Notes ho\u1eb7c Description, vi\u1ec7c c\u1ed1 t\u1ea1o dropdown s\u1ebd l\u00e0m file m\u1ea5t t\u00ednh linh ho\u1ea1t.<\/p>\n<p>Data Validation n\u00ean t\u1eadp trung v\u00e0o nh\u1eefng field c\u00f3 t\u1eadp gi\u00e1 tr\u1ecb h\u1eefu h\u1ea1n ho\u1eb7c logic r\u00f5 r\u00e0ng, ch\u1eb3ng h\u1ea1n Department, Status, Priority, Category, Date Range ho\u1eb7c Numeric Range.<\/p>\n<p>M\u1ee5c ti\u00eau l\u00e0 gi\u1ea3m l\u1ed7i ch\u1ee9 kh\u00f4ng ph\u1ea3i bi\u1ebfn m\u1ecdi \u00f4 th\u00e0nh m\u1ed9t form c\u1ee9ng nh\u1eafc.<\/p>\n<h2>L\u1ed7i th\u01b0\u1eddng g\u1eb7p: kh\u00f4ng test c\u1ea3 d\u1eef li\u1ec7u \u0111\u00fang v\u00e0 sai<\/h2>\n<p>Microsoft khuy\u1ebfn ngh\u1ecb sau khi thi\u1ebft l\u1eadp Data Validation n\u00ean th\u1eed nh\u1eadp c\u1ea3 gi\u00e1 tr\u1ecb h\u1ee3p l\u1ec7 v\u00e0 kh\u00f4ng h\u1ee3p l\u1ec7 \u0111\u1ec3 x\u00e1c nh\u1eadn rule ho\u1ea1t \u0111\u1ed9ng nh\u01b0 mong \u0111\u1ee3i.<\/p>\n<p>\u0110\u00e2y l\u00e0 b\u01b0\u1edbc \u0111\u01a1n gi\u1ea3n nh\u01b0ng th\u01b0\u1eddng b\u1ecb b\u1ecf qua.<\/p>\n<p>V\u00ed d\u1ee5, n\u1ebfu rule ch\u1ec9 cho ph\u00e9p s\u1ed1 t\u1eeb 1 \u0111\u1ebfn 100, h\u00e3y th\u1eed nh\u1eadp 50, 0, 101 v\u00e0 m\u1ed9t chu\u1ed7i text. N\u1ebfu t\u1ea5t c\u1ea3 ph\u1ea3n \u1ee9ng \u0111\u00fang, rule m\u1edbi th\u1ef1c s\u1ef1 s\u1eb5n s\u00e0ng.<\/p>\n<p>V\u1edbi Custom formula, vi\u1ec7c test c\u00e0ng quan tr\u1ecdng v\u00ec l\u1ed7i c\u00f4ng th\u1ee9c c\u00f3 th\u1ec3 l\u00e0m validation kh\u00f4ng ho\u1ea1t \u0111\u1ed9ng \u0111\u00fang.<\/p>\n<h2>N\u1ebfu Data Validation kh\u00f4ng ch\u1ec9nh s\u1eeda \u0111\u01b0\u1ee3c th\u00ec sao?<\/h2>\n<p>Microsoft l\u01b0u \u00fd r\u1eb1ng l\u1ec7nh Data Validation c\u00f3 th\u1ec3 kh\u00f4ng kh\u1ea3 d\u1ee5ng n\u1ebfu worksheet \u0111ang \u0111\u01b0\u1ee3c protected ho\u1eb7c workbook \u0111ang \u1edf tr\u1ea1ng th\u00e1i shared theo m\u1ed9t s\u1ed1 m\u00f4 h\u00ecnh c\u0169.<\/p>\n<p>N\u1ebfu ng\u01b0\u1eddi d\u00f9ng kh\u00f4ng th\u1ec3 thay \u0111\u1ed5i validation, tr\u01b0\u1edbc ti\u00ean n\u00ean ki\u1ec3m tra protection.<\/p>\n<p>Trong file doanh nghi\u1ec7p, \u0111\u00e2y th\u01b0\u1eddng l\u00e0 h\u00e0nh vi c\u00f3 ch\u1ee7 \u0111\u00edch. Ng\u01b0\u1eddi d\u00f9ng cu\u1ed1i c\u00f3 th\u1ec3 ch\u1ec9 \u0111\u01b0\u1ee3c ph\u00e9p nh\u1eadp d\u1eef li\u1ec7u, c\u00f2n c\u1ea5u tr\u00fac validation do owner ho\u1eb7c administrator qu\u1ea3n l\u00fd.<\/p>\n<p>Kh\u00f4ng n\u00ean t\u1ef1 \u00fd b\u1ecf protection n\u1ebfu ch\u01b0a hi\u1ec3u l\u00fd do workbook \u0111\u01b0\u1ee3c kh\u00f3a.<\/p>\n<h2>Data Validation kh\u00f4ng thay th\u1ebf data governance<\/h2>\n<p>Data Validation gi\u00fap ki\u1ec3m so\u00e1t \u0111\u1ea7u v\u00e0o t\u1ea1i c\u1ea5p workbook, nh\u01b0ng n\u00f3 kh\u00f4ng ph\u1ea3i l\u00e0 m\u1ed9t h\u1ec7 th\u1ed1ng database hay data governance ho\u00e0n ch\u1ec9nh.<\/p>\n<p>N\u1ebfu doanh nghi\u1ec7p c\u00f3 h\u00e0ng tr\u0103m ng\u01b0\u1eddi c\u00f9ng nh\u1eadp d\u1eef li\u1ec7u, nhi\u1ec1u workflow approval ho\u1eb7c y\u00eau c\u1ea7u audit ch\u1eb7t ch\u1ebd, Excel c\u00f3 th\u1ec3 b\u1eaft \u0111\u1ea7u v\u01b0\u1ee3t qu\u00e1 vai tr\u00f2 ph\u00f9 h\u1ee3p.<\/p>\n<p>Trong nh\u1eefng t\u00ecnh hu\u1ed1ng \u0111\u00f3, Microsoft Lists, Power Apps, SharePoint ho\u1eb7c m\u1ed9t h\u1ec7 th\u1ed1ng business application c\u00f3 th\u1ec3 ph\u00f9 h\u1ee3p h\u01a1n.<\/p>\n<p>Excel v\u1eabn r\u1ea5t m\u1ea1nh cho data collection quy m\u00f4 nh\u1ecf v\u00e0 trung b\u00ecnh, \u0111\u1eb7c bi\u1ec7t khi Data Validation, Table v\u00e0 protection \u0111\u01b0\u1ee3c thi\u1ebft k\u1ebf t\u1ed1t. Nh\u01b0ng doanh nghi\u1ec7p n\u00ean bi\u1ebft khi n\u00e0o c\u1ea7n chuy\u1ec3n t\u1eeb spreadsheet sang m\u1ed9t h\u1ec7 th\u1ed1ng c\u00f3 c\u1ea5u tr\u00fac h\u01a1n.<\/p>\n<h2>M\u1ed9t nguy\u00ean t\u1eafc tri\u1ec3n khai \u0111\u01a1n gi\u1ea3n<\/h2>\n<p>Tr\u01b0\u1edbc khi t\u1ea1o Data Validation, h\u00e3y h\u1ecfi ba c\u00e2u: field n\u00e0y c\u00f3 m\u1ed9t t\u1eadp gi\u00e1 tr\u1ecb h\u1ee3p l\u1ec7 r\u00f5 r\u00e0ng kh\u00f4ng, l\u1ed7i nh\u1eadp li\u1ec7u \u1edf field n\u00e0y c\u00f3 \u1ea3nh h\u01b0\u1edfng t\u1edbi b\u00e1o c\u00e1o ph\u00eda sau kh\u00f4ng, v\u00e0 ng\u01b0\u1eddi d\u00f9ng c\u00f3 c\u1ea7n t\u1ef1 do nh\u1eadp n\u1ed9i dung hay ch\u1ec9 c\u1ea7n ch\u1ecdn t\u1eeb m\u1ed9t danh s\u00e1ch?<\/p>\n<p>N\u1ebfu gi\u00e1 tr\u1ecb c\u1ea7n chu\u1ea9n h\u00f3a, Data Validation r\u1ea5t ph\u00f9 h\u1ee3p. N\u1ebfu field l\u00e0 n\u1ed9i dung t\u1ef1 do, kh\u00f4ng n\u00ean \u00e9p ng\u01b0\u1eddi d\u00f9ng v\u00e0o m\u1ed9t h\u1ec7 th\u1ed1ng dropdown kh\u00f4ng c\u1ea7n thi\u1ebft.<\/p>\n<p>M\u1ed9t thi\u1ebft k\u1ebf t\u1ed1t th\u01b0\u1eddng ch\u1ec9 \u00e1p d\u1ee5ng validation cho nh\u1eefng \u0111i\u1ec3m d\u1eef li\u1ec7u quan tr\u1ecdng nh\u1ea5t.<\/p>\n<h2>Checklist tri\u1ec3n khai Data Validation<\/h2>\n<p>Tr\u01b0\u1edbc khi \u0111\u01b0a workbook v\u00e0o s\u1eed d\u1ee5ng chung, doanh nghi\u1ec7p n\u00ean ki\u1ec3m tra dropdown source \u0111\u00e3 \u0111\u01b0\u1ee3c chu\u1ea9n h\u00f3a hay ch\u01b0a, master list c\u00f3 n\u1eb1m trong Excel Table \u0111\u1ec3 d\u1ec5 c\u1eadp nh\u1eadt kh\u00f4ng, c\u00e1c gi\u1edbi h\u1ea1n s\u1ed1 v\u00e0 ng\u00e0y c\u00f3 ph\u00f9 h\u1ee3p v\u1edbi business rule kh\u00f4ng, v\u00e0 Input Message\/Error Alert c\u00f3 gi\u00fap ng\u01b0\u1eddi d\u00f9ng hi\u1ec3u c\u1ea7n nh\u1eadp g\u00ec kh\u00f4ng. Nh\u1eefng v\u00f9ng c\u00f3 validation n\u00ean \u0111\u01b0\u1ee3c test b\u1eb1ng c\u1ea3 d\u1eef li\u1ec7u \u0111\u00fang v\u00e0 sai, \u0111\u1ed3ng th\u1eddi c\u1ea7n ki\u1ec3m tra kh\u1ea3 n\u0103ng copy-paste l\u00e0m m\u1ea5t ho\u1eb7c v\u01b0\u1ee3t qua validation.<\/p>\n<p>V\u1edbi file d\u00f9ng l\u00e2u d\u00e0i, n\u00ean \u0111\u1ecbnh k\u1ef3 d\u00f9ng Circle Invalid Data ho\u1eb7c c\u00e1c b\u01b0\u1edbc ki\u1ec3m tra t\u01b0\u01a1ng t\u1ef1 \u0111\u1ec3 ph\u00e1t hi\u1ec7n d\u1eef li\u1ec7u kh\u00f4ng h\u1ee3p l\u1ec7 \u0111\u00e3 t\u1ed3n t\u1ea1i. N\u1ebfu worksheet \u0111\u01b0\u1ee3c b\u1ea3o v\u1ec7, c\u1ea7n ho\u00e0n thi\u1ec7n validation tr\u01b0\u1edbc khi kh\u00f3a c\u1ea5u tr\u00fac, v\u00ec Microsoft l\u01b0u \u00fd ng\u01b0\u1eddi d\u00f9ng kh\u00f4ng th\u1ec3 ch\u1ec9nh setting validation khi sheet \u0111ang protected.<\/p>\n<h1>Conclude<\/h1>\n<p>Microsoft Excel Data Validation l\u00e0 m\u1ed9t trong nh\u1eefng c\u00f4ng c\u1ee5 \u0111\u01a1n gi\u1ea3n nh\u1ea5t \u0111\u1ec3 gi\u1ea3m l\u1ed7i nh\u1eadp li\u1ec7u trong file d\u00f9ng chung. N\u00f3 cho ph\u00e9p doanh nghi\u1ec7p gi\u1edbi h\u1ea1n d\u1eef li\u1ec7u theo danh s\u00e1ch, s\u1ed1, ng\u00e0y, th\u1eddi gian, \u0111\u1ed9 d\u00e0i v\u0103n b\u1ea3n ho\u1eb7c Custom formula, \u0111\u1ed3ng th\u1eddi h\u1ed7 tr\u1ee3 Input Message v\u00e0 Error Alert \u0111\u1ec3 h\u01b0\u1edbng d\u1eabn ng\u01b0\u1eddi d\u00f9ng ngay t\u1ea1i th\u1eddi \u0111i\u1ec3m nh\u1eadp.<\/p>\n<p>Gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t c\u1ee7a Data Validation kh\u00f4ng n\u1eb1m \u1edf vi\u1ec7c l\u00e0m workbook ph\u1ee9c t\u1ea1p h\u01a1n, m\u00e0 \u1edf vi\u1ec7c gi\u00fap d\u1eef li\u1ec7u <strong>nh\u1ea5t qu\u00e1n ngay t\u1eeb \u0111\u1ea7u<\/strong>. M\u1ed9t dropdown Department chu\u1ea9n c\u00f3 th\u1ec3 tr\u00e1nh h\u00e0ng tr\u0103m bi\u1ebfn th\u1ec3 t\u00ean ph\u00f2ng ban. M\u1ed9t gi\u1edbi h\u1ea1n Date ho\u1eb7c Number \u0111\u00fang c\u00f3 th\u1ec3 ng\u0103n nh\u1eefng gi\u00e1 tr\u1ecb sai \u0111i v\u00e0o b\u00e1o c\u00e1o. Khi ngu\u1ed3n dropdown \u0111\u01b0\u1ee3c qu\u1ea3n l\u00fd b\u1eb1ng Excel Table, c\u00e1c danh s\u00e1ch c\u0169ng d\u1ec5 b\u1ea3o tr\u00ec h\u01a1n v\u00ec ch\u00fang t\u1ef1 c\u1eadp nh\u1eadt khi th\u00eam ho\u1eb7c x\u00f3a item.<\/p>\n<p>Tuy nhi\u00ean, Data Validation kh\u00f4ng ph\u1ea3i l\u00e0 c\u01a1 ch\u1ebf b\u1ea3o v\u1ec7 tuy\u1ec7t \u0111\u1ed1i. Copy-paste c\u00f3 th\u1ec3 khi\u1ebfn d\u1eef li\u1ec7u kh\u00f4ng h\u1ee3p l\u1ec7 l\u1ecdt v\u00e0o ho\u1eb7c l\u00e0m thay \u0111\u1ed5i rule, v\u00ec v\u1eady workbook quan tr\u1ecdng v\u1eabn c\u1ea7n review d\u1eef li\u1ec7u, protection ph\u00f9 h\u1ee3p v\u00e0 governance r\u00f5 r\u00e0ng.<\/p>\n<p>C\u00f3 th\u1ec3 ghi nh\u1edb m\u1ed9t nguy\u00ean t\u1eafc \u0111\u01a1n gi\u1ea3n: <strong>n\u1ebfu m\u1ed9t field c\u00f3 gi\u00e1 tr\u1ecb h\u1ee3p l\u1ec7 r\u00f5 r\u00e0ng, \u0111\u1eebng \u0111\u1ec3 m\u1ed7i ng\u01b0\u1eddi t\u1ef1 nh\u1eadp theo c\u00e1ch ri\u00eang.<\/strong> H\u00e3y \u0111\u01b0a business rule \u0111\u00f3 tr\u1ef1c ti\u1ebfp v\u00e0o workbook \u0111\u1ec3 Excel h\u1ed7 tr\u1ee3 ki\u1ec3m so\u00e1t ngay t\u1eeb \u0111i\u1ec3m nh\u1eadp d\u1eef li\u1ec7u.<\/p>\n<p><a href=\"https:\/\/f-techsolution.com\/en\/\"><strong>F-Tech h\u1ed7 tr\u1ee3 doanh nghi\u1ec7p chu\u1ea9n h\u00f3a Microsoft Excel, Excel Table, Data Validation, Power Query v\u00e0 c\u00e1c workflow d\u1eef li\u1ec7u trong Microsoft 365 nh\u1eb1m gi\u1ea3m l\u1ed7i th\u1ee7 c\u00f4ng v\u00e0 gi\u00fap d\u1eef li\u1ec7u d\u1ec5 qu\u1ea3n tr\u1ecb h\u01a1n.<\/strong><\/a><\/p>\n<p><a href=\"https:\/\/f-techsolution.com\/en\/\"><strong>Li\u00ean h\u1ec7 F-Tech \u0111\u1ec3 \u0111\u01b0\u1ee3c t\u01b0 v\u1ea5n c\u00e1ch x\u00e2y d\u1ef1ng file Excel v\u00e0 quy tr\u00ecnh d\u1eef li\u1ec7u ph\u00f9 h\u1ee3p v\u1edbi doanh nghi\u1ec7p.<\/strong><\/a><\/p>\n<div class=\"elementor-element elementor-element-bb440f2 e-flex e-con-boxed e-con e-parent e-lazyloaded\" data-id=\"bb440f2\" data-element_type=\"container\">\n<div class=\"e-con-inner\">\n<div class=\"elementor-element elementor-element-d5c554e elementor-widget elementor-widget-heading\" data-id=\"d5c554e\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n<div class=\"elementor-widget-container\">\n<h5 class=\"elementor-heading-title elementor-size-default\">Related articles<\/h5>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"elementor-element elementor-element-2ca2f28 e-flex e-con-boxed e-con e-parent e-lazyloaded\" data-id=\"2ca2f28\" data-element_type=\"container\">\n<div class=\"e-con-inner\">\n<div class=\"elementor-element elementor-element-5a9ead4 elementor-widget elementor-widget-text-editor\" data-id=\"5a9ead4\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n<div class=\"elementor-widget-container\">\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/f-techsolution.com\/en\/blog\/camera-khong-hoat-dong-teams-nen-kiem-tra\/\">Camera kh\u00f4ng ho\u1ea1t \u0111\u1ed9ng trong Teams: n\u00ean ki\u1ec3m tra g\u00ec tr\u01b0\u1edbc?<\/a><\/li>\n<li><a href=\"https:\/\/f-techsolution.com\/en\/blog\/microsoft-365-cloud-productivity\/\">Cloud productivity thay \u0111\u1ed5i c\u00e1ch team c\u1ed9ng t\u00e1c nh\u01b0 th\u1ebf n\u00e0o?<\/a><\/li>\n<li><a href=\"https:\/\/f-techsolution.com\/en\/blog\/4-loai-link-chia-se-onedrive-va-khi-nao-nen-dung-tung-loai\/\">4 lo\u1ea1i link chia s\u1ebb OneDrive v\u00e0 khi n\u00e0o n\u00ean d\u00f9ng t\u1eebng lo\u1ea1i<\/a><\/li>\n<li><a href=\"https:\/\/f-techsolution.com\/en\/blog\/microsoft-teams-shared-channel\/\">Shared Channel trong Teams ph\u00f9 h\u1ee3p v\u1edbi t\u00ecnh hu\u1ed1ng c\u1ed9ng t\u00e1c n\u00e0o?<\/a><\/li>\n<li><a href=\"https:\/\/f-techsolution.com\/en\/blog\/microsoft-planner-labels\/\">D\u00f9ng Label trong Planner th\u1ebf n\u00e0o \u0111\u1ec3 kh\u00f4ng th\u00e0nh m\u1ed9t h\u1ec7 m\u00e0u r\u1ed1i?<\/a><\/li>\n<\/ul>\n<\/div>\n<\/div>\n<\/div>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>Data Validation gi\u00fap gi\u1ea3m l\u1ed7i nh\u1eadp li\u1ec7u trong file Excel d\u00f9ng chung Khi m\u1ed9t file Excel ch\u1ec9 do m\u1ed9t ng\u01b0\u1eddi [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":43888,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"set","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[7],"tags":[],"class_list":["post-43887","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-blog"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Data Validation gi\u00fap gi\u1ea3m l\u1ed7i nh\u1eadp li\u1ec7u trong file Excel d\u00f9ng chung - F-Tech Solution<\/title>\n<meta name=\"description\" content=\"T\u00ecm hi\u1ec3u Excel Data Validation gi\u00fap t\u1ea1o dropdown, gi\u1edbi h\u1ea1n s\u1ed1\/ng\u00e0y, c\u1ea3nh b\u00e1o d\u1eef li\u1ec7u sai v\u00e0 gi\u1ea3m l\u1ed7i nh\u1eadp li\u1ec7u trong file d\u00f9ng chung.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/f-techsolution.com\/en\/blog\/microsoft-excel-data-validation\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Data Validation gi\u00fap gi\u1ea3m l\u1ed7i nh\u1eadp li\u1ec7u trong file Excel d\u00f9ng chung - F-Tech Solution\" \/>\n<meta property=\"og:description\" content=\"T\u00ecm hi\u1ec3u Excel Data Validation gi\u00fap t\u1ea1o dropdown, gi\u1edbi h\u1ea1n s\u1ed1\/ng\u00e0y, c\u1ea3nh b\u00e1o d\u1eef li\u1ec7u sai v\u00e0 gi\u1ea3m l\u1ed7i nh\u1eadp li\u1ec7u trong file d\u00f9ng chung.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/f-techsolution.com\/en\/blog\/microsoft-excel-data-validation\/\" \/>\n<meta property=\"og:site_name\" content=\"F-Tech Solution\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/ftech.solution.vn\" \/>\n<meta property=\"article:published_time\" content=\"2026-11-11T02:11:13+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-11-16T13:14:16+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/f-techsolution.com\/wp-content\/uploads\/2026\/11\/Excel-Data-Validation_-Giam-Loi-Nhap-Lieu.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1671\" \/>\n\t<meta property=\"og:image:height\" content=\"941\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Vi Anh\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Vi Anh\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"16 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":[\"Article\",\"BlogPosting\"],\"@id\":\"https:\\\/\\\/f-techsolution.com\\\/blog\\\/microsoft-excel-data-validation\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/f-techsolution.com\\\/blog\\\/microsoft-excel-data-validation\\\/\"},\"author\":{\"name\":\"Vi Anh\",\"@id\":\"https:\\\/\\\/fusionsol.com.vn\\\/#\\\/schema\\\/person\\\/27b7778b486d7bfd6fa65e3350567f9e\"},\"headline\":\"Data Validation gi\u00fap gi\u1ea3m l\u1ed7i nh\u1eadp li\u1ec7u trong file Excel d\u00f9ng chung\",\"datePublished\":\"2026-11-11T02:11:13+00:00\",\"dateModified\":\"2026-11-16T13:14:16+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/f-techsolution.com\\\/blog\\\/microsoft-excel-data-validation\\\/\"},\"wordCount\":5089,\"publisher\":{\"@id\":\"https:\\\/\\\/fusionsol.com.vn\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/f-techsolution.com\\\/blog\\\/microsoft-excel-data-validation\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/f-techsolution.com\\\/wp-content\\\/uploads\\\/2026\\\/11\\\/Excel-Data-Validation_-Giam-Loi-Nhap-Lieu.png\",\"articleSection\":[\"Blog\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/f-techsolution.com\\\/blog\\\/microsoft-excel-data-validation\\\/\",\"url\":\"https:\\\/\\\/f-techsolution.com\\\/blog\\\/microsoft-excel-data-validation\\\/\",\"name\":\"Data Validation gi\u00fap gi\u1ea3m l\u1ed7i nh\u1eadp li\u1ec7u trong file Excel d\u00f9ng chung - F-Tech Solution\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/fusionsol.com.vn\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/f-techsolution.com\\\/blog\\\/microsoft-excel-data-validation\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/f-techsolution.com\\\/blog\\\/microsoft-excel-data-validation\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/f-techsolution.com\\\/wp-content\\\/uploads\\\/2026\\\/11\\\/Excel-Data-Validation_-Giam-Loi-Nhap-Lieu.png\",\"datePublished\":\"2026-11-11T02:11:13+00:00\",\"dateModified\":\"2026-11-16T13:14:16+00:00\",\"description\":\"T\u00ecm hi\u1ec3u Excel Data Validation gi\u00fap t\u1ea1o dropdown, gi\u1edbi h\u1ea1n s\u1ed1\\\/ng\u00e0y, c\u1ea3nh b\u00e1o d\u1eef li\u1ec7u sai v\u00e0 gi\u1ea3m l\u1ed7i nh\u1eadp li\u1ec7u trong file d\u00f9ng chung.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/f-techsolution.com\\\/blog\\\/microsoft-excel-data-validation\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/f-techsolution.com\\\/blog\\\/microsoft-excel-data-validation\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/f-techsolution.com\\\/blog\\\/microsoft-excel-data-validation\\\/#primaryimage\",\"url\":\"https:\\\/\\\/f-techsolution.com\\\/wp-content\\\/uploads\\\/2026\\\/11\\\/Excel-Data-Validation_-Giam-Loi-Nhap-Lieu.png\",\"contentUrl\":\"https:\\\/\\\/f-techsolution.com\\\/wp-content\\\/uploads\\\/2026\\\/11\\\/Excel-Data-Validation_-Giam-Loi-Nhap-Lieu.png\",\"width\":1671,\"height\":941,\"caption\":\"Microsoft Excel data validation\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/f-techsolution.com\\\/blog\\\/microsoft-excel-data-validation\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/f-techsolution.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Data Validation gi\u00fap gi\u1ea3m l\u1ed7i nh\u1eadp li\u1ec7u trong file Excel d\u00f9ng chung\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/fusionsol.com.vn\\\/#website\",\"url\":\"https:\\\/\\\/fusionsol.com.vn\\\/\",\"name\":\"F-Tech Solution\",\"description\":\"Business Innovation Provider\",\"publisher\":{\"@id\":\"https:\\\/\\\/fusionsol.com.vn\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/fusionsol.com.vn\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/fusionsol.com.vn\\\/#organization\",\"name\":\"F-Tech Solution\",\"alternateName\":\"Fusion Solution Vietnam\",\"url\":\"https:\\\/\\\/fusionsol.com.vn\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/fusionsol.com.vn\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/f-techsolution.com\\\/wp-content\\\/uploads\\\/2026\\\/06\\\/F.Tech-Logo-Final.png\",\"contentUrl\":\"https:\\\/\\\/f-techsolution.com\\\/wp-content\\\/uploads\\\/2026\\\/06\\\/F.Tech-Logo-Final.png\",\"width\":512,\"height\":265,\"caption\":\"F-Tech Solution\"},\"image\":{\"@id\":\"https:\\\/\\\/fusionsol.com.vn\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/ftech.solution.vn\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/f-tech-solutionvn\\\/\",\"https:\\\/\\\/www.youtube.com\\\/@congngheftech\",\"https:\\\/\\\/zalo.me\\\/congngheftech\",\"https:\\\/\\\/www.instagram.com\\\/congnghe.ftech\\\/\",\"https:\\\/\\\/www.threads.com\\\/@congnghe.ftech\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/fusionsol.com.vn\\\/#\\\/schema\\\/person\\\/27b7778b486d7bfd6fa65e3350567f9e\",\"name\":\"Vi Anh\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/02bd04ba761e395025096fd6fade99f99f53476d07f535fd8e0d1e14da075c28?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/02bd04ba761e395025096fd6fade99f99f53476d07f535fd8e0d1e14da075c28?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/02bd04ba761e395025096fd6fade99f99f53476d07f535fd8e0d1e14da075c28?s=96&d=mm&r=g\",\"caption\":\"Vi Anh\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Data Validation gi\u00fap gi\u1ea3m l\u1ed7i nh\u1eadp li\u1ec7u trong file Excel d\u00f9ng chung - F-Tech Solution","description":"T\u00ecm hi\u1ec3u Excel Data Validation gi\u00fap t\u1ea1o dropdown, gi\u1edbi h\u1ea1n s\u1ed1\/ng\u00e0y, c\u1ea3nh b\u00e1o d\u1eef li\u1ec7u sai v\u00e0 gi\u1ea3m l\u1ed7i nh\u1eadp li\u1ec7u trong file d\u00f9ng chung.","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:\/\/f-techsolution.com\/en\/blog\/microsoft-excel-data-validation\/","og_locale":"en_US","og_type":"article","og_title":"Data Validation gi\u00fap gi\u1ea3m l\u1ed7i nh\u1eadp li\u1ec7u trong file Excel d\u00f9ng chung - F-Tech Solution","og_description":"T\u00ecm hi\u1ec3u Excel Data Validation gi\u00fap t\u1ea1o dropdown, gi\u1edbi h\u1ea1n s\u1ed1\/ng\u00e0y, c\u1ea3nh b\u00e1o d\u1eef li\u1ec7u sai v\u00e0 gi\u1ea3m l\u1ed7i nh\u1eadp li\u1ec7u trong file d\u00f9ng chung.","og_url":"https:\/\/f-techsolution.com\/en\/blog\/microsoft-excel-data-validation\/","og_site_name":"F-Tech Solution","article_publisher":"https:\/\/www.facebook.com\/ftech.solution.vn","article_published_time":"2026-11-11T02:11:13+00:00","article_modified_time":"2026-11-16T13:14:16+00:00","og_image":[{"width":1671,"height":941,"url":"https:\/\/f-techsolution.com\/wp-content\/uploads\/2026\/11\/Excel-Data-Validation_-Giam-Loi-Nhap-Lieu.png","type":"image\/png"}],"author":"Vi Anh","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Vi Anh","Est. reading time":"16 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":["Article","BlogPosting"],"@id":"https:\/\/f-techsolution.com\/blog\/microsoft-excel-data-validation\/#article","isPartOf":{"@id":"https:\/\/f-techsolution.com\/blog\/microsoft-excel-data-validation\/"},"author":{"name":"Vi Anh","@id":"https:\/\/fusionsol.com.vn\/#\/schema\/person\/27b7778b486d7bfd6fa65e3350567f9e"},"headline":"Data Validation gi\u00fap gi\u1ea3m l\u1ed7i nh\u1eadp li\u1ec7u trong file Excel d\u00f9ng chung","datePublished":"2026-11-11T02:11:13+00:00","dateModified":"2026-11-16T13:14:16+00:00","mainEntityOfPage":{"@id":"https:\/\/f-techsolution.com\/blog\/microsoft-excel-data-validation\/"},"wordCount":5089,"publisher":{"@id":"https:\/\/fusionsol.com.vn\/#organization"},"image":{"@id":"https:\/\/f-techsolution.com\/blog\/microsoft-excel-data-validation\/#primaryimage"},"thumbnailUrl":"https:\/\/f-techsolution.com\/wp-content\/uploads\/2026\/11\/Excel-Data-Validation_-Giam-Loi-Nhap-Lieu.png","articleSection":["Blog"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/f-techsolution.com\/blog\/microsoft-excel-data-validation\/","url":"https:\/\/f-techsolution.com\/blog\/microsoft-excel-data-validation\/","name":"Data Validation gi\u00fap gi\u1ea3m l\u1ed7i nh\u1eadp li\u1ec7u trong file Excel d\u00f9ng chung - F-Tech Solution","isPartOf":{"@id":"https:\/\/fusionsol.com.vn\/#website"},"primaryImageOfPage":{"@id":"https:\/\/f-techsolution.com\/blog\/microsoft-excel-data-validation\/#primaryimage"},"image":{"@id":"https:\/\/f-techsolution.com\/blog\/microsoft-excel-data-validation\/#primaryimage"},"thumbnailUrl":"https:\/\/f-techsolution.com\/wp-content\/uploads\/2026\/11\/Excel-Data-Validation_-Giam-Loi-Nhap-Lieu.png","datePublished":"2026-11-11T02:11:13+00:00","dateModified":"2026-11-16T13:14:16+00:00","description":"T\u00ecm hi\u1ec3u Excel Data Validation gi\u00fap t\u1ea1o dropdown, gi\u1edbi h\u1ea1n s\u1ed1\/ng\u00e0y, c\u1ea3nh b\u00e1o d\u1eef li\u1ec7u sai v\u00e0 gi\u1ea3m l\u1ed7i nh\u1eadp li\u1ec7u trong file d\u00f9ng chung.","breadcrumb":{"@id":"https:\/\/f-techsolution.com\/blog\/microsoft-excel-data-validation\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/f-techsolution.com\/blog\/microsoft-excel-data-validation\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/f-techsolution.com\/blog\/microsoft-excel-data-validation\/#primaryimage","url":"https:\/\/f-techsolution.com\/wp-content\/uploads\/2026\/11\/Excel-Data-Validation_-Giam-Loi-Nhap-Lieu.png","contentUrl":"https:\/\/f-techsolution.com\/wp-content\/uploads\/2026\/11\/Excel-Data-Validation_-Giam-Loi-Nhap-Lieu.png","width":1671,"height":941,"caption":"Microsoft Excel data validation"},{"@type":"BreadcrumbList","@id":"https:\/\/f-techsolution.com\/blog\/microsoft-excel-data-validation\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/f-techsolution.com\/"},{"@type":"ListItem","position":2,"name":"Data Validation gi\u00fap gi\u1ea3m l\u1ed7i nh\u1eadp li\u1ec7u trong file Excel d\u00f9ng chung"}]},{"@type":"WebSite","@id":"https:\/\/fusionsol.com.vn\/#website","url":"https:\/\/fusionsol.com.vn\/","name":"F-Tech Solution","description":"Business Innovation Provider","publisher":{"@id":"https:\/\/fusionsol.com.vn\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/fusionsol.com.vn\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/fusionsol.com.vn\/#organization","name":"F-Tech Solution","alternateName":"Fusion Solution Vietnam","url":"https:\/\/fusionsol.com.vn\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/fusionsol.com.vn\/#\/schema\/logo\/image\/","url":"https:\/\/f-techsolution.com\/wp-content\/uploads\/2026\/06\/F.Tech-Logo-Final.png","contentUrl":"https:\/\/f-techsolution.com\/wp-content\/uploads\/2026\/06\/F.Tech-Logo-Final.png","width":512,"height":265,"caption":"F-Tech Solution"},"image":{"@id":"https:\/\/fusionsol.com.vn\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/ftech.solution.vn","https:\/\/www.linkedin.com\/company\/f-tech-solutionvn\/","https:\/\/www.youtube.com\/@congngheftech","https:\/\/zalo.me\/congngheftech","https:\/\/www.instagram.com\/congnghe.ftech\/","https:\/\/www.threads.com\/@congnghe.ftech"]},{"@type":"Person","@id":"https:\/\/fusionsol.com.vn\/#\/schema\/person\/27b7778b486d7bfd6fa65e3350567f9e","name":"Vi Anh","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/02bd04ba761e395025096fd6fade99f99f53476d07f535fd8e0d1e14da075c28?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/02bd04ba761e395025096fd6fade99f99f53476d07f535fd8e0d1e14da075c28?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/02bd04ba761e395025096fd6fade99f99f53476d07f535fd8e0d1e14da075c28?s=96&d=mm&r=g","caption":"Vi Anh"}}]}},"_links":{"self":[{"href":"https:\/\/f-techsolution.com\/en\/wp-json\/wp\/v2\/posts\/43887","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/f-techsolution.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/f-techsolution.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/f-techsolution.com\/en\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/f-techsolution.com\/en\/wp-json\/wp\/v2\/comments?post=43887"}],"version-history":[{"count":1,"href":"https:\/\/f-techsolution.com\/en\/wp-json\/wp\/v2\/posts\/43887\/revisions"}],"predecessor-version":[{"id":43889,"href":"https:\/\/f-techsolution.com\/en\/wp-json\/wp\/v2\/posts\/43887\/revisions\/43889"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/f-techsolution.com\/en\/wp-json\/wp\/v2\/media\/43888"}],"wp:attachment":[{"href":"https:\/\/f-techsolution.com\/en\/wp-json\/wp\/v2\/media?parent=43887"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/f-techsolution.com\/en\/wp-json\/wp\/v2\/categories?post=43887"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/f-techsolution.com\/en\/wp-json\/wp\/v2\/tags?post=43887"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}