{"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
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t
\n\t\t\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

\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t

M\u1ee5c L\u1ee5c B\u00e0i Vi\u1ebft<\/h4>\t\t\t\t\t\t\t
<\/i><\/div>\n\t\t\t\t
<\/i><\/div>\n\t\t\t\t\t<\/div>\n\t\t
\n\t\t\t
\n\t\t\t\t<\/i>\n\t\t\t<\/div>\n\t\t<\/div>\n\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\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\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
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t
\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

\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t\"C\u00e1ch\t\t\t\t\t\t\t\t\t\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\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t
\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

\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t\"Kh\u00f3a\t\t\t\t\t\t\t\t\t\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\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t
\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\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\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
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t
\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

\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t\"C\u00e1ch\t\t\t\t\t\t\t\t\t\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\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t
\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

\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t\"Kh\u00f3a\t\t\t\t\t\t\t\t\t\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\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t
\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

\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t\"Kh\u00f3a\t\t\t\t\t\t\t\t\t\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\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t
\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

\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t\"Kh\u00f3a\t\t\t\t\t\t\t\t\t\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\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\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
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t
\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\t

\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t
    \n\t\t\t\t\t\t\t
  • \n\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t<\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\tTr\u01b0\u1eddng h\u1ee3p 1<\/span>:<\/span> <\/span>ch\u1ecdn kh\u00f3a 1 s\u1ed1 \u00f4 nh\u1ea5t \u0111\u1ecbnh.<\/span><\/span>
    Tr\u01b0\u1eddng h\u1ee3p n\u00e0y \u00e1p d\u1ee5ng khi c\u00e1c \u00f4 c\u1ea7n kh\u00f3a ch\u1ee9a c\u00f4ng th\u1ee9c, ho\u1eb7c khi s\u1ed1 \u00f4 c\u1ea7n kh\u00f3a nh\u1ecf, n\u1eb1m trong s\u1ed1 l\u01b0\u1ee3ng \u00edt d\u1ea3i \u00f4 (\u0111\u1ec3 ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 ch\u1ecdn c\u00e1c \u00f4 n\u00e0y d\u1ec5 d\u00e0ng).<\/span><\/span>
    <\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t
  • \n\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t<\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\tTr\u01b0\u1eddng h\u1ee3p 2<\/span>: <\/span>kh\u00f3a to\u00e0n b\u1ed9 trang t\u00ednh v\u00e0 m\u1edf kh\u00f3a 1 s\u1ed1 \u00f4 \u0111\u1ec3 ng\u01b0\u1eddi d\u00f9ng kh\u00e1c ch\u1ec9 ch\u1ec9nh s\u1eeda trong ph\u1ea1m vi cho ph\u00e9p n\u00e0y.<\/span><\/span>
    Tr\u01b0\u1eddng h\u1ee3p n\u00e0y th\u01b0\u1eddng \u00e1p d\u1ee5ng khi s\u1ed1 \u00f4 c\u1ea7n kh\u00f3a chi\u1ebfm ph\u1ea7n l\u1edbn trang t\u00ednh ho\u1eb7c s\u1ed1 \u00f4 kh\u00f4ng c\u1ea7n kh\u00f3a c\u00f3 s\u1ed1 l\u01b0\u1ee3ng \u00edt h\u01a1n s\u1ed1 \u00f4 c\u1ea7n kh\u00f3a v\u00e0 n\u1eb1m \u1edf c\u00e1c v\u1ecb tr\u00ed li\u1ec1n k\u1ec1 thu\u1eadn ti\u1ec7n cho ng\u01b0\u1eddi d\u00f9ng ch\u1ecdn.<\/span><\/span><\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t<\/ul>\n\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\t\t\t\t\t\t
    \n\t\t\t\t\t\t\t
    \n\t\t\t\t\t
    \n\t\t\t
    \n\t\t\t\t\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t

    3.1, Tr\u01b0\u1eddng H\u1ee3p Ch\u1ec9 Kh\u00f3a C\u00e1c \u00d4 V\u00e0 Ph\u1ea1m Vi C\u1ee5 Th\u1ec3 \u0110\u00e3 X\u00e1c \u0110\u1ecbnh Tr\u01b0\u1edbc<\/span><\/span><\/h3>\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\t\t\t\t\t\t
    \n\t\t\t\t\t\t\t
    \n\t\t\t\t\t
    \n\t\t\t
    \n\t\t\t\t\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\t\t\t\t
    \n\t\t\t\t

    Nh\u01b0 \u0111\u00e3 \u0111\u1ec1 c\u1eadp \u1edf tr\u00ean, ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 ch\u1ecdn kh\u00f4ng cho nh\u1eadp d\u1eef li\u1ec7u v\u00e0o \u00f4 trong Excel b\u1eb1ng c\u00e1ch kh\u00f3a 1 s\u1ed1 \u00f4 nh\u1ea5t \u0111\u1ecbnh.<\/span><\/p>

    \u00a0<\/span><\/p>

    C\u00e1ch n\u00e0y th\u01b0\u1eddng s\u1eed d\u1ee5ng \u0111\u1ec3 kh\u00f3a c\u00f4ng th\u1ee9c trong Excel. Ng\u01b0\u1eddi d\u00f9ng kh\u00f4ng th\u1ec3 ch\u1ecdn v\u00e0o \u00f4, gi\u00e1 tr\u1ecb \u0111\u00e3 b\u1ecb kh\u00f3a n\u00ean hay kh\u00f3a cell hay \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 \u1ea9n c\u00f4ng th\u1ee9c trong Excel.<\/span><\/p>

    \u00a0<\/span><\/p>

    C\u00f3 th\u1ec3 t\u00f3m t\u1eaft <\/span>quy tr\u00ecnh kh\u00f3a \u00f4 trong Excel <\/span>nh\u01b0 sau: \u0111\u1ecbnh d\u1ea1ng unlock to\u00e0n b\u1ed9 sheet b\u1eb1ng h\u1ed9p tho\u1ea1i Format Cells, sau \u0111\u00f3 lock cells ch\u1ec9 ri\u00eang c\u00e1c \u00f4 c\u1ea7n kh\u00f3a v\u00e0 cu\u1ed1i c\u00f9ng l\u00e0 ch\u1ecdn Protect Sheet nh\u01b0 m\u1ee5c 2.<\/span><\/p>

    \u00a0<\/span><\/p>

    Chi ti\u1ebft c\u00e1c b\u01b0\u1edbc v\u00e0 gi\u1ea3i th\u00edch 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

    \n\t\t\t\t\t\t
    \n\t\t\t\t\t\t\t
    \n\t\t\t\t\t
    \n\t\t\t
    \n\t\t\t\t\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t

    Giai \u0110o\u1ea1n 1: B\u1ecf \u0110\u1ecbnh D\u1ea1ng Locked cho To\u00e0n B\u1ed9 Sheet B\u1eb1ng H\u1ed9p Tho\u1ea1i Format Cells<\/span><\/span><\/h4>\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\t\t\t\t\t\t
    \n\t\t\t\t\t\t\t
    \n\t\t\t\t\t
    \n\t\t\t
    \n\t\t\t\t\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\t\t\t\t
    \n\t\t\t\t

    1a<\/b><\/span>,<\/b><\/span> Ch\u1ecdn c\u1ea3 trang t\u00ednh b\u1eb1ng ph\u00edm t\u1eaft <\/span>Ctrl + A<\/span>.<\/span><\/p>

    \u00a0<\/b><\/span><\/p>

    1b,<\/b><\/span> M\u1edf h\u1ed9p tho\u1ea1i<\/span> Format Cells<\/span> b\u1eb1ng 1 trong 3 c\u00e1ch sau:<\/span><\/p>

    • S\u1eed d\u1ee5ng ph\u00edm t\u1eaft Ctrl + 1<\/span><\/p><\/li>

    • Ho\u1eb7c b\u1ea5m chu\u1ed9t ph\u1ea3i, sau \u0111\u00f3 b\u1ea5m Format Cells<\/span><\/p><\/li>

    • Ho\u1eb7c v\u00e0o Home >> ch\u1ecdn Format >> Format Cells<\/span><\/p><\/li><\/ul>\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\t\t\t\t\t\t
      \n\t\t\t\t\t\t\t
      \n\t\t\t\t\t
      \n\t\t\t
      \n\t\t\t\t\t\t\t
      \n\t\t\t\t\t\t
      \n\t\t\t\t
      \n\t\t\t\t\t\t\t\t
      \n\t\t\t\t\t\t\t\t\t\t\t\t\"Kh\u00f3a\t\t\t\t\t\t\t\t\t\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\t\t\t\t\t\t
      \n\t\t\t\t\t\t\t
      \n\t\t\t\t\t
      \n\t\t\t
      \n\t\t\t\t\t\t\t
      \n\t\t\t\t\t\t
      \n\t\t\t\t
      \n\t\t\t\t\t\t\t\t
      \n\t\t\t\t

      \u00a0<\/span><\/p>

      1c<\/span>, Trong h\u1ed9p tho\u1ea1i <\/span>Format Cells<\/span>, ch\u1ecdn tab <\/span>Protection, b\u1ecf ch\u1ecdn Locked <\/span>v\u00e0 \u1ea5n <\/span>OK<\/span>.<\/span><\/p>

      L\u00ed gi\u1ea3i cho h\u00e0nh \u0111\u1ed9ng n\u00e0y, \u0111\u00f3 l\u00e0 v\u00ec Excel lu\u00f4n m\u1eb7c \u0111\u1ecbnh t\u1ea5t c\u1ea3 c\u00e1c \u00f4 trong trang t\u00ednh \u0111\u1ecbnh d\u1ea1ng Locked n\u00ean n\u1ebfu b\u1ea1n ch\u1ec9 mu\u1ed1n kh\u00f3a c\u00e1c \u00f4 nh\u1ea5t \u0111\u1ecbnh th\u00ec c\u1ea7n m\u1edf kh\u00f3a to\u00e0n b\u1ed9.<\/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\t\t\t\t\t\t
      \n\t\t\t\t\t\t\t
      \n\t\t\t\t\t
      \n\t\t\t
      \n\t\t\t\t\t\t\t
      \n\t\t\t\t\t\t
      \n\t\t\t\t
      \n\t\t\t\t\t\t\t\t
      \n\t\t\t\t\t\t\t\t\t\t\t\t\"Trong\t\t\t\t\t\t\t\t\t\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\t\t\t\t\t\t
      \n\t\t\t\t\t\t\t
      \n\t\t\t\t\t
      \n\t\t\t
      \n\t\t\t\t\t\t\t
      \n\t\t\t\t\t\t
      \n\t\t\t\t
      \n\t\t\t

      Giai \u0110o\u1ea1n 2: \u0110\u1ecbnh D\u1ea1ng Locked Cho C\u00e1c \u00d4 C\u1ea7n Kh\u00f3a B\u1eb1ng H\u1ed9p Tho\u1ea1i Format Cells<\/span><\/span><\/h4>\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\t\t\t\t\t\t
      \n\t\t\t\t\t\t\t
      \n\t\t\t\t\t
      \n\t\t\t
      \n\t\t\t\t\t\t\t
      \n\t\t\t\t\t\t
      \n\t\t\t\t
      \n\t\t\t\t\t\t\t\t
      \n\t\t\t\t

      L\u00fac n\u00e0y, \u0111\u1ec3 kh\u00f3a c\u00e1c \u00f4 ch\u1ec9 \u0111\u1ecbnh trong Excel, b\u1ea1n c\u1ea7n ch\u1ecdn ri\u00eang c\u00e1c \u00f4 n\u00e0y \u0111\u1ec3 t\u00f9y ch\u1ecdn locked.<\/span><\/p>

      \u00a0<\/b><\/span><\/p>

      2a<\/b><\/span>, Ch\u1ecdn c\u00e1c \u00f4 c\u1ea7n kh\u00f3a trong Excel:<\/span><\/p>

      • B\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00e1ch b\u1ea5m chu\u1ed9t tr\u00e1i v\u00e0o c\u00e1c \u00f4 c\u1ea7n ch\u1ecdn \u0111\u1ed3ng th\u1eddi gi\u1eef ph\u00edm Ctrl.<\/span><\/p><\/li>

      • Ho\u1eb7c n\u1ebfu b\u1ea1n c\u1ea7n kh\u00f3a to\u00e0n b\u1ed9 c\u00f4ng th\u1ee9c trong Sheet th\u00ec c\u00f3 th\u1ec3 ch\u1ecdn nhanh to\u00e0n b\u1ed9 c\u00f4ng th\u1ee9c b\u1eb1ng c\u00e1ch \u1ea5n <\/span>Ctrl + G<\/span> \u0111\u1ec3 m\u1edf h\u1ed9p tho\u1ea1i Go To >> ch\u1ecdn <\/span>Special <\/span>\u0111\u1ec3 m\u1edf h\u1ed9p tho\u1ea1i <\/span>Go To Special<\/span> >> ch\u1ecdn <\/span>Formulas <\/span>>> \u1ea5n <\/span>OK.<\/span><\/p><\/li><\/ul>\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\t\t\t\t\t\t
        \n\t\t\t\t\t\t\t
        \n\t\t\t\t\t
        \n\t\t\t
        \n\t\t\t\t\t\t\t
        \n\t\t\t\t\t\t
        \n\t\t\t\t
        \n\t\t\t\t\t\t\t\t
        \n\t\t\t\t\t\t\t\t\t\t\t\t\"M\u1edf\t\t\t\t\t\t\t\t\t\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\t\t\t\t\t\t
        \n\t\t\t\t\t\t\t
        \n\t\t\t\t\t
        \n\t\t\t
        \n\t\t\t\t\t\t\t
        \n\t\t\t\t\t\t
        \n\t\t\t\t
        \n\t\t\t\t\t\t\t\t
        \n\t\t\t\t\t\t\t\t\t\t\t\t\"C\u00e1ch\t\t\t\t\t\t\t\t\t\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\t\t\t\t\t\t
        \n\t\t\t\t\t\t\t
        \n\t\t\t\t\t
        \n\t\t\t
        \n\t\t\t\t\t\t\t
        \n\t\t\t\t\t\t
        \n\t\t\t\t
        \n\t\t\t\t\t\t\t\t
        \n\t\t\t\t

        \u00a0<\/span><\/p>

        2b<\/b>, Ng\u01b0\u1ee3c v\u1edbi giai \u0111o\u1ea1n 1, l\u00fac n\u00e0y trong h\u1ed9p tho\u1ea1i <\/span>Format Cells<\/span>, ch\u1ecdn tab <\/span>Protection, ch\u1ecdn Locked <\/span>v\u00e0 \u1ea5n <\/span>OK <\/span>\u0111\u1ec3 ch\u1ec9 \u0111\u1ecbnh c\u00e1c \u00f4 \u0111\u00e3 ch\u1ecdn s\u1ebd \u0111\u01b0\u1ee3c kh\u00f3a khi \u00e1p d\u1ee5ng Protect Sheet.<\/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\t\t\t\t\t\t
        \n\t\t\t\t\t\t\t
        \n\t\t\t\t\t
        \n\t\t\t
        \n\t\t\t\t\t\t\t
        \n\t\t\t\t\t\t
        \n\t\t\t\t
        \n\t\t\t\t\t\t\t\t
        \n\t\t\t\t\t\t\t\t\t\t\t\t\"C\u00e1ch\t\t\t\t\t\t\t\t\t\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\t\t\t\t\t\t
        \n\t\t\t\t\t\t\t
        \n\t\t\t\t\t
        \n\t\t\t
        \n\t\t\t\t\t\t\t
        \n\t\t\t\t\t\t
        \n\t\t\t\t
        \n\t\t\t

        Giai \u0110o\u1ea1n 3: S\u1eed D\u1ee5ng Protect Sheet \u0110\u1ec3 Kh\u00f3a \u00d4 Trong Excel<\/span><\/span><\/h4>\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\t\t\t\t\t\t
        \n\t\t\t\t\t\t\t
        \n\t\t\t\t\t
        \n\t\t\t
        \n\t\t\t\t\t\t\t
        \n\t\t\t\t\t\t
        \n\t\t\t\t
        \n\t\t\t\t\t\t\t\t
        \n\t\t\t\t

        T\u01b0\u01a1ng t\u1ef1 nh\u01b0 m\u1ee5c 2, c\u00e1ch kh\u00f3a sheet trong Excel, b\u1ea1n v\u00e0o tab <\/span>Review<\/span> >> Ch\u1ecdn <\/span>Protect Sheet<\/span>.<\/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

        \n\t\t\t\t\t\t
        \n\t\t\t\t\t\t\t
        \n\t\t\t\t\t
        \n\t\t\t
        \n\t\t\t\t\t\t\t
        \n\t\t\t\t\t\t
        \n\t\t\t\t
        \n\t\t\t\t\t\t\t\t
        \n\t\t\t\t

        H\u1ed9p tho\u1ea1i Protect Sheet quen thu\u1ed9c hi\u1ec7n ra, l\u00fac n\u00e0y b\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn t\u1ea1o m\u1eadt kh\u1ea9u b\u1ea3o v\u1ec7 ho\u1eb7c kh\u00f4ng; sau \u0111\u00f3 tick ch\u1ecdn \u201c<\/span>Select unlocked cells<\/span>\u201d \u0111\u1ec3 cho ph\u00e9p ng\u01b0\u1eddi d\u00f9ng \u0111\u01b0\u1ee3c ph\u00e9p ch\u1ecdn v\u00e0 ch\u1ec9nh s\u1eeda c\u00e1c \u00f4 kh\u00f4ng kh\u00f3a.<\/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

        \n\t\t\t\t\t\t
        \n\t\t\t\t\t\t\t
        \n\t\t\t\t\t
        \n\t\t\t
        \n\t\t\t\t\t\t\t
        \n\t\t\t\t\t\t
        \n\t\t\t\t
        \n\t\t\t\t\t\t\t\t
        \n\t\t\t\t\t\t\t\t\t\t\t\t\"H\u1ed9p\t\t\t\t\t\t\t\t\t\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\t\t\t\t\t\t
        \n\t\t\t\t\t\t\t
        \n\t\t\t\t\t
        \n\t\t\t
        \n\t\t\t\t\t\t\t
        \n\t\t\t\t\t\t
        \n\t\t\t\t
        \n\t\t\t\t\t\t\t\t
        \n\t\t\t\t

        \u00a0<\/span><\/p>

        K\u1ebft qu\u1ea3<\/span>: ng\u01b0\u1eddi d\u00f9ng kh\u00f4ng th\u1ec3 ch\u1ecdn v\u00e0o c\u00e1c v\u00f9ng \u0111\u00e3 kh\u00f3a \u00f4 trong Excel nh\u01b0 d\u01b0\u1edbi \u0111\u00e2y. C\u00e1c c\u00f4ng th\u1ee9c \u0111\u00e3 b\u1ecb kh\u00f3a v\u00e0 b\u1ea1n kh\u00f4ng th\u1ec3 xem \u0111\u01b0\u1ee3c chi ti\u1ebft c\u00e1c h\u00e0m \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng n\u1ebfu nh\u01b0 kh\u00f4ng c\u00f3 m\u1eadt kh\u1ea9u \u0111\u1ec3 m\u1edf 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\t\t\t\t\t\t
        \n\t\t\t\t\t\t\t
        \n\t\t\t\t\t
        \n\t\t\t
        \n\t\t\t\t\t\t\t
        \n\t\t\t\t\t\t
        \n\t\t\t\t
        \n\t\t\t\t\t\t\t\t
        \n\t\t\t\t\t\t\t\t\t\t\t\t\"K\u1ebft\t\t\t\t\t\t\t\t\t\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\t\t\t\t\t\t
        \n\t\t\t\t\t\t\t
        \n\t\t\t\t\t
        \n\t\t\t
        \n\t\t\t\t\t\t\t
        \n\t\t\t\t\t\t
        \n\t\t\t\t
        \n\t\t\t

        3.2, C\u00e1ch M\u1edf Kh\u00f3a \u00d4 Trong Excel<\/span><\/span><\/h3>\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\t\t\t\t\t\t
        \n\t\t\t\t\t\t\t
        \n\t\t\t\t\t
        \n\t\t\t
        \n\t\t\t\t\t\t\t
        \n\t\t\t\t\t\t
        \n\t\t\t\t
        \n\t\t\t\t\t\t\t\t
        \n\t\t\t\t

        \u0110\u1ec3 m\u1edf kh\u00f3a \u00f4 trong Excel, b\u1ea1n c\u1ea7n c\u00f3 m\u1eadt kh\u1ea9u. Ch\u1ecdn <\/span>Unprotect Sheet<\/span> trong tab <\/span>Review <\/span>v\u00e0 nh\u1eadp m\u1eadt kh\u1ea9u \u0111\u1ec3 m\u1edf kh\u00f3a:<\/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

        \n\t\t\t\t\t\t
        \n\t\t\t\t\t\t\t
        \n\t\t\t\t\t
        \n\t\t\t
        \n\t\t\t\t\t\t\t
        \n\t\t\t\t\t\t
        \n\t\t\t\t
        \n\t\t\t\t\t\t\t\t
        \n\t\t\t\t\t\t\t\t\t\t\t\t\"C\u00e1ch\t\t\t\t\t\t\t\t\t\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\t\t\t\t\t\t
        \n\t\t\t\t\t\t\t
        \n\t\t\t\t\t
        \n\t\t\t
        \n\t\t\t\t\t\t\t
        \n\t\t\t\t\t\t
        \n\t\t\t\t
        \n\t\t\t

        3.3, Kh\u00f3a To\u00e0n B\u1ed9 Trang T\u00ednh V\u00e0 M\u1edf Kh\u00f3a 1 S\u1ed1 \u00d4 \u0110\u1ec3 Ng\u01b0\u1eddi D\u00f9ng Kh\u00e1c Ch\u1ec9 Ch\u1ec9nh S\u1eeda Trong Ph\u1ea1m Vi Cho Ph\u00e9p N\u00e0y<\/span><\/span><\/h3>\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\t\t\t\t\t\t
        \n\t\t\t\t\t\t\t
        \n\t\t\t\t\t
        \n\t\t\t
        \n\t\t\t\t\t\t\t
        \n\t\t\t\t\t\t
        \n\t\t\t\t
        \n\t\t\t\t\t\t\t\t
        \n\t\t\t\t

        \u0110\u1ec3 cho ph\u00e9p ng\u01b0\u1eddi d\u00f9ng kh\u00e1c c\u00f3 th\u1ec3 ch\u1ec9nh s\u1eeda 1 s\u1ed1 \u00f4 c\u1ee5 th\u1ec3 tr\u00ean trang t\u00ednh c\u1ee7a m\u00ecnh khi th\u1ef1c hi\u1ec7n b\u1ea3o v\u1ec7 trang t\u00ednh:<\/span><\/p>

        \u00a0<\/span><\/p>

        B\u01b0\u1edbc 1:<\/span> Trong tab Review >> Ch\u1ecdn <\/span>Allow Users to Edit Ranges<\/span>. L\u1ec7nh n\u00e0y ch\u1ec9 c\u00f3 th\u1ec3 ch\u1ecdn \u0111\u01b0\u1ee3c khi trang t\u00ednh kh\u00f4ng \u0111\u01b0\u1ee3c b\u1ea3o v\u1ec7.<\/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\t\t\t\t\t\t
        \n\t\t\t\t\t\t\t
        \n\t\t\t\t\t
        \n\t\t\t
        \n\t\t\t\t\t\t\t
        \n\t\t\t\t\t\t
        \n\t\t\t\t
        \n\t\t\t\t\t\t\t\t
        \n\t\t\t\t\t\t\t\t\t\t\t\t\"C\u00e1ch\t\t\t\t\t\t\t\t\t\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\t\t\t\t\t\t
        \n\t\t\t\t\t\t\t
        \n\t\t\t\t\t
        \n\t\t\t
        \n\t\t\t\t\t\t\t
        \n\t\t\t\t\t\t
        \n\t\t\t\t
        \n\t\t\t\t\t\t\t\t
        \n\t\t\t\t

        \u00a0<\/span><\/p>

        B\u01b0\u1edbc 2: <\/span>Trong h\u1ed9p tho\u1ea1i <\/span>Allow Users to Edit Ranges<\/span>, ch\u1ecdn <\/span>New <\/span>\u0111\u1ec3 m\u1edf h\u1ed9p tho\u1ea1i <\/span>New Range <\/span>v\u00e0 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><\/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\t\t\t\t\t\t
        \n\t\t\t\t\t\t\t
        \n\t\t\t\t\t
        \n\t\t\t
        \n\t\t\t\t\t\t\t
        \n\t\t\t\t\t\t
        \n\t\t\t\t
        \n\t\t\t\t\t\t\t\t
        \n\t\t\t\t\t\t\t\t\t\t\t\t\"H\u1ed9p\t\t\t\t\t\t\t\t\t\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\t\t\t\t\t\t
        \n\t\t\t\t\t\t\t
        \n\t\t\t\t\t
        \n\t\t\t
        \n\t\t\t\t\t\t\t
        \n\t\t\t\t\t\t
        \n\t\t\t\t
        \n\t\t\t\t\t\t\t\t
        \n\t\t\t\t

        B\u1ea1n c\u00f3 th\u1ec3 b\u1ecf qua \u00f4 nh\u1eadp password n\u1ebfu kh\u00f4ng y\u00eau c\u1ea7u ng\u01b0\u1eddi d\u00f9ng ph\u1ea3i c\u00f3 m\u1eadt kh\u1ea9u m\u1edbi \u0111\u01b0\u1ee3c ch\u1ec9nh s\u1eeda tr\u00ean c\u00e1c \u00f4 \u0111\u00e3 ch\u1ecdn. <\/span>C\u00f3 th\u1ec3 \u0111\u1eb7t c\u00e1c m\u1eadt kh\u1ea9u kh\u00e1c nhau cho c\u00e1c ph\u1ea1m vi \u00f4 kh\u00e1c nhau.<\/span><\/p>

        \u00a0<\/span><\/p>

        Sau khi th\u00eam c\u00e1c Ranges cho ph\u00e9p ng\u01b0\u1eddi d\u00f9ng kh\u00e1c c\u00f3 th\u1ec3 ch\u1ec9nh s\u1eeda ngay c\u1ea3 khi sheet \u0111\u00e3 b\u1ecb kh\u00f3a, h\u1ed9p tho\u1ea1i Allow Users to Edit Ranges c\u00f3 d\u1ea1ng nh\u01b0 d\u01b0\u1edbi \u0111\u00e2y. B\u1ea5m OK \u0111\u1ec3 x\u00e1c nh\u1eadn.<\/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\t\t\t\t\t\t
        \n\t\t\t\t\t\t\t
        \n\t\t\t\t\t
        \n\t\t\t
        \n\t\t\t\t\t\t\t
        \n\t\t\t\t\t\t
        \n\t\t\t\t
        \n\t\t\t\t\t\t\t\t
        \n\t\t\t\t\t\t\t\t\t\t\t\t\"M\u1edf\t\t\t\t\t\t\t\t\t\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\t\t\t\t\t\t
        \n\t\t\t\t\t\t\t
        \n\t\t\t\t\t
        \n\t\t\t
        \n\t\t\t\t\t\t\t
        \n\t\t\t\t\t\t
        \n\t\t\t\t
        \n\t\t\t\t\t\t\t\t
        \n\t\t\t\t

        \u00a0<\/span><\/p>

        B\u01b0\u1edbc 3<\/span>: Cu\u1ed1i c\u00f9ng, b\u1ea1n th\u1ef1c hi\u1ec7n c\u00e1c b\u01b0\u1edbc kh\u00f3a to\u00e0n b\u1ed9 sheet b\u1eb1ng c\u00e1ch v\u00e0o tab <\/span>Review<\/span> >> ch\u1ecdn <\/span>Protect Sheet.<\/span><\/p>

        \u00a0<\/p>

        Trong h\u1ed9p tho\u1ea1i kh\u00f3a trang t\u00ednh, ch\u1ecdn Select locked cells v\u00e0 Select unlocked cells \u0111\u1ec3 ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 ch\u1ecdn c\u00e1c \u00f4 trong sheet (tuy nhi\u00ean h\u1ecd ch\u1ec9 c\u00f3 th\u1ec3 ch\u1ec9nh s\u1eeda c\u00e1c v\u00f9ng \u0111\u00e3 quy \u0111\u1ecbnh \u1edf b\u01b0\u1edbc 2 n\u1ebfu c\u00f3 m\u1eadt kh\u1ea9u).<\/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\t\t\t\t\t\t
        \n\t\t\t\t\t\t\t
        \n\t\t\t\t\t
        \n\t\t\t
        \n\t\t\t\t\t\t\t
        \n\t\t\t\t\t\t
        \n\t\t\t\t
        \n\t\t\t\t\t\t\t\t
        \n\t\t\t\t\t\t\t\t\t\t\t\t\"Kh\u00f3a\t\t\t\t\t\t\t\t\t\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\t\t\t\t\t\t
        \n\t\t\t\t\t\t\t
        \n\t\t\t\t\t
        \n\t\t\t
        \n\t\t\t\t\t\t\t
        \n\t\t\t\t\t\t
        \n\t\t\t\t
        \n\t\t\t\t\t\t\t\t
        \n\t\t\t\t

        Sau khi th\u1ef1c hi\u1ec7n c\u00e1c b\u01b0\u1edbc tr\u00ean, trang t\u00ednh (Sheet) c\u1ee7a b\u1ea1n \u0111\u01b0\u1ee3c b\u1ea3o v\u1ec7 b\u1eb1ng m\u1eadt kh\u1ea9u, nh\u01b0ng ng\u01b0\u1eddi d\u00f9ng kh\u00e1c v\u1eabn c\u00f3 th\u1ec3 ch\u1ec9nh s\u1eeda tr\u00ean c\u00e1c \u00f4 c\u1ee5 th\u1ec3 b\u1eb1ng m\u1eadt kh\u1ea9u b\u1ea1n cung c\u1ea5p cho ph\u1ea1m vi \u0111\u00f3.<\/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

        \n\t\t\t\t\t\t
        \n\t\t\t\t\t\t\t
        \n\t\t\t\t\t
        \n\t\t\t
        \n\t\t\t\t\t\t\t
        \n\t\t\t\t\t\t
        \n\t\t\t\t
        \n\t\t\t\t\t\t\t\t
        \n\t\t\t\t

        Tr\u00ean \u0111\u00e2y l\u00e0 c\u00e1c c\u00e1ch kh\u00f3a file, kh\u00f3a c\u00f4ng th\u1ee9c v\u00e0 kh\u00f3a \u00f4 trong Excel. Hi v\u1ecdng b\u00e0i vi\u1ebft c\u1ee7a hoctin.vn \u0111\u00e3 mang l\u1ea1i cho c\u00e1c b\u1ea1n c\u00e1c th\u00f4ng tin h\u1eefu \u00edch.<\/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

        \n\t\t\t\t\t\t
        \n\t\t\t\t\t\t\t
        \n\t\t\t\t\t
        \n\t\t\t
        \n\t\t\t\t\t\t\t
        \n\t\t\t\t\t\t
        \n\t\t\t\t
        \n\t\t\t\t\t\t\t\t
        \n\t\t\t\t

        Hoctin.vn \u0111\u00e3 c\u00f3 series b\u00e0i vi\u1ebft v\u1ec1 th\u1ee7 thu\u1eadt Excel, ph\u1ee5c v\u1ee5 vi\u1ec7c \u0111\u1ecbnh d\u1ea1ng, x\u1eed l\u00fd d\u1eef li\u1ec7u v\u00e0 c\u00f4ng th\u1ee9c trong Excel, b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o c\u00e1c b\u00e0i vi\u1ebft:<\/span><\/p>

        \u00a0<\/span><\/p>

        C\u00e1ch L\u1ecdc V\u00e0 S\u1eafp X\u1ebfp D\u1eef Li\u1ec7u Trong Excel<\/a><\/p>

        H\u01b0\u1edbng D\u1eabn C\u00e1ch G\u1ed9p \u00d4 Trong Excel<\/a><\/p>

        C\u00e1c C\u00e1ch Copy Trong Excel<\/a><\/p>

        Chuy\u1ec3n Ch\u1eef Th\u01b0\u1eddng Th\u00e0nh Ch\u1eef Hoa Trong Excel V\u00e0 Ng\u01b0\u1ee3c L\u1ea1i<\/a><\/p>

        L\u00e0m Tr\u00f2n S\u1ed1 Trong Excel<\/a><\/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\t\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"

        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. M\u1ee5c L\u1ee5c B\u00e0i Vi\u1ebft 1, C\u00e1ch Kh\u00f3a File Excel V\u00e0o Tab Review >> Ch\u1ecdn Protect Workbook. C\u1eeda s\u1ed5 hi\u1ec7n l\u00ean y\u00eau c\u1ea7u b\u1ea1n \u0111\u1eb7t m\u1eadt kh\u1ea9u … Read more C\u00e1ch Kh\u00f3a File, Kh\u00f3a C\u00f4ng Th\u1ee9c V\u00e0 Kh\u00f3a \u00d4 Trong Excel<\/span><\/a><\/p>\n","protected":false},"author":3,"featured_media":1550,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[30],"tags":[60,7],"_links":{"self":[{"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/posts\/1511"}],"collection":[{"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/comments?post=1511"}],"version-history":[{"count":0,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/posts\/1511\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/media\/1550"}],"wp:attachment":[{"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/media?parent=1511"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/categories?post=1511"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/tags?post=1511"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}