{"id":10717,"date":"2025-01-14T23:21:46","date_gmt":"2025-01-14T23:21:46","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/14\/tim-hieu-ve-chuc-nang-khoa-va-bao-mat-trong-excel\/"},"modified":"2025-01-14T23:21:46","modified_gmt":"2025-01-14T23:21:46","slug":"tim-hieu-ve-chuc-nang-khoa-va-bao-mat-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/14\/tim-hieu-ve-chuc-nang-khoa-va-bao-mat-trong-excel\/","title":{"rendered":"T\u00ecm hi\u1ec3u v\u1ec1 ch\u1ee9c n\u0103ng Kh\u00f3a v\u00e0 B\u1ea3o m\u1eadt trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Khi l\u00e0m vi\u1ec7c tr\u00ean\u00a0Excel, vi\u1ec7c thao t\u00e1c tr\u00ean nhi\u1ec1u d\u1eef li\u1ec7u, nhi\u1ec1u sheet, nhi\u1ec1u\u00a0workbook, nhi\u1ec1u ng\u01b0\u1eddi c\u00f9ng l\u00e0m vi\u1ec7c tr\u00ean 1 b\u1ea3ng t\u00ednh d\u1eabn t\u1edbi nhu c\u1ea7u c\u1ea7n\u00a0\u0111\u01b0\u1ee3c b\u1ea3o m\u1eadt d\u1eef li\u1ec7u, tr\u00e1nh vi\u1ec7c t\u1ef1\u00a0\u00fd s\u1eeda, x\u00f3a, m\u1edf\u00a0workbook. Trong b\u00e0i h\u1ecdc n\u00e0y ch\u00fang ta c\u00f9ng t\u00ecm hi\u1ec3u v\u1ec1 <a href=\"http:\/\/blog.ezworkapp.com\/cach-khoa-va-mo-cac-o-trong-excel.html\"><strong>ch\u1ee9c n\u0103ng kh\u00f3a v\u00e0 b\u1ea3o m\u1eadt trong\u00a0excel<\/strong><\/a> nh\u00e9.<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-6786f1891c43c\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/tim-hieu-ve-chuc-nang-khoa-va-bao-mat-trong-excel.html#Tong_quan\" title=\"T\u1ed5ng quan\">T\u1ed5ng quan<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/tim-hieu-ve-chuc-nang-khoa-va-bao-mat-trong-excel.html#Nhung_buoc_bao_ve_co_ban\" title=\"Nh\u1eefng b\u01b0\u1edbc b\u1ea3o v\u1ec7 c\u01a1 b\u1ea3n\">Nh\u1eefng b\u01b0\u1edbc b\u1ea3o v\u1ec7 c\u01a1 b\u1ea3n<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/tim-hieu-ve-chuc-nang-khoa-va-bao-mat-trong-excel.html#Bao_ve_khi_mo_file_Excel_File_Protect\" title=\"B\u1ea3o v\u1ec7 khi m\u1edf file\u00a0Excel (File Protect)\">B\u1ea3o v\u1ec7 khi m\u1edf file\u00a0Excel (File Protect)<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/tim-hieu-ve-chuc-nang-khoa-va-bao-mat-trong-excel.html#Bao_ve_WorkSheet_Protect_Workbook\" title=\"B\u1ea3o v\u1ec7\u00a0WorkSheet (Protect\u00a0Workbook)\">B\u1ea3o v\u1ec7\u00a0WorkSheet (Protect\u00a0Workbook)<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/tim-hieu-ve-chuc-nang-khoa-va-bao-mat-trong-excel.html#Bao_ve_noi_dung_trong_Sheet_Protect_Sheet\" title=\"B\u1ea3o v\u1ec7\u00a0 n\u1ed9i dung trong Sheet (Protect Sheet)\">B\u1ea3o v\u1ec7\u00a0 n\u1ed9i dung trong Sheet (Protect Sheet)<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Tong_quan\"><\/span>T\u1ed5ng quan<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>C\u00f3 nhi\u1ec1u c\u1ea5p\u00a0\u0111\u1ed9 b\u1ea3o m\u1eadt\u00a0trong\u00a0excel\u00a0nh\u01b0:<\/p>\n<ul>\n<li>B\u1ea3o v\u1ec7 khi m\u1edf file\u00a0Excel (Protect an\u00a0Excel file): ng\u0103n ng\u01b0\u1eddi d\u00f9ng t\u1ef1\u00a0\u00fd m\u1edf file\u00a0Excel, bao g\u1ed3m m\u1edf ch\u1ec9 \u0111\u1ec3 xem n\u1ed9i dung\u00a0ho\u1eb7c m\u1edf\u00a0\u0111\u1ec3 xem v\u00e0 s\u1eeda n\u1ed9i dung trong file.<\/li>\n<li>B\u1ea3o v\u1ec7 c\u1ea5u tr\u00fac Workbook (Protect\u00a0Workbook): ng\u0103n ng\u01b0\u1eddi d\u00f9ng t\u1ef1\u00a0\u00fd thay\u00a0\u0111\u1ed5i c\u00e1c sheet trong\u00a0workbook:\u00a0\u0111\u1ed5i t\u00ean, th\u00eam m\u1edbi, x\u00f3a, \u1ea9n, b\u1ecf \u1ea9n\u2026 m\u00e0 nh\u1eefng vi\u1ec7c\u00a0\u0111\u00f3\u00a0\u1ea3nh h\u01b0\u1edfng t\u1edbi c\u1ea5u tr\u00fac c\u1ee7a\u00a0workbook.<\/li>\n<li>B\u1ea3o v\u1ec7 n\u1ed9i dung trong 1 sheet (Protect Sheet): ng\u0103n ng\u01b0\u1eddi d\u00f9ng t\u1ef1\u00a0\u00fd thay\u00a0\u0111\u1ed5i n\u1ed9i dung c\u1ee7a 1\u00a0\u00f4 hay 1 v\u00f9ng trong\u00a0\u00f4, bao g\u1ed3m nhi\u1ec1u t\u00f9y ch\u1ecdn\u00a0\u0111\u1ec3 c\u00f3 th\u1ec3 cho ph\u00e9p hay kh\u00f4ng cho ph\u00e9p s\u1eed d\u1ee5ng m\u1ed9t v\u00e0i t\u00ednh n\u0103ng trong khi sheet\u00a0\u0111ang b\u1ecb kh\u00f3a.<\/li>\n<li>B\u1ea3o v\u1ec7 th\u00f4ng qua thi\u1ebft l\u1eadp b\u1ea3o v\u1ec7 trong VBA<\/li>\n<\/ul>\n<p>Tuy c\u00f3 nhi\u1ec1u c\u1ea5p\u00a0\u0111\u1ed9 b\u1ea3o m\u1eadt nh\u01b0ng t\u00ednh n\u0103ng b\u1ea3o m\u1eadt trong\u00a0Excel l\u1ea1i d\u1ec5 b\u1ecb ph\u00e1. V\u00ec v\u1eady m\u1ee5c\u00a0\u0111\u00edch ch\u00ednh c\u1ee7a vi\u1ec7c b\u1ea3o m\u1eadt trong\u00a0excel nh\u1eb1m tr\u00e1nh cho ng\u01b0\u1eddi s\u1eed d\u1ee5ng c\u00f3 nh\u1eefng l\u1ed7i v\u00f4\u00a0\u00fd l\u00e0m m\u1ea5t d\u1eef li\u1ec7u ho\u1eb7c ph\u00e1 v\u1ee1 t\u00ednh li\u00ean k\u1ebft s\u1eb5n c\u00f3 c\u1ee7a n\u1ed9i dung trong\u00a0Excel.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Nhung_buoc_bao_ve_co_ban\"><\/span>Nh\u1eefng b\u01b0\u1edbc b\u1ea3o v\u1ec7 c\u01a1 b\u1ea3n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"Bao_ve_khi_mo_file_Excel_File_Protect\"><\/span>B\u1ea3o v\u1ec7 khi m\u1edf file\u00a0Excel (File Protect)<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>V\u1edbi phi\u00ean b\u1ea3n\u00a0Excel 2007 tr\u1edf v\u1ec1 sau vi\u1ec7c kh\u00f3a file\u00a0\u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n\u00a0\u1edf c\u1eeda s\u1ed5 L\u01b0u File<\/p>\n<p>B\u1ea5m\u00a0 ch\u1ecdn Save\u00a0as (ph\u00edm t\u1eaft F12)\u00a0\u0111\u1ec3 m\u1edf c\u1eeda s\u1ed5 L\u01b0u file. Trong c\u1eeda s\u1ed5 L\u01b0u file ch\u00fang ta ch\u00fa\u00a0\u00fd v\u00e0o m\u1ee5c Tools c\u1ea1nh n\u00fat Save<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-13150 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/protect-01.png\" width=\"942\" height=\"626\" title=\"protect-01\"><\/p>\n<p>B\u1ea5m v\u00e0o m\u1ee5c <strong><em>Tool<\/em><\/strong> &gt; <strong><em>General Options\u2026<\/em><\/strong><\/p>\n<div class=\"code-block code-block-2\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/vba101_92019-nho-13.gif\" title=\"vba101_92019-nho-13\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ex101_92019-nho-214.gif\" title=\"ex101_92019-nho-214\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-13151 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/protect-02.png\" width=\"954\" height=\"326\" title=\"protect-02\"><\/p>\n<p>Trong c\u1eeda s\u1ed5 General Options, ch\u00fang ta c\u00f3 c\u00e1c ch\u1ee9c n\u0103ng sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-13152 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/protect-03.png\" width=\"942\" height=\"623\" title=\"protect-03\"><\/p>\n<ul>\n<li>Always creat backup : Lu\u00f4n t\u1ea1o 1 b\u1ea3n l\u01b0u d\u1ef1 ph\u00f2ng cho file c\u1ee7a ch\u00fang ta, nh\u1eb1m m\u1ee5c\u00a0\u0111\u00edch ch\u00fang ta kh\u00f4ng m\u1edf l\u1ea1i\u00a0\u0111\u01b0\u1ee3c file g\u1ed1c (qu\u00ean m\u1eadt kh\u1ea9u)<\/li>\n<li>Password to open: M\u1eadt kh\u1ea9u\u00a0\u0111\u1ec3 m\u1edf file. Khi\u00a0\u0111\u1eb7t m\u1eadt kh\u1ea9u m\u1edf file th\u00ec m\u1ed7i khi m\u1edf file\u00a0Excel\u00a0\u0111\u1ec1u s\u1ebd y\u00eau c\u1ea7u ph\u1ea3i nh\u1eadp m\u1eadt kh\u1ea9u m\u1edbi cho ph\u00e9p ch\u00fang ta truy c\u1eadp v\u00e0o n\u1ed9i dung file<\/li>\n<li>Password to modify: M\u1eadt kh\u1ea9u\u00a0\u0111\u1ec3 s\u1eeda file. Ngo\u00e0i vi\u1ec7c m\u1edf file\u00a0\u0111\u1ec3 xem n\u1ed9i dung, ch\u00fang ta c\u00f3 th\u1ec3 thi\u1ebft l\u1eadp\u00a0\u0111\u1ec3 kh\u00f4ng cho ph\u00e9p ng\u01b0\u1eddi kh\u00e1c t\u1ef1\u00a0\u00fd s\u1eeda file khi\u00a0\u0111\u00e3 m\u1edf\u00a0\u0111\u01b0\u1ee3c file, mu\u1ed1n s\u1eeda c\u1ea7n ph\u1ea3i c\u00f3 m\u1eadt kh\u1ea9u\u00a0\u0111\u1ec3 m\u1edf l\u1edbp b\u1ea3o v\u1ec7 n\u00e0y.<\/li>\n<li>Read-only recommended: khuy\u1ebfn c\u00e1o file ch\u1ec9 n\u00ean\u00a0\u0111\u1ecdc. Khi file\u00a0excel c\u1ee7a ch\u00fang ta c\u00f3 t\u00ecnh tr\u1ea1ng b\u1ea3o v\u1ec7 m\u1edf v\u00e0 s\u1eeda file th\u00ec ch\u00fang ta c\u00f3 th\u1ec3\u00a0\u0111\u1eb7t 1 th\u00f4ng b\u00e1o t\u1edbi ng\u01b0\u1eddi m\u1edf file r\u1eb1ng ch\u1ec9 n\u00ean\u00a0\u0111\u1ecdc ch\u1ee9 kh\u00f4ng n\u00ean s\u1eeda n\u1ed9i dung,\u00a0nh\u1eb1m tr\u00e1nh g\u00e2y ra nh\u1eefng sai s\u00f3t do vi\u1ec7c kh\u00f4ng hi\u1ec3u c\u1ea5u tr\u00fac n\u1ed9i dung c\u1ee7a file.<\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"Bao_ve_WorkSheet_Protect_Workbook\"><\/span>B\u1ea3o v\u1ec7\u00a0WorkSheet (Protect\u00a0Workbook)<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Trong tab Review, ch\u00fang ta ch\u00fa\u00a0\u00fd t\u1edbi ch\u1ee9c n\u0103ng Protect\u00a0Workbook. Khi s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng n\u00e0y ch\u00fang ta c\u00f3 th\u1ec3 thi\u1ebft l\u1eadp b\u1ea3o v\u1ec7 cho c\u1ea5u tr\u00fac c\u1ee7a\u00a0Workbook, tr\u00e1nh vi\u1ec7c ng\u01b0\u1eddi d\u00f9ng t\u1ef1\u00a0\u00fd s\u1eeda, x\u00f3a sheet, thay\u00a0\u0111\u1ed5i v\u1ecb tr\u00ed c\u00e1c c\u1ea5u tr\u00fac trong\u00a0workbook.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-13156\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/protect-04.png\" width=\"1144\" height=\"332\" title=\"protect-04\"><\/p>\n<p>Khi s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng Protect\u00a0Workbook, s\u1ebd hi\u1ec7n l\u00ean c\u1eeda s\u1ed5 Nh\u1eadp m\u1eadt kh\u1ea9u:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-13157 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/protect-05.png\" width=\"917\" height=\"492\" title=\"protect-05\"><\/p>\n<p>T\u1ea1i\u00a0\u0111\u00e2y b\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn vi\u1ec7c c\u00f3 s\u1eed d\u1ee5ng m\u1eadt kh\u1ea9u hay kh\u00f4ng. N\u1ebfu kh\u00f3a kh\u00f4ng d\u00f9ng m\u1eadt kh\u1ea9u, b\u1ea1n c\u00f3 th\u1ec3 b\u1ea5m ngay v\u00e0o n\u00fat OK\u00a0\u0111\u1ec3 ho\u00e0n t\u1ea5t th\u1ee7 t\u1ee5c.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-13158 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/protect-06.png\" width=\"595\" height=\"336\" title=\"protect-06\"><\/p>\n<p>Sau khi\u00a0\u0111\u00e3\u00a0\u00e1p d\u1ee5ng Protect\u00a0Workbook, c\u00e1c b\u1ea1n th\u1eed click chu\u1ed9t ph\u1ea3i v\u00e0o v\u00f9ng SheetTab s\u1ebd th\u1ea5y c\u00e1c ch\u1ee9c n\u0103ng trong sheetTab\u00a0\u0111\u00e3 b\u1ecb gi\u1edbi h\u1ea1n kh\u00f4ng cho ph\u00e9p th\u1ef1c hi\u1ec7n c\u00e1c y\u00eau c\u1ea7u sau:<\/p>\n<ul>\n<li>Ch\u00e8n th\u00eam sheet (Insert)<\/li>\n<li>X\u00f3a sheet (Delete)<\/li>\n<li>\u0110\u1ed5i t\u00ean sheet (Rename)<\/li>\n<li>Di chuy\u1ec3n ho\u1eb7c copy sheet (Move\u00a0or Copy)<\/li>\n<li>T\u00f4 m\u00e0u cho sheet (Tab Color)<\/li>\n<li>\u1ea8n sheet (Hide)<\/li>\n<li>M\u1edf\u00a0\u1ea9n sheet (Unhide)<\/li>\n<\/ul>\n<p>V\u1edbi nh\u1eefng gi\u1edbi h\u1ea1n nh\u01b0 v\u1eady ch\u00fang ta ch\u1ec9 c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng nh\u1eefng sheet\u00a0\u0111\u00e3 cho s\u1eb5n m\u00e0 kh\u00f4ng th\u1ec3\u00a0l\u00e0m thay\u00a0\u0111\u1ed5i c\u1ea5u tr\u00fac c\u00e1c sheet trong\u00a0workbook.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Bao_ve_noi_dung_trong_Sheet_Protect_Sheet\"><\/span>B\u1ea3o v\u1ec7\u00a0 n\u1ed9i dung trong Sheet (Protect Sheet)<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Ch\u1ee9c n\u0103ng n\u00e0y n\u1eb1m trong tab Review, b\u00ean c\u1ea1nh ch\u1ee9c n\u0103ng Protect\u00a0Workbook<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-13159 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/protect-07.png\" width=\"900\" height=\"590\" title=\"protect-07\"><\/p>\n<p>Khi ch\u1ecdn ch\u1ee9c n\u0103ng Protect Sheet =&gt; H\u1ed9p tho\u1ea1i Protect Sheet m\u1edf ra, bao g\u1ed3m c\u00e1c n\u1ed9i dung sau:<\/p>\n<p><strong>+Password to unprotect sheet<\/strong>: M\u00e3\u00a0\u0111\u1ec3 m\u1edf kh\u00f3a. N\u1ebfu ch\u00fang ta nh\u1eadp m\u00e3 v\u00e0o m\u1ee5c n\u00e0y th\u00ec khi mu\u1ed1n m\u1edf kh\u00f3a ch\u1ee9c n\u0103ng protect Sheet th\u00ec ch\u00fang ta ph\u1ea3i nh\u1eadp\u00a0\u0111\u00fang m\u00e3\u00a0\u0111\u00e3 ch\u1ecdn. Tuy nhi\u00ean ch\u00fang ta c\u00f3 th\u1ec3 kh\u00f4ng c\u1ea7n\u00a0\u0111\u1eb7t m\u00e3 v\u1eabn s\u1eed d\u1ee5ng\u00a0\u0111\u01b0\u1ee3c ch\u1ee9c n\u0103ng Protect Sheet, khi\u00a0\u0111\u00f3 vi\u1ec7c m\u1edf kh\u00f3a s\u1ebd kh\u00f4ng y\u00eau c\u1ea7u m\u1eadt kh\u1ea9u =&gt; Vi\u1ec7c\u00a0\u0111\u1eb7t m\u1eadt kh\u1ea9u l\u00e0 kh\u00f4ng b\u1eaft bu\u1ed9c.<\/p>\n<p><strong>+Allow all\u00a0users\u00a0of this\u00a0worksheet to<\/strong>: Cho ph\u00e9p th\u1ef1c hi\u1ec7n nh\u1eefng\u00a0\u0111i\u1ec1u sau\u00a0\u0111\u00e2y trong khi Sheet\u00a0\u0111ang\u00a0\u0111\u01b0\u1ee3c Protect b\u1eb1ng vi\u1ec7c\u00a0\u0111\u00e1nh d\u1ea5u ch\u1ecdn v\u00e0o m\u1ee5c t\u01b0\u01a1ng\u00a0\u1ee9ng:<\/p>\n<ul>\n<li><strong><em>Select locked cells<\/em><\/strong>: ch\u1ecdn c\u00e1c\u00a0\u00f4\u00a0\u0111ang b\u1ecb kh\u00f3a. M\u1eb7c\u00a0\u0111\u1ecbnh l\u00e0 cho ph\u00e9p ch\u1ecdn t\u1edbi c\u00e1c\u00a0\u00f4\u00a0\u0111ang b\u1ecb kh\u00f3a. N\u1ebfu b\u1ecf ch\u1ecdn m\u1ee5c n\u00e0y th\u00ec ch\u00fang ta kh\u00f4ng th\u1ec3 ch\u1ecdn t\u1edbi \u00f4 b\u1ecb kh\u00f3a\u00a0(d\u00f9ng chu\u1ed9t click v\u00e0o\u00a0\u00f4 b\u1ecb kh\u00f3a, hay d\u00f9ng n\u00fat di chuy\u1ec3n tr\u00ean b\u00e0n ph\u00edm t\u1edbi\u00a0\u00f4 b\u1ecb kh\u00f3a). Th\u01b0\u1eddng d\u00f9ng trong tr\u01b0\u1eddng h\u1ee3p trong sheet ch\u1ec9 cho ph\u00e9p ch\u1ecdn t\u1edbi nh\u1eefng\u00a0\u00f4 nh\u1ea5t\u00a0\u0111\u1ecbnh kh\u00f4ng kh\u00f3a.<\/li>\n<li><strong><em>Select unlocked cells<\/em><\/strong>: Ch\u1ecdn t\u1edbi c\u00e1c\u00a0\u00f4 kh\u00f4ng b\u1ecb kh\u00f3a. M\u1eb7c\u00a0\u0111\u1ecbnh l\u00e0 cho ph\u00e9p ch\u1ecdn t\u1edbi c\u00e1c\u00a0\u00f4 kh\u00f4ng b\u1ecb kh\u00f3a (h\u1ea7u h\u1ebft\u00a0\u0111\u1ec1u s\u1eed d\u1ee5ng n\u1ed9i dung n\u00e0y)<\/li>\n<li><em><strong>Format cells<\/strong><\/em>: s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng \u0111\u1ecbnh d\u1ea1ng\u00a0\u00f4. M\u1eb7c\u00a0\u0111\u1ecbnh l\u00e0 kh\u00f4ng cho ph\u00e9p. Khi kh\u00f3a sheet th\u00ec b\u1ea1n c\u00f3 th\u1ec3 cho ph\u00e9p \/ kh\u00f4ng cho ph\u00e9p ng\u01b0\u1eddi d\u00f9ng th\u1ef1c hi\u1ec7n ch\u1ee9c n\u0103ng\u00a0\u0111\u1ecbnh d\u1ea1ng, m\u1ee5c\u00a0\u0111\u00edch\u00a0\u0111\u1ec3 b\u1ea3o v\u1ec7 nh\u1eefng thi\u1ebft l\u1eadp\u00a0\u0111\u1ecbnh d\u1ea1ng ban\u00a0\u0111\u1ea7u theo\u00a0\u00fd mu\u1ed1n c\u1ee7a m\u00ecnh, kh\u00f4ng cho ng\u01b0\u1eddi kh\u00e1c t\u1ef1\u00a0\u00fd thay\u00a0\u0111\u1ed5i\u00a0\u0111\u1ecbnh d\u1ea1ng (font ch\u1eef, m\u00e0u s\u1eafc,\u00a0lo\u1ea1i d\u1eef li\u1ec7u\u2026).\u00a0\u00c1p d\u1ee5ng ngay c\u1ea3 v\u1edbi nh\u1eefng\u00a0\u00f4 kh\u00f3a hay kh\u00f4ng b\u1ecb kh\u00f3a.<\/li>\n<li><strong><em>Format columns + Format rows<\/em><\/strong>: s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng\u00a0\u0111\u1ecbnh d\u1ea1ng c\u1ed9t, h\u00e0ng. M\u1ee5c\u00a0\u0111\u00edch\u00a0\u0111\u1ec3 ng\u0103n ng\u01b0\u1eddi d\u00f9ng\u00a0\u0111\u1ecbnh d\u1ea1ng c\u00e1c v\u1ea5n\u00a0\u0111\u1ec1 v\u1ec1 c\u1ed9t, h\u00e0ng (v\u00ed d\u1ee5 nh\u01b0\u00a0\u1ea9n c\u1ed9t,\u00a0\u1ea9n h\u00e0ng, m\u1edf\u00a0\u1ea9n, ch\u1ec9nh\u00a0\u0111\u1ed9 r\u1ed9ng, t\u00f4 m\u00e0u\u2026)<\/li>\n<li><strong><em>Insert columns<\/em><\/strong> +\u00a0<strong><em>Insert rows<\/em><\/strong>: S\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng ch\u00e8n th\u00eam c\u1ed9t, h\u00e0ng<\/li>\n<li><strong><em>Delete columns<\/em><\/strong> + <strong><em>Delete rows<\/em><\/strong>: S\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng x\u00f3a c\u1ed9t, h\u00e0ng<\/li>\n<li><em><strong>Sort<\/strong><\/em>: S\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng s\u1eafp x\u1ebfp d\u1eef li\u1ec7u (Data&gt;Sort)<\/li>\n<li><strong><em>Use AutoFilter<\/em><\/strong>:\u00a0S\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng l\u1ecdc d\u1eef li\u1ec7u\u00a0(Data&gt;Filter)<\/li>\n<li><strong><em>Use PivotTable &amp; PivotChart<\/em><\/strong>: S\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng pivot (b\u1ea3ng b\u00e1o c\u00e1o\u00a0\u0111\u1ed9ng, bi\u1ec3u\u00a0\u0111\u1ed3\u00a0\u0111\u1ed9ng)<\/li>\n<li><strong><em>Edit Objects<\/em><\/strong>: S\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng ch\u1ec9nh s\u1eeda c\u00e1c\u00a0\u0111\u1ed1i t\u01b0\u1ee3ng<\/li>\n<li><strong><em>Edit scenarios<\/em><\/strong>: S\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng k\u1ecbch b\u1ea3n (ch\u1ee9c n\u0103ng scenarios trong\u00a0excel)<\/li>\n<\/ul>\n<p>Tuy nhi\u00ean ch\u00fang ta c\u1ea7n ch\u00fa\u00a0\u00fd th\u00eam 1 n\u1ed9i dung n\u1eefa l\u00e0: thi\u1ebft l\u1eadp Cell n\u00e0o l\u00e0 cell b\u1ecb kh\u00f3a (locked cell), cell n\u00e0o kh\u00f4ng b\u1ecb kh\u00f3a (unlocked cell)<\/p>\n<ul>\n<li>Trong b\u1ea5t k\u1ef3 cell n\u00e0o trong sheet\u00a0\u0111\u1ec1u m\u1eb7c\u00a0\u0111\u1ecbnh l\u00e0\u00a0\u1edf ch\u1ebf\u00a0\u0111\u1ed9 lock<\/li>\n<li>Mu\u1ed1n thi\u1ebft l\u1eadp cell\u00a0\u1edf ch\u1ebf\u00a0\u0111\u1ed9 kh\u00f4ng kh\u00f3a, b\u1ea1n ch\u1ecdn cell\u00a0\u0111\u00f3 r\u1ed3i v\u00e0o ch\u1ee9c n\u0103ng Format cells&gt;Protection&gt;b\u1ecf ch\u1ecdn\u00a0\u1edf m\u1ee5c Locked<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-13160 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/protect-08.png\" width=\"673\" height=\"595\" title=\"protect-08\"><\/p>\n<p>Nh\u01b0 v\u1eady ch\u00fang ta\u00a0\u0111\u00e3 n\u1eafm\u00a0\u0111\u01b0\u1ee3c nh\u1eefng nguy\u00ean t\u1eafc c\u01a1 b\u1ea3n c\u1ee7a vi\u1ec7c kh\u00f3a b\u1ea3o v\u1ec7 ch\u01b0\u01a1ng tr\u00ecnh\u00a0excel.<\/p>\n<p>Ch\u00fac c\u00e1c b\u1ea1n h\u1ecdc t\u1ed1t c\u00f9ng H\u1ecdc\u00a0Excel Online!<\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/vba101_92019-nho-13.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":10718,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-10717","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/10717","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=10717"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/10717\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/10718"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=10717"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=10717"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=10717"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}