{"id":10145,"date":"2025-01-08T19:46:09","date_gmt":"2025-01-08T19:46:09","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/08\/bao-ve-trang-tinh-voi-chuc-nang-protect-sheet\/"},"modified":"2025-01-08T19:46:09","modified_gmt":"2025-01-08T19:46:09","slug":"bao-ve-trang-tinh-voi-chuc-nang-protect-sheet","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/08\/bao-ve-trang-tinh-voi-chuc-nang-protect-sheet\/","title":{"rendered":"B\u1ea3o v\u1ec7 trang t\u00ednh v\u1edbi ch\u1ee9c n\u0103ng Protect Sheet"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>B\u1ea1n c\u00f3 m\u1ed9t b\u1ea3ng d\u1eef li\u1ec7u nh\u00f3m ph\u1ea3i chia s\u1ebb v\u1edbi ng\u01b0\u1eddi kh\u00e1c? B\u1ea1n kh\u00f4ng mu\u1ed1n c\u00f3 nh\u1eefng thay \u0111\u1ed5i s\u01a1 su\u1ea5t \u1ea3nh h\u01b0\u1edfng t\u1edbi d\u1eef li\u1ec7u c\u00f3 s\u1eb5n? H\u00e3y \u0111\u1ecdc b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u1ec3\u00a0b\u1ea3o v\u1ec7 trang t\u00ednh v\u1edbi ch\u1ee9c n\u0103ng Protect Sheet ngay:<\/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-677ed600e0238\" 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-3\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/bao-ve-trang-tinh-voi-chuc-nang-protect-sheet.html#Khoa_oMo_khoa_o\" title=\"Kh\u00f3a \u00f4\/M\u1edf kh\u00f3a \u00f4\">Kh\u00f3a \u00f4\/M\u1edf kh\u00f3a \u00f4<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/bao-ve-trang-tinh-voi-chuc-nang-protect-sheet.html#Bao_ve_trang_tinh_voi_chuc_nang_Protect_Sheet\" title=\"B\u1ea3o v\u1ec7 trang t\u00ednh v\u1edbi ch\u1ee9c n\u0103ng Protect Sheet\">B\u1ea3o v\u1ec7 trang t\u00ednh v\u1edbi ch\u1ee9c n\u0103ng Protect Sheet<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Khoa_oMo_khoa_o\"><\/span><strong>Kh\u00f3a \u00f4\/M\u1edf kh\u00f3a \u00f4<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Nh\u01b0 \u1edf b\u00e0i tr\u01b0\u1edbc v\u1ec1 <a href=\"http:\/\/blog.ezworkapp.com\/thao-tac-voi-trang-tinh-mos-excel.html\">c\u00e1c thao t\u00e1c v\u1edbi trang t\u00ednh<\/a> v\u00e0 <a href=\"http:\/\/blog.ezworkapp.com\/dinh-dang-mos-excel-voi-format-cells.html\">h\u1ed9p tho\u1ea1i Format Cells\u2026<\/a> , ch\u00fang ta \u0111\u00e3 bi\u1ebft t\u1edbi hai \u0111\u1ed1i t\u01b0\u1ee3ng: Th\u1ebb <strong>Protection<\/strong> v\u00e0 ch\u1ee9c n\u0103ng <strong>Protect Sheet.<\/strong><\/p>\n<p>Th\u1ebb <strong>Protection<\/strong> ch\u1ee9a hai t\u00f9y ch\u1ecdn: Hidden \u2013 \u1ea9n v\u00e0 Locked \u2013 kh\u00f3a<\/p>\n<figure id=\"attachment_20647\" aria-describedby=\"caption-attachment-20647\" style=\"width: 542px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-20647\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/protection.png\" alt=\"protection\" width=\"542\" height=\"472\" title=\"protection\"><figcaption id=\"caption-attachment-20647\" class=\"wp-caption-text\">Th\u1ebb Protection<\/figcaption><\/figure>\n<p>\u0110\u1ec3 ti\u1ebfn h\u00e0nh kh\u00f3a \u00f4 ta b\u00f4i \u0111en v\u00f9ng c\u1ea7n kh\u00f3a, sau \u0111\u00f3 t\u00edch v\u00e0o <strong>Locked<\/strong> trong th\u1ebb <strong>Protection. <\/strong>\u1ea4n OK \u0111\u1ec3 l\u01b0u thay \u0111\u1ed5i.<\/p>\n<p>V\u1eabn ch\u01b0a c\u00f3 g\u00ec x\u1ea3y ra, ch\u01b0a \u201ckh\u00f3a\u201d ph\u1ea3i kh\u00f4ng? H\u00e3y \u0111i ti\u1ebfp xu\u1ed1ng ph\u1ea7n d\u01b0\u1edbi.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Bao_ve_trang_tinh_voi_chuc_nang_Protect_Sheet\"><\/span><strong>B\u1ea3o v\u1ec7 trang t\u00ednh v\u1edbi ch\u1ee9c n\u0103ng Protect Sheet<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Ch\u1ee9c n\u0103ng Protect Sheet c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng t\u00ecm th\u1ea5y khi click chu\u1ed9t ph\u1ea3i v\u00e0o t\u00ean trang t\u00ednh, ho\u1eb7c trong th\u1ebb <strong>Review <\/strong>tr\u00ean thanh Ribbon.<\/p>\n<p>Khi \u1ea5n v\u00e0o Protect Sheet, m\u1ed9t h\u1ed9p tho\u1ea1i s\u1ebd hi\u1ec7n ra nh\u01b0 sau:<\/p>\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-136.gif\" title=\"ex101_92019-nho-136\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><strong>Password to unprotect sheet: <\/strong>M\u1eadt kh\u1ea9u \u0111\u1ec3 b\u1ecf ch\u1ebf \u0111\u1ed9 b\u1ea3o v\u1ec7 trang t\u00ednh<\/p>\n<p>V\u1edbi nh\u1eefng t\u00f9y ch\u1ecdn \u1edf trong b\u1ea3ng <strong>Allow all users of this worksheet to:<\/strong> ta c\u00f3:<\/p>\n<p>-Select locked\/unlocked cells: Ch\u1ecdn nh\u1eefng \u00f4 kh\u00f3a\/kh\u00f4ng kh\u00f3a. \u0110i\u1ec1u n\u00e0y c\u00f3 ngh\u0129a l\u00e0, khi ta b\u1ecf ch\u1ecdn \u201cSelect locked cells\u201d sau thao t\u00e1c kh\u00f3a \u00f4 \u1edf tr\u00ean v\u00e0 ti\u1ebfn h\u00e0nh Protect Sheet, ta kh\u00f4ng th\u1ec3 click v\u00e0o nh\u1eefng \u00f4 \u0111\u00e3 b\u1ecb kh\u00f3a n\u1eefa.<\/p>\n<p>-Format cells\/rows\/columns: Ch\u1ec9nh s\u1eeda v\u1ec1 k\u00edch c\u1ee1 \u00f4, h\u00e0ng v\u00e0 c\u1ed9t. N\u1ebfu b\u1ea1n kh\u00f4ng mu\u1ed1n h\u00e0ng c\u1ed9t c\u00f3 b\u1ea5t k\u00ec thay \u0111\u1ed5i g\u00ec, h\u00e3y b\u1ecf ch\u1ecdn.<\/p>\n<p>-Insert\/Delete hyperlink\/rows\/columns: Th\u00eam\/x\u00f3a hyperlink, h\u00e0ng ho\u1eb7c c\u1ed9t. Vi\u1ec7c b\u1ecf t\u00edch s\u1ebd kh\u00f4ng cho ph\u00e9p ng\u01b0\u1eddi kh\u00e1c ch\u1ec9nh s\u1eeda.<\/p>\n<p>V\u00e0 c\u00e1c ch\u1ee9c n\u0103ng kh\u00e1c t\u01b0\u01a1ng t\u1ef1 nh\u01b0 tr\u00ean.<\/p>\n<p>\u0110\u1ec3 ti\u1ebfn h\u00e0nh m\u1edf kh\u00f3a, ta \u1ea5n m\u1ed9t l\u1ea7n n\u1eefa v\u00e0o <strong>Protect Sheet, <\/strong>t\u1ea1i th\u1eddi \u0111i\u1ec3m n\u00e0y \u0111\u00e3 chuy\u1ec3n th\u00e0nh <strong>Unprotect Sheet<\/strong> v\u00e0 nh\u1eadp m\u1eadt kh\u1ea9u n\u1ebfu c\u00f3.<\/p>\n<figure id=\"attachment_20646\" aria-describedby=\"caption-attachment-20646\" style=\"width: 289px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-20646\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/hop-thoai-protect-sheet.png\" alt=\"protect sheet\" width=\"289\" height=\"316\" title=\"hop-thoai-protect-sheet\"><figcaption id=\"caption-attachment-20646\" class=\"wp-caption-text\">H\u1ed9p tho\u1ea1i protect sheet<\/figcaption><\/figure>\n<p>V\u1eady l\u00e0 ta \u0111\u00e3 xong thao t\u00e1c b\u1ea3o v\u1ec7 trang t\u00ednh. Th\u1eadt \u0111\u01a1n gi\u1ea3n ph\u1ea3i kh\u00f4ng? Ch\u00fac c\u00e1c b\u1ea1n h\u1ecdc t\u1ed1t c\u00f9ng H\u1ecdc Excel Online v\u00e0 \u0111\u1eebng qu\u00ean theo d\u00f5i nh\u1eefng b\u00e0i vi\u1ebft ti\u1ebfp theo nh\u00e9.<\/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\/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-136.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":10146,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-10145","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\/10145","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=10145"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/10145\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/10146"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=10145"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=10145"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=10145"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}