{"id":4124,"date":"2024-12-04T09:51:23","date_gmt":"2024-12-04T09:51:23","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/04\/cach-dat-bao-ve-va-huy-bao-ve-trang-trong-excel-khi-co-hoac-khong-co-mat-khau\/"},"modified":"2024-12-04T09:51:23","modified_gmt":"2024-12-04T09:51:23","slug":"cach-dat-bao-ve-va-huy-bao-ve-trang-trong-excel-khi-co-hoac-khong-co-mat-khau","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/04\/cach-dat-bao-ve-va-huy-bao-ve-trang-trong-excel-khi-co-hoac-khong-co-mat-khau\/","title":{"rendered":"C\u00e1ch \u0111\u1eb7t b\u1ea3o v\u1ec7 v\u00e0 h\u1ee7y b\u1ea3o v\u1ec7 trang trong Excel khi c\u00f3 ho\u1eb7c kh\u00f4ng c\u00f3 m\u1eadt kh\u1ea9u"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-dQf5b79p#1\">\n<blockquote id=\"unprotect-sheet\" cite=\"https:\/\/blog.hocexcel.online\/cach-dat-bao-ve-va-huy-bao-ve-trang-trong-excel-khi-co-hoac-khong-co-mat-khau.html?unprotect-sheet\">\n<p>Trong b\u00e0i h\u01b0\u1edbng d\u1eabn n\u00e0y, <strong>H\u1ecdc Excel Online<\/strong> s\u1ebd gi\u1edbi thi\u1ec7u \u0111\u1ebfn c\u00e1c b\u1ea1n c\u00e1ch b\u1ea3o v\u1ec7 b\u1ea3ng t\u00ednh Excel v\u00e0 <strong>unprotect sheet<\/strong> (h\u1ee7y b\u1ea3o v\u1ec7 trang) khi c\u00f3 ho\u1eb7c kh\u00f4ng c\u00f3 m\u1eadt kh\u1ea9u. Ngo\u00e0i ra, c\u00f2n c\u00f3 h\u01b0\u1edbng d\u1eabn v\u1ec1 vi\u1ec7c m\u1edf kh\u00f3a b\u1ea3ng t\u00ednh Excel khi b\u1ea1n qu\u00ean m\u1ea5t m\u1eadt kh\u1ea9u c\u1ee7a m\u00ecnh.<\/p>\n<\/blockquote>\n<p><span style=\"font-family: georgia, palatino, serif\">Khi chia s\u1ebb b\u1ea3ng t\u00ednh c\u1ee7a b\u1ea1n v\u1edbi ng\u01b0\u1eddi kh\u00e1c ho\u1eb7c g\u1eedi c\u00e1c t\u1ec7p Excel ra b\u00ean ngo\u00e0i, c\u00f3 th\u1ec3 b\u1ea1n s\u1ebd mu\u1ed1n ng\u0103n ng\u01b0\u1eddi d\u00f9ng kh\u00e1c thay \u0111\u1ed5i c\u00e1c \u00f4 kh\u00f4ng n\u00ean thay \u0111\u1ed5i, c\u0169ng nh\u01b0 di chuy\u1ec3n ho\u1eb7c x\u00f3a d\u1eef li\u1ec7u quan tr\u1ecdng trong trang t\u00ednh ho\u1eb7c b\u1ea3ng t\u00ednh c\u1ee7a b\u1ea1n.<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">May m\u1eafn thay, Excel cung c\u1ea5p m\u1ed9t c\u00e1ch nhanh ch\u00f3ng v\u00e0 d\u1ec5 d\u00e0ng \u0111\u1ec3 kh\u00f3a m\u1ed9t b\u1ea3ng t\u00ednh ho\u1eb7c m\u1eadt kh\u1ea9u b\u1ea3o v\u1ec7 m\u1ed9t b\u1ea3ng t\u00ednh to\u00e0n b\u1ed9 \u0111\u1ec3 ng\u0103n ng\u1eeba nh\u1eefng thay \u0111\u1ed5i ng\u1eabu nhi\u00ean ho\u1eb7c c\u1ed1 \u00fd trong n\u1ed9i dung Excel \u0111ang l\u01b0u tr\u1eef.<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> Nh\u1eefng \u0111i\u1ec1u c\u1ea7n bi\u1ebft v\u1ec1 b\u1ea3o v\u1ec7 b\u1ea3ng t\u00ednh Excel<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> B\u1ea3o v\u1ec7 b\u1ea3ng t\u00ednh trong Excel kh\u00f4ng ph\u1ea3i l\u00e0 t\u00ednh n\u0103ng b\u1ea3o m\u1eadt. N\u00f3 kh\u00f4ng th\u1ef1c s\u1ef1 nh\u1eb1m ng\u0103n ng\u01b0\u1eddi kh\u00e1c truy c\u1eadp v\u00e0o d\u1eef li\u1ec7u trong m\u1ed9t b\u1ea3ng t\u00ednh \u0111\u01b0\u1ee3c b\u1ea3o v\u1ec7 b\u1eb1ng m\u1eadt kh\u1ea9u. T\u1ea1i sao? B\u1edfi v\u00ec Microsoft Excel s\u1eed d\u1ee5ng m\u1ed9t thu\u1eadt to\u00e1n m\u00e3 h\u00f3a r\u1ea5t \u0111\u01a1n gi\u1ea3n \u0111\u1ec3 b\u1ea3o v\u1ec7 b\u1ea3ng t\u00ednh. Ngay c\u1ea3 khi b\u1ea1n b\u1ea3o v\u1ec7 b\u1ea3ng t\u00ednh Excel c\u1ee7a b\u1ea1n v\u1edbi m\u1ed9t m\u1eadt kh\u1ea9u, m\u1eadt kh\u1ea9u \u0111\u00f3 v\u1eabn c\u00f3 th\u1ec3 b\u1ecb ph\u00e1 v\u1ee1 r\u1ea5t d\u1ec5 d\u00e0ng.<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">Trong c\u00e1c phi\u00ean b\u1ea3n c\u0169 h\u01a1n (d\u01b0\u1edbi \u0111\u00e2y l\u00e0 Microsoft Excel 2010), d\u00f9 m\u1eadt kh\u1ea9u c\u1ee7a b\u1ea1n d\u00e0i v\u00e0 ph\u1ee9c t\u1ea1p. B\u1ea5t c\u1ee9 ai c\u00f3 \u00edt nh\u1ea5t m\u1ed9t s\u1ed1 ki\u1ebfn th\u1ee9c c\u01a1 b\u1ea3n v\u1ec1 VBA c\u00f3 th\u1ec3 c\u0169ng c\u00f3 th\u1ec3 hack n\u00f3 trong v\u00e0i ph\u00fat (\u0111\u00e2y l\u00e0 m\u1ed9t v\u00ed d\u1ee5 c\u1ee7a m\u00e3 VBA d\u1ec5 d\u00e0ng b\u1ecb hack m\u1eadt kh\u1ea9u trong Excel 2010 v\u00e0 c\u00e1c phi\u00ean b\u1ea3n th\u1ea5p h\u01a1n).<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">C\u00e1c phi\u00ean b\u1ea3n g\u1ea7n \u0111\u00e2y c\u1ee7a Excel 2013 v\u00e0 2016 s\u1eed d\u1ee5ng c\u00e1c ph\u01b0\u01a1ng ph\u00e1p b\u1ea3o v\u1ec7 b\u1ea3ng t\u00ednh ph\u1ee9c t\u1ea1p h\u01a1n, nh\u01b0ng ch\u00fang c\u0169ng d\u1ec5 b\u1ecb ph\u00e1 v\u1ee1 v\u00e0 c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c m\u1edf m\u00e0 kh\u00f4ng c\u1ea7n bi\u1ebft m\u1eadt kh\u1ea9u. N\u00f3i c\u00e1ch kh\u00e1c, n\u1ebfu c\u00f3 ai \u0111\u00f3 th\u1ef1c s\u1ef1 mu\u1ed1n truy c\u1eadp v\u00e0o m\u1ed9t b\u1ea3ng t\u00ednh \u0111\u01b0\u1ee3c b\u1ea3o v\u1ec7, h\u1ecd s\u1ebd l\u00e0m \u0111\u01b0\u1ee3c.<\/span><\/p>\n<blockquote>\n<p><span style=\"font-family: georgia, palatino, serif\">Xem ngay: T\u00e0i li\u1ec7u\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/tag\/hoc-excel-2013\">h\u01b0\u1edbng d\u1eabn h\u1ecdc excel 2013<\/a><\/span><\/p>\n<\/blockquote>\n<p><span style=\"font-family: georgia, palatino, serif\">V\u00ec v\u1eady, \u0111i\u1ec1u n\u00e0y c\u00f3 ngh\u0129a l\u00e0 b\u1ea3o v\u1ec7 b\u1ea3ng t\u00ednh Excel l\u00e0 ho\u00e0n to\u00e0n v\u00f4 ngh\u0129a? Kh\u00f4ng h\u1eb3n nh\u01b0 v\u1eady v\u00ec n\u00f3 v\u1eabn c\u00f3 \u00fd ngh\u0129a \u0111\u1ed1i v\u1edbi vi\u1ec7c kh\u00f3a b\u1ea3ng t\u00ednh Excel \u0111\u1ec3 tr\u00e1nh thay \u0111\u1ed5i t\u00ecnh c\u1edd trong c\u00e1c n\u1ed9i dung trang t\u00ednh.<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">\u0110i\u1ec3m m\u1ea5u ch\u1ed1t l\u00e0 \u2013 kh\u00f3a b\u1ea3ng t\u00ednh Excel \u0111\u1ec3 ng\u0103n ng\u01b0\u1eddi d\u00f9ng kh\u00e1c v\u00f4 t\u00ecnh l\u00e0m sai d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n, nh\u01b0ng kh\u00f4ng bao gi\u1edd l\u01b0u tr\u1eef l\u1ea1i th\u00f4ng tin nh\u1ea1y c\u1ea3m trong b\u1ea3ng t\u00ednh Excel \u0111\u00f3.<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">N\u1ebfu b\u1ea1n c\u1ed1 g\u1eafng gi\u1eef b\u1ea3o v\u1ec7 an to\u00e0n t\u1ed1i \u0111a cho c\u00e1c t\u1ec7p Excel c\u1ee7a m\u00ecnh, h\u00e3y \u0111\u1ea3m b\u1ea3o th\u1ef1c hi\u1ec7n t\u1ea5t c\u1ea3 c\u00e1c thao t\u00e1c sau:<\/span><\/p>\n<ul>\n<li><span style=\"font-family: georgia, palatino, serif\">\u2013 S\u1eed d\u1ee5ng c\u00e1c phi\u00ean b\u1ea3n Excel 2010, Excel 2013 v\u00e0 2016 hi\u1ec7n \u0111\u1ea1i v\u1edbi c\u00e1c c\u01a1 ch\u1ebf m\u00e3 h\u00f3a d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c t\u0103ng c\u01b0\u1eddng.<\/span><\/li>\n<li><span style=\"font-family: georgia, palatino, serif\">\u2013 B\u1ea3o v\u1ec7 trang t\u00ednh c\u1ee7a b\u1ea1n b\u1eb1ng m\u1eadt kh\u1ea9u m\u1ea1nh bao g\u1ed3m c\u00e1c lo\u1ea1i k\u00fd t\u1ef1 ch\u1eef s\u1ed1 v\u00e0 c\u00e1c k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t kh\u00e1c nhau. L\u00fac \u0111\u00f3, h\u00e3y th\u1eed l\u00e0m cho m\u1eadt kh\u1ea9u c\u00e0ng ng\u1eabu nhi\u00ean c\u00e0ng t\u1ed1t, v\u00ed d\u1ee5 b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng c\u00f4ng c\u1ee5 t\u1ea1o m\u1eadt kh\u1ea9u.<\/span><\/li>\n<li><span style=\"font-family: georgia, palatino, serif\">\u2013 B\u1ea3o v\u1ec7 c\u1ea5u tr\u00fac b\u1ea3ng t\u00ednh \u0111\u1ec3 ng\u0103n ng\u01b0\u1eddi kh\u00e1c th\u00eam, di chuy\u1ec3n, \u0111\u1ed5i t\u00ean, xo\u00e1 ho\u1eb7c b\u1ecf \u1ea9n trang c\u1ee7a b\u1ea1n.<\/span><\/li>\n<li><span style=\"font-family: georgia, palatino, serif\">\u2013 \u0110\u1ed1i v\u1edbi b\u1ea3o m\u1eadt c\u1ea5p b\u1ea3ng t\u00ednh, m\u00e3 h\u00f3a b\u1ea3ng t\u00ednh v\u1edbi c\u00e1c m\u1eadt kh\u1ea9u kh\u00e1c nhau \u0111\u1ed1i v\u1edbi vi\u1ec7c m\u1edf v\u00e0 s\u1eeda \u0111\u1ed5i.<\/span><\/li>\n<li><span style=\"font-family: georgia, palatino, serif\">\u2013 N\u1ebfu c\u00f3 th\u1ec3, l\u01b0u c\u00e1c t\u1ec7p Excel c\u1ee7a b\u1ea1n v\u1edbi th\u00f4ng tin nh\u1ea1y c\u1ea3m \u1edf m\u1ed9t v\u1ecb tr\u00ed an to\u00e0n, v\u00ed d\u1ee5: Tr\u00ean \u1ed5 c\u1ee9ng \u0111\u01b0\u1ee3c m\u00e3 h\u00f3a.<\/span><\/li>\n<\/ul>\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<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\/2024\/12\/vba101_92019-nho-140.gif\" title=\"vba101_92019-nho-140\"><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\/2024\/12\/ex101_92019-nho-329.gif\" title=\"ex101_92019-nho-329\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><label for=\"ez-toc-cssicon-toggle-item-6750261a2d5cc\" 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\/cach-dat-bao-ve-va-huy-bao-ve-trang-trong-excel-khi-co-hoac-khong-co-mat-khau.html#Cach_bao_ve_bang_tinh_Excel\" title=\"C\u00e1ch b\u1ea3o v\u1ec7 b\u1ea3ng t\u00ednh Excel\">C\u00e1ch b\u1ea3o v\u1ec7 b\u1ea3ng t\u00ednh Excel<\/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\/cach-dat-bao-ve-va-huy-bao-ve-trang-trong-excel-khi-co-hoac-khong-co-mat-khau.html#Cach_huy_bao_ve_bang_tinh_Excel\" title=\"C\u00e1ch h\u1ee7y b\u1ea3o v\u1ec7 b\u1ea3ng t\u00ednh Excel\">C\u00e1ch h\u1ee7y b\u1ea3o v\u1ec7 b\u1ea3ng t\u00ednh Excel<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/cach-dat-bao-ve-va-huy-bao-ve-trang-trong-excel-khi-co-hoac-khong-co-mat-khau.html#Cach_huy_bao_ve_cho_bang_tinh_Excel_khi_co_mat_khau\" title=\"C\u00e1ch\u00a0h\u1ee7y b\u1ea3o v\u1ec7 cho b\u1ea3ng t\u00ednh Excel khi c\u00f3 m\u1eadt kh\u1ea9u\">C\u00e1ch\u00a0h\u1ee7y b\u1ea3o v\u1ec7 cho b\u1ea3ng t\u00ednh Excel khi c\u00f3 m\u1eadt kh\u1ea9u<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/cach-dat-bao-ve-va-huy-bao-ve-trang-trong-excel-khi-co-hoac-khong-co-mat-khau.html#Cach_bo_bao_ve_bang_tinh_Excel_khi_khong_co_mat_khau\" title=\"C\u00e1ch b\u1ecf b\u1ea3o v\u1ec7 b\u1ea3ng t\u00ednh Excel khi kh\u00f4ng c\u00f3 m\u1eadt kh\u1ea9u\">C\u00e1ch b\u1ecf b\u1ea3o v\u1ec7 b\u1ea3ng t\u00ednh Excel khi kh\u00f4ng c\u00f3 m\u1eadt kh\u1ea9u<\/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-5\" href=\"https:\/\/blog.hocexcel.online\/cach-dat-bao-ve-va-huy-bao-ve-trang-trong-excel-khi-co-hoac-khong-co-mat-khau.html#Mo_bang_tinh_Excel_voi_ma_VBA_cho_Excel_2010_va_phien_ban_cu_hon\" title=\"M\u1edf b\u1ea3ng t\u00ednh Excel v\u1edbi m\u00e3 VBA (cho Excel 2010 v\u00e0 phi\u00ean b\u1ea3n c\u0169 h\u01a1n)\">M\u1edf b\u1ea3ng t\u00ednh Excel v\u1edbi m\u00e3 VBA (cho Excel 2010 v\u00e0 phi\u00ean b\u1ea3n c\u0169 h\u01a1n)<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/cach-dat-bao-ve-va-huy-bao-ve-trang-trong-excel-khi-co-hoac-khong-co-mat-khau.html#Sao_chep_noi_dung_trang_duoc_bao_ve_sang_mot_bang_tinh_khac\" title=\"Sao ch\u00e9p n\u1ed9i dung trang \u0111\u01b0\u1ee3c b\u1ea3o v\u1ec7 sang m\u1ed9t b\u1ea3ng t\u00ednh kh\u00e1c\">Sao ch\u00e9p n\u1ed9i dung trang \u0111\u01b0\u1ee3c b\u1ea3o v\u1ec7 sang m\u1ed9t b\u1ea3ng t\u00ednh kh\u00e1c<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/cach-dat-bao-ve-va-huy-bao-ve-trang-trong-excel-khi-co-hoac-khong-co-mat-khau.html#Cach_bao_ve_mot_bang_tinh_trong_Excel\" title=\"C\u00e1ch b\u1ea3o v\u1ec7 m\u1ed9t b\u1ea3ng t\u00ednh trong Excel\">C\u00e1ch b\u1ea3o v\u1ec7 m\u1ed9t b\u1ea3ng t\u00ednh trong Excel<\/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-8\" href=\"https:\/\/blog.hocexcel.online\/cach-dat-bao-ve-va-huy-bao-ve-trang-trong-excel-khi-co-hoac-khong-co-mat-khau.html#Cach_mo_mot_bang_tinh_duoc_bao_ve_trong_Excel\" title=\"C\u00e1ch m\u1edf m\u1ed9t b\u1ea3ng t\u00ednh \u0111\u01b0\u1ee3c b\u1ea3o v\u1ec7 trong Excel\">C\u00e1ch m\u1edf m\u1ed9t b\u1ea3ng t\u00ednh \u0111\u01b0\u1ee3c b\u1ea3o v\u1ec7 trong Excel<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/blog.hocexcel.online\/cach-dat-bao-ve-va-huy-bao-ve-trang-trong-excel-khi-co-hoac-khong-co-mat-khau.html#Mat_khau_bao_ve_bang_tinh_Excel_khi_dang_mo\" title=\"M\u1eadt kh\u1ea9u b\u1ea3o v\u1ec7 b\u1ea3ng t\u00ednh Excel khi \u0111ang m\u1edf\">M\u1eadt kh\u1ea9u b\u1ea3o v\u1ec7 b\u1ea3ng t\u00ednh Excel khi \u0111ang m\u1edf<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Cach_bao_ve_bang_tinh_Excel\"><\/span><span style=\"font-family: georgia, palatino, serif\">C\u00e1ch b\u1ea3o v\u1ec7 b\u1ea3ng t\u00ednh Excel<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-family: georgia, palatino, serif\">\u0110\u1ec3 b\u1ea3o v\u1ec7 b\u1ea3ng t\u00ednh trong Excel 2016, 2013 v\u00e0 2010, h\u00e3y th\u1ef1c hi\u1ec7n theo c\u00e1c b\u01b0\u1edbc sau.<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">1. Nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o m\u1ed9t b\u1ea3ng t\u00ednh \u1edf d\u01b0\u1edbi c\u00f9ng c\u1ee7a m\u00e0n h\u00ecnh v\u00e0 ch\u1ecdn Protect Sheet t\u1eeb tr\u00ecnh \u0111\u01a1n ng\u1eef c\u1ea3nh.<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> Ho\u1eb7c, b\u1ea5m v\u00e0o n\u00fat Protect Sheet tr\u00ean tab Review, trong nh\u00f3m Changes.<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> <img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7721\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/1-2-2.png\" width=\"583\" height=\"131\" title=\"1-2-2\"><\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> 2. Trong c\u1eeda s\u1ed5 h\u1ed9p tho\u1ea1i Protect Sheet, h\u00e3y th\u1ef1c hi\u1ec7n theo c\u00e1c b\u01b0\u1edbc sau:<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> \u2013 \u0110\u1ec3 b\u1ea3o v\u1ec7 m\u1eadt kh\u1ea9u cho b\u1ea3ng t\u00ednh Excel c\u1ee7a b\u1ea1n, nh\u1eadp m\u1eadt kh\u1ea9u v\u00e0o tr\u01b0\u1eddng t\u01b0\u01a1ng \u1ee9ng. \u0110\u1ea3m b\u1ea3o nh\u1edb m\u1eadt kh\u1ea9u ho\u1eb7c l\u01b0u tr\u1eef n\u00f3 \u1edf m\u1ed9t v\u1ecb tr\u00ed an to\u00e0n v\u00ec sau n\u00e0y b\u1ea1n s\u1ebd c\u1ea7n d\u00f9ng \u0111\u1ec3 h\u1ee7y b\u1ea3o v\u1ec7 trang t\u00ednh \u0111\u00f3.<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> \u2013 N\u1ebfu b\u1ea3o v\u1ec7 b\u1ea3ng t\u00ednh kh\u00f4ng ch\u1ec9 l\u00e0 m\u1ed9t bi\u1ec7n ph\u00e1p ph\u00f2ng ng\u1eeba \u0111\u1ed1i v\u1edbi vi\u1ec7c s\u1eeda \u0111\u1ed5i t\u00ecnh c\u1edd c\u00e1c n\u1ed9i dung c\u1ee7a trang t\u00ednh b\u1edfi ch\u00ednh b\u1ea1n ho\u1eb7c b\u1edfi c\u00e1c th\u00e0nh vi\u00ean c\u1ee7a nh\u00f3m, b\u1ea1n c\u0169ng kh\u00f4ng mu\u1ed1n ph\u1ea3i ghi nh\u1edb m\u1eadt kh\u1ea9u v\u00e0 \u0111\u1ec3 tr\u1ed1ng tr\u01b0\u1eddng m\u1eadt kh\u1ea9u. Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, vi\u1ec7c kh\u00f4ng b\u1ea3o v\u1ec7 b\u1ea3ng ch\u1ec9 m\u1ea5t m\u1ed9t l\u1ea7n nh\u1ea5p v\u00e0o n\u00fat Unprotect Sheet tr\u00ean ribbon ho\u1eb7c trong menu chu\u1ed9t ph\u1ea3i c\u1ee7a tab.<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> \u2013 Ch\u1ecdn h\u00e0nh \u0111\u1ed9ng cho ph\u00e9p ng\u01b0\u1eddi d\u00f9ng th\u1ef1c hi\u1ec7n.<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> + Theo m\u1eb7c \u0111\u1ecbnh, 2 l\u1ef1a ch\u1ecdn sau \u0111\u00e2y \u0111\u01b0\u1ee3c ch\u1ecdn: Select locked cells v\u00e0 Select unlocked cells. N\u1ebfu b\u1ea1n ch\u1ec9 ch\u1ecdn hai t\u00f9y ch\u1ecdn n\u00e0y, ng\u01b0\u1eddi d\u00f9ng c\u1ee7a trang t\u00ednh c\u1ee7a b\u1ea1n, bao g\u1ed3m c\u1ea3 b\u1ea1n, s\u1ebd ch\u1ec9 c\u00f3 th\u1ec3 ch\u1ecdn c\u00e1c \u00f4 (c\u1ea3 kh\u00f3a v\u00e0 m\u1edf kh\u00f3a).<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> + \u0110\u1ec3 cho ph\u00e9p m\u1ed9t s\u1ed1 h\u00e0nh \u0111\u1ed9ng kh\u00e1c nh\u01b0 s\u1eafp x\u1ebfp, l\u1ecdc, \u0111\u1ecbnh d\u1ea1ng \u00f4, x\u00f3a ho\u1eb7c ch\u00e8n c\u00e1c h\u00e0ng v\u00e0 c\u1ed9t, th\u00ec ki\u1ec3m tra h\u1ed9p t\u01b0\u01a1ng \u1ee9ng.<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> + N\u1ebfu b\u1ea1n kh\u00f4ng ki\u1ec3m tra b\u1ea5t k\u1ef3 h\u00e0nh \u0111\u1ed9ng n\u00e0o, ng\u01b0\u1eddi d\u00f9ng s\u1ebd ch\u1ec9 c\u00f3 th\u1ec3 xem n\u1ed9i dung c\u1ee7a b\u1ea3ng t\u00ednh Excel c\u1ee7a b\u1ea1n.<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> \u2013 Nh\u1ea5p v\u00e0o n\u00fat OK.<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> <img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7722\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/2-2-1.png\" width=\"336\" height=\"337\" title=\"2-2-1\"><\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">3. H\u1ed9p tho\u1ea1i Confirm Password s\u1ebd b\u1eadt l\u00ean nh\u1eafc b\u1ea1n nh\u1eadp l\u1ea1i m\u1eadt kh\u1ea9u nh\u01b0 v\u1eady s\u1ebd kh\u00f4ng x\u1ea3y ra vi\u1ec7c sai m\u1eadt kh\u1ea9u d\u1eabn \u0111\u1ebfn kh\u00f3a b\u1ea3ng t\u00ednh Excel c\u1ee7a b\u1ea1n m\u00e3i m\u00e3i. Nh\u1eadp l\u1ea1i m\u1eadt kh\u1ea9u xong th\u00ec nh\u1ea5n OK l\u00e0 \u0111\u01b0\u1ee3c<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cach_huy_bao_ve_bang_tinh_Excel\"><\/span><span style=\"font-family: georgia, palatino, serif\">C\u00e1ch h\u1ee7y b\u1ea3o v\u1ec7 b\u1ea3ng t\u00ednh Excel<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-family: georgia, palatino, serif\">Nh\u01b0 b\u1ea1n v\u1eeba th\u1ea5y, th\u1eadt d\u1ec5 d\u00e0ng \u0111\u1ec3 \u0111\u1eb7t m\u1eadt kh\u1ea9u b\u1ea3o v\u1ec7 cho m\u1ed9t trang trong Excel. Vi\u1ec7c kh\u00f4ng b\u1ea3o v\u1ec7 b\u1ea3ng t\u00ednh th\u1eadm ch\u00ed c\u00f2n d\u1ec5 d\u00e0ng h\u01a1n, mi\u1ec5n l\u00e0 b\u1ea1n bi\u1ebft m\u1eadt kh\u1ea9u. Th\u1eadm ch\u00ed, vi\u1ec7c m\u1edf kh\u00f3a b\u1ea3ng t\u00ednh Excel khi kh\u00f4ng c\u00f3 m\u1eadt kh\u1ea9u c\u0169ng kh\u00f4ng h\u1ec1 kh\u00f3.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cach_huy_bao_ve_cho_bang_tinh_Excel_khi_co_mat_khau\"><\/span><span style=\"font-family: georgia, palatino, serif\">C\u00e1ch\u00a0h\u1ee7y b\u1ea3o v\u1ec7 cho b\u1ea3ng t\u00ednh Excel khi c\u00f3 m\u1eadt kh\u1ea9u<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-family: georgia, palatino, serif\">N\u1ebfu b\u1ea1n bi\u1ebft m\u1eadt kh\u1ea9u c\u1ee7a trang \u0111\u01b0\u1ee3c b\u1ea3o v\u1ec7, vi\u1ec7c lo\u1ea1i b\u1ecf b\u1ea3o v\u1ec7 ch\u1ec9 m\u1ea5t m\u1ed9t v\u00e0i gi\u00e2y. Ch\u1ec9 c\u1ea7n l\u00e0m m\u1ed9t trong nh\u1eefng thao t\u00e1c sau \u0111\u00e2y:<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">\u2013 Nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o tab Sheet, v\u00e0 ch\u1ecdn Unprotect Sheet t\u1eeb tr\u00ecnh \u0111\u01a1n ng\u1eef c\u1ea3nh.<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> \u2013 Tr\u00ean tab Review tab, nh\u00f3m Changes, ch\u1ecdn Unprotect Sheet.<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> <img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7723\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/4-2-1.png\" width=\"616\" height=\"136\" title=\"4-2-1\"><\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> \u2013 Tr\u00ean tab Home, trong nh\u00f3m Cells, ch\u1ecdn Format, r\u1ed3i ch\u1ecdn ti\u1ebfp Unprotect Sheet t\u1eeb tr\u00ecnh \u0111\u01a1n th\u1ea3 xu\u1ed1ng.<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> <img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7724\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/5-2-1.png\" width=\"249\" height=\"455\" title=\"5-2-1\"><\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> N\u1ebfu b\u1ea1n \u0111ang x\u1eed l\u00fd m\u1ed9t b\u1ea3ng t\u00ednh \u0111\u01b0\u1ee3c b\u1ea3o v\u1ec7 b\u1eb1ng m\u1eadt kh\u1ea9u, Excel s\u1ebd y\u00eau c\u1ea7u b\u1ea1n nh\u1eadp m\u1eadt kh\u1ea9u. Nh\u1eadp m\u1eadt kh\u1ea9u v\u00e0 nh\u1ea5n OK.<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">N\u1ebfu b\u1ea3ng t\u00ednh kh\u00f4ng \u0111\u01b0\u1ee3c b\u1ea3o v\u1ec7 b\u1eb1ng m\u1eadt kh\u1ea9u, nh\u1ea5n v\u00e0o n\u00fat Unprotect Sheet l\u00e0 c\u00f3 th\u1ec3 m\u1edf kh\u00f3a.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cach_bo_bao_ve_bang_tinh_Excel_khi_khong_co_mat_khau\"><\/span><span style=\"font-family: georgia, palatino, serif\">C\u00e1ch b\u1ecf b\u1ea3o v\u1ec7 b\u1ea3ng t\u00ednh Excel khi kh\u00f4ng c\u00f3 m\u1eadt kh\u1ea9u<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-family: georgia, palatino, serif\">Nh\u01b0 \u0111\u00e3 \u0111\u1ec1 c\u1eadp \u1edf ph\u1ea7n \u0111\u1ea7u c\u1ee7a h\u01b0\u1edbng d\u1eabn n\u00e0y, t\u00ednh n\u0103ng b\u1ea3o v\u1ec7 b\u1ea3ng c\u1ee7a Excel kh\u00e1 y\u1ebfu, ngay c\u1ea3 trong c\u00e1c phi\u00ean b\u1ea3n Excel 2013 v\u00e0 Excel 2016 g\u1ea7n \u0111\u00e2y. N\u1ebfu b\u1ea1n c\u1ea7n ch\u1ec9nh s\u1eeda m\u1eadt kh\u1ea9u \u0111\u01b0\u1ee3c b\u1ea3o v\u1ec7 nh\u01b0ng b\u1ea1n kh\u00f4ng th\u1ec3 nh\u1edb m\u1eadt kh\u1ea9u, h\u00e3y th\u1eed m\u1edf b\u1ea3ng t\u00ednh Excel \u0111\u00f3 b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng m\u1ed9t trong nh\u1eefng ph\u01b0\u01a1ng ph\u00e1p sau:<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Mo_bang_tinh_Excel_voi_ma_VBA_cho_Excel_2010_va_phien_ban_cu_hon\"><\/span><span style=\"font-family: georgia, palatino, serif\">M\u1edf b\u1ea3ng t\u00ednh Excel v\u1edbi m\u00e3 VBA (cho Excel 2010 v\u00e0 phi\u00ean b\u1ea3n c\u0169 h\u01a1n)<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-family: georgia, palatino, serif\">N\u1ebfu b\u1ea1n \u0111ang s\u1eed d\u1ee5ng Excel 2010 ho\u1eb7c phi\u00ean b\u1ea3n c\u0169 h\u01a1n, b\u1ea1n c\u00f3 th\u1ec3 m\u1edf kh\u00f3a m\u1ed9t b\u1ea3ng \u0111\u01b0\u1ee3c b\u1ea3o v\u1ec7 b\u1eb1ng m\u1eadt kh\u1ea9u v\u1edbi macro sau.<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">1. Nh\u1ea5n Alt + F11 \u0111\u1ec3 m\u1edf Visual Basic Editor.<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> 2. Nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o t\u00ean workbook \u1edf khung b\u00ean tr\u00e1i (Project-VBaproject panel) v\u00e0 ch\u1ecdn Insert&gt; Module t\u1eeb tr\u00ecnh \u0111\u01a1n ng\u1eef c\u1ea3nh.<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> 3. Trong c\u1eeda s\u1ed5 xu\u1ea5t hi\u1ec7n, d\u00e1n m\u00e3 sau \u0111\u00e2y:<\/span><\/p>\n<\/p>\n<div class=\"oembed-gist\">View the code on <a href=\"https:\/\/gist.github.com\/ndthanh\/f9665a4b042aa17a0d7b3db25b5138bc\">Gist<\/a>.<\/div>\n<p>\u00a0<\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">4. Nh\u1ea5n F5 ho\u1eb7c nh\u1ea5p v\u00e0o n\u00fat Run tr\u00ean thanh c\u00f4ng c\u1ee5 v\u00e0 ch\u1edd v\u00e0i ph\u00fat. Macre s\u1ebd b\u00e1o c\u00e1o m\u1ed9t m\u1eadt kh\u1ea9u hack \u0111\u01b0\u1ee3c, kh\u00f4ng ph\u1ea3i l\u00e0 m\u1eadt kh\u1ea9u ban \u0111\u1ea7u (lu\u00f4n lu\u00f4n l\u00e0 m\u1ed9t s\u1ed1 k\u1ebft h\u1ee3p c\u1ee7a A v\u00e0 B), nh\u01b0ng tuy nhi\u00ean n\u00f3 v\u1eabn ho\u1ea1t \u0111\u1ed9ng.<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">N\u1ebfu b\u1ea1n c\u1ea7n ph\u1ea3i b\u1ecf b\u1ea3o v\u1ec7 b\u1ea3ng t\u00ednh Excel m\u00e0 kh\u00f4ng c\u00f3 m\u1eadt kh\u1ea9u trong c\u00e1c phi\u00ean b\u1ea3n hi\u1ec7n \u0111\u1ea1i c\u1ee7a Excel 2013 v\u00e0 Excel 2016, h\u00e3y th\u1eed m\u1ed9t trong nh\u1eefng c\u00f4ng c\u1ee5 mi\u1ec5n ph\u00ed, v\u00ed d\u1ee5 nh\u01b0 Password Protection Remover add-in cho Excel.<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Sao_chep_noi_dung_trang_duoc_bao_ve_sang_mot_bang_tinh_khac\"><\/span><span style=\"font-family: georgia, palatino, serif\">Sao ch\u00e9p n\u1ed9i dung trang \u0111\u01b0\u1ee3c b\u1ea3o v\u1ec7 sang m\u1ed9t b\u1ea3ng t\u00ednh kh\u00e1c<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-family: georgia, palatino, serif\">M\u1ed9t c\u00e1ch kh\u00e1c \u0111\u1ec3 m\u1edf m\u1ed9t b\u1ea3ng t\u00ednh Excel \u0111\u00e3 \u0111\u01b0\u1ee3c b\u1ea3o v\u1ec7 b\u1eb1ng m\u1eadt kh\u1ea9u l\u00e0 sao ch\u00e9p to\u00e0n b\u1ed9 n\u1ed9i dung c\u1ee7a n\u00f3 v\u00e0o m\u1ed9t trang t\u00ednh m\u1edbi. Ch\u00fang ta l\u00e0m nh\u01b0 sau:<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">1. M\u1edf b\u1ea3ng b\u1ea3o v\u1ec7 b\u1eb1ng m\u1eadt kh\u1ea9u.<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> 2. V\u1edbi con tr\u1ecf \u0111\u1ecbnh v\u1ecb trong \u00f4 A1, nh\u1ea5n Shift + Ctrl + End \u0111\u1ec3 ch\u1ecdn t\u1ea5t c\u1ea3 c\u00e1c \u00f4 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong b\u1ea3ng t\u00ednh.<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> 3. Nh\u1ea5n Ctrl + C \u0111\u1ec3 sao ch\u00e9p c\u00e1c \u00f4 \u0111\u00e3 ch\u1ecdn.<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> 4. T\u1ea1o m\u1ed9t b\u1ea3ng m\u1edbi trong b\u1ea3ng t\u00ednh hi\u1ec7n t\u1ea1i ho\u1eb7c trong m\u1ed9t b\u1ea3ng t\u00ednh kh\u00e1c (\u0111\u1ec3 t\u1ea1o m\u1ed9t t\u1ec7p Excel m\u1edbi, ch\u1ec9 c\u1ea7n nh\u1ea5n Ctrl + N).<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> 5. Trong b\u1ea3ng t\u00ednh tr\u1ed1ng m\u1edbi, \u0111\u1eb7t con tr\u1ecf v\u00e0o A1 v\u00e0 nh\u1ea5n Ctrl + V \u0111\u1ec3 d\u00e1n n\u1ed9i dung c\u1ee7a b\u1ea3ng b\u1ea3o v\u1ec7 b\u1eb1ng m\u1eadt kh\u1ea9u.<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> <strong> Ghi ch\u00fa:<\/strong><\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> Ph\u01b0\u01a1ng ph\u00e1p n\u00e0y ch\u1ec9 ho\u1ea1t \u0111\u1ed9ng n\u1ebfu c\u00e1c h\u00e0nh \u0111\u1ed9ng Select locked cells v\u00e0 Select unlocked cells \u0111\u01b0\u1ee3c cho ph\u00e9p trong b\u1ea3ng t\u00ednh \u0111\u01b0\u1ee3c b\u1ea3o v\u1ec7.<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> N\u1ebfu b\u1ea3ng t\u00ednh \u0111\u01b0\u1ee3c b\u1ea3o v\u1ec7 b\u1eb1ng m\u1eadt kh\u1ea9u c\u00f3 li\u00ean k\u1ebft b\u00ean ngo\u00e0i v\u1edbi c\u00e1c trang t\u00ednh ho\u1eb7c b\u1ea3ng t\u00ednh kh\u00e1c, b\u1ea1n c\u1ea7n ph\u1ea3i t\u1ea1o l\u1ea1i c\u00e1c li\u00ean k\u1ebft \u0111\u00f3 theo c\u00e1ch th\u1ee7 c\u00f4ng.<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> B\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng Paste Special \u0111\u1ec3 sao ch\u00e9p \/ d\u00e1n chi\u1ec1u r\u1ed9ng c\u1ee7a c\u1ed9t v\u00ec v\u1eady b\u1ea1n s\u1ebd kh\u00f4ng c\u1ea7n ph\u1ea3i \u0111i\u1ec1u ch\u1ec9nh ch\u00fang trong trang m\u1edbi theo c\u00e1ch th\u1ee7 c\u00f4ng.<\/span><\/p>\n<blockquote>\n<p><span style=\"font-family: georgia, palatino, serif\">T\u00ecm hi\u1ec3u th\u00eam: B\u1ed9 t\u00e0i li\u1ec7u v\u1ec1\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/excel-co-ban\">Excel c\u01a1 ba\u0309n<\/a> c\u1ef1c hay<\/span><\/p>\n<\/blockquote>\n<h2><span class=\"ez-toc-section\" id=\"Cach_bao_ve_mot_bang_tinh_trong_Excel\"><\/span><span style=\"font-family: georgia, palatino, serif\">C\u00e1ch b\u1ea3o v\u1ec7 m\u1ed9t b\u1ea3ng t\u00ednh trong Excel<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-family: georgia, palatino, serif\">Ngo\u00e0i vi\u1ec7c b\u1ea3o v\u1ec7 n\u1ed9i dung c\u1ee7a b\u1ea3ng, b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 kh\u00f3a to\u00e0n b\u1ed9 b\u1ea3ng t\u00ednh \u0111\u1ec3 ng\u0103n ng\u01b0\u1eddi d\u00f9ng th\u00eam, di chuy\u1ec3n, \u0111\u1ed5i t\u00ean ho\u1eb7c x\u00f3a c\u00e1c b\u1ea3ng t\u00ednh v\u00e0 xem c\u00e1c trang \u1ea9n.<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">\u0110\u1ec3 b\u1ea3o v\u1ec7 b\u1ea3ng t\u00ednh, h\u00e3y th\u1ef1c hi\u1ec7n c\u00e1c b\u01b0\u1edbc sau:<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">Tr\u00ean tab Review, trong nh\u00f3m Changes, nh\u1ea5p v\u00e0o Protect Workbook.<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> <img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7726\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/7-2-1.png\" width=\"582\" height=\"132\" title=\"7-2-1\"><\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> 2. Trong Protect workbook for, h\u00e3y ch\u1ecdn m\u1ed9t trong hai t\u00f9y ch\u1ecdn, ho\u1eb7c c\u1ea3 hai:<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> \u2013 Ki\u1ec3m tra h\u1ed9p Structure \u0111\u1ec3 b\u1ea3o v\u1ec7 c\u1ea5u tr\u00fac c\u1ee7a m\u1ed9t b\u1ea3ng t\u00ednh. \u0110i\u1ec1u n\u00e0y s\u1ebd ng\u0103n ch\u1eb7n c\u00e1c ho\u1ea1t \u0111\u1ed9ng sau:<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> + Xem b\u1ea3ng t\u00ednh \u1ea9n.<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> + \u0110\u1eb7t l\u1ea1i t\u00ean, di chuy\u1ec3n, \u1ea9n ho\u1eb7c xo\u00e1 c\u00e1c trang.<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> + Ch\u00e8n trang m\u1edbi v\u00e0 b\u1ea3ng bi\u1ec3u. Tuy nhi\u00ean, ng\u01b0\u1eddi d\u00f9ng s\u1ebd c\u00f3 th\u1ec3 ch\u00e8n m\u1ed9t bi\u1ec3u \u0111\u1ed3 v\u00e0o m\u1ed9t b\u1ea3ng t\u00ednh hi\u1ec7n c\u00f3.<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> + Di chuy\u1ec3n ho\u1eb7c sao ch\u00e9p trang t\u00ednh sang m\u1ed9t b\u1ea3ng t\u00ednh kh\u00e1c.<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> \u2013 Ki\u1ec3m tra h\u1ed9p Windows \u0111\u1ec3 gi\u1eef l\u1ea1i k\u00edch th\u01b0\u1edbc v\u00e0 v\u1ecb tr\u00ed c\u1ee7a s\u1ed5 l\u00e0m vi\u1ec7c. \u0110i\u1ec1u n\u00e0y s\u1ebd ng\u0103n ng\u01b0\u1eddi d\u00f9ng di chuy\u1ec3n, thay \u0111\u1ed5i k\u00edch c\u1ee1, gi\u1ea3m thi\u1ec3u, ho\u1eb7c \u0111\u00f3ng b\u1ea3ng t\u00ednh.<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> <img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7727\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/8-2.png\" width=\"269\" height=\"191\" title=\"8-2\"><\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> Ch\u00fa th\u00edch. Tu\u1ef3 ch\u1ecdn Windows \u1edf \u0111\u00e2y kh\u00f4ng c\u00f3 s\u1eb5n (b\u1ecb b\u00f4i x\u00e1m) trong Excel 2013 v\u00e0 Excel 2016, nh\u01b0 th\u1ec3 hi\u1ec7n trong \u1ea3nh ch\u1ee5p m\u00e0n h\u00ecnh \u1edf tr\u00ean. \u0110\u00f3 l\u00e0 v\u00ec Microsoft \u0111\u00e3 gi\u1edbi thi\u1ec7u Single Document Interface trong Excel 2013, n\u01a1i m\u00e0 m\u1ed7i b\u1ea3ng l\u00e0m vi\u1ec7c c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c thu nh\u1ecf, kh\u00f4i ph\u1ee5c v\u00e0 \u0111\u00f3ng l\u1ea1i.<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">Trong h\u1ed9p Password, nh\u1eadp m\u1eadt kh\u1ea9u v\u00e0 nh\u1ea5p v\u00e0o n\u00fat OK.<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">B\u1ea1n c\u00f3 th\u1ec3 t\u00f9y ch\u1ecdn m\u1eadt kh\u1ea9u ho\u1eb7c kh\u00f4ng nh\u1eadp \u0111\u1ec1u \u0111\u01b0\u1ee3c nh\u01b0ng n\u1ebfu b\u1ea1n kh\u00f4ng nh\u1eadp m\u1eadt kh\u1ea9u, th\u00ec b\u1ea5t k\u1ef3 ai c\u0169ng c\u00f3 th\u1ec3 m\u1edf kh\u00f3a b\u1ea3ng t\u00ednh b\u1eb1ng m\u1ed9t n\u00fat b\u1ea5m.<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">Nh\u1eadp l\u1ea1i m\u1eadt kh\u1ea9u trong c\u1eeda s\u1ed5Confirm Password v\u00e0 nh\u1ea5p v\u00e0o OK.<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cach_mo_mot_bang_tinh_duoc_bao_ve_trong_Excel\"><\/span><span style=\"font-family: georgia, palatino, serif\">C\u00e1ch m\u1edf m\u1ed9t b\u1ea3ng t\u00ednh \u0111\u01b0\u1ee3c b\u1ea3o v\u1ec7 trong Excel<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-family: georgia, palatino, serif\">\u0110\u1ec3 h\u1ee7y b\u1ea3o v\u1ec7 b\u1ea3ng t\u00ednh, h\u00e3y th\u1ef1c hi\u1ec7n theo c\u00e1c b\u01b0\u1edbc sau:<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">Nh\u1ea5p l\u1ea1i v\u00e0o n\u00fat Protect Workbook (trong m\u1ed9t b\u1ea3ng t\u00ednh b\u1ecb kh\u00f3a, n\u00f3 \u0111\u01b0\u1ee3c \u0111\u00e1nh d\u1ea5u m\u00e0u xanh nh\u01b0 trong \u1ea3nh ch\u1ee5p m\u00e0n h\u00ecnh b\u00ean d\u01b0\u1edbi):<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> <img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7728\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/9-2.png\" width=\"413\" height=\"129\" title=\"9-2\"><\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> 2. G\u00f5 m\u1eadt kh\u1ea9u n\u1ebfu \u0111\u01b0\u1ee3c nh\u1eafc.<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> 3. L\u01b0u b\u1ea3ng t\u00ednh.<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">L\u01b0u \u00fd quan tr\u1ecdng! B\u1ea3o v\u1ec7 c\u1ea5u tr\u00fac b\u1ea3ng t\u00ednh kh\u00f4ng n\u00ean nh\u1ea7m l\u1eabn v\u1edbi m\u00e3 ho\u00e1 m\u1eadt kh\u1ea9u \u1edf b\u1ea3ng t\u00ednh c\u00f3 th\u1ec3 ng\u0103n ng\u01b0\u1eddi d\u00f9ng kh\u00e1c m\u1edf ho\u1eb7c s\u1eeda \u0111\u1ed5i b\u1ea3ng t\u00ednh c\u1ee7a b\u1ea1n.<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Mat_khau_bao_ve_bang_tinh_Excel_khi_dang_mo\"><\/span><span style=\"font-family: georgia, palatino, serif\">M\u1eadt kh\u1ea9u b\u1ea3o v\u1ec7 b\u1ea3ng t\u00ednh Excel khi \u0111ang m\u1edf<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-family: georgia, palatino, serif\">N\u1ebfu b\u1ea1n l\u01b0u c\u00e1c b\u1ea3ng t\u00ednh c\u1ee7a m\u00ecnh \u1edf v\u1ecb tr\u00ed \u0111\u01b0\u1ee3c chia s\u1ebb nh\u01b0 m\u1ea1ng c\u1ee5c b\u1ed9 c\u1ee7a c\u00f4ng ty v\u00e0 b\u1ea1n mu\u1ed1n ng\u0103n ng\u01b0\u1eddi d\u00f9ng kh\u00e1c xem c\u00e1c t\u1ec7p Excel c\u1ee7a m\u00ecnh, b\u1ea1n c\u00f3 th\u1ec3 m\u00e3 ho\u00e1 b\u1ea3ng t\u00ednh b\u1eb1ng m\u1eadt kh\u1ea9u th\u1eadm ch\u00ed c\u00f2n c\u00f3 th\u1ec3 kh\u00f4ng cho ph\u00e9p ng\u01b0\u1eddi kh\u00e1c m\u1edf n\u00f3.<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">1. Trong b\u1ea3ng t\u00ednh m\u00e0 b\u1ea1n mu\u1ed1n m\u00e3 h\u00f3a, nh\u1ea5p v\u00e0o File&gt; Info, nh\u1ea5n v\u00e0o n\u00fat Protect Workbook, v\u00e0 ch\u1ecdn Encrypt with Password trong tr\u00ecnh \u0111\u01a1n th\u1ea3 xu\u1ed1ng.<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> <img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7729\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/10-2.png\" width=\"464\" height=\"330\" title=\"10-2\"><\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> 2. C\u1eeda s\u1ed5 Encrypt Document s\u1ebd xu\u1ea5t hi\u1ec7n, b\u1ea1n nh\u1eadp m\u1eadt kh\u1ea9u v\u00e0o h\u1ed9p Password, v\u00e0 nh\u1ea5n OK.<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> <img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7730\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/11-2.png\" width=\"335\" height=\"227\" title=\"11-2\"><\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">Theo m\u1eb7c \u0111\u1ecbnh, Microsoft Excel s\u1eed d\u1ee5ng m\u00e3 h\u00f3a ti\u00ean ti\u1ebfn 128-bit AES v\u00e0 b\u1ea1n c\u00f3 th\u1ec3 cung c\u1ea5p m\u1eadt kh\u1ea9u t\u1ed1i \u0111a 255 k\u00fd t\u1ef1.<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">3. G\u00f5 l\u1ea1i m\u1eadt kh\u1ea9u trong h\u1ed9p Reenter password, v\u00e0 nh\u1ea5n OK.<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> 4. L\u01b0u b\u1ea3ng t\u00ednh c\u1ee7a b\u1ea1n.<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> \u0110\u1ec3 lo\u1ea1i b\u1ecf vi\u1ec7c m\u00e3 h\u00f3a b\u1ea3ng t\u00ednh, h\u00e3y l\u1eb7p l\u1ea1i c\u00e1c b\u01b0\u1edbc tr\u00ean, x\u00f3a m\u1eadt kh\u1ea9u t\u1eeb h\u1ed9p Password, b\u1ea5m OK, v\u00e0 sau \u0111\u00f3 l\u01b0u b\u1ea3ng t\u00ednh c\u1ee7a b\u1ea1n.<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">M\u1eb9o. Ngo\u00e0i b\u1ea3o v\u1ec7 b\u1eb1ng m\u1eadt kh\u1ea9u, b\u1ea1n c\u00f3 th\u1ec3 b\u1ea3o v\u1ec7 t\u1ec7p Excel c\u1ee7a m\u00ecnh t\u1ed1t h\u01a1n b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng BitLocker Drive Encryption, c\u00f3 s\u1eb5n trong phi\u00ean b\u1ea3n Ultimate v\u00e0 Enterprise c\u1ee7a Windows Vista v\u00e0 Windows.<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">M\u1eadt kh\u1ea9u b\u1ea3o v\u1ec7 b\u1ea3ng t\u00ednh Excel \u0111\u1ec3 tr\u00e1nh b\u1ecb thay \u0111\u1ed5i d\u1eef li\u1ec7u<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> N\u1ebfu b\u1ea1n kh\u00f4ng quan t\u00e2m vi\u1ec7c ng\u01b0\u1eddi d\u00f9ng kh\u00e1c \u0111ang m\u1edf t\u1ec7p Excel c\u1ee7a m\u00ecnh nh\u01b0ng b\u1ea1n mu\u1ed1n ng\u0103n h\u1ecd th\u1ef1c hi\u1ec7n b\u1ea5t k\u1ef3 thay \u0111\u1ed5i n\u00e0o \u0111\u1ed1i v\u1edbi b\u1ea3ng t\u00ednh c\u1ee7a b\u1ea1n, h\u00e3y th\u1ef1c hi\u1ec7n theo c\u00e1c b\u01b0\u1edbc sau.<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">1. Trong b\u1ea3ng t\u00ednh Excel c\u1ee7a b\u1ea1n, nh\u1ea5p v\u00e0o n\u00fat Save As, sau \u0111\u00f3 nh\u1ea5p v\u00e0o n\u00fat Tools \u1edf cu\u1ed1i c\u1eeda s\u1ed5.<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> 2. Trong tr\u00ecnh \u0111\u01a1n Tools th\u1ea3 xu\u1ed1ng, h\u00e3y ch\u1ecdn General Options.<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> <img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7731\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/12-2.png\" width=\"587\" height=\"519\" title=\"12-2\"><\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> 3. Trong c\u1eeda s\u1ed5 h\u1ed9p tho\u1ea1i General Options, nh\u1eadp m\u1eadt kh\u1ea9u v\u00e0o h\u1ed9p Password \u0111\u1ec3 s\u1eeda \u0111\u1ed5i. Ngo\u00e0i ra, b\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn t\u00f9y ch\u1ecdn Read-only (ch\u1ec9 \u0111\u1ecdc).<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> <img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7732\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/13-2.png\" width=\"306\" height=\"193\" title=\"13-2\"><\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> M\u1eb9o. N\u1ebfu b\u1ea1n mu\u1ed1n b\u1ea3o v\u1ec7 t\u1ec7p Excel c\u1ee7a b\u1ea1n tr\u00e1nh b\u1ecb s\u1eeda \u0111\u1ed5i v\u00e0 m\u1edf, h\u00e3y nh\u1eadp m\u1eadt kh\u1ea9u v\u00e0o Password to open v\u00e0 Password to modify. Hai h\u1ed9p tho\u1ea1i \u0111\u00f3 c\u00f3 th\u1ec3 c\u00e0i chung 1 m\u1eadt kh\u1ea9u.<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">4. G\u00f5 l\u1ea1i m\u1eadt kh\u1ea9u trong h\u1ed9p tho\u1ea1i Confirm Password v\u00e0 nh\u1ea5p v\u00e0o Ok. N\u1ebfu b\u1ea1n \u0111\u00e3 nh\u1eadp 2 m\u1eadt kh\u1ea9u trong b\u01b0\u1edbc tr\u01b0\u1edbc, b\u1ea1n s\u1ebd \u0111\u01b0\u1ee3c y\u00eau c\u1ea7u x\u00e1c nh\u1eadn c\u1ea3 hai.<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> 5. Cu\u1ed1i c\u00f9ng, nh\u1ea5p v\u00e0o n\u00fat Save trong h\u1ed9p tho\u1ea1i Save As.<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">\u0110\u1ec3 h\u1ee7y b\u1ea3o v\u1ec7 m\u1eadt kh\u1ea9u, h\u00e3y l\u1eb7p l\u1ea1i c\u00e1c b\u01b0\u1edbc tr\u00ean, v\u00e0 x\u00f3a m\u1eadt kh\u1ea9u t\u1eeb Password to open v\u00e0 Password to modify. Sau \u0111\u00f3 nh\u1ea5p v\u00e0o n\u00fat Save \u0111\u1ec3 l\u01b0u b\u1ea3ng t\u00ednh c\u1ee7a b\u1ea1n.<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">\u0110\u00e2y l\u00e0 c\u00e1ch b\u1ea1n c\u00f3 th\u1ec3 b\u1ea3o v\u1ec7 b\u1ea3ng t\u00ednh Excel v\u00e0 kh\u00f3a to\u00e0n b\u1ed9 b\u1ea3ng t\u00ednh \u0111\u1ec3 tr\u00e1nh b\u1ecb thay \u0111\u1ed5i ho\u1eb7c m\u1edf. Tuy nhi\u00ean, \u0111\u00f4i khi b\u1ea1n c\u00f3 th\u1ec3 ch\u1ec9 mu\u1ed1n kh\u00f3a c\u00e1c \u00f4 nh\u1ea5t \u0111\u1ecbnh trong b\u1ea3ng c\u1ee7a b\u1ea1n. V\u1eady, b\u1ea1n c\u00f3 th\u1ec3 theo d\u00f5i b\u00e0i vi\u1ebft v\u1ec1 c\u00e1ch kh\u00f3a m\u1ed9t s\u1ed1 \u00f4 nh\u1ea5t \u0111\u1ecbnh trong trang t\u00ednh v\u00e0 b\u1ea3ng t\u00ednh Excel c\u1ee7a H\u1ecdc Excel Online nh\u00e9.<\/span><\/p>\n<p>R\u1ea5t nhi\u1ec1u ki\u1ebfn th\u1ee9c ph\u1ea3i kh\u00f4ng n\u00e0o? To\u00e0n b\u1ed9 nh\u1eefng ki\u1ebfn th\u1ee9c n\u00e0y c\u00e1c b\u1ea1n \u0111\u1ec1u c\u00f3 th\u1ec3 h\u1ecdc \u0111\u01b0\u1ee3c trong kh\u00f3a h\u1ecdc\u00a0<a href=\"http:\/\/bit.ly\/2w6YAe8\">EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi chuy\u00ean gia<\/a>\u00a0c\u1ee7a H\u1ecdc Excel Online. \u0110\u00e2y l\u00e0 kh\u00f3a h\u1ecdc gi\u00fap b\u1ea1n h\u1ec7 th\u1ed1ng ki\u1ebfn th\u1ee9c m\u1ed9t c\u00e1ch \u0111\u1ea7y \u0111\u1ee7, chi ti\u1ebft. H\u01a1n n\u1eefa kh\u00f4ng h\u1ec1 c\u00f3 gi\u1edbi h\u1ea1n v\u1ec1 th\u1eddi gian h\u1ecdc t\u1eadp n\u00ean b\u1ea1n c\u00f3 th\u1ec3 tho\u1ea3i m\u00e1i h\u1ecdc b\u1ea5t c\u1ee9 l\u00fac n\u00e0o, d\u1ec5 d\u00e0ng tra c\u1ee9u l\u1ea1i ki\u1ebfn th\u1ee9c khi c\u1ea7n. Hi\u1ec7n nay h\u1ec7 th\u1ed1ng \u0111ang c\u00f3 \u01b0u \u0111\u00e3i r\u1ea5t l\u1edbn cho b\u1ea1n khi \u0111\u0103ng k\u00fd tham gia kh\u00f3a h\u1ecdc. Chi ti\u1ebft xem t\u1ea1i: <a href=\"https:\/\/hocexcel.online\" target=\"_blank\" rel=\"noopener noreferrer\">HocExcel.Online<\/a><\/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\/2024\/12\/vba101_92019-nho-140.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":4125,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-4124","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\/4124","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=4124"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/4124\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/4125"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=4124"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=4124"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=4124"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}