{"id":2927,"date":"2024-12-02T09:41:58","date_gmt":"2024-12-02T09:41:58","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/cach-an-va-khoa-cong-thuc-trong-excel-2010-2013-2016\/"},"modified":"2024-12-02T09:41:58","modified_gmt":"2024-12-02T09:41:58","slug":"cach-an-va-khoa-cong-thuc-trong-excel-2010-2013-2016","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/cach-an-va-khoa-cong-thuc-trong-excel-2010-2013-2016\/","title":{"rendered":"C\u00e1ch \u1ea9n v\u00e0 kh\u00f3a c\u00f4ng th\u1ee9c trong Excel 2010, 2013, 2016"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\">Trong b\u00e0i vi\u1ebft n\u00e0y, <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong><\/a> s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n <strong>c\u00e1ch \u1ea9n c\u00f4ng th\u1ee9c<\/strong> \u0111\u1ec3 ch\u00fang kh\u00f4ng hi\u1ec7n tr\u00ean thanh c\u00f4ng th\u1ee9c, \u0111\u1ed3ng th\u1eddi <strong>c\u00e1ch kh\u00f3a c\u00f4ng th\u1ee9c excel<\/strong> \u0111\u01b0\u1ee3c ch\u1ecdn ho\u1eb7c t\u1ea5t c\u1ea3 c\u00f4ng th\u1ee9c trong trang t\u00ednh \u0111\u1ec3 ch\u00fang kh\u00f4ng b\u1ecb x\u00f3a ho\u1eb7c thay \u0111\u1ed5i b\u1edfi ng\u01b0\u1eddi d\u00f9ng kh\u00e1c.<\/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-674d80e55dfc4\" 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-an-va-khoa-cong-thuc-trong-excel-2010-2013-2016.html#Cach_khoa_cong_thuc_trong_Excel\" title=\"C\u00e1ch kh\u00f3a c\u00f4ng th\u1ee9c trong Excel:\">C\u00e1ch kh\u00f3a c\u00f4ng th\u1ee9c trong 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-an-va-khoa-cong-thuc-trong-excel-2010-2013-2016.html#Cach_an_cong_thuc_trong_Excel\" title=\"C\u00e1ch \u1ea9n c\u00f4ng th\u1ee9c trong Excel:\">C\u00e1ch \u1ea9n c\u00f4ng th\u1ee9c trong Excel:<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_khoa_cong_thuc_trong_Excel\"><\/span><strong>C\u00e1ch kh\u00f3a c\u00f4ng th\u1ee9c trong Excel:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>L\u01b0u \u00fd r\u1eb1ng \u0111\u00e2y l\u00e0 <strong>c\u00e1ch kh\u00f3a c\u00f4ng th\u1ee9c Excel 2010<\/strong> n\u00e0y c\u0169ng c\u00f3 th\u1ec3 \u1ee9ng d\u1ee5ng \u0111\u1ec3 kh\u00f3a c\u00f4ng th\u1ee9c excel 2013,2016. C\u00e1c b\u01b0\u1edbc sau \u0111\u00e2y s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1ch kh\u00f3a m\u1ed9t c\u00f4ng th\u1ee9c \u0111\u01b0\u1ee3c ch\u1ecdn ho\u1eb7c t\u1ea5t c\u1ea3 c\u00e1c \u00f4 t\u00ednh ch\u1ee9a c\u00f4ng th\u1ee9c trong m\u1ed9t b\u1ea3ng t\u00ednh trong khi c\u00e1c \u00f4 kh\u00e1c kh\u00f4ng b\u1ecb kh\u00f3a.<\/p>\n<ol style=\"text-align: justify\">\n<li><strong> M\u1edf kh\u00f3a t\u1ea5t c\u1ea3 \u00f4 trong trang t\u00ednh<\/strong><\/li>\n<\/ol>\n<p style=\"text-align: justify\">Theo m\u1eb7c \u0111\u1ecbnh, t\u00f9y ch\u1ecdn <strong><em>Locked <\/em><\/strong>\u0111\u01b0\u1ee3c thi\u1ebft l\u1eadp cho t\u1ea5t c\u1ea3 \u00f4 t\u00ednh trong trang t\u00ednh Excel, b\u1ea5t k\u1ec3 \u0111\u00f3 trang t\u00ednh m\u1edbi hay trang t\u00ednh \u0111\u00e3 sao l\u01b0u. \u0110i\u1ec1u n\u00e0y kh\u00f4ng c\u00f3 ngh\u0129a l\u00e0 b\u1ea1n kh\u00f4ng th\u1ec3 ch\u1ec9nh s\u1eeda c\u00e1c \u00f4 \u0111\u00f3, v\u00ec c\u00e1c \u00f4 t\u00ednh b\u1ecb kh\u00f3a l\u00e0 \u0111\u1ec3 b\u1ea3o v\u1ec7 trang t\u00ednh.<\/p>\n<p>Xem th\u00eam: <a href=\"http:\/\/blog.ezworkapp.com\/cach-khoa-va-mo-cac-o-trong-excel.html\"><strong>C\u00e1ch kh\u00f3a \u00f4 trong Excel<\/strong><\/a><\/p>\n<p style=\"text-align: justify\">V\u1eady, n\u1ebfu b\u1ea1n mu\u1ed1n kh\u00f3a ch\u1ec9 nh\u1eefng \u00f4 ch\u1ee9a c\u00f4ng th\u1ee9c, h\u00e3y th\u1ef1c hi\u1ec7n b\u01b0\u1edbc n\u00e0y v\u00e0 m\u1edf kh\u00f3a t\u1ea5t c\u1ea3 c\u00e1c \u00f4 t\u00ednh trong trang t\u00ednh tr\u01b0\u1edbc \u0111\u00e3.<\/p>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n mu\u1ed1n kh\u00f3a t\u1ea5t c\u1ea3 c\u00e1c \u00f4 t\u00ednh trong trang t\u00ednh (b\u1ea5t k\u1ec3 ch\u00fang ch\u1ee9a c\u00f4ng th\u1ee9c, gi\u00e1 tr\u1ecb hay \u00f4 tr\u1ed1ng), b\u1ecf qua 3 b\u01b0\u1edbc \u0111\u1ea7u ti\u00ean v\u00e0 b\u1eaft \u0111\u1ea7u t\u1eeb b\u01b0\u1edbc 4.<\/p>\n<ul style=\"text-align: justify\">\n<li>Ch\u1ecdn to\u00e0n b\u1ed9 trang t\u00ednh b\u1eb1ng c\u00e1ch nh\u1ea5n <strong><em>Ctrl + A<\/em><\/strong>, ho\u1eb7c nh\u1ea5n v\u00e0o n\u00fat <strong><em>Select All <\/em><\/strong>(tam gi\u00e1c m\u00e0u x\u00e1m \u1edf g\u00f3c tr\u00ean b\u00ean tr\u00e1i c\u1ee7a trang t\u00ednh, b\u00ean tr\u00e1i ch\u1eef A)<\/li>\n<li>M\u1edf h\u1ed9p tho\u1ea1i <strong><em>Format Cells <\/em><\/strong>b\u1eb1ng c\u00e1ch nh\u1ea5n <strong><em>Ctrl + 1 <\/em><\/strong>ho\u1eb7c nh\u1ea5p ph\u1ea3i v\u00e0o b\u1ea5t k\u1ef3 \u00f4 \u0111\u01b0\u1ee3c ch\u1ecdn n\u00e0o v\u00e0 ch\u1ecdn <strong><em>Format Cells<\/em><\/strong> t\u1eeb danh s\u00e1ch t\u00f9y ch\u1ecdn.<\/li>\n<li>Trong h\u1ed9p tho\u1ea1i <strong><em>Format Cells<\/em><\/strong>, \u0111\u1ebfn th\u1ebb <strong><em>Protection<\/em><\/strong>, b\u1ecf \u0111\u00e1nh d\u1ea5u t\u00f9y ch\u1ecdn <strong><em>Locked <\/em><\/strong>v\u00e0 nh\u1ea5n OK. Thao t\u00e1c n\u00e0y s\u1ebd m\u1edf kh\u00f3a t\u1ea5t c\u1ea3 c\u00e1c \u00f4 t\u00ednh trong trang t\u00ednh.<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-unlock-cells.png\" alt=\"Unlock all cells in the worksheet.\" title=\"excel-unlock-cells\"><\/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-93.gif\" title=\"vba101_92019-nho-93\"><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-223.gif\" title=\"ex101_92019-nho-223\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<blockquote>\n<p style=\"text-align: justify\">Xem th\u00eam:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\">ho\u0323c Word Excel c\u00e2\u0301p t\u00f4\u0301c<\/a> v\u1edbi c\u00e1c chuy\u00ean gia<\/p>\n<\/blockquote>\n<ol style=\"text-align: justify\" start=\"2\">\n<li><strong> Ch\u1ecdn c\u00f4ng th\u1ee9c b\u1ea1n mu\u1ed1n kh\u00f3a<\/strong><\/li>\n<\/ol>\n<p style=\"text-align: justify\">Ch\u1ecdn \u00f4 t\u00ednh ch\u1ee9a c\u00f4ng th\u1ee9c b\u1ea1n mu\u1ed1n kh\u00f3a<\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 ch\u1ecdn c\u00e1c \u00f4 ho\u1eb7c v\u00f9ng d\u1eef li\u1ec7u kh\u00f4ng li\u1ec1n k\u1ec1, ch\u1ecdn \u00f4 t\u00ednh\/v\u00f9ng d\u1eef li\u1ec7u \u0111\u1ea7u ti\u00ean, nh\u1ea5n gi\u1eef <strong><em>Ctrl<\/em><\/strong>, ch\u1ecdn nh\u1eefng \u00f4 t\u00ednh\/v\u00f9ng d\u1eef li\u1ec7u kh\u00e1c.<\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 ch\u1ecdn t\u1ea5t c\u1ea3 c\u00e1c \u00f4 ch\u1ee9a c\u00f4ng th\u1ee9c c\u00f3 trong b\u1ea3ng t\u00ednh, th\u1ef1c hi\u1ec7n c\u00e1c b\u01b0\u1edbc sau:<\/p>\n<p style=\"text-align: justify\">Di chuy\u1ec3n \u0111\u1ebfn th\u1ebb <strong><em>Home &gt; Find &amp; Select <\/em><\/strong>(trong nh\u00f3m <strong><em>Editing<\/em><\/strong>), ch\u1ecdn <strong><em>Go To Special<\/em><\/strong>.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-go-to-special-1.png\" alt=\"Click 'Go to Special' option.\" title=\"excel-go-to-special-1\"><\/p>\n<p style=\"text-align: justify\">Trong h\u1ed9p tho\u1ea1i <strong><em>Go To Special<\/em><\/strong>, \u0111\u00e1nh d\u1ea5u ch\u1ecdn <strong><em>Formulas<\/em><\/strong> (b\u01b0\u1edbc n\u00e0y s\u1ebd ch\u1ecdn t\u1ea5t c\u1ea3 c\u00e1c ki\u1ec3u c\u00f4ng th\u1ee9c) v\u00e0 nh\u1ea5n OK.<\/p>\n<p style=\"text-align: justify\"><strong><em>\u00a0<img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/select-all-formulas-excel.png\" alt=\"Select all cells with formulas on the sheet.\" title=\"select-all-formulas-excel\"><\/em><\/strong><\/p>\n<ol style=\"text-align: justify\" start=\"3\">\n<li><strong> Kh\u00f3a c\u00e1c \u00f4 t\u00ednh ch\u1ee9a c\u00f4ng th\u1ee9c<\/strong><\/li>\n<\/ol>\n<p style=\"text-align: justify\">\u0110\u1ec3 kh\u00f3a c\u00e1c \u00f4 t\u00ednh \u0111\u01b0\u1ee3c ch\u1ecdn c\u00f3 ch\u1ee9a c\u00f4ng th\u1ee9c, nh\u1ea5n <strong><em>Ctrl + 1 <\/em><\/strong>\u0111\u1ec3 m\u1edf h\u1ed9p tho\u1ea1i <strong><em>Format Cells<\/em><\/strong>, m\u1edf th\u1ebb <strong><em>Protection<\/em><\/strong>, \u0111\u00e1nh d\u1ea5u ch\u1ecdn <strong><em>Locked<\/em><\/strong>.<\/p>\n<p style=\"text-align: justify\">T\u00f9y ch\u1ecdn <strong><em>Locked <\/em><\/strong>s\u1ebd ng\u0103n ng\u01b0\u1eddi d\u00f9ng kh\u00e1c vi\u1ebft \u0111\u00e8 l\u00ean, x\u00f3a hay thay \u0111\u1ed5i n\u1ed9i dung \u00f4 t\u00ednh.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/lock-formulas-excel.png\" alt=\"Lock the selected cells with formulas.\" title=\"lock-formulas-excel\"><\/p>\n<ol style=\"text-align: justify\" start=\"4\">\n<li><strong> B\u1ea3o v\u1ec7 trang t\u00ednh<\/strong><\/li>\n<\/ol>\n<p style=\"text-align: justify\">\u0110\u1ec3 kh\u00f3a c\u00f4ng th\u1ee9c trong Excel, \u0111\u00e1nh d\u1ea5u ch\u1ecdn <strong><em>Locked <\/em><\/strong>kh\u00f4ng \u0111\u1ee7 b\u1edfi v\u00ec <strong><em>Locked <\/em><\/strong>ch\u1ec9 c\u00f3 t\u00e1c d\u1ee5ng khi trang t\u00ednh \u0111\u01b0\u1ee3c b\u1ea3o v\u1ec7. \u0110\u1ec3 b\u1ea3o v\u1ec7 trang t\u00ednh, th\u1ef1c hi\u1ec7n c\u00e1c b\u01b0\u1edbc sau:<\/p>\n<p style=\"text-align: justify\">\u0110\u1ebfn th\u1ebb <strong><em>Review &gt; Changes<\/em><\/strong>, nh\u1ea5n <strong><em>Protect Sheet<\/em><\/strong>.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/protect-sheet-excel.png\" alt=\"Protecting the worksheet in Excel\" title=\"protect-sheet-excel\"><\/p>\n<p style=\"text-align: justify\">H\u1ed9p tho\u1ea1i <strong><em>Protect Sheet<\/em><\/strong> xu\u1ea5t hi\u1ec7n, g\u00f5 m\u1eadt kh\u1ea9u v\u00e0o \u00f4 <strong><em>Password to unprotect sheet:<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">M\u1eadt kh\u1ea9u n\u00e0y nh\u1eb1m b\u1ea3o v\u1ec7 trang t\u00ednh. Kh\u00f4ng ai, k\u1ec3 c\u1ea3 b\u1ea1n c\u00f3 th\u1ec3 ch\u1ec9nh s\u1eeda n\u1ebfu kh\u00f4ng g\u00f5 m\u1eadt kh\u1ea9u, v\u1eady n\u00ean h\u00e3y \u0111\u1ea3m b\u1ea3o b\u1ea1n nh\u1edb n\u00f3.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/blog.hocexcel.online\/wp-content\/uploads\/img-blog\/protect-formulas-excel.png\" alt=\"Protecting formulas in Excel\"><\/p>\n<p style=\"text-align: justify\">Ngo\u00e0i ra, b\u1ea1n c\u1ea7n ph\u1ea3i ch\u1ecdn c\u00e1c h\u00e0nh \u0111\u1ed9ng \u0111\u01b0\u1ee3c ph\u00e9p trong b\u1ea3ng t\u00ednh c\u1ee7a m\u00ecnh. Trong h\u00ecnh ch\u1ee5p tr\u00ean, hai ti\u00eau ch\u00ed \u0111\u01b0\u1ee3c \u0111\u00e1nh d\u1ea5u theo m\u1eb7c \u0111\u1ecbnh l\u00e0 <em>Select locked cells<\/em> v\u00e0 <em>Select unlocked cells<\/em>. N\u1ebfu b\u1ea1n nh\u1ea5n OK, ng\u01b0\u1eddi d\u00f9ng ch\u1ec9 c\u00f3 th\u1ec3 ch\u1ecdn \u00f4 t\u00ednh (k\u1ec3 c\u1ea3 \u00f4 kh\u00f3a v\u00e0 kh\u00f4ng kh\u00f3a) trong b\u1ea3ng t\u00ednh.<\/p>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n mu\u1ed1n cho ph\u00e9p m\u1ed9t s\u1ed1 h\u00e0nh \u0111\u1ed9ng kh\u00e1c, v\u00ed d\u1ee5: s\u1eafp x\u1ebfp, t\u1ef1 \u0111\u1ed9ng l\u1ecdc, \u0111\u1ecbnh d\u1ea1ng \u00f4, x\u00f3a ho\u1eb7c ch\u00e8n c\u00e1c h\u00e0ng v\u00e0 c\u1ed9t, \u0111\u00e1nh d\u1ea5u t\u00f9y ch\u1ecdn t\u01b0\u01a1ng \u1ee9ng trong danh s\u00e1ch.<\/p>\n<ul style=\"text-align: justify\">\n<li>Khi b\u1ea1n ch\u1ecdn xong c\u00e1c thao t\u00e1c tr\u00ean trang t\u00ednh b\u1ea1n mu\u1ed1n cho ph\u00e9p, h\u00e3y nh\u1ea5n OK.<\/li>\n<li>H\u1ed9p tho\u1ea1i X\u00e1c nh\u1eadn m\u1eadt kh\u1ea9u s\u1ebd xu\u1ea5t hi\u1ec7n v\u00e0 y\u00eau c\u1ea7u b\u1ea1n nh\u1eadp l\u1ea1i m\u1eadt kh\u1ea9u nh\u1eb1m tr\u00e1nh vi\u1ec7c b\u1ea3ng t\u00ednh Excel b\u1ecb kh\u00f3a v\u0129nh vi\u1ec5n do l\u1ed7i nh\u1eadp sai. Nh\u1eadp l\u1ea1i m\u1eadt kh\u1ea9u v\u00e0 nh\u1ea5p v\u00e0o OK.<\/li>\n<\/ul>\n<p style=\"text-align: justify\">Xong! C\u00e1c c\u00f4ng th\u1ee9c Excel c\u1ee7a b\u1ea1n hi\u1ec7n \u0111\u00e3 b\u1ecb kh\u00f3a v\u00e0 \u0111\u01b0\u1ee3c b\u1ea3o v\u1ec7 m\u1eb7c d\u00f9 ch\u00fang v\u1eabn hi\u1ec3n th\u1ecb trong thanh c\u00f4ng th\u1ee9c. N\u1ebfu b\u1ea1n mu\u1ed1n \u1ea9n c\u00f4ng th\u1ee9c, h\u00e3y \u0111\u1ecdc ph\u1ea7n ti\u1ebfp theo.<\/p>\n<p style=\"text-align: justify\"><strong>Ch\u00fa \u00fd. <\/strong>N\u1ebfu b\u1ea1n c\u1ea7n ch\u1ec9nh s\u1eeda ho\u1eb7c c\u1eadp nh\u1eadt c\u00f4ng th\u1ee9c c\u1ee7a m\u00ecnh v\u00e0 kh\u00f4ng mu\u1ed1n l\u00e3ng ph\u00ed th\u1eddi gian \u0111\u1ec3 b\u1eadt\/t\u1eaft ch\u1ebf \u0111\u1ed9 b\u1ea3o v\u1ec7 trang t\u00ednh, b\u1ea1n c\u00f3 th\u1ec3 sao ch\u00e9p c\u00f4ng th\u1ee9c sang m\u1ed9t trang t\u00ednh ho\u1eb7c b\u1ea3ng t\u00ednh ri\u00eang bi\u1ec7t, \u1ea9n trang \u0111\u00f3 \u0111i v\u00e0 sau \u0111\u00f3 trong trang t\u00ednh ch\u00ednh, ch\u1ec9 c\u1ea7n tham kh\u1ea3o \u00f4 th\u00edch h\u1ee3p v\u1edbi c\u00f4ng th\u1ee9c trong trang t\u00ednh v\u1eeba \u1ea9n.<\/p>\n<blockquote>\n<p style=\"text-align: justify\">T\u1ed5ng h\u1ee3p\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/thu-thuat-excel\">th\u1ee7 thu\u1eadt Excel hay<\/a><\/p>\n<\/blockquote>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_an_cong_thuc_trong_Excel\"><\/span><strong>C\u00e1ch \u1ea9n c\u00f4ng th\u1ee9c trong Excel:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">\u1ea8n c\u00f4ng th\u1ee9c trong Excel c\u00f3 ngh\u0129a l\u00e0 ng\u0103n kh\u00f4ng cho c\u00f4ng th\u1ee9c hi\u1ec3n th\u1ecb trong thanh c\u00f4ng th\u1ee9c khi b\u1ea1n nh\u1ea5p v\u00e0o m\u1ed9t \u00f4 ch\u1ee9a k\u1ebft qu\u1ea3 c\u1ee7a c\u00f4ng th\u1ee9c \u0111\u00f3. \u0110\u1ec3 \u1ea9n c\u00f4ng th\u1ee9c Excel, th\u1ef1c hi\u1ec7n c\u00e1c b\u01b0\u1edbc sau.<\/p>\n<ol style=\"text-align: justify\">\n<li>Ch\u1ecdn \u00f4 ho\u1eb7c v\u00f9ng d\u1eef li\u1ec7u ch\u1ee9a c\u00f4ng th\u1ee9c b\u1ea1n mu\u1ed1n \u1ea9n.<\/li>\n<\/ol>\n<p style=\"text-align: justify\">B\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn c\u00e1c \u00f4 ho\u1eb7c v\u00f9ng d\u1eef li\u1ec7u kh\u00f4ng li\u1ec1n k\u1ec1 b\u1eb1ng c\u00e1ch gi\u1eef ph\u00edm <strong><em>Ctrl<\/em><\/strong>, ho\u1eb7c ch\u1ecdn to\u00e0n b\u1ed9 trang t\u00ednh b\u1eb1ng c\u00e1ch nh\u1ea5n <strong><em>Ctrl + A<\/em><\/strong>.<\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 ch\u1ecdn t\u1ea5t c\u1ea3 c\u00e1c \u00f4 ch\u1ee9a c\u00f4ng th\u1ee9c, s\u1eed d\u1ee5ng <strong><em>Go To Special &gt; Formula<\/em><\/strong>.<\/p>\n<ol style=\"text-align: justify\" start=\"2\">\n<li>M\u1edf h\u1ed9p tho\u1ea1i <strong><em>Format Cells <\/em><\/strong>b\u1eb1ng c\u00e1ch th\u1ef1c hi\u1ec7n b\u1ea5t k\u1ef3 thao t\u00e1c n\u00e0o sau \u0111\u00e2y:<\/li>\n<\/ol>\n<ul style=\"text-align: justify\">\n<li>Nh\u1ea5n <strong><em>Ctrl + 1<\/em><\/strong>.<\/li>\n<li>Nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o \u00f4 \u0111\u00e3 ch\u1ecdn v\u00e0 ch\u1ecdn <strong><em>Format Cells <\/em><\/strong>t\u1eeb danh s\u00e1ch t\u00f9y ch\u1ecdn.<\/li>\n<li>Di chuy\u1ec3n \u0111\u1ebfn th\u1ebb <strong><em>Home &gt; <\/em><\/strong>Cells, nh\u1ea5p ch\u1ecdn <strong><em>Format &gt; Format <\/em><\/strong><\/li>\n<\/ul>\n<ol style=\"text-align: justify\" start=\"3\">\n<li>Trong h\u1ed9p tho\u1ea1i <strong><em>Format Cells<\/em><\/strong>, chuy\u1ec3n sang th\u1ebb <strong><em>Protection<\/em><\/strong>, \u0111\u00e1nh d\u1ea5u ch\u1ecdn <strong><em>Hidden<\/em><\/strong>. \u0110\u00f3 l\u00e0 t\u00f9y ch\u1ecdn \u0111\u1ec3 ng\u0103n c\u00f4ng th\u1ee9c Excel hi\u1ec3n th\u1ecb trong thanh c\u00f4ng th\u1ee9c.<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><strong><em>Locked<\/em><\/strong>, ng\u0103n kh\u00f4ng cho n\u1ed9i dung c\u1ee7a c\u00e1c \u00f4 b\u1ecb ch\u1ec9nh s\u1eeda, \u0111\u01b0\u1ee3c \u0111\u00e1nh d\u1ea5u theo m\u1eb7c \u0111\u1ecbnh, v\u00e0 th\u01b0\u1eddng b\u1ea1n s\u1ebd mu\u1ed1n gi\u1eef nguy\u00ean \u0111\u00e1nh d\u1ea5u n\u00e0y.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/hide-formulas-excel.png\" alt=\"Hiding formulas in Excel\" title=\"hide-formulas-excel\"><\/p>\n<ol style=\"text-align: justify\" start=\"4\">\n<li>Nh\u1ea5n OK.<\/li>\n<li>Ti\u1ebfn h\u00e0nh b\u1ea3o v\u1ec7 trang t\u00ednh nh\u01b0 \u0111\u00e3 h\u01b0\u1edbng d\u1eabn \u1edf ph\u1ea7n tr\u01b0\u1edbc.<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><strong>Ch\u00fa th\u00edch.<\/strong> H\u00e3y nh\u1edb r\u1eb1ng vi\u1ec7c kh\u00f3a \u00f4 v\u00e0 \u1ea9n c\u00f4ng th\u1ee9c ch\u1ec9 c\u00f3 hi\u1ec7u l\u1ef1c khi trang t\u00ednh \u0111\u00e3 \u0111\u01b0\u1ee3c b\u1ea3o v\u1ec7 (m\u1ed9t d\u00f2ng ch\u00fa \u00fd ng\u1eafn n\u1eb1m ngay b\u00ean d\u01b0\u1edbi t\u00f9y ch\u1ecdn <strong><em>Locked <\/em><\/strong>v\u00e0 <strong><em>Hidden <\/em><\/strong>trong h\u1ed9p tho\u1ea1i <strong><em>Format Cells<\/em><\/strong>. \u0110\u1ec3 \u0111\u1ea3m b\u1ea3o \u0111i\u1ec1u n\u00e0y, ch\u1ecdn \u00f4 t\u00ednh b\u1ea5t k\u1ef3 c\u00f3 ch\u1ee9a c\u00f4ng th\u1ee9c v\u00e0 nh\u00ecn v\u00e0o \u00f4 c\u00f4ng th\u1ee9c. \u0110\u1ec3 c\u00e1c c\u00f4ng th\u1ee9c th\u1eadt s\u1ef1 \u0111\u01b0\u1ee3c \u1ea9n \u0111i, h\u00e3y ch\u1eafc ch\u1eafn r\u1eb1ng trang t\u00ednh \u0111\u00e3 \u0111\u01b0\u1ee3c b\u1ea3o v\u1ec7.<\/p>\n<p style=\"text-align: justify\"><strong>C\u00e1ch h\u1ee7y b\u1ea3o v\u1ec7 v\u00e0 hi\u1ec7n c\u00f4ng th\u1ee9c trong Excel<\/strong><\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 hi\u1ec7n c\u00e1c c\u00f4ng th\u1ee9c tr\u00ean thanh c\u00f4ng th\u1ee9c l\u1ea7n n\u1eefa, th\u1ef1c hi\u1ec7n m\u1ed9t trong c\u00e1c c\u00e1ch sau:<\/p>\n<ul style=\"text-align: justify\">\n<li>Tr\u00ean th\u1ebb <strong><em>Home<\/em><\/strong>, trong nh\u00f3m <strong><em>Cells<\/em><\/strong>, nh\u1ea5n n\u00fat <strong><em>Format<\/em><\/strong>, ch\u1ecdn <strong><em>Unprotect Sheet<\/em><\/strong> t\u1eeb danh s\u00e1ch t\u00f9y ch\u1ecdn. Sau \u0111\u00f3 g\u00f5 m\u1eadt kh\u1ea9u \u0111\u1ec3 b\u1ea3o v\u1ec7 trang t\u00ednh, nh\u1ea5n OK.<\/li>\n<li>Ho\u1eb7c, di chuy\u1ec3n \u0111\u1ebfn th\u1ebb <strong><em>Review &gt; Changes<\/em><\/strong>, nh\u1ea5p v\u00e0o n\u00fat <strong><em>Unprotect Sheet<\/em><\/strong>.<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/unhide-formulas-excel.png\" alt=\"Unprotecting the worksheet in Excel\" title=\"unhide-formulas-excel\"><\/p>\n<p style=\"text-align: justify\"><strong>Ch\u00fa \u00fd<\/strong><em>. <\/em>N\u1ebfu b\u1ea1n \u1ea9n c\u00f4ng th\u1ee9c tr\u01b0\u1edbc khi b\u1ea3o v\u1ec7 trang t\u00ednh, b\u1ea1n c\u00f3 th\u1ec3 mu\u1ed1n b\u1ecf ch\u1ecdn <strong><em>Hidden <\/em><\/strong>sau khi g\u1ee1 b\u1ea3o v\u1ec7 n\u00f3. \u0110i\u1ec1u n\u00e0y s\u1ebd kh\u00f4ng c\u00f3 hi\u1ec7u qu\u1ea3 l\u1eadp t\u1ee9c n\u00e0o b\u1edfi v\u00ec c\u00e1c c\u00f4ng th\u1ee9c b\u1eaft \u0111\u1ea7u hi\u1ec3n th\u1ecb tr\u00ean thanh c\u00f4ng th\u1ee9c ngay khi b\u1ea1n g\u1ee1 b\u1ea3o v\u1ec7 trang t\u00ednh. Tuy nhi\u00ean, n\u1ebfu b\u1ea1n mu\u1ed1n b\u1ea3o v\u1ec7 trang t\u00ednh t\u01b0\u01a1ng t\u1ef1 sau n\u00e0y, nh\u01b0ng v\u1eabn \u0111\u1ec3 ng\u01b0\u1eddi d\u00f9ng th\u1ea5y \u0111\u01b0\u1ee3c c\u00f4ng th\u1ee9c, \u0111\u1ea3m b\u1ea3o r\u1eb1ng t\u00f9y ch\u1ecdn <strong><em>Hidden <\/em><\/strong>kh\u00f4ng \u0111\u01b0\u1ee3c \u0111\u00e1nh d\u1ea5u cho c\u00e1c \u00f4 t\u00ednh \u0111\u00f3 (ch\u1ecdn \u00f4 t\u00ednh ch\u1ee9a c\u00f4ng th\u1ee9c, nh\u1ea5n <strong><em>Ctrl + 1 <\/em><\/strong>\u0111\u1ec3 m\u1edf h\u1ed9p tho\u1ea1i <strong><em>Format Cells<\/em><\/strong>, \u0111\u1ebfn th\u1ebb <strong><em>Protection<\/em><\/strong> v\u00e0 b\u1ecf ch\u1ecdn <strong><em>Hidden<\/em><\/strong>).<\/p>\n<blockquote>\n<p style=\"text-align: justify\">\u0110\u1eebng b\u1ecf qua: t\u00e0i li\u1ec7u <a href=\"http:\/\/blog.ezworkapp.com\/tag\/excel-2010\">h\u1ecdc excel 2010 c\u01a1 b\u1ea3n<\/a><\/p>\n<\/blockquote>\n<p>\u0110\u00f3 l\u00e0 to\u00e0n b\u1ed9 c\u00e1ch kh\u00f3a c\u00f4ng th\u1ee9c excel 2010 2013 2016. \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 Khi k\u1ebft h\u1ee3p t\u1ed1t c\u00e1c h\u00e0m v\u00e0 c\u00e1c c\u00f4ng c\u1ee5 v\u1edbi nhau th\u00ec b\u1ea1n s\u1ebd th\u1ea5y hi\u1ec7u qu\u1ea3 c\u00f4ng vi\u1ec7c tr\u00ean Excel s\u1ebd \u0111\u01b0\u1ee3c c\u1ea3i thi\u1ec7n r\u1ea5t nhi\u1ec1u.<\/p>\n<p>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<p><strong>Xem th\u00eam: <a href=\"http:\/\/blog.ezworkapp.com\/cach-khoa-va-mo-cac-o-trong-excel.html\">C\u00e1ch kh\u00f3a \u00f4 trong excel<\/a>, \u0111\u01a1n gi\u1ea3n d\u1ec5 th\u1ef1c hi\u1ec7n<\/strong><\/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-93.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":2928,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-2927","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\/2927","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=2927"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/2927\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/2928"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=2927"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=2927"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=2927"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}