{"id":6464,"date":"2024-12-21T15:23:43","date_gmt":"2024-12-21T15:23:43","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cach-khoa-va-mo-cac-o-trong-excel\/"},"modified":"2024-12-21T15:23:43","modified_gmt":"2024-12-21T15:23:43","slug":"cach-khoa-va-mo-cac-o-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cach-khoa-va-mo-cac-o-trong-excel\/","title":{"rendered":"C\u00e1ch kh\u00f3a v\u00e0 m\u1edf c\u00e1c \u00f4 trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<blockquote id=\"kh\u00f3a-\u00f4-trong-excel\" cite=\"https:\/\/blog.hocexcel.online\/cach-khoa-va-mo-cac-o-trong-excel.html?khoa-o-trong-excel\">\n<p><span style=\"font-family: 'Times New Roman', Times\">Trong b\u00e0i h\u01b0\u1edbng d\u1eabn n\u00e0y, <strong><a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\" target=\"_blank\" rel=\"noopener noreferrer\">H\u1ecdc Excel Online<\/a><\/strong> s\u1ebd gi\u1ea3i th\u00edch c\u00e1ch kh\u00f3a m\u1ed9t \u00f4 ho\u1eb7c m\u1ed9t s\u1ed1 \u00f4 trong Excel \u0111\u1ec3 b\u1ea3o v\u1ec7 ch\u00fang kh\u1ecfi b\u1ecb x\u00f3a, ghi \u0111\u00e8 ho\u1eb7c ch\u1ec9nh s\u1eeda. \u0110\u1ed3ng th\u1eddi, h\u01b0\u1edbng d\u1eabn c\u00e1ch m\u1edf kh\u00f3a c\u00e1c \u00f4 \u0111\u00f3 s\u1eed d\u1ee5ng m\u1eadt kh\u1ea9u ho\u1eb7c cho ph\u00e9p ng\u01b0\u1eddi d\u00f9ng c\u1ee5 th\u1ec3 c\u00f3 quy\u1ec1n ch\u1ec9nh s\u1eeda \u00f4 \u0111\u00f3 d\u00f9 kh\u00f4ng c\u00f3 m\u1eadt kh\u1ea9u. Cu\u1ed1i c\u00f9ng, b\u00e0i vi\u1ebft s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1ch ph\u00e1t hi\u1ec7n v\u00e0 l\u00e0m n\u1ed5i b\u1eadt c\u00e1c \u00f4 \u0111\u00e3 \u0111\u01b0\u1ee3c kh\u00f3a v\u00e0 m\u1edf kh\u00f3a trong Excel.<\/span><\/p>\n<\/blockquote>\n<p><span style=\"font-family: 'Times New Roman', Times\">C\u00f3 th\u1ec3 b\u1ea1n \u0111\u00e3 bi\u1ebft c\u00e1ch \u0111\u1ec3 kh\u00f3a m\u1ed9t trang t\u00ednh, tuy nhi\u00ean, trong m\u1ed9t s\u1ed1 tr\u01b0\u1eddng h\u1ee3p b\u1ea1n kh\u00f4ng mu\u1ed1n kh\u00f3a to\u00e0n b\u1ed9 trang m\u00e0 ch\u1ec9 c\u1ea7n kh\u00f3a m\u1ed9t s\u1ed1 \u00f4, c\u1ed9t ho\u1eb7c h\u00e0ng c\u1ee5 th\u1ec3, c\u00f2n l\u1ea1i v\u1eabn gi\u1eef nguy\u00ean kh\u00f4ng kh\u00f3a.<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">V\u00ed d\u1ee5: b\u1ea1n c\u00f3 th\u1ec3 cho ph\u00e9p ng\u01b0\u1eddi d\u00f9ng nh\u1eadp v\u00e0 ch\u1ec9nh s\u1eeda d\u1eef li\u1ec7u ngu\u1ed3n, nh\u01b0ng b\u1ea3o v\u1ec7 c\u00e1c \u00f4 b\u1eb1ng c\u00e1c c\u00f4ng th\u1ee9c t\u00ednh to\u00e1n d\u1eef li\u1ec7u \u0111\u00f3. N\u00f3i c\u00e1ch kh\u00e1c, b\u1ea1n ch\u1ec9 kh\u00f3a m\u1ed9t \u00f4 ho\u1eb7c d\u1ea3i \u00f4 kh\u00f4ng mu\u1ed1n b\u1ecb thay \u0111\u1ed5i.<\/span><\/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-6766dd7eaf93d\" 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-khoa-va-mo-cac-o-trong-excel.html#Cach_khoa_o_trong_Excel\" title=\"C\u00e1ch kh\u00f3a \u00f4 trong Excel\">C\u00e1ch kh\u00f3a \u00f4 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-2\" href=\"https:\/\/blog.hocexcel.online\/cach-khoa-va-mo-cac-o-trong-excel.html#Cac_buoc_chi_tiet_de_khoa_o_trong_Excel_2010_Excel_2013_va_Excel_2016_duoc_the_hien_ngay_duoi_day\" title=\"C\u00e1c b\u01b0\u1edbc chi ti\u1ebft \u0111\u1ec3 kh\u00f3a \u00f4 trong Excel 2010, Excel 2013 v\u00e0 Excel 2016 \u0111\u01b0\u1ee3c th\u1ec3 hi\u1ec7n ngay d\u01b0\u1edbi \u0111\u00e2y.\">C\u00e1c b\u01b0\u1edbc chi ti\u1ebft \u0111\u1ec3 kh\u00f3a \u00f4 trong Excel 2010, Excel 2013 v\u00e0 Excel 2016 \u0111\u01b0\u1ee3c th\u1ec3 hi\u1ec7n ngay d\u01b0\u1edbi \u0111\u00e2y.<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/cach-khoa-va-mo-cac-o-trong-excel.html#De_bao_ve_cot_trong_Excel_hay_thuc_hien_mot_trong_cac_thao_tac_sau\" title=\"\u0110\u1ec3 b\u1ea3o v\u1ec7 c\u1ed9t trong Excel, h\u00e3y th\u1ef1c hi\u1ec7n m\u1ed9t trong c\u00e1c thao t\u00e1c sau:\">\u0110\u1ec3 b\u1ea3o v\u1ec7 c\u1ed9t trong Excel, h\u00e3y th\u1ef1c hi\u1ec7n m\u1ed9t trong c\u00e1c thao t\u00e1c sau:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/cach-khoa-va-mo-cac-o-trong-excel.html#Cach_mo_khoa_cho_cac_o_trong_Excel_bo_cai_dat_bao_ve_cho_trang_tinh\" title=\"C\u00e1ch m\u1edf kh\u00f3a cho c\u00e1c \u00f4 trong Excel (b\u1ecf c\u00e0i \u0111\u1eb7t b\u1ea3o v\u1ec7 cho trang t\u00ednh)\">C\u00e1ch m\u1edf kh\u00f3a cho c\u00e1c \u00f4 trong Excel (b\u1ecf c\u00e0i \u0111\u1eb7t b\u1ea3o v\u1ec7 cho trang t\u00ednh)<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/cach-khoa-va-mo-cac-o-trong-excel.html#Cach_mo_khoa_mot_so_o_tren_mot_bang_tinh_Excel_duoc_bao_ve\" title=\"C\u00e1ch m\u1edf kh\u00f3a m\u1ed9t s\u1ed1 \u00f4 tr\u00ean m\u1ed9t b\u1ea3ng t\u00ednh Excel \u0111\u01b0\u1ee3c b\u1ea3o v\u1ec7\">C\u00e1ch m\u1edf kh\u00f3a m\u1ed9t s\u1ed1 \u00f4 tr\u00ean m\u1ed9t b\u1ea3ng t\u00ednh Excel \u0111\u01b0\u1ee3c b\u1ea3o v\u1ec7<\/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-6\" href=\"https:\/\/blog.hocexcel.online\/cach-khoa-va-mo-cac-o-trong-excel.html#Cho_phep_nguoi_dung_nhat_dinh_chinh_sua_o_da_chon_ma_khong_co_mat_khau\" title=\"Cho ph\u00e9p ng\u01b0\u1eddi d\u00f9ng nh\u1ea5t \u0111\u1ecbnh ch\u1ec9nh s\u1eeda \u00f4 \u0111\u00e3 ch\u1ecdn m\u00e0 kh\u00f4ng c\u00f3 m\u1eadt kh\u1ea9u\">Cho ph\u00e9p ng\u01b0\u1eddi d\u00f9ng nh\u1ea5t \u0111\u1ecbnh ch\u1ec9nh s\u1eeda \u00f4 \u0111\u00e3 ch\u1ecdn m\u00e0 kh\u00f4ng 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-7\" href=\"https:\/\/blog.hocexcel.online\/cach-khoa-va-mo-cac-o-trong-excel.html#Cach_khoa_cac_o_khac_trong_Excel_ngoai_cac_o_dau_vao\" title=\"C\u00e1ch kh\u00f3a c\u00e1c \u00f4 kh\u00e1c trong Excel ngo\u00e0i c\u00e1c \u00f4 \u0111\u1ea7u v\u00e0o\">C\u00e1ch kh\u00f3a c\u00e1c \u00f4 kh\u00e1c trong Excel ngo\u00e0i c\u00e1c \u00f4 \u0111\u1ea7u v\u00e0o<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/blog.hocexcel.online\/cach-khoa-va-mo-cac-o-trong-excel.html#Cach_tim_va_lam_noi_bat_cac_o_da_khoa_mo_khoa_tren_mot_trang_tinh\" title=\"C\u00e1ch t\u00ecm v\u00e0 l\u00e0m n\u1ed5i b\u1eadt c\u00e1c \u00f4 \u0111\u00e3 kh\u00f3a \/ m\u1edf kh\u00f3a tr\u00ean m\u1ed9t trang t\u00ednh\">C\u00e1ch t\u00ecm v\u00e0 l\u00e0m n\u1ed5i b\u1eadt c\u00e1c \u00f4 \u0111\u00e3 kh\u00f3a \/ m\u1edf kh\u00f3a tr\u00ean m\u1ed9t trang t\u00ednh<\/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-9\" href=\"https:\/\/blog.hocexcel.online\/cach-khoa-va-mo-cac-o-trong-excel.html#Giai_phap_la_lam_noi_bat_cac_o_bi_khoa_va_hoac_da_duoc_mo_khoa_bang_cach_tao_ra_mot_quy_tac_dinh_dang_co_dieu_kien_dua_tren_cac_cong_thuc_sau\" title=\"Gi\u1ea3i ph\u00e1p l\u00e0 l\u00e0m n\u1ed5i b\u1eadt c\u00e1c \u00f4 b\u1ecb kh\u00f3a v\u00e0 \/ ho\u1eb7c \u0111\u00e3 \u0111\u01b0\u1ee3c m\u1edf kh\u00f3a b\u1eb1ng c\u00e1ch t\u1ea1o ra m\u1ed9t quy t\u1eafc \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n d\u1ef1a tr\u00ean c\u00e1c c\u00f4ng th\u1ee9c sau:\">Gi\u1ea3i ph\u00e1p l\u00e0 l\u00e0m n\u1ed5i b\u1eadt c\u00e1c \u00f4 b\u1ecb kh\u00f3a v\u00e0 \/ ho\u1eb7c \u0111\u00e3 \u0111\u01b0\u1ee3c m\u1edf kh\u00f3a b\u1eb1ng c\u00e1ch t\u1ea1o ra m\u1ed9t quy t\u1eafc \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n d\u1ef1a tr\u00ean c\u00e1c c\u00f4ng th\u1ee9c sau:<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Cach_khoa_o_trong_Excel\"><\/span><span style=\"font-family: 'Times New Roman', Times\">C\u00e1ch kh\u00f3a \u00f4 trong Excel<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-family: 'Times New Roman', Times\">Kh\u00f3a t\u1ea5t c\u1ea3 c\u00e1c \u00f4 tr\u00ean m\u1ed9t b\u1ea3ng Excel r\u1ea5t d\u1ec5 d\u00e0ng \u2013 b\u1ea1n ch\u1ec9 c\u1ea7n \u0111\u1eb7t b\u1ea3o v\u1ec7 cho c\u1ea3 trang t\u00ednh, nh\u01b0 v\u1eady t\u1ea5t c\u1ea3 c\u00e1c \u00f4 s\u1ebd \u0111\u01b0\u1ee3c kh\u00f3a theo m\u1eb7c \u0111\u1ecbnh.<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">N\u1ebfu b\u1ea1n kh\u00f4ng mu\u1ed1n kh\u00f3a t\u1ea5t c\u1ea3 c\u00e1c \u00f4 tr\u00ean trang, nh\u01b0ng mu\u1ed1n b\u1ea3o v\u1ec7 c\u00e1c \u00f4 nh\u1ea5t \u0111\u1ecbnh \u0111\u1ec3 ch\u00fang kh\u00f4ng b\u1ecb ghi \u0111\u00e8, x\u00f3a ho\u1eb7c ch\u1ec9nh s\u1eeda, tr\u01b0\u1edbc ti\u00ean b\u1ea1n c\u1ea7n ph\u1ea3i m\u1edf kh\u00f3a t\u1ea5t c\u1ea3 c\u00e1c \u00f4, sau \u0111\u00f3 kh\u00f3a nh\u1eefng \u00f4 c\u1ee5 th\u1ec3 v\u00e0 sau \u0111\u00f3 \u0111\u1eb7t b\u1ea3o v\u1ec7 b\u1ea3ng.<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cac_buoc_chi_tiet_de_khoa_o_trong_Excel_2010_Excel_2013_va_Excel_2016_duoc_the_hien_ngay_duoi_day\"><\/span><span style=\"font-family: 'Times New Roman', Times\">C\u00e1c b\u01b0\u1edbc chi ti\u1ebft \u0111\u1ec3 kh\u00f3a \u00f4 trong Excel 2010, Excel 2013 v\u00e0 Excel 2016 \u0111\u01b0\u1ee3c th\u1ec3 hi\u1ec7n ngay d\u01b0\u1edbi \u0111\u00e2y.<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-family: 'Times New Roman', Times\">1. M\u1edf t\u1ea5t c\u1ea3 \u00f4 tr\u00ean trang Excel.<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> Theo m\u1eb7c \u0111\u1ecbnh, t\u00f9y ch\u1ecdn Locked \u0111\u01b0\u1ee3c k\u00edch ho\u1ea1t cho t\u1ea5t c\u1ea3 c\u00e1c \u00f4 tr\u00ean trang t\u00ednh. \u0110\u00f3 l\u00e0 l\u00fd do t\u1ea1i sao, \u0111\u1ec3 kh\u00f3a c\u00e1c \u00f4 nh\u1ea5t \u0111\u1ecbnh trong Excel, b\u1ea1n c\u1ea7n ph\u1ea3i m\u1edf kh\u00f3a t\u1ea5t c\u1ea3 c\u00e1c \u00f4 \u0111\u1ea7u ti\u00ean.<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">Nh\u1ea5n Ctrl + A ho\u1eb7c nh\u1ea5p v\u00e0o n\u00fat Select All trong m\u1ed9t b\u1ea3ng t\u00ednh Excel \u0111\u1ec3 ch\u1ecdn to\u00e0n b\u1ed9 trang t\u00ednh.<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> Nh\u1ea5n Ctrl + 1 \u0111\u1ec3 m\u1edf h\u1ed9p tho\u1ea1i Format Cells (ho\u1eb7c nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o b\u1ea5t k\u1ef3 \u00f4 n\u00e0o \u0111\u00e3 ch\u1ecdn v\u00e0 ch\u1ecdn Format Cells t\u1eeb tr\u00ecnh \u0111\u01a1n ng\u1eef c\u1ea3nh).<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> Trong h\u1ed9p tho\u1ea1i Format Cells, chuy\u1ec3n sang tab Protection, b\u1ecf ch\u1ecdn t\u00f9y ch\u1ecdn Locked, v\u00e0 nh\u1ea5n OK.<\/span><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7735\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/1-3-3.png\" width=\"523\" height=\"332\" title=\"1-3-3\"><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">2. Ch\u1ecdn \u00f4, d\u00e3y, c\u1ed9t ho\u1eb7c h\u00e0ng b\u1ea1n mu\u1ed1n \u0111\u1eb7t b\u1ea3o v\u1ec7.<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> \u0110\u1ec3 kh\u00f3a c\u00e1c \u00f4 ho\u1eb7c d\u00e3y, h\u00e3y ch\u1ecdn ch\u00fang theo c\u00e1ch th\u00f4ng th\u01b0\u1eddng b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c ph\u00edm, con chu\u1ed9t ho\u1eb7c m\u0169i t\u00ean k\u1ebft h\u1ee3p v\u1edbi Shift. \u0110\u1ec3 ch\u1ecdn c\u00e1c \u00f4 kh\u00f4ng li\u1ec1n k\u1ec1, ch\u1ecdn \u00f4 \u0111\u1ea7u ti\u00ean ho\u1eb7c m\u1ed9t d\u00e3y \u00f4, b\u1ea5m v\u00e0 gi\u1eef ph\u00edm Ctrl, v\u00e0 ch\u1ecdn c\u00e1c \u00f4 kh\u00e1c ho\u1eb7c c\u00e1c d\u1ea3i \u00f4 kh\u00e1c.<\/span><\/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\/2024\/12\/ex101_92019-nho-580.gif\" title=\"ex101_92019-nho-580\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"De_bao_ve_cot_trong_Excel_hay_thuc_hien_mot_trong_cac_thao_tac_sau\"><\/span><span style=\"font-family: 'Times New Roman', Times\">\u0110\u1ec3 b\u1ea3o v\u1ec7 c\u1ed9t trong Excel, h\u00e3y th\u1ef1c hi\u1ec7n m\u1ed9t trong c\u00e1c thao t\u00e1c sau:<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-family: 'Times New Roman', Times\">\u2013 \u0110\u1ec3 b\u1ea3o v\u1ec7 m\u1ed9t c\u1ed9t, nh\u1ea5p v\u00e0o ch\u1eef c\u00e1i \u0111\u1ea1i di\u1ec7n c\u1ee7a c\u1ed9t \u0111\u1ec3 ch\u1ecdn c\u1ed9t \u0111\u00f3. Ho\u1eb7c, ch\u1ecdn b\u1ea5t k\u1ef3 \u00f4 n\u00e0o trong c\u1ed9t m\u00e0 b\u1ea1n mu\u1ed1n kh\u00f3a, v\u00e0 nh\u1ea5n Ctrl + Space.<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> \u2013 \u0110\u1ec3 ch\u1ecdn c\u00e1c c\u1ed9t li\u1ec1n k\u1ec1, nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o ti\u00eau \u0111\u1ec1 c\u1ed9t \u0111\u1ea7u ti\u00ean v\u00e0 k\u00e9o v\u00f9ng ch\u1ecdn qua c\u00e1c ch\u1eef c\u00e1i \u0111\u1ea1i di\u1ec7n c\u1ee7a c\u1ed9t v\u1ec1 ph\u00eda b\u00ean ph\u1ea3i ho\u1eb7c b\u00ean tr\u00e1i. Ho\u1eb7c, ch\u1ecdn c\u1ed9t \u0111\u1ea7u ti\u00ean, gi\u1eef ph\u00edm Shift, v\u00e0 ch\u1ecdn c\u1ed9t cu\u1ed1i c\u00f9ng.<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> \u2013 \u0110\u1ec3 ch\u1ecdn c\u00e1c c\u1ed9t kh\u00f4ng li\u1ec1n k\u1ec1, nh\u1ea5p v\u00e0o ch\u1eef c\u00e1i c\u1ee7a c\u1ed9t \u0111\u1ea7u ti\u00ean, gi\u1eef ph\u00edm Ctrl v\u00e0 nh\u1ea5p v\u00e0o c\u00e1c ti\u00eau \u0111\u1ec1 c\u1ee7a c\u00e1c c\u1ed9t kh\u00e1c m\u00e0 b\u1ea1n mu\u1ed1n \u0111\u1eb7t b\u1ea3o v\u1ec7.<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> \u2013 \u0110\u1ec3 b\u1ea3o v\u1ec7 c\u00e1c h\u00e0ng trong Excel, h\u00e3y ch\u1ecdn ch\u00fang theo c\u00e1ch th\u1ee9c t\u01b0\u01a1ng t\u1ef1.<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">\u0110\u1ec3 kh\u00f3a t\u1ea5t c\u1ea3 c\u00e1c \u00f4 b\u1eb1ng c\u00f4ng th\u1ee9c, h\u00e3y chuy\u1ec3n \u0111\u1ebfn tab <em><strong>Trang ch\u1ee7&gt; &gt; Editing group &gt; Find &amp; Select &gt; Go To Special<\/strong><\/em>. Trong h\u1ed9p tho\u1ea1i Go To Special, ki\u1ec3m tra n\u00fat radio Formulas, v\u00e0 nh\u1ea5n OK.<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> 3. Kh\u00f3a c\u00e1c \u00f4 \u0111\u00e3 ch\u1ecdn.<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> V\u1edbi c\u00e1c \u00f4 \u0111\u01b0\u1ee3c y\u00eau c\u1ea7u \u0111\u00e3 ch\u1ecdn, nh\u1ea5n Ctrl + 1 \u0111\u1ec3 m\u1edf h\u1ed9p tho\u1ea1i Format Cells (ho\u1eb7c nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o \u00f4 \u0111\u00e3 ch\u1ecdn v\u00e0 nh\u1ea5p v\u00e0o Format Cells), chuy\u1ec3n sang tab Protection v\u00e0 ki\u1ec3m tra ph\u1ea7n Locked.<\/span><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7736\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/2-3-4.png\" width=\"525\" height=\"331\" title=\"2-3-4\"><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> 4. B\u1ea3o v\u1ec7 trang t\u00ednh<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> Kh\u00f3a c\u00e1c \u00f4 trong Excel kh\u00f4ng c\u00f3 hi\u1ec7u l\u1ef1c cho \u0111\u1ebfn khi b\u1ea1n \u0111\u1eb7t b\u1ea3o v\u1ec7 cho b\u1ea3ng t\u00ednh \u0111\u00f3. \u0110i\u1ec1u n\u00e0y c\u00f3 th\u1ec3 g\u00e2y ch\u00fat nh\u1ea7m l\u1eabn, nh\u01b0ng Microsoft \u0111\u00e3 thi\u1ebft k\u1ebf theo c\u00e1ch n\u00e0y, v\u00e0 ch\u00fang ta ph\u1ea3i tu\u00e2n theo \u0111i\u1ec1u \u0111\u00f3.<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">Tr\u00ean tab Review, trong nh\u00f3m Changes, h\u00e3y nh\u1ea5p v\u00e0o n\u00fat Protect Sheet. Ho\u1eb7c, nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o tab sheet v\u00e0 ch\u1ecdn Protect Sheet trong tr\u00ecnh \u0111\u01a1n ng\u1eef c\u1ea3nh.<\/span><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7737\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/3-2-2.png\" width=\"585\" height=\"130\" title=\"3-2-2\"><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">B\u1ea1n s\u1ebd \u0111\u01b0\u1ee3c nh\u1eafc nh\u1eadp m\u1eadt kh\u1ea9u (t\u00f9y ch\u1ecdn) v\u00e0 ch\u1ecdn h\u00e0nh \u0111\u1ed9ng m\u00e0 b\u1ea1n mu\u1ed1n cho ph\u00e9p ng\u01b0\u1eddi d\u00f9ng th\u1ef1c hi\u1ec7n. Th\u1ef1c hi\u1ec7n vi\u1ec7c n\u00e0y v\u00e0 nh\u1ea5p OK.<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">Gi\u1edd th\u00ec c\u00e1c \u00f4 \u0111\u00e3 ch\u1ecdn \u0111\u00e3 \u0111\u01b0\u1ee3c kh\u00f3a v\u00e0 b\u1ea3o v\u1ec7 kh\u1ecfi b\u1ea5t k\u1ef3 thay \u0111\u1ed5i n\u00e0o, trong khi t\u1ea5t c\u1ea3 c\u00e1c \u00f4 kh\u00e1c trong b\u1ea3ng t\u00ednh v\u1eabn c\u00f3 th\u1ec3 ch\u1ec9nh s\u1eeda \u0111\u01b0\u1ee3c.<\/span><\/p>\n<h2><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"Cach_mo_khoa_cho_cac_o_trong_Excel_bo_cai_dat_bao_ve_cho_trang_tinh\"><\/span><span style=\"font-family: 'Times New Roman', Times\">C\u00e1ch m\u1edf kh\u00f3a cho c\u00e1c \u00f4 trong Excel (b\u1ecf c\u00e0i \u0111\u1eb7t b\u1ea3o v\u1ec7 cho trang t\u00ednh)<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-family: 'Times New Roman', Times\">\u0110\u1ec3 m\u1edf kh\u00f3a t\u1ea5t c\u1ea3 c\u00e1c \u00f4 tr\u00ean m\u1ed9t trang t\u00ednh, b\u1ea1n c\u00f3 th\u1ec3 lo\u1ea1i b\u1ecf b\u1ea3o v\u1ec7 b\u1ea3ng t\u00ednh. \u0110\u1ec3 l\u00e0m \u0111i\u1ec1u n\u00e0y, h\u00e3y nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o tab sheet v\u00e0 ch\u1ecdn Unprotect Sheet \u2026 t\u1eeb tr\u00ecnh \u0111\u01a1n ng\u1eef c\u1ea3nh. Ngo\u00e0i ra, b\u1ea5m v\u00e0o n\u00fat Unprotect Sheet tr\u00ean tab Review, trong nh\u00f3m Changes:<\/span><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7738\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/4-3-2.png\" width=\"600\" height=\"125\" title=\"4-3-2\"><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> Ngay khi b\u1ea3ng t\u00ednh kh\u00f4ng \u0111\u01b0\u1ee3c b\u1ea3o v\u1ec7, b\u1ea1n c\u00f3 th\u1ec3 ch\u1ec9nh s\u1eeda b\u1ea5t k\u1ef3 \u00f4 n\u00e0o v\u00e0 sau \u0111\u00f3 v\u1eabn c\u00f3 th\u1ec3 \u0111\u1eb7t b\u1ea3o v\u1ec7 b\u1ea3ng t\u00ednh m\u1ed9t l\u1ea7n n\u1eefa.<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">N\u1ebfu b\u1ea1n mu\u1ed1n cho ph\u00e9p ng\u01b0\u1eddi d\u00f9ng ch\u1ec9nh s\u1eeda c\u00e1c \u00f4 ho\u1eb7c d\u1ea3i \u00f4 c\u1ee5 th\u1ec3 tr\u00ean m\u1ed9t b\u1ea3ng t\u00ednh \u0111\u01b0\u1ee3c b\u1ea3o v\u1ec7 b\u1eb1ng m\u1eadt kh\u1ea9u, h\u00e3y ki\u1ec3m tra ph\u1ea7n sau \u0111\u00e2y.<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cach_mo_khoa_mot_so_o_tren_mot_bang_tinh_Excel_duoc_bao_ve\"><\/span><span style=\"font-family: 'Times New Roman', Times\">C\u00e1ch m\u1edf kh\u00f3a m\u1ed9t s\u1ed1 \u00f4 tr\u00ean m\u1ed9t b\u1ea3ng t\u00ednh Excel \u0111\u01b0\u1ee3c b\u1ea3o v\u1ec7<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-family: 'Times New Roman', Times\">Trong ph\u1ea7n \u0111\u1ea7u c\u1ee7a h\u01b0\u1edbng d\u1eabn n\u00e0y, ch\u00fang ta \u0111\u00e3 th\u1ea3o lu\u1eadn l\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 kh\u00f3a c\u00e1c \u00f4 trong Excel sao cho kh\u00f4ng ai c\u00f3 th\u1ec3 ch\u1ec9nh s\u1eeda nh\u1eefng \u00f4 \u0111\u00f3 m\u00e0 kh\u00f4ng c\u1ea7n b\u1ea3o v\u1ec7 n\u00f3.<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">Tuy nhi\u00ean, \u0111\u00f4i khi b\u1ea1n c\u00f3 th\u1ec3 mu\u1ed1n ch\u1ec9nh s\u1eeda c\u00e1c \u00f4 c\u1ee5 th\u1ec3 tr\u00ean t\u1edd c\u1ee7a ri\u00eang m\u00ecnh ho\u1eb7c \u0111\u1ec3 cho nh\u1eefng ng\u01b0\u1eddi d\u00f9ng tin c\u1eady kh\u00e1c ch\u1ec9nh s\u1eeda c\u00e1c \u00f4 \u0111\u00f3. N\u00f3i c\u00e1ch kh\u00e1c, b\u1ea1n c\u00f3 th\u1ec3 cho ph\u00e9p c\u00e1c \u00f4 nh\u1ea5t \u0111\u1ecbnh tr\u00ean m\u1ed9t b\u1ea3ng t\u00ednh \u0111\u01b0\u1ee3c m\u1edf kh\u00f3a b\u1eb1ng m\u1eadt kh\u1ea9u. V\u1eady h\u00e3y th\u1ef1c hi\u1ec7n theo c\u00e1ch sau:<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">1. Ch\u1ecdn c\u00e1c \u00f4 ho\u1eb7c d\u00e3y b\u1ea1n mu\u1ed1n m\u1edf b\u1eb1ng m\u1eadt kh\u1ea9u khi trang \u0111\u01b0\u1ee3c b\u1ea3o v\u1ec7.<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> 2. Chuy\u1ec3n \u0111\u1ebfn tab <em><strong>Review &gt; Changes<\/strong><\/em> v\u00e0 nh\u1ea5p v\u00e0o Allow Users to Edit Ranges.<\/span><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7739\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/5-3-1.png\" width=\"584\" height=\"129\" title=\"5-3-1\"><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> Ch\u00fa th\u00edch. T\u00ednh n\u0103ng n\u00e0y ch\u1ec9 kh\u1ea3 d\u1ee5ng trong m\u1ed9t t\u1ea5m kh\u00f4ng \u0111\u01b0\u1ee3c b\u1ea3o v\u1ec7. N\u1ebfu n\u00fat Allow Users to Edit Ranges \u0111\u01b0\u1ee3c t\u00f4 m\u00e0u x\u00e1m, h\u00e3y nh\u1ea5p v\u00e0o n\u00fat Unprotect Sheet tr\u00ean tab Review.<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> 3. Trong h\u1ed9p tho\u1ea1i Allow Users to Edit Ranges, nh\u1ea5p v\u00e0o n\u00fat New \u0111\u1ec3 th\u00eam m\u1ed9t ph\u1ea1m vi m\u1edbi:<\/span><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7740\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/6-3-1.png\" width=\"380\" height=\"270\" title=\"6-3-1\"><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> 4. Trong c\u1eeda s\u1ed5 h\u1ed9p tho\u1ea1i New Range, h\u00e3y th\u1ef1c hi\u1ec7n theo c\u00e1c b\u01b0\u1edbc sau:<\/span><\/p>\n<ul>\n<li><span style=\"font-family: 'Times New Roman', Times\">Trong h\u1ed9p Title, h\u00e3y nh\u1eadp t\u00ean d\u1ea3i \u00f4 c\u00f3 \u00fd ngh\u0129a thay v\u00ec t\u00ean m\u1eb7c \u0111\u1ecbnh l\u00e0 Range1 (t\u00f9y ch\u1ecdn).<\/span><\/li>\n<li><span style=\"font-family: 'Times New Roman', Times\">Trong \u00f4 Refers to cells, nh\u1eadp \u00f4 ho\u1eb7c tham chi\u1ebfu ph\u1ea1m vi. Theo m\u1eb7c \u0111\u1ecbnh, (c\u00e1c) \u00f4 ho\u1eb7c ph\u1ea1m vi \u0111\u01b0\u1ee3c ch\u1ecdn hi\u1ec7n t\u1ea1i.<\/span><\/li>\n<li><span style=\"font-family: 'Times New Roman', Times\">Trong h\u1ed9p Range password, nh\u1eadp m\u1eadt kh\u1ea9u.<\/span><\/li>\n<li><span style=\"font-family: 'Times New Roman', Times\">Nh\u1ea5p v\u00e0o n\u00fat OK.<\/span><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7742\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/7-1-2.png\" width=\"396\" height=\"226\" title=\"7-1-2\"><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> M\u1eb9o. B\u00ean c\u1ea1nh vi\u1ec7c m\u1edf kh\u00f3a ph\u1ea1m vi quy \u0111\u1ecbnh b\u1eb1ng m\u1eadt kh\u1ea9u, b\u1ea1n c\u00f3 th\u1ec3 cho m\u1ed9t s\u1ed1 ng\u01b0\u1eddi d\u00f9ng quy\u1ec1n ch\u1ec9nh s\u1eeda ph\u1ea1m vi \u0111\u00f3 m\u00e0 kh\u00f4ng c\u00f3 m\u1eadt kh\u1ea9u. \u0110\u1ec3 l\u00e0m \u0111i\u1ec1u n\u00e0y, h\u00e3y nh\u1ea5p v\u00e0o n\u00fat Permissions \u1edf g\u00f3c d\u01b0\u1edbi b\u00ean tr\u00e1i c\u1ee7a h\u1ed9p tho\u1ea1i New Range v\u00e0 th\u1ef1c hi\u1ec7n theo c\u00e1c h\u01b0\u1edbng d\u1eabn n\u00e0y (c\u00e1c b\u01b0\u1edbc 3- 5).<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> 5. C\u1eeda s\u1ed5 X\u00e1c nh\u1eadn m\u1eadt kh\u1ea9u s\u1ebd xu\u1ea5t hi\u1ec7n v\u00e0 nh\u1eafc b\u1ea1n nh\u1eadp l\u1ea1i m\u1eadt kh\u1ea9u. Th\u1ef1c hi\u1ec7n vi\u1ec7c n\u00e0y v\u00e0 nh\u1ea5p OK.<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> 6. D\u1ea3i m\u1edbi s\u1ebd \u0111\u01b0\u1ee3c li\u1ec7t k\u00ea trong h\u1ed9p tho\u1ea1i Allow Users to Edit Ranges. N\u1ebfu b\u1ea1n mu\u1ed1n th\u00eam m\u1ed9t v\u00e0i d\u1ea3i, h\u00e3y l\u1eb7p l\u1ea1i c\u00e1c b\u01b0\u1edbc t\u1eeb 2 \u0111\u1ebfn 5.<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> 7. Nh\u1ea5p v\u00e0o n\u00fat Protect Sheet \u1edf n\u00fat c\u1ee7a c\u1eeda s\u1ed5 \u0111\u1ec3 \u00e1p d\u1ee5ng \u0111\u1eb7t b\u1ea3o v\u1ec7 cho trang.<\/span><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7743\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/8-3.png\" width=\"383\" height=\"270\" title=\"8-3\"><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> 8. Trong c\u1eeda s\u1ed5 Protect Sheet, g\u00f5 m\u1eadt kh\u1ea9u \u0111\u1ec3 h\u1ee7y b\u1ea3o v\u1ec7 sheet, ch\u1ecdn c\u00e1c h\u1ed9p ki\u1ec3m tra b\u00ean c\u1ea1nh c\u00e1c thao t\u00e1c b\u1ea1n mu\u1ed1n cho ph\u00e9p, v\u00e0 nh\u1ea5n OK.<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> M\u1eb9o. B\u1ea1n n\u00ean b\u1ea3o v\u1ec7 m\u1ed9t trang b\u1eb1ng m\u1eadt kh\u1ea9u kh\u00e1c v\u1edbi m\u1eadt kh\u1ea9u b\u1ea1n \u0111\u00e3 s\u1eed d\u1ee5ng \u0111\u1ec3 m\u1edf kh\u00f3a ph\u1ea1m vi.<\/span><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7744\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/9-3-1.png\" width=\"301\" height=\"327\" title=\"9-3-1\"><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> 9. Trong c\u1eeda s\u1ed5 x\u00e1c nh\u1eadn m\u1eadt kh\u1ea9u, nh\u1eadp l\u1ea1i m\u1eadt kh\u1ea9u v\u00e0 nh\u1ea5n OK.<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> B\u00e2y gi\u1edd, b\u1ea3ng t\u00ednh c\u1ee7a b\u1ea1n \u0111\u01b0\u1ee3c b\u1ea3o v\u1ec7 b\u1eb1ng m\u1eadt kh\u1ea9u, nh\u01b0ng c\u00e1c \u00f4 c\u1ee5 th\u1ec3 c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c m\u1edf kh\u00f3a b\u1eb1ng m\u1eadt kh\u1ea9u b\u1ea1n cung c\u1ea5p cho ph\u1ea1m vi \u0111\u00f3. V\u00e0 b\u1ea5t k\u1ef3 ng\u01b0\u1eddi d\u00f9ng n\u00e0o bi\u1ebft r\u1eb1ng m\u1eadt kh\u1ea9u ph\u1ea1m vi c\u00f3 th\u1ec3 ch\u1ec9nh s\u1eeda ho\u1eb7c x\u00f3a c\u00e1c n\u1ed9i dung c\u1ee7a \u00f4.<\/span><\/p>\n<blockquote>\n<p>Chia se\u0309 b\u00f4\u0323\u00a0<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\">t\u00e0i li\u1ec7u excel c\u01a1 b\u1ea3n<\/a> hay nh\u00e2\u0301t mo\u0323i th\u01a1\u0300i \u0111a\u0323i<\/p>\n<\/blockquote>\n<h2><span class=\"ez-toc-section\" id=\"Cho_phep_nguoi_dung_nhat_dinh_chinh_sua_o_da_chon_ma_khong_co_mat_khau\"><\/span><span style=\"font-family: 'Times New Roman', Times\">Cho ph\u00e9p ng\u01b0\u1eddi d\u00f9ng nh\u1ea5t \u0111\u1ecbnh ch\u1ec9nh s\u1eeda \u00f4 \u0111\u00e3 ch\u1ecdn m\u00e0 kh\u00f4ng c\u00f3 m\u1eadt kh\u1ea9u<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-family: 'Times New Roman', Times\">M\u1edf kh\u00f3a c\u00e1c \u00f4 v\u1edbi m\u1eadt kh\u1ea9u c\u00f3 th\u1ec3 r\u1ea5t h\u1eefu \u00edch trong m\u1ed9t s\u1ed1 tr\u01b0\u1eddng h\u1ee3p, nh\u01b0ng n\u1ebfu b\u1ea1n c\u1ea7n ph\u1ea3i th\u01b0\u1eddng xuy\u00ean ch\u1ec9nh s\u1eeda c\u00e1c \u00f4 \u0111\u00f3, vi\u1ec7c g\u00f5 m\u1eadt kh\u1ea9u m\u1ed7i l\u1ea7n c\u00f3 th\u1ec3 l\u00e0 m\u1ed9t s\u1ef1 l\u00e3ng ph\u00ed th\u1eddi gian. Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 thi\u1ebft l\u1eadp quy\u1ec1n cho ng\u01b0\u1eddi d\u00f9ng c\u1ee5 th\u1ec3 \u0111\u1ec3 ch\u1ec9nh s\u1eeda m\u1ed9t s\u1ed1 d\u00e3y ho\u1eb7c c\u00e1c \u00f4 ri\u00eang l\u1ebb m\u00e0 kh\u00f4ng c\u00f3 m\u1eadt kh\u1ea9u.<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">Ch\u00fa th\u00edch. C\u00e1c t\u00ednh n\u0103ng n\u00e0y ho\u1ea1t \u0111\u1ed9ng tr\u00ean Windows XP ho\u1eb7c cao h\u01a1n, v\u00e0 m\u00e1y t\u00ednh c\u1ee7a b\u1ea1n ph\u1ea3i n\u1eb1m tr\u00ean m\u1ed9t t\u00ean mi\u1ec1n.<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> Gi\u1ea3 s\u1eed b\u1ea1n \u0111\u00e3 th\u00eam m\u1ed9t ho\u1eb7c nhi\u1ec1u d\u1ea3i m\u1edf kh\u00f3a b\u1eb1ng m\u1eadt kh\u1ea9u, h\u00e3y th\u1ef1c hi\u1ec7n theo c\u00e1c b\u01b0\u1edbc sau.<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">1. Chuy\u1ec3n \u0111\u1ebfn tab <em><strong>Review &gt; Changes<\/strong><\/em> v\u00e0 nh\u1ea5p Allow Users to Edit Ranges.<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> Ch\u00fa th\u00edch. N\u1ebfu Allow User to Edit Ranges c\u00f3 m\u00e0u x\u00e1m, nh\u1ea5p v\u00e0o n\u00fat Unprotect Sheet \u0111\u1ec3 lo\u1ea1i b\u1ecf b\u1ea3o v\u1ec7 b\u1ea3ng.<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> 2. Trong c\u1eeda s\u1ed5 Allow Users to Edit Ranges, ch\u1ecdn ph\u1ea1m vi m\u00e0 b\u1ea1n mu\u1ed1n thay \u0111\u1ed5i c\u00e1c quy\u1ec1n, v\u00e0 nh\u1ea5p v\u00e0o n\u00fat Permissions.<\/span><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7745\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/10-3-1.png\" width=\"380\" height=\"268\" title=\"10-3-1\"><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">M\u1eb9o. N\u00fat Permissions c\u0169ng c\u00f3 s\u1eb5n khi b\u1ea1n t\u1ea1o m\u1ed9t d\u1ea3i m\u1edbi \u0111\u01b0\u1ee3c m\u1edf b\u1eb1ng m\u1eadt kh\u1ea9u.<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> 3. C\u1eeda s\u1ed5 Permissions s\u1ebd m\u1edf ra, v\u00e0 b\u1ea1n nh\u1ea5n n\u00fat Add<\/span><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7746\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/11-3-1.png\" width=\"387\" height=\"463\" title=\"11-3-1\"><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> 4. Trong h\u1ed9p Enter the object names to select, nh\u1eadp t\u00ean c\u1ee7a ng\u01b0\u1eddi d\u00f9ng m\u00e0 b\u1ea1n mu\u1ed1n cho ph\u00e9p ch\u1ec9nh s\u1eeda ph\u1ea1m vi.<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> \u0110\u1ec3 xem \u0111\u1ecbnh d\u1ea1ng t\u00ean y\u00eau c\u1ea7u, h\u00e3y nh\u1ea5p v\u00e0o li\u00ean k\u1ebft examples. Ho\u1eb7c ch\u1ec9 c\u1ea7n g\u00f5 t\u00ean ng\u01b0\u1eddi d\u00f9ng khi n\u00f3 \u0111\u01b0\u1ee3c l\u01b0u tr\u1eef tr\u00ean mi\u1ec1n c\u1ee7a b\u1ea1n v\u00e0 nh\u1ea5p v\u00e0o n\u00fat Check Names \u0111\u1ec3 x\u00e1c minh t\u00ean.<\/span><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7747\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/12-3.png\" width=\"477\" height=\"262\" title=\"12-3\"><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> Excel s\u1ebd x\u00e1c nh\u1eadn t\u00ean v\u00e0 \u00e1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng \u0111\u01b0\u1ee3c y\u00eau c\u1ea7u.<\/span><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7748\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/13-3.png\" width=\"479\" height=\"266\" title=\"13-3\"><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">5. Khi b\u1ea1n nh\u1eadp v\u00e0 x\u00e1c nh\u1eadn t\u00ean c\u1ee7a t\u1ea5t c\u1ea3 ng\u01b0\u1eddi d\u00f9ng m\u00e0 b\u1ea1n mu\u1ed1n cho ph\u00e9p ch\u1ec9nh s\u1eeda ph\u1ea1m vi \u0111\u00e3 ch\u1ecdn, nh\u1ea5p v\u00e0o n\u00fat OK.<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> 6. Trong m\u1ee5c Group or user names, ch\u1ec9 \u0111\u1ecbnh lo\u1ea1i quy\u1ec1n cho m\u1ed7i ng\u01b0\u1eddi d\u00f9ng (Allow ho\u1eb7c Deny), v\u00e0 nh\u1ea5p v\u00e0o n\u00fat OK \u0111\u1ec3 l\u01b0u c\u00e1c thay \u0111\u1ed5i r\u1ed3i \u0111\u00f3ng h\u1ed9p tho\u1ea1i l\u1ea1i.<\/span><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7749\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/14-1-2.png\" width=\"383\" height=\"466\" title=\"14-1-2\"><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> Ch\u00fa th\u00edch. N\u1ebfu m\u1ed9t \u00f4 n\u00e0o \u0111\u00f3 thu\u1ed9c nhi\u1ec1u h\u01a1n m\u1ed9t ph\u1ea1m vi \u0111\u01b0\u1ee3c m\u1edf b\u1eb1ng m\u1eadt kh\u1ea9u, t\u1ea5t c\u1ea3 ng\u01b0\u1eddi d\u00f9ng \u0111\u01b0\u1ee3c ph\u00e9p ch\u1ec9nh s\u1eeda b\u1ea5t k\u1ef3 ph\u1ea1m vi n\u00e0o c\u00f3 th\u1ec3 ch\u1ec9nh s\u1eeda \u00f4 \u0111\u00f3.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cach_khoa_cac_o_khac_trong_Excel_ngoai_cac_o_dau_vao\"><\/span><span style=\"font-family: 'Times New Roman', Times\">C\u00e1ch kh\u00f3a c\u00e1c \u00f4 kh\u00e1c trong Excel ngo\u00e0i c\u00e1c \u00f4 \u0111\u1ea7u v\u00e0o<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-family: 'Times New Roman', Times\">Khi b\u1ea1n \u0111\u00e3 n\u1ed7 l\u1ef1c r\u1ea5t nhi\u1ec1u trong vi\u1ec7c t\u1ea1o ra m\u1ed9t bi\u1ec3u m\u1eabu tinh vi ho\u1eb7c b\u1ea3ng t\u00ednh trong Excel, ch\u1eafc ch\u1eafn b\u1ea1n s\u1ebd mu\u1ed1n b\u1ea3o v\u1ec7 c\u00f4ng vi\u1ec7c c\u1ee7a m\u00ecnh v\u00e0 ng\u0103n ng\u01b0\u1eddi d\u00f9ng can thi\u1ec7p v\u00e0o c\u00f4ng th\u1ee9c c\u1ee7a b\u1ea1n ho\u1eb7c thay \u0111\u1ed5i d\u1eef li\u1ec7u kh\u00f4ng n\u00ean thay \u0111\u1ed5i. Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 kh\u00f3a t\u1ea5t c\u1ea3 c\u00e1c \u00f4 tr\u00ean b\u1ea3ng t\u00ednh Excel tr\u1eeb c\u00e1c \u00f4 \u0111\u1ea7u v\u00e0o n\u01a1i ng\u01b0\u1eddi d\u00f9ng c\u1ee7a b\u1ea1n \u0111\u01b0\u1ee3c y\u00eau c\u1ea7u nh\u1eadp d\u1eef li\u1ec7u.<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">M\u1ed9t trong nh\u1eefng gi\u1ea3i ph\u00e1p c\u00f3 th\u1ec3 l\u00e0 s\u1eed d\u1ee5ng t\u00ednh n\u0103ng Allow User to Edit Ranges \u0111\u1ec3 m\u1edf kh\u00f3a c\u00e1c \u00f4 \u0111\u00e3 ch\u1ecdn, nh\u01b0 \u0111\u00e3 tr\u00ecnh b\u00e0y \u1edf tr\u00ean. M\u1ed9t gi\u1ea3i ph\u00e1p c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 n\u00f3 kh\u00f4ng ch\u1ec9 \u0111\u1ecbnh d\u1ea1ng \u00f4 \u0111\u1ea7u v\u00e0o m\u00e0 c\u00f2n m\u1edf kh\u00f3a ch\u00fang.<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">\u0110\u1ed1i v\u1edbi v\u00ed d\u1ee5 n\u00e0y, ch\u00fang ta s\u1ebd s\u1eed d\u1ee5ng m\u1ed9t ph\u00e9p to\u00e1n t\u00ednh l\u00e3i su\u1ea5t cao, c\u00e1c b\u1ea1n theo d\u00f5i v\u00ed d\u1ee5 \u1edf ph\u1ea7n b\u00ean d\u01b0\u1edbi:<\/span><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7750\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/15.png\" width=\"314\" height=\"288\" title=\"15\"><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> Ng\u01b0\u1eddi d\u00f9ng s\u1ebd nh\u1eadp d\u1eef li\u1ec7u v\u00e0o c\u00e1c \u00f4 B2:B9, v\u00e0 c\u00f4ng th\u1ee9c trong B11 t\u00ednh to\u00e1n s\u1ef1 c\u00e2n b\u1eb1ng d\u1ef1a tr\u00ean \u0111\u1ea7u v\u00e0o c\u1ee7a ng\u01b0\u1eddi d\u00f9ng. V\u00ec v\u1eady, m\u1ee5c ti\u00eau c\u1ee7a ch\u00fang ta l\u00e0 kh\u00f3a t\u1ea5t c\u1ea3 c\u00e1c \u00f4 tr\u00ean b\u1ea3ng t\u00ednh Excel n\u00e0y, bao g\u1ed3m c\u00e1c \u00f4 c\u1ee7a c\u00f4ng th\u1ee9c v\u00e0 m\u00f4 t\u1ea3 c\u00e1c tr\u01b0\u1eddng, v\u00e0 ch\u1ec9 \u0111\u1ec3 l\u1ea1i c\u00e1c \u00f4 \u0111\u1ea7u v\u00e0o (B3:B9). \u0110\u1ec3 th\u1ef1c hi\u1ec7n vi\u1ec7c n\u00e0y, c\u00e1c b\u1ea1n l\u00e0m theo c\u00e1c b\u01b0\u1edbc sau.<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> 1. Tr\u00ean tab Trang ch\u1ee7, trong nh\u00f3m Styles, t\u00ecm ki\u1ec3u Input, nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o n\u00f3, sau \u0111\u00f3 b\u1ea5m Modify<\/span><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7751\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/16-1-2.png\" width=\"561\" height=\"189\" title=\"16-1-2\"><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> 2. Theo m\u1eb7c \u0111\u1ecbnh, ki\u1ec3u nh\u1eadp li\u1ec7u Excel bao g\u1ed3m th\u00f4ng tin v\u1ec1 ph\u00f4ng ch\u1eef, \u0111\u01b0\u1eddng vi\u1ec1n v\u00e0 m\u00e0u s\u1eafc, nh\u01b0ng kh\u00f4ng c\u00f3 tr\u1ea1ng th\u00e1i b\u1ea3o v\u1ec7 \u00f4. \u0110\u1ec3 th\u00eam, ch\u1ec9 c\u1ea7n ch\u1ecdn h\u1ed9p ki\u1ec3m tra Protection:<\/span><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7752\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/17-1-1.png\" width=\"293\" height=\"350\" title=\"17-1-1\"><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> M\u1eb9o: N\u1ebfu b\u1ea1n ch\u1ec9 mu\u1ed1n m\u1edf c\u00e1c \u00f4 \u0111\u1ea7u v\u00e0o m\u00e0 kh\u00f4ng thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng \u00f4, h\u00e3y b\u1ecf ch\u1ecdn t\u1ea5t c\u1ea3 c\u00e1c h\u1ed9p tr\u00ean h\u1ed9p tho\u1ea1i Style thay v\u00ec h\u1ed9p tho\u1ea1i Protection.<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> 3. Nh\u01b0 b\u1ea1n th\u1ea5y trong \u1ea3nh ch\u1ee5p m\u00e0n h\u00ecnh \u1edf tr\u00ean, Protection bao g\u1ed3m ki\u1ec3u Input , nh\u01b0ng n\u00f3 \u0111\u01b0\u1ee3c \u0111\u1eb7t th\u00e0nh Locked, trong khi ch\u00fang ta c\u1ea7n ph\u1ea3i m\u1edf kh\u00f3a c\u00e1c \u00f4 \u0111\u1ea7u v\u00e0o. \u0110\u1ec3 thay \u0111\u1ed5i \u0111i\u1ec1u n\u00e0y, nh\u1ea5p v\u00e0o n\u00fat Format \u1edf g\u00f3c tr\u00ean b\u00ean ph\u1ea3i c\u1ee7a c\u1eeda s\u1ed5 Style.<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> 4. H\u1ed9p tho\u1ea1i Format Cells s\u1ebd m\u1edf ra, b\u1ea1n chuy\u1ec3n sang tab Protection, b\u1ecf ch\u1ecdn h\u1ed9p Locked, v\u00e0 nh\u1ea5n OK:<\/span><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7753\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/18-1-2.png\" width=\"547\" height=\"480\" title=\"18-1-2\"><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> 5. C\u1eeda s\u1ed5 h\u1ed9p tho\u1ea1i Style s\u1ebd c\u1eadp nh\u1eadt \u0111\u1ec3 cho bi\u1ebft t\u00ecnh tr\u1ea1ng No Protection nh\u01b0 th\u1ec3 hi\u1ec7n d\u01b0\u1edbi \u0111\u00e2y, v\u00e0 b\u1ea1n nh\u1ea5n OK:<\/span><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7754\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/19-1-2.png\" width=\"298\" height=\"355\" title=\"19-1-2\"><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> 6. B\u00e2y gi\u1edd, ch\u1ecdn c\u00e1c \u00f4 \u0111\u1ea7u v\u00e0o tr\u00ean trang t\u00ednh c\u1ee7a b\u1ea1n v\u00e0 nh\u1ea5p v\u00e0o n\u00fat Input style tr\u00ean thanh th\u1ef1c \u0111\u01a1n. C\u00e1c \u00f4 \u0111\u01b0\u1ee3c ch\u1ecdn s\u1ebd \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng v\u00e0 m\u1edf kh\u00f3a c\u00f9ng m\u1ed9t l\u00fac:<\/span><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7755\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/20-1-1.png\" width=\"632\" height=\"468\" title=\"20-1-1\"><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> 7. Vi\u1ec7c kh\u00f3a c\u00e1c \u00f4 trong Excel kh\u00f4ng c\u00f3 hi\u1ec7u l\u1ef1c cho \u0111\u1ebfn khi b\u1ea3o v\u1ec7 b\u1ea3ng \u0111\u01b0\u1ee3c b\u1eadt. V\u00ec v\u1eady, \u0111i\u1ec1u cu\u1ed1i c\u00f9ng b\u1ea1n c\u1ea7n l\u00e0m l\u00e0 v\u00e0o tab <em><strong>Review &gt; Changes<\/strong><\/em>, and nh\u1ea5n n\u00fat Protect Sheet.<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">N\u1ebfu ki\u1ec3u Input c\u1ee7a Excel kh\u00f4ng ph\u00f9 h\u1ee3p v\u1edbi b\u1ea1n v\u00ec m\u1ed9t s\u1ed1 l\u00fd do n\u00e0o \u0111\u00f3, b\u1ea1n c\u00f3 th\u1ec3 t\u1ea1o phong c\u00e1ch ri\u00eang c\u1ee7a b\u1ea1n \u0111\u1ec3 m\u1edf kh\u00f3a c\u00e1c \u00f4 \u0111\u01b0\u1ee3c ch\u1ecdn, \u0111i\u1ec3m then ch\u1ed1t l\u00e0 ch\u1ecdn h\u1ed9p b\u1ea3o v\u1ec7 v\u00e0 \u0111\u1eb7t No Protection nh\u01b0 \u0111\u00e3 tr\u00ecnh b\u00e0y \u1edf tr\u00ean.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cach_tim_va_lam_noi_bat_cac_o_da_khoa_mo_khoa_tren_mot_trang_tinh\"><\/span><span style=\"font-family: 'Times New Roman', Times\">C\u00e1ch t\u00ecm v\u00e0 l\u00e0m n\u1ed5i b\u1eadt c\u00e1c \u00f4 \u0111\u00e3 kh\u00f3a \/ m\u1edf kh\u00f3a tr\u00ean m\u1ed9t trang t\u00ednh<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-family: 'Times New Roman', Times\">N\u1ebfu b\u1ea1n \u0111\u00e3 kh\u00f3a v\u00e0 m\u1edf kh\u00f3a c\u00e1c \u00f4 tr\u00ean m\u1ed9t b\u1ea3ng t\u00ednh nh\u1ea5t \u0111\u1ecbnh nhi\u1ec1u l\u1ea7n, b\u1ea1n c\u00f3 th\u1ec3 \u0111\u00e3 qu\u00ean nh\u1eefng \u00f4 n\u00e0o b\u1ecb kh\u00f3a v\u00e0 \u0111\u00e3 \u0111\u01b0\u1ee3c m\u1edf kh\u00f3a. \u0110\u1ec3 t\u00ecm c\u00e1c \u00f4 \u0111\u00e3 kh\u00f3a v\u00e0 \u0111\u00e3 \u0111\u01b0\u1ee3c m\u1edf kh\u00f3a, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng CELL, n\u00f3 s\u1ebd tr\u1ea3 v\u1ec1 th\u00f4ng tin v\u1ec1 \u0111\u1ecbnh d\u1ea1ng, v\u1ecb tr\u00ed v\u00e0 c\u00e1c thu\u1ed9c t\u00ednh kh\u00e1c n\u1ebfu ch\u1ec9 \u0111\u1ecbnh \u00f4 \u0111\u00f3.<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">\u0110\u1ec3 x\u00e1c \u0111\u1ecbnh t\u00ecnh tr\u1ea1ng b\u1ea3o v\u1ec7 c\u1ee7a m\u1ed9t \u00f4, h\u00e3y nh\u1eadp t\u1eeb \u201cprotect\u201d trong \u0111\u1ed1i s\u1ed1 \u0111\u1ea7u ti\u00ean c\u1ee7a c\u00f4ng th\u1ee9c CELL v\u00e0 \u0111\u1ecba ch\u1ec9 \u00f4 trong \u0111\u1ed1i s\u1ed1 th\u1ee9 hai. V\u00ed d\u1ee5:<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">=CELL(\u201cprotect\u201d, A1)<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">N\u1ebfu A1 b\u1ecb kh\u00f3a, c\u00f4ng th\u1ee9c tr\u00ean tr\u1ea3 v\u1ec1 1 (TRUE), v\u00e0 n\u1ebfu n\u00f3 \u0111\u01b0\u1ee3c m\u1edf kh\u00f3a, c\u00f4ng th\u1ee9c s\u1ebd tr\u1ea3 v\u1ec1 0 (FALSE) nh\u01b0 th\u1ec3 hi\u1ec7n trong h\u00ecnh b\u00ean d\u01b0\u1edbi (c\u00f4ng th\u1ee9c n\u1eb1m trong c\u00e1c \u00f4 B1 v\u00e0 B2):<\/span><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7756\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/21-1-1.png\" width=\"471\" height=\"65\" title=\"21-1-1\"><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> D\u00f9 c\u00e1ch n\u00e0y r\u1ea5t d\u1ec5 th\u1ef1c hi\u1ec7n nh\u01b0ng n\u1ebfu b\u1ea1n c\u00f3 nhi\u1ec1u c\u1ed9t d\u1eef li\u1ec7u, c\u00e1ch ti\u1ebfp c\u1eadn tr\u00ean kh\u00f4ng ph\u1ea3i l\u00e0 c\u00e1ch t\u1ed1t nh\u1ea5t. S\u1ebd thu\u1eadn ti\u1ec7n h\u01a1n nhi\u1ec1u n\u1ebfu c\u00f3 th\u1ec3 xem t\u1ea5t c\u1ea3 c\u00e1c \u00f4 b\u1ecb kh\u00f3a ho\u1eb7c \u0111\u00e3 \u0111\u01b0\u1ee3c m\u1edf kh\u00f3a h\u01a1n l\u00e0 ph\u00e2n lo\u1ea1i ra.<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Giai_phap_la_lam_noi_bat_cac_o_bi_khoa_va_hoac_da_duoc_mo_khoa_bang_cach_tao_ra_mot_quy_tac_dinh_dang_co_dieu_kien_dua_tren_cac_cong_thuc_sau\"><\/span><span style=\"font-family: 'Times New Roman', Times\">Gi\u1ea3i ph\u00e1p l\u00e0 l\u00e0m n\u1ed5i b\u1eadt c\u00e1c \u00f4 b\u1ecb kh\u00f3a v\u00e0 \/ ho\u1eb7c \u0111\u00e3 \u0111\u01b0\u1ee3c m\u1edf kh\u00f3a b\u1eb1ng c\u00e1ch t\u1ea1o ra m\u1ed9t quy t\u1eafc \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n d\u1ef1a tr\u00ean c\u00e1c c\u00f4ng th\u1ee9c sau:<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-family: 'Times New Roman', Times\">\u2013 \u0110\u1ec3 l\u00e0m n\u1ed5i b\u1eadt c\u00e1c \u00f4 \u0111\u00e3 b\u1ecb kh\u00f3a: =CELL(\u201cprotect\u201d, A1)=1<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> \u2013 \u0110\u1ec3 \u0111\u00e1nh d\u1ea5u c\u00e1c \u00f4 \u0111\u00e3 m\u1edf kh\u00f3a: =CELL(\u201cprotect\u201d, A1)=0<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> Tr\u01b0\u1eddng h\u1ee3p A1 l\u00e0 \u00f4 s\u00e1t b\u00ean tr\u00e1i trong ph\u1ea1m vi \u0111\u01b0\u1ee3c quy \u0111\u1ecbnh b\u1edfi quy t\u1eafc \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n c\u1ee7a b\u1ea1n.<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">V\u00ed d\u1ee5, \u1edf \u0111\u00e2y c\u00f3 m\u1ed9t b\u1ea3ng nh\u1ecf v\u00e0 kh\u00f3a c\u00e1c \u00f4 B2:D2 c\u00f3 ch\u1ee9a c\u00f4ng th\u1ee9c SUM. \u1ea2nh ch\u1ee5p m\u00e0n h\u00ecnh sau minh h\u1ecda quy t\u1eafc l\u00e0m n\u1ed5i b\u1eadt c\u00e1c \u00f4 b\u1ecb kh\u00f3a:<\/span><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7757\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/22-1.png\" width=\"401\" height=\"525\" title=\"22-1\"><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">Ch\u00fa th\u00edch. T\u00ednh n\u0103ng \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n b\u1ecb v\u00f4 hi\u1ec7u tr\u00ean m\u1ed9t trang \u0111\u01b0\u1ee3c b\u1ea3o v\u1ec7. V\u00ec v\u1eady, h\u00e3y ch\u1eafc ch\u1eafn t\u1eaft b\u1ea3o v\u1ec7 b\u1ea3ng tr\u01b0\u1edbc khi t\u1ea1o quy t\u1eafc (tab <strong><em>Review &gt; Changes group &gt; Unprotect Sheet<\/em><\/strong>).<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">Tr\u00ean \u0111\u00e2y, <strong>H\u1ecdc Excel Online <\/strong>\u0111\u00e3 tr\u00ecnh b\u00e0y cho c\u00e1c b\u1ea1n th\u1ea5y c\u00e1ch kh\u00f3a m\u1ed9t ho\u1eb7c nhi\u1ec1u \u00f4 trong b\u1ea3ng t\u00ednh Excel c\u1ee7a b\u1ea1n. Hy v\u1ecdng b\u00e0i vi\u1ebft n\u00e0y mang l\u1ea1i nhi\u1ec1u th\u00f4ng tin h\u1eefu \u00edch cho c\u00f4ng vi\u1ec7c c\u1ee7a b\u1ea1n. Nh\u1eefng ki\u1ebfn th\u1ee9c n\u00e0y c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 h\u1ecdc \u0111\u01b0\u1ee3c trong kh\u00f3a h\u1ecdc <a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\">Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi n\u00e2ng cao c\u1ee7a H\u1ecdc Excel Online<\/a>. Kh\u00f3a h\u1ecdc n\u00e0y cung c\u1ea5p cho b\u1ea1n c\u00e1c ki\u1ebfn th\u1ee9c \u0111\u1ea7y \u0111\u1ee7 v\u00e0 c\u00f3 h\u1ec7 th\u1ed1ng v\u1ec1 c\u00e1c h\u00e0m, c\u00e1c c\u00f4ng c\u1ee5 trong Excel, \u1ee9ng d\u1ee5ng Excel trong m\u1ed9t s\u1ed1 c\u00f4ng vi\u1ec7c. H\u00e3y tham gia ngay \u0111\u1ec3 nh\u1eadn \u0111\u01b0\u1ee3c nhi\u1ec1u \u01b0u \u0111\u00e3i.\u00a0<\/span><\/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\/2024\/12\/ex101_92019-nho-580.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":6465,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-6464","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\/6464","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=6464"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/6464\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/6465"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=6464"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=6464"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=6464"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}