{"id":1511,"date":"2020-10-18T15:50:33","date_gmt":"2020-10-18T08:50:33","guid":{"rendered":"https:\/\/hoctin.vn\/?p=1511"},"modified":"2020-10-18T15:50:35","modified_gmt":"2020-10-18T08:50:35","slug":"cach-khoa-va-mo-khoa-o-trong-excel","status":"publish","type":"post","link":"https:\/\/hoctin.vn\/cach-khoa-va-mo-khoa-o-trong-excel\/","title":{"rendered":"C\u00e1ch Kh\u00f3a File, Kh\u00f3a C\u00f4ng Th\u1ee9c V\u00e0 Kh\u00f3a \u00d4 Trong Excel"},"content":{"rendered":"\t\t
\u00a0<\/p>
B\u00e0i vi\u1ebft n\u00e0y h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n c\u00e1ch kh\u00f3a file, kh\u00f3a c\u00f4ng th\u1ee9c v\u00e0 kh\u00f3a \u00f4 trong Excel \u0111\u1ec3 b\u1ea3o v\u1ec7 c\u00e1c b\u1ea3ng t\u00ednh, \u00f4 kh\u1ecfi b\u1ecb ch\u1ec9nh s\u1eeda.<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t V\u00e0o Tab <\/span>Review <\/span>>> Ch\u1ecdn <\/span>Protect Workbook<\/span>.<\/span><\/p> C\u1eeda s\u1ed5 hi\u1ec7n l\u00ean y\u00eau c\u1ea7u b\u1ea1n \u0111\u1eb7t m\u1eadt kh\u1ea9u cho file Excel b\u1eb1ng c\u00e1ch nh\u1eadp l\u1eb7p l\u1ea1i 2 l\u1ea7n.<\/span><\/p> Khi t\u1ea1o m\u1edbi m\u1eadt kh\u1ea9u b\u1ea5t k\u1ef3, b\u1ea1n n\u00ean k\u1ebft h\u1ee3p m\u1eadt kh\u1ea9u g\u1ed3m c\u00e1c ch\u1eef c\u00e1i vi\u1ebft th\u01b0\u1eddng, vi\u1ebft hoa, ch\u1eef s\u1ed1 v\u00e0 k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t \u0111\u1ec3 m\u1eadt kh\u1ea9u c\u00f3 t\u00ednh b\u1ea3o m\u1eadt h\u01a1n.<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t \u00a0<\/span><\/p> Ch\u1ee9c n\u0103ng Protect workbook kh\u00f4ng cho ng\u01b0\u1eddi d\u00f9ng t\u1ef1 \u00fd ch\u1ec9nh s\u1eeda c\u00e1c sheet g\u00e2y \u1ea3nh h\u01b0\u1edfng \u0111\u1ebfn c\u1ea5u tr\u00fac c\u1ee7a file nh\u01b0 vi\u1ec7c th\u00eam m\u1edbi, x\u00f3a, \u0111\u1ed5i t\u00ean, di chuy\u1ec3n ho\u1eb7c copy \u0111\u1ebfn trang t\u00ednh kh\u00e1c, \u0111\u1ed5i m\u00e0u tab t\u00ean sheet, \u1ea9n, b\u1ecf \u1ea9n.<\/span><\/p> \u00a0<\/span><\/p> D\u01b0\u1edbi \u0111\u00e2y l\u00e0 h\u00ecnh \u1ea3nh c\u00e1c t\u00e1c v\u1ee5 b\u1ecb l\u00e0m m\u1edd (bi\u1ec3u hi\u1ec7n c\u1ee7a vi\u1ec7c Excel kh\u00f4ng h\u1ed7 tr\u1ee3) sau khi file Excel b\u1ecb kh\u00f3a b\u1eb1ng Protect workbook:<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t \u0110\u1ec3 m\u1edf kh\u00f3a file Excel, b\u1ea1n c\u1ea7n ghi nh\u1edb m\u1eadt kh\u1ea9u v\u00e0 ch\u1ecdn Protect workbook r\u1ed3i nh\u1eadp m\u1eadt kh\u1ea9u, \u0111\u1ebfn khi n\u00fat n\u00e0y kh\u00f4ng c\u00f2n s\u1eabm m\u00e0u t\u1ee9c l\u00e0 file Excel c\u1ee7a b\u1ea1n kh\u00f4ng c\u00f2n b\u1ecb kh\u00f3a.<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t N\u1ebfu file b\u1ea3ng t\u00ednh Excel c\u00f3 t\u1eeb 2 trang t\u00ednh (sheet) tr\u1edf l\u00ean m\u00e0 b\u1ea1n ch\u1ec9 mu\u1ed1n h\u1ea1n ch\u1ebf quy\u1ec1n ch\u1ec9nh s\u1eeda \u0111\u1ed1i v\u1edbi m\u1ed9t s\u1ed1 sheet trong file th\u00ec kh\u00f3a sheet l\u00e0 gi\u1ea3i ph\u00e1p b\u1ea1n c\u1ea7n th\u1ef1c hi\u1ec7n.<\/span><\/p> \u00a0<\/span><\/p> S\u1eed d\u1ee5ng t\u00ednh n\u0103ng <\/span>Protect Sheet<\/span> trong Tab <\/span>Review <\/span>gi\u00fap b\u1ea3o v\u1ec7 n\u1ed9i dung trong 1 sheet.<\/span><\/p> \u00a0<\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t Khi d\u00f9ng t\u00ednh n\u0103ng n\u00e0y cho c\u1ea3 sheet hay 1 v\u00f9ng trong sheet (d\u1ea3i \u00f4, c\u1ed9t ho\u1eb7c h\u00e0ng), ng\u01b0\u1eddi d\u00f9ng kh\u00f4ng th\u1ec3 t\u1ef1 \u00fd thay \u0111\u1ed5i n\u1ed9i dung trong v\u00f9ng \u0111\u01b0\u1ee3c \u00e1p d\u1ee5ng Protect Sheet.<\/span><\/p> \u00a0<\/span><\/p> T\u01b0\u01a1ng t\u1ef1 Protect Workbook, t\u00ednh n\u0103ng kh\u00f3a trang t\u00ednh Protect Sheet trong Excel c\u0169ng y\u00eau c\u1ea7u b\u1ea1n t\u1ea1o m\u1edbi m\u1eadt kh\u1ea9u \u0111\u1ec3 b\u1ea3o v\u1ec7 trang t\u00ednh.<\/span><\/p> B\u1ea1n c\u00f3 th\u1ec3 b\u1ecf qua v\u00e0 kh\u00f4ng nh\u1eadp pass v\u00e0o \u00f4 y\u00eau c\u1ea7u password. Khi \u0111\u00f3 ng\u01b0\u1eddi d\u00f9ng kh\u00e1c c\u00f3 th\u1ec3 m\u1edf kh\u00f3a m\u00e0 kh\u00f4ng c\u1ea7n m\u1eadt kh\u1ea9u.<\/span><\/p> \u00a0<\/span><\/p> Kh\u00f3a trang t\u00ednh c\u00f3 nhi\u1ec1u t\u00f9y ch\u1ecdn h\u01a1n, gi\u00fap b\u1ea1n quy\u1ebft \u0111\u1ecbnh c\u00f3 cho ph\u00e9p ng\u01b0\u1eddi d\u00f9ng kh\u00e1c t\u00e1c \u0111\u1ed9ng v\u00e0o sheet hay kh\u00f4ng, nh\u01b0 vi\u1ec7c ch\u1ecdn v\u00f9ng \u0111\u00e3 kh\u00f3a, ch\u1ecdn v\u00f9ng ch\u01b0a kh\u00f3a, \u0111\u1ecbnh d\u1ea1ng \u00f4, c\u1ed9t, d\u00f2ng, th\u00eam, b\u1edbt \u00f4 t\u00ednh,\u2026\u00a0 trong sheet \u0111ang b\u1ecb kh\u00f3a nh\u01b0 b\u1ea3ng d\u01b0\u1edbi \u0111\u00e2y:<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t C\u1ea7n nh\u1ea5n m\u1ea1nh r\u1eb1ng, t\u00ednh n\u0103ng Protect Sheet \u0111\u01b0\u1ee3c d\u00f9ng cho vi\u1ec7c kh\u00f3a to\u00e0n b\u1ed9 trang t\u00ednh \u0111ang m\u1edf, ho\u1eb7c cho ri\u00eang 1 s\u1ed1 \u00f4 t\u00ednh, c\u00f4ng th\u1ee9c.<\/span><\/p> \u00a0<\/span><\/p> N\u1ebfu kh\u00f4ng th\u1ef1c hi\u1ec7n th\u00eam 1 s\u1ed1 t\u00e1c v\u1ee5 unlock v\u00e0 lock cells \u0111\u1ec3 ch\u1ec9 kh\u00f3a c\u00e1c \u00f4 t\u00ednh \u0111\u01b0\u1ee3c \u0111\u00e1nh d\u1ea5u (s\u1ebd \u0111\u01b0\u1ee3c gi\u1edbi thi\u1ec7u \u1edf m\u1ee5c 3), th\u00ec Excel s\u1ebd lu\u00f4n m\u1eb7c \u0111\u1ecbnh t\u1ea5t c\u1ea3 c\u00e1c \u00f4 t\u00ednh trong sheet s\u1ebd \u0111\u01b0\u1ee3c kh\u00f3a khi ch\u1ecdn Protect Sheet.<\/span><\/p> \u00a0<\/span><\/p> N\u1ebfu kh\u00f4ng tick ch\u1ecdn b\u1ea5t k\u1ef3 t\u00e1c v\u1ee5 n\u00e0o m\u00e0 ng\u01b0\u1eddi d\u00f9ng kh\u00e1c \u0111\u01b0\u1ee3c ph\u00e9p th\u1ef1c hi\u1ec7n tr\u00ean sheet \u1edf \u1ea3nh tr\u00ean th\u00ec khi click v\u00e0o b\u1ea5t k\u1ef3 v\u1ecb tr\u00ed n\u00e0o trong trang t\u00ednh, Excel c\u0169ng s\u1ebd b\u00e1o l\u1ed7i nh\u01b0 sau:<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t D\u00f2ng c\u1ea3nh b\u00e1o \u00f4 t\u00ednh ho\u1eb7c bi\u1ec3u \u0111\u1ed3 b\u1ea1n c\u1ed1 g\u1eafng thay \u0111\u1ed5i n\u1eb1m trong sheet hi\u1ec7n \u0111\u00e3 b\u1ecb kh\u00f3a. \u0110\u1ec3 ch\u1ec9nh s\u1eeda c\u00e1c \u00f4 n\u00e0y, b\u1ea1n ph\u1ea3i b\u1ecf b\u1ea3o v\u1ec7 trang t\u00ednh b\u1eb1ng c\u00e1ch nh\u1eadp m\u1eadt kh\u1ea9u.<\/span><\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t Ngo\u00e0i vi\u1ec7c kh\u00f3a to\u00e0n b\u1ed9 c\u00e1c \u00f4 trong 1 trang t\u00ednh, b\u1ea1n c\u00f3 th\u1ec3 ng\u0103n ng\u01b0\u1eddi d\u00f9ng kh\u00e1c ch\u1ec9nh s\u1eeda ph\u1ea1m vi nh\u1ea5t \u0111\u1ecbnh trong b\u1ea3ng t\u00ednh Excel theo 2 c\u00e1ch ti\u1ebfp c\u1eadn:<\/span><\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\tM\u1ee5c L\u1ee5c B\u00e0i Vi\u1ebft<\/h4>\t\t\t\t\t\t\t
1, C\u00e1ch Kh\u00f3a File Excel<\/span><\/span><\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
2, Kh\u00f3a Sheet Trong Excel<\/span><\/span><\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
3, Kh\u00f3a \u00d4 Trong Excel<\/span><\/span><\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t