{"id":6356,"date":"2024-12-21T15:09:16","date_gmt":"2024-12-21T15:09:16","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cach-bao-ve-khoa-cot-an-trong-excel\/"},"modified":"2024-12-21T15:09:16","modified_gmt":"2024-12-21T15:09:16","slug":"cach-bao-ve-khoa-cot-an-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cach-bao-ve-khoa-cot-an-trong-excel\/","title":{"rendered":"C\u00e1ch b\u1ea3o v\u1ec7\/kh\u00f3a c\u1ed9t \u1ea9n trong Excel"},"content":{"rendered":"
\n

H\u00f4m nay H\u1ecdc Excel Online s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n C\u00e1ch b\u1ea3o v\u1ec7\/kh\u00f3a c\u1ed9t \u1ea9n trong Excel<\/p>\n

Trong Excel, \u1ea9n v\u00e0 b\u1ecf \u1ea9n c\u00e1c c\u1ed9t l\u00e0 c\u00e1c ch\u1ee9c n\u0103ng ph\u1ed5 bi\u1ebfn, b\u1ea1n c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng \u1ea9n c\u00e1c c\u1ed9t v\u00e0 sau \u0111\u00f3 b\u1ecf \u1ea9n ch\u00fang. Nh\u01b0ng \u0111\u00f4i khi, b\u1ea1n c\u1ea7n \u1ea9n m\u1ed9t s\u1ed1 c\u1ed9t ch\u1ee9a d\u1eef li\u1ec7u quan tr\u1ecdng m\u00e0 b\u1ea1n kh\u00f4ng mu\u1ed1n ng\u01b0\u1eddi kh\u00e1c \u0111\u1ecdc. L\u00e0m th\u1ebf n\u00e0o b\u1ea1n c\u00f3 th\u1ec3 b\u1ea3o v\u1ec7 c\u00e1c c\u1ed9t \u2013 Kh\u00f3a c\u00e1c \u00f4<\/strong><\/a>\u00a0\u0111\u1ec3 kh\u00f4ng b\u1ecb ng\u01b0\u1eddi kh\u00e1c nh\u00ecn th\u1ea5y trong Excel?
\nTrong Excel, c\u00e1c b\u01b0\u1edbc sau \u0111\u00e2y c\u00f3 th\u1ec3 gi\u00fap b\u1ea1n ng\u0103n kh\u00f4ng cho c\u00e1c c\u1ed9t \u1ea9n b\u1ecb nh\u00ecn th\u1ea5y, vui l\u00f2ng th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/p>\n

1. Ch\u1ecdn n\u00fat\u00a0Select All\u00a0. <\/strong>Nh\u01b0 h\u00ecnh:<\/p>\n

<\/p>\n

2. Nh\u1ea5p ph\u1ea3i, ch\u1ecdn\u00a0Format Cells, <\/strong>trong h\u1ed9p tho\u1ea1i\u00a0<\/strong>Format Cells, <\/strong>ch\u1ecdn tab Protection,\u00a0<\/strong>v\u00e0 kh\u00f4ng ch\u1ecdn t\u00f9y ch\u1ecdn Locked.<\/strong>\u00a0Nh\u1ea5p b\u00fat OK\u00a0\u00a0<\/strong>\u0111\u1ec3 \u0111\u00f3ng h\u1ed9p tho\u1ea1i. Nh\u01b0 h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n

<\/p>\n

3. Ch\u1ecdn c\u1ed9t b\u1ea1n mu\u1ed1n b\u1ea3o v\u1ec7, nh\u1ea5p ph\u1ea3i, ch\u1ecdn\u00a0Format Cells.<\/strong><\/p>\n

<\/p>\n

\n
\n
\n
\n<\/a>\n<\/div>\n<\/div>\n
\n
\n
\n
\n<\/a>\n<\/div>\n<\/div>\n

4. Trong\u00a0h\u1ed9p tho\u1ea1i\u00a0<\/strong>Format Cells, <\/strong>ch\u1ecdn tab Protection,\u00a0<\/strong>v\u00e0 ch\u1ecdn t\u00f9y ch\u1ecdn Locked.<\/strong>\u00a0Nh\u1ea5p b\u00fat OK\u00a0\u00a0<\/strong>\u0111\u1ec3 \u0111\u00f3ng h\u1ed9p tho\u1ea1i. Nh\u01b0 h\u00ecnh sau:<\/p>\n

<\/p>\n

5. Trong b\u01b0\u1edbc n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 \u1ea9n c\u1ed9t \u0111\u01b0\u1ee3c ch\u1ecdn, b\u1eb1ng c\u00e1ch v\u00e0o\u00a0Review<\/strong> > Protect Sheet<\/strong>.<\/p>\n

<\/p>\n

6. Trong h\u1ed9p tho\u1ea1i\u00a0Protect Sheet\u00a0<\/strong>nh\u1eadp password v\u00e0 x\u00e1c nh\u1eadn n\u00f3. Nh\u01b0 h\u00ecnh sau:<\/p>\n

<\/p>\n

V\u00e0 khi b\u1ea1n b\u1ecf \u1ea9n c\u00e1c c\u1ed9t n\u00e0y b\u1eb1ng ch\u1ee9c n\u0103ng Unhide<\/strong>, d\u00f2ng Unhide s\u1ebd th\u00e0nh m\u00e0u x\u00e1m n\u00ean kh\u00f4ng th\u1ec3 b\u1ecf \u1ea9n, nh\u01b0 h\u00ecnh sau:<\/p>\n

<\/p>\n

Ch\u00fa \u00fd:<\/strong> V\u00ec b\u1ea1n \u0111\u00e3 b\u1ecf tr\u1ea1ng th\u00e1i kh\u00f3a cho t\u1ea5t c\u1ea3 c\u00e1c \u00f4, b\u1ea1n c\u00f3 th\u1ec3 th\u00eam d\u1eef li\u1ec7u v\u00e0o trang t\u00ednh nh\u01b0 b\u00ecnh th\u01b0\u1eddng.<\/p>\n

\u0110\u1ec3 c\u00f3 th\u1ec3 \u1ee9ng d\u1ee5ng t\u1ed1t Excel v\u00e0o trong c\u00f4ng vi\u1ec7c, ch\u00fang ta kh\u00f4ng ch\u1ec9 n\u1eafm v\u1eefng \u0111\u01b0\u1ee3c c\u00e1c h\u00e0m m\u00e0 c\u00f2n ph\u1ea3i s\u1eed d\u1ee5ng t\u1ed1t c\u1ea3 c\u00e1c c\u00f4ng c\u1ee5 c\u1ee7a Excel. Nh\u1eefng h\u00e0m n\u00e2ng cao gi\u00fap \u00e1p d\u1ee5ng t\u1ed1t v\u00e0o c\u00f4ng vi\u1ec7c nh\u01b0 SUMIFS, COUNTIFS, SUMPRODUCT, INDEX + MATCH\u2026 Nh\u1eefng c\u00f4ng c\u1ee5 th\u01b0\u1eddng s\u1eed d\u1ee5ng l\u00e0 Data validation, Conditional formatting, Pivot table\u2026<\/p>\n

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<\/p>\n<\/div>\n

\n

Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n

T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0\ud83d\udcd6<\/span><\/a><\/p>\n

H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n

HKD H\u1ecdc Excel Online
S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n

\n

\u00a9 document.currentScript.insertAdjacentHTML(‘afterend’, ” + new Intl.DateTimeFormat(document.documentElement.lang, {year: ‘numeric’}).format() + ”); H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

\n
\n
\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":6357,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-6356","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-nang-cao"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/6356","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=6356"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/6356\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/6357"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=6356"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=6356"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=6356"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}