{"id":8054,"date":"2024-12-21T19:45:14","date_gmt":"2024-12-21T19:45:14","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cach-an-cong-thuc-trong-excel\/"},"modified":"2024-12-21T19:45:14","modified_gmt":"2024-12-21T19:45:14","slug":"cach-an-cong-thuc-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cach-an-cong-thuc-trong-excel\/","title":{"rendered":"C\u00e1ch \u1ea9n c\u00f4ng th\u1ee9c trong Excel"},"content":{"rendered":"
\n

Trong Excel, s\u1ebd c\u00f3 m\u1ed9t l\u00fac n\u00e0o \u0111\u00f3 b\u1ea1n c\u1ea7n ph\u1ea3i gi\u1ea5u \u0111i m\u1ed9t c\u00f4ng th\u1ee9c, m\u1ed9t b\u1ee9c \u1ea3nh hay m\u1ed9t b\u00ecnh lu\u1eadn n\u00e0o \u0111\u00f3 m\u00e0 kh\u00f4ng mu\u1ed1n ng\u01b0\u1eddi kh\u00e1c bi\u1ebft. V\u00ec t\u00ednh b\u1ea3o m\u1eadt hay v\u00ec m\u1ed9t m\u1ee5c \u0111\u00edch g\u00ec \u0111\u00f3. Hi v\u1ecdng, b\u00e0i chia s\u1ebb n\u00e0y c\u1ee7a m\u00ecnh s\u1ebd gi\u00fap c\u00e1c b\u1ea1n \u1ea9n c\u00f4ng th\u1ee9c trong Excel m\u1ed9t c\u00e1ch \u0111\u01a1n gi\u1ea3n.<\/strong><\/em><\/p>\n

B\u01b0\u1edbc 1:<\/strong> Ch\u1ecdn m\u1ed9t \u00f4 ho\u1eb7c nh\u1eefng \u00f4 c\u1ea7n \u1ea9n c\u00f4ng th\u1ee9c.<\/p>\n

Ch\u1eb3ng h\u1ea1n, b\u1ea1n mu\u1ed1n \u1ea9n \u00f4 G3<\/strong> trong b\u1ea3ng Excel d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n

<\/p>\n

B\u01b0\u1edbc 2:<\/strong> V\u00e0o Format Cells <\/strong>b\u1eb1ng c\u00e1ch nh\u1ea5n t\u1ed5 h\u1ee3p ph\u00edm Ctrl + 1<\/strong> ho\u1eb7c nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0 ch\u1ecdn Format Cells.<\/strong><\/p>\n

<\/p>\n

B\u01b0\u1edbc 3:<\/strong> V\u00e0o m\u1ee5c \u00a0Protection<\/strong>,\u00a0\u0111\u00e1nh d\u1ea5u t\u00edch v\u00e0o check box Hidden\u00a0<\/strong>n\u1ebfu n\u00f3 ch\u01b0a \u0111\u01b0\u1ee3c t\u00edch.<\/p>\n

<\/p>\n

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

B\u01b0\u1edbc 4:<\/strong> V\u00e0o Review\u00a0<\/strong>-> ch\u1ecdn\u00a0Protect Sheet.\u00a0<\/strong>Khi \u0111\u00f3, h\u1ed9p tho\u1ea1i Protect Sheet\u00a0<\/strong>hi\u1ec7n ra, b\u1ea1n \u00a0ch\u1ec9 c\u1ea7n nh\u1eadp m\u1eadt kh\u1ea9u b\u1ea3o v\u1ec7 v\u00e0o \u00f4 \u00a0Password to unprotect sheet<\/strong>. Sau \u0111\u00f3 nh\u1ea5n OK\u00a0<\/strong>v\u00e0 nh\u1eadp l\u1ea1i m\u1eadt kh\u1ea9u \u0111\u00f3 v\u00e0o m\u1ee5c\u00a0Reenter password to proceed. <\/strong>Xong nh\u1ea5p \u00a0OK.<\/strong><\/p>\n

<\/p>\n

<\/p>\n

Xong xu\u00f4i, b\u1ea1n ch\u1ecdn l\u1ea1i \u00f4 G3<\/strong> \u0111\u1ec3 xem c\u00f4ng th\u1ee9c th\u00ec ho\u00e0n to\u00e0n kh\u00f4ng th\u1ea5y g\u00ec. Th\u1ebf l\u00e0 \u0111\u00e3 th\u00e0nh c\u00f4ng r\u1ed3i.<\/p>\n

<\/p>\n

Xem th\u00eam: C\u00e1ch hi\u1ec3n th\u1ecb c\u00f4ng th\u1ee9c trong b\u1ea3ng t\u00ednh Excel<\/a><\/strong><\/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":8055,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-8054","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\/8054","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=8054"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/8054\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/8055"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=8054"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=8054"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=8054"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}