{"id":28516,"date":"2022-04-12T14:57:31","date_gmt":"2022-04-12T07:57:31","guid":{"rendered":"https:\/\/divineshop.vn\/tin-tuc\/?p=28516"},"modified":"2022-04-12T14:57:31","modified_gmt":"2022-04-12T07:57:31","slug":"bo-tui-cach-khoa-o-trong-excel-nhanh-chong-chi-trong-vai-buoc","status":"publish","type":"post","link":"https:\/\/divineshop.vn\/tin-tuc\/bo-tui-cach-khoa-o-trong-excel-nhanh-chong-chi-trong-vai-buoc\/","title":{"rendered":"B\u1ecf t\u00fai c\u00e1ch kh\u00f3a \u00f4 trong Excel nhanh ch\u00f3ng ch\u1ec9 trong v\u00e0i b\u01b0\u1edbc"},"content":{"rendered":"<div class=\"content-inner\">\n<p><strong>\u0110\u1ec3 tr\u00e1nh ng\u01b0\u1eddi kh\u00e1c thay \u0111\u1ed5i th\u00f4ng tin v\u00e0 c\u00e1c gi\u00e1 tr\u1ecb trong b\u1ea3ng Excel th\u00ec vi\u1ec7c kh\u00f3a \u00f4 trong Excel l\u00e0 \u0111i\u1ec1u v\u00f4 c\u00f9ng c\u1ea7n thi\u1ebft. Tuy nhi\u00ean, b\u1ea1n kh\u00f4ng bi\u1ebft l\u00e0m c\u00e1ch n\u00e0o \u0111\u1ec3 kh\u00f3a \u00f4, c\u1ed9t trong Excel nhanh ch\u00f3ng?\u00a0<\/strong><\/p>\n<p>\u0110\u1ec3 gi\u00fap b\u1ea1n gi\u1ea3i quy\u1ebft v\u1ea5n \u0111\u1ec1 n\u00e0y, Divine Shop s\u1ebd chia s\u1ebb c\u00e1ch kh\u00f3a \u00f4 trong Excel c\u1ef1c \u0111\u01a1n gi\u1ea3n, chi ti\u1ebft v\u00e0 hi\u1ec7u qu\u1ea3 nh\u1ea5t.<\/p>\n<p><img loading=\"lazy\" class=\"aligncenter size-full wp-image-549761\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/bo-tui-cach-khoa-o-trong-excel-nhanh-chong-chi-trong-vai-buoc_6235cb7a668c5.png\" alt=\"Kh\u00f3a \u00f4 trong Excel\" width=\"1024\" height=\"683\" \/><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_17 counter-hierarchy counter-decimal ez-toc-grey\">\n<h2><span class=\"ez-toc-section\" id=\"Huong_dan_cach_khoa_o_trong_Excel_khong_cho_chinh_sua\"><\/span><span id=\"Huong_dan_cach_khoa_o_trong_Excel_khong_cho_chinh_sua\" class=\"ez-toc-section\"><\/span><strong><span style=\"font-size: 18pt\">H\u01b0\u1edbng d\u1eabn c\u00e1ch kh\u00f3a \u00f4 trong Excel kh\u00f4ng cho ch\u1ec9nh s\u1eeda<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Khi s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng Protect Sheet \u0111\u1ec3 kh\u00f3a \u00f4 trong Excel cho t\u1ea5t c\u1ea3 c\u00e1c \u00f4 trong sheet th\u00ec t\u1ea5t c\u1ea3 nh\u1eefng \u00f4 c\u00f3 trong sheet Excel s\u1ebd b\u1ecb kh\u00f3a l\u1ea1i. L\u00fac n\u00e0y, ng\u01b0\u1eddi d\u00f9ng kh\u00f4ng th\u1ec3 th\u1ef1c hi\u1ec7n b\u1ea5t k\u1ef3 thao t\u00e1c ch\u1ec9nh s\u1eeda, x\u00f3a b\u1ea5t k\u1ef3 d\u1eef li\u1ec7u c\u00f3 trong file Excel \u0111\u1ebfn khi b\u1ea1n b\u1eadt t\u00ednh n\u0103ng Unprotect Sheet \u0111\u1ec3 m\u1edf kh\u00f3a. C\u00e1c b\u1ea1n ti\u1ebfn h\u00e0nh th\u1ef1c hi\u1ec7n kh\u00f3a \u00f4 trong Excel nh\u01b0 sau:<\/p>\n<p><strong>B\u01b0\u1edbc 1:<\/strong> M\u1edf file Excel m\u00e0 b\u1ea1n mu\u1ed1n kh\u00f3a \u00f4 tr\u00ean m\u00e1y t\u00ednh l\u00ean &gt;<strong> Click chu\u1ed9t ph\u1ea3i v\u00e0o Sheet c\u1ea7n kh\u00f3a<\/strong> &gt; <strong>B\u1ea5m ch\u1ecdn Protect Sheet<\/strong> \u1edf menu t\u00f9y ch\u1ecdn.<\/p>\n<p><img loading=\"lazy\" class=\"aligncenter wp-image-549687 size-full\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/bo-tui-cach-khoa-o-trong-excel-nhanh-chong-chi-trong-vai-buoc_6235cb7ddbfde.jpeg\" alt=\"H\u01b0\u1edbng d\u1eabn c\u00e1ch kh\u00f3a \u00f4 trong Excel kh\u00f4ng cho ch\u1ec9nh s\u1eeda b\u01b0\u1edbc 1\" width=\"1005\" height=\"601\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 2:<\/strong> H\u1ed9p tho\u1ea1i Protect Sheet hi\u1ec3n th\u1ecb, b\u1ea1n ti\u1ebfn h\u00e0nh <strong>nh\u1eadp m\u1eadt kh\u1ea9u v\u00e0o \u00f4 Password to unprotect sheet<\/strong> &gt;<strong> \u1ea4n OK<\/strong> \u0111\u1ec3 m\u1eadt kh\u1ea9u \u0111\u01b0\u1ee3c thi\u1ebft l\u1eadp.<\/p>\n<p><img loading=\"lazy\" class=\"aligncenter wp-image-549688 size-full\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/bo-tui-cach-khoa-o-trong-excel-nhanh-chong-chi-trong-vai-buoc_6235cb7ebcc56.jpeg\" alt=\"H\u01b0\u1edbng d\u1eabn c\u00e1ch kh\u00f3a \u00f4 trong Excel kh\u00f4ng cho ch\u1ec9nh s\u1eeda b\u01b0\u1edbc 2\" width=\"1006\" height=\"604\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 3: Nh\u1eadp l\u1ea1i m\u1eadt kh\u1ea9u<\/strong> \u0111\u00e3 \u0111\u1eb7t m\u1ed9t l\u1ea7n n\u1eefa v\u00e0o <strong>\u00f4 Reeter password to proceed<\/strong> &gt; <strong>B\u1ea5m OK<\/strong> \u0111\u1ec3 ho\u00e0n t\u1ea5t vi\u1ec7c kh\u00f3a b\u1ea3ng.<\/p>\n<p><img loading=\"lazy\" class=\"aligncenter wp-image-549689 size-full\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/bo-tui-cach-khoa-o-trong-excel-nhanh-chong-chi-trong-vai-buoc_6235cb7f5dbfa.jpeg\" alt=\"H\u01b0\u1edbng d\u1eabn c\u00e1ch kh\u00f3a \u00f4 trong Excel kh\u00f4ng cho ch\u1ec9nh s\u1eeda b\u01b0\u1edbc 3\" width=\"1003\" height=\"601\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 4:<\/strong> Gi\u1edd \u0111\u1ec3 m\u1edf kh\u00f3a \u00f4 trong Excel, b\u1ea1n b\u00f4i \u0111en to\u00e0n b\u1ed9 sheet &gt;<strong> Click ch\u1ecdn Sheet<\/strong> v\u00e0 b\u1ea5m v\u00e0o t\u00f9y ch\u1ecdn <strong>Unprotect sheet.\u00a0<\/strong><\/p>\n<p><img loading=\"lazy\" class=\"aligncenter wp-image-549715 size-full\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/bo-tui-cach-khoa-o-trong-excel-nhanh-chong-chi-trong-vai-buoc_6235cb802ce8a.jpeg\" alt=\"H\u01b0\u1edbng d\u1eabn c\u00e1ch kh\u00f3a \u00f4 trong Excel kh\u00f4ng cho ch\u1ec9nh s\u1eeda b\u01b0\u1edbc 4\" width=\"1006\" height=\"605\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 5:<\/strong> <strong>Nh\u1eadp m\u1eadt kh\u1ea9u v\u00e0o \u00f4 Password<\/strong> v\u00e0 <strong>ch\u1ecdn OK<\/strong> l\u00e0 ho\u00e0n t\u1ea5t m\u1edf kh\u00f3a.<\/p>\n<p><img loading=\"lazy\" class=\"aligncenter wp-image-549716 size-full\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/bo-tui-cach-khoa-o-trong-excel-nhanh-chong-chi-trong-vai-buoc_6235cb8113577.jpeg\" alt=\"H\u01b0\u1edbng d\u1eabn c\u00e1ch kh\u00f3a \u00f4 trong Excel kh\u00f4ng cho ch\u1ec9nh s\u1eeda b\u01b0\u1edbc 5\" width=\"1001\" height=\"603\" \/><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cach_khoa_cot_trong_Excel_khong_cho_chinh_sua_don_gian\"><\/span><span id=\"Cach_khoa_cot_trong_Excel_khong_cho_chinh_sua_don_gian\" class=\"ez-toc-section\"><\/span><strong><span style=\"font-size: 18pt\">C\u00e1ch kh\u00f3a c\u1ed9t trong Excel kh\u00f4ng cho ch\u1ec9nh s\u1eeda \u0111\u01a1n gi\u1ea3n<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>N\u1ebfu mu\u1ed1n kh\u00f3a c\u1ed9t trong Excel ho\u1eb7c kh\u00f3a m\u1ed9t v\u00e0i \u00f4 nh\u1ea5t \u0111\u1ecbnh th\u00ec \u0111i\u1ec1u b\u1ea1n c\u1ea7n l\u00e0m l\u00e0 x\u00e1c \u0111\u1ecbnh c\u1ed9t ho\u1eb7c nh\u1eefng \u00f4 m\u00e0 b\u1ea1n mu\u1ed1n \u0111\u1ecbnh d\u1ea1ng. Th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/p>\n<p><strong>B\u01b0\u1edbc 1:<\/strong> <strong>Nh\u1ea5n Ctrl + A<\/strong> \u0111\u1ec3 ch\u1ecdn to\u00e0n b\u1ed9 \u00f4 trong Excel.<\/p>\n<p><strong>B\u01b0\u1edbc 2:<\/strong> B\u1ea5m chu\u1ed9t ph\u1ea3i v\u00e0 <strong>ch\u1ecdn Format Cells<\/strong> ho\u1eb7c b\u1ea1n <strong>\u1ea5n Ctrl + 1.\u00a0<\/strong><\/p>\n<p><img loading=\"lazy\" class=\"aligncenter wp-image-549694 size-full\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/bo-tui-cach-khoa-o-trong-excel-nhanh-chong-chi-trong-vai-buoc_6235cb81b0274.jpeg\" alt=\"C\u00e1ch kh\u00f3a c\u1ed9t trong Excel kh\u00f4ng cho ch\u1ec9nh s\u1eeda \u0111\u01a1n gi\u1ea3n b\u01b0\u1edbc 2\" width=\"1005\" height=\"607\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 3:<\/strong> C\u1eeda s\u1ed5 Format Cells xu\u1ea5t hi\u1ec7n, ch\u1ecdn <strong>tab Protection<\/strong> &gt; <strong>B\u1ecf d\u1ea5u t\u00edch \u1edf m\u1ee5c Locked<\/strong> &gt; <strong>\u1ea4n OK.\u00a0<\/strong><\/p>\n<ul>\n<li>Th\u1ef1c hi\u1ec7n vi\u1ec7c n\u00e0y nh\u1eb1m \u0111\u01b0a to\u00e0n b\u1ed9 nh\u1eefng \u00f4 trong Sheet tr\u1edf l\u1ea1i ch\u1ebf \u0111\u1ed9 kh\u00f4ng kh\u00f3a. Sau khi t\u1eaft ch\u1ebf \u0111\u1ed9 n\u00e0y s\u1ebd gi\u00fap b\u1ea1n d\u1ec5 d\u00e0ng l\u1ef1a ch\u1ecdn nh\u1eefng \u00f4 nh\u1ea5t \u0111\u1ecbnh \u0111\u1ec3 kh\u00f3a.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" class=\"aligncenter wp-image-549695 size-full\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/bo-tui-cach-khoa-o-trong-excel-nhanh-chong-chi-trong-vai-buoc_6235cb827641b.jpeg\" alt=\"C\u00e1ch kh\u00f3a c\u1ed9t trong Excel kh\u00f4ng cho ch\u1ec9nh s\u1eeda \u0111\u01a1n gi\u1ea3n b\u01b0\u1edbc 3\" width=\"1006\" height=\"604\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 4:<\/strong> Ti\u1ebfp theo, b\u1ea1n<strong> l\u1ef1a ch\u1ecdn c\u1ed9t ho\u1eb7c m\u1ed9t v\u00e0i \u00f4 c\u1ea7n kh\u00f3a<\/strong> &gt; <strong>B\u1ea5m chu\u1ed9t ph\u1ea3i v\u00e0 ch\u1ecdn Format Cell<\/strong> ho\u1eb7c <strong>nh\u1ea5p t\u1ed5 h\u1ee3p ph\u00edm Ctrl + 1.<\/strong><\/p>\n<p><img loading=\"lazy\" class=\"aligncenter wp-image-549696 size-full\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/bo-tui-cach-khoa-o-trong-excel-nhanh-chong-chi-trong-vai-buoc_6235cb844a30f.jpeg\" alt=\"C\u00e1ch kh\u00f3a c\u1ed9t trong Excel kh\u00f4ng cho ch\u1ec9nh s\u1eeda \u0111\u01a1n gi\u1ea3n b\u01b0\u1edbc 4\" width=\"1004\" height=\"602\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 5:<\/strong> \u1ede m\u1ee5c Protection,<strong> \u0111\u00e1nh d\u1ea5u t\u00edch v\u00e0o \u00f4 Locked<\/strong> \u0111\u1ec3 kh\u00f3a v\u00e0 <strong>b\u1ea5m OK.\u00a0<\/strong><\/p>\n<p><img loading=\"lazy\" class=\"aligncenter wp-image-549697 size-full\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/bo-tui-cach-khoa-o-trong-excel-nhanh-chong-chi-trong-vai-buoc_6235cb8611e01.jpeg\" alt=\"C\u00e1ch kh\u00f3a c\u1ed9t trong Excel kh\u00f4ng cho ch\u1ec9nh s\u1eeda \u0111\u01a1n gi\u1ea3n b\u01b0\u1edbc 5\" width=\"1006\" height=\"604\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 6:<\/strong> Sau \u0111\u00f3, b\u1ea1n \u1ea5n ch\u1ecdn v\u00e0o m\u1ee5c <strong>Sheet<\/strong> &gt; Nh\u1ea5p ch\u1ecdn <strong>Protect Sheet.\u00a0<\/strong><\/p>\n<p><img loading=\"lazy\" class=\"aligncenter wp-image-549698 size-full\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/bo-tui-cach-khoa-o-trong-excel-nhanh-chong-chi-trong-vai-buoc_6235cb8706f61.jpeg\" alt=\"C\u00e1ch kh\u00f3a c\u1ed9t trong Excel kh\u00f4ng cho ch\u1ec9nh s\u1eeda \u0111\u01a1n gi\u1ea3n b\u01b0\u1edbc 6\" width=\"1003\" height=\"605\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 7:<\/strong> Th\u1ef1c hi\u1ec7n nh\u1eadp m\u1eadt kh\u1ea9u v\u00e0o \u00f4<strong> Password to unprotect sheet<\/strong> &gt;<strong>\u00a0 Nh\u1ea5p ch\u1ecdn Ok <\/strong>\u0111\u1ec3 thi\u1ebft l\u1eadp.<\/p>\n<p><img loading=\"lazy\" class=\"aligncenter wp-image-549699 size-full\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/bo-tui-cach-khoa-o-trong-excel-nhanh-chong-chi-trong-vai-buoc_6235cb8892424.jpeg\" alt=\"C\u00e1ch kh\u00f3a c\u1ed9t trong Excel kh\u00f4ng cho ch\u1ec9nh s\u1eeda \u0111\u01a1n gi\u1ea3n b\u01b0\u1edbc 7\" width=\"1004\" height=\"604\" \/><\/p>\n<p><strong> B\u01b0\u1edbc 8:<\/strong> Ti\u1ebfn h\u00e0nh \u0111i\u1ec1n m\u1eadt kh\u1ea9u m\u1ed9t l\u1ea7n n\u1eefa v\u00e0o <strong>\u00f4 Reenter password to proceed <\/strong>v\u00e0<strong> ch\u1ecdn OK \u0111\u1ec3 l\u01b0u.<\/strong><\/p>\n<p><img loading=\"lazy\" class=\"aligncenter wp-image-549700 size-full\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/bo-tui-cach-khoa-o-trong-excel-nhanh-chong-chi-trong-vai-buoc_6235cb895a824.jpeg\" alt=\"C\u00e1ch kh\u00f3a c\u1ed9t trong Excel kh\u00f4ng cho ch\u1ec9nh s\u1eeda \u0111\u01a1n gi\u1ea3n b\u01b0\u1edbc 8\" width=\"1007\" height=\"603\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 9:<\/strong> \u0110\u1ec3 m\u1edf kh\u00f3a c\u1ed9t trong Excel, b\u1ea1n <strong>b\u1ea5m ch\u1ecdn v\u00e0o m\u1ee5c Sheet<\/strong> &gt;<strong> Ch\u1ecdn Unprotect Sheet<\/strong> \u0111\u1ec3 m\u1edf kh\u00f3a.<\/p>\n<p><img loading=\"lazy\" class=\"aligncenter wp-image-549701 size-full\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/bo-tui-cach-khoa-o-trong-excel-nhanh-chong-chi-trong-vai-buoc_6235cb8a2bfaf.jpeg\" alt=\"C\u00e1ch kh\u00f3a c\u1ed9t trong Excel kh\u00f4ng cho ch\u1ec9nh s\u1eeda \u0111\u01a1n gi\u1ea3n b\u01b0\u1edbc 9\" width=\"1005\" height=\"607\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 10:<\/strong> <strong>Nh\u1eadp m\u1eadt kh\u1ea9u v\u00e0o \u00f4 Password<\/strong> v\u00e0<strong> \u1ea5n OK<\/strong> l\u00e0 kh\u00f3a c\u1ed9t \u0111\u01b0\u1ee3c m\u1edf r\u1ed3i \u0111\u00f3.<\/p>\n<p><img loading=\"lazy\" class=\"aligncenter wp-image-549703 size-full\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/bo-tui-cach-khoa-o-trong-excel-nhanh-chong-chi-trong-vai-buoc_6235cb8c1c9ca.jpeg\" alt=\"C\u00e1ch kh\u00f3a c\u1ed9t trong Excel kh\u00f4ng cho ch\u1ec9nh s\u1eeda \u0111\u01a1n gi\u1ea3n b\u01b0\u1edbc 10\" width=\"1003\" height=\"600\" \/><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Khoa_cong_thuc_Excel_don_gian_va_chi_tiet\"><\/span><span id=\"Khoa_cong_thuc_Excel_don_gian_va_chi_tiet\" class=\"ez-toc-section\"><\/span><strong><span style=\"font-size: 18pt\">Kh\u00f3a c\u00f4ng th\u1ee9c Excel \u0111\u01a1n gi\u1ea3n v\u00e0 chi ti\u1ebft<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>C\u00e1ch n\u00e0y s\u1ebd gi\u00fap cho b\u1ea1n tr\u00e1nh b\u1ecb ng\u01b0\u1eddi kh\u00e1c thay \u0111\u1ed5i, ch\u1ec9nh s\u1eeda ho\u1eb7c x\u00f3a c\u00f4ng th\u1ee9c b\u1ea1n \u0111\u00e3 nh\u1eadp. V\u00ec ch\u1ec9 c\u1ea7n c\u00f4ng th\u1ee9c b\u1ecb thay \u0111\u1ed5i nh\u1ecf c\u0169ng khi\u1ebfn cho t\u1ea5t c\u1ea3 gi\u00e1 tr\u1ecb trong c\u00f4ng th\u1ee9c kh\u00f4ng c\u00f2n \u0111\u00fang. Ti\u1ebfn h\u00e0nh thao t\u00e1c kh\u00f3a c\u00f4ng th\u1ee9c trong Excel nh\u01b0 sau:<\/p>\n<p><strong>\u00a0B\u01b0\u1edbc 1:<\/strong> M\u1edf file Excel ch\u1ee9a c\u00f4ng th\u1ee9c v\u00e0 <strong>nh\u1ea5n Ctrl + A \u0111\u1ec3 ch\u1ecdn to\u00e0n b\u1ed9 b\u1ea3ng<\/strong> &gt; B\u1ea5m chu\u1ed9t ph\u1ea3i ch\u1ecdn<strong> Format Cells.\u00a0<\/strong><\/p>\n<p><img loading=\"lazy\" class=\"aligncenter wp-image-549704 size-full\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/bo-tui-cach-khoa-o-trong-excel-nhanh-chong-chi-trong-vai-buoc_6235cb8cbc3f6.jpeg\" alt=\"Kh\u00f3a c\u00f4ng th\u1ee9c Excel \u0111\u01a1n gi\u1ea3n v\u00e0 chi ti\u1ebft b\u01b0\u1edbc 1\" width=\"1000\" height=\"599\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 2:<\/strong> H\u1ed9p tho\u1ea1i Format Cells hi\u1ec3n th\u1ecb, <strong>b\u1ea5m ch\u1ecdn tab Protection<\/strong> v\u00e0 <strong>b\u1ecf d\u1ea5u t\u00edch \u1edf \u00f4 Locked <\/strong>&gt;<strong> \u1ea4n ch\u1ecdn OK<\/strong> \u0111\u1ec3 l\u01b0u thay \u0111\u1ed5i.<\/p>\n<p><img loading=\"lazy\" class=\"aligncenter wp-image-549705 size-full\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/bo-tui-cach-khoa-o-trong-excel-nhanh-chong-chi-trong-vai-buoc_6235cb8d7445f.jpeg\" alt=\"Kh\u00f3a c\u00f4ng th\u1ee9c Excel \u0111\u01a1n gi\u1ea3n v\u00e0 chi ti\u1ebft b\u01b0\u1edbc 2\" width=\"1004\" height=\"602\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 3:<\/strong> Tr\u1edf l\u1ea1i b\u1ea3ng t\u00ednh, <strong>\u0111\u1eb7t con tr\u1ecf chu\u1ed9t \u1edf v\u1ecb tr\u00ed b\u1ea5t k\u1ef3<\/strong>\u00a0&gt;<strong> B\u1ea5m tab Home<\/strong> v\u00e0<strong> click ch\u1ecdn Find &amp; Select<\/strong> trong ph\u1ea7n Editing &gt; Nh\u1ea5p ch\u1ecdn<strong> Go to Special.<\/strong><\/p>\n<p><img loading=\"lazy\" class=\"aligncenter wp-image-549706 size-full\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/bo-tui-cach-khoa-o-trong-excel-nhanh-chong-chi-trong-vai-buoc_6235cb8e15d22.jpeg\" alt=\"Kh\u00f3a c\u00f4ng th\u1ee9c Excel \u0111\u01a1n gi\u1ea3n v\u00e0 chi ti\u1ebft b\u01b0\u1edbc 3\" width=\"1298\" height=\"642\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 4:<\/strong> C\u1eeda s\u1ed5 Go to Special xu\u1ea5t hi\u1ec7n, <strong>t\u00edch ch\u1ecdn v\u00e0o m\u1ee5c Formulas<\/strong> v\u00e0 <strong>nh\u1ea5n OK.\u00a0<\/strong><\/p>\n<p><img loading=\"lazy\" class=\"aligncenter wp-image-549707 size-full\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/bo-tui-cach-khoa-o-trong-excel-nhanh-chong-chi-trong-vai-buoc_6235cb8f071e0.jpeg\" alt=\"Kh\u00f3a c\u00f4ng th\u1ee9c Excel \u0111\u01a1n gi\u1ea3n v\u00e0 chi ti\u1ebft b\u01b0\u1edbc 4\" width=\"1302\" height=\"635\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 5:<\/strong> B\u00e2y gi\u1edd, b\u1ea1n <strong>\u1ea5n v\u00e0o c\u00f4ng th\u1ee9c \u1edf file Excel<\/strong> s\u1ebd <strong>xu\u1ea5t hi\u1ec7n bi\u1ec3u t\u01b0\u1ee3ng d\u1ea5u ch\u1ea5m than.\u00a0<\/strong><\/p>\n<p><img loading=\"lazy\" class=\"aligncenter wp-image-549708 size-full\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/bo-tui-cach-khoa-o-trong-excel-nhanh-chong-chi-trong-vai-buoc_6235cb9002931.jpeg\" alt=\"Kh\u00f3a c\u00f4ng th\u1ee9c Excel \u0111\u01a1n gi\u1ea3n v\u00e0 chi ti\u1ebft b\u01b0\u1edbc 5\" width=\"1303\" height=\"645\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 6:<\/strong> <strong>Ch\u1ecdn t\u1ea5t c\u1ea3 c\u00e1c \u00f4 ch\u1ee9a c\u00f4ng th\u1ee9c<\/strong> v\u00e0<strong> b\u1ea5m v\u00e0o Format Cell.<\/strong><\/p>\n<p><img loading=\"lazy\" class=\"aligncenter wp-image-549709 size-full\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/bo-tui-cach-khoa-o-trong-excel-nhanh-chong-chi-trong-vai-buoc_6235cb912ec76.jpeg\" alt=\"Kh\u00f3a c\u00f4ng th\u1ee9c Excel \u0111\u01a1n gi\u1ea3n v\u00e0 chi ti\u1ebft b\u01b0\u1edbc 5\" width=\"1133\" height=\"641\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 7:\u00a0 Click v\u00e0o tab Protection<\/strong> v\u00e0 <strong>t\u00edch ch\u1ecdn \u00f4 Locked<\/strong> &gt; <strong>Nh\u1ea5p OK.\u00a0<\/strong><\/p>\n<ul>\n<li><strong>L\u01b0u \u00fd:<\/strong> N\u1ebfu b\u1ea1n ch\u1ecdn \u00f4 Hidden th\u00ec to\u00e0n b\u1ed9 nh\u1eefng ng\u01b0\u1eddi d\u00f9ng kh\u00e1c s\u1ebd kh\u00f4ng th\u1ec3 th\u1ea5y \u0111\u01b0\u1ee3c c\u00f4ng th\u1ee9c m\u00e0 b\u1ea1n \u0111\u00e3 nh\u1eadp \u1edf trong thanh c\u00f4ng th\u1ee9c (Formula bar) khi h\u1ecd ch\u1ecdn v\u00e0o gi\u00e1 tr\u1ecb.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" class=\"aligncenter wp-image-549710 size-full\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/bo-tui-cach-khoa-o-trong-excel-nhanh-chong-chi-trong-vai-buoc_6235cb9245147.jpeg\" alt=\"Kh\u00f3a c\u00f4ng th\u1ee9c Excel \u0111\u01a1n gi\u1ea3n v\u00e0 chi ti\u1ebft b\u01b0\u1edbc 6\" width=\"1141\" height=\"640\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 8:<\/strong> Gi\u1edd b\u1ea1n<strong> \u1ea5n ch\u1ecdn Sheet<\/strong> v\u00e0<strong> b\u1ea5m v\u00e0o t\u00f9y ch\u1ecdn Protect<\/strong> \u0111\u1ec3 kh\u00f3a c\u00f4ng th\u1ee9c trong \u00f4 Excel.<\/p>\n<p><img loading=\"lazy\" class=\"aligncenter wp-image-549711 size-full\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/bo-tui-cach-khoa-o-trong-excel-nhanh-chong-chi-trong-vai-buoc_6235cb9337161.jpeg\" alt=\"Kh\u00f3a c\u00f4ng th\u1ee9c Excel \u0111\u01a1n gi\u1ea3n v\u00e0 chi ti\u1ebft b\u01b0\u1edbc 8\" width=\"1138\" height=\"643\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 9:<\/strong> Nh\u1eadp m\u1eadt kh\u1ea9u v\u00e0o \u00f4<strong> Password to unprotect sheet<\/strong> v\u00e0<strong> nh\u1ea5p ch\u1ecdn OK &gt; Sau \u0111\u00f3, th\u1ef1c hi\u1ec7n nh\u1eadp m\u1ed9t l\u1ea7n n\u1eefa v\u00e0o \u00f4<\/strong><strong> Reeter password to proceed v\u00e0 click <\/strong><strong>OK \u0111\u1ec3 l\u01b0u.<\/strong><\/p>\n<p><img loading=\"lazy\" class=\"aligncenter wp-image-549712 size-full\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/bo-tui-cach-khoa-o-trong-excel-nhanh-chong-chi-trong-vai-buoc_6235cb94503c4.jpeg\" alt=\"Kh\u00f3a c\u00f4ng th\u1ee9c Excel \u0111\u01a1n gi\u1ea3n v\u00e0 chi ti\u1ebft b\u01b0\u1edbc 9\" width=\"1138\" height=\"642\" \/><\/p>\n<p>Khi th\u1ef1c hi\u1ec7n ho\u00e0n t\u1ea5t nh\u1eefng b\u01b0\u1edbc tr\u00ean, b\u1ea5t c\u1ee9 ai c\u0169ng kh\u00f4ng th\u1ec3 thay \u0111\u1ed5i ho\u1eb7c x\u00f3a c\u00f4ng th\u1ee9c \u0111\u01b0\u1ee3c. C\u00f2n nh\u1eefng \u00f4 kh\u00f4ng kh\u00f3a v\u1eabn s\u1eed d\u1ee5ng \u0111\u01b0\u1ee3c b\u00ecnh th\u01b0\u1eddng. C\u00e1c b\u1ea1n th\u1ef1c hi\u1ec7n m\u1edf kh\u00f3a \u00f4 \u0111\u00e3 kh\u00f3a nh\u01b0 c\u00e1c c\u00e1ch tr\u00ean.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Tam_ket\"><\/span><span id=\"Tam_ket\" class=\"ez-toc-section\"><\/span><strong><span style=\"font-size: 18pt\">T\u1ea1m k\u1ebft<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Tr\u00ean \u0111\u00e2y, Divine Shop \u0111\u00e3 h\u01b0\u1edbng d\u1eabn xong cho c\u00e1c b\u1ea1n c\u00e1ch kh\u00f3a \u00f4 trong Excel nhanh ch\u00f3ng v\u00e0 d\u1ec5 th\u1ef1c hi\u1ec7n. Ch\u1ec9 c\u1ea7n v\u00e0i b\u01b0\u1edbc \u0111\u01a1n gi\u1ea3n, c\u00e1c \u00f4, c\u1ed9t v\u00e0 c\u00f4ng th\u1ee9c trong file Excel s\u1ebd \u0111\u01b0\u1ee3c b\u1ea3o v\u1ec7 tr\u00e1nh b\u1ecb ng\u01b0\u1eddi kh\u00e1c ch\u1ec9nh s\u1eeda. Hy v\u1ecdng b\u00e0i vi\u1ebft ng\u1eafn n\u00e0y s\u1ebd h\u1eefu \u00edch v\u1edbi b\u1ea1n trong qu\u00e1 tr\u00ecnh s\u1eed d\u1ee5ng. Ch\u00fac b\u1ea1n th\u1ef1c hi\u1ec7n th\u00e0nh c\u00f4ng.<\/p>\n<p>\u00a0<\/p>\n<\/div>\n<\/div>\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/divineshop.vn\/search?q=netflix\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" width=\"728\" height=\"240\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2025\/11\/Netflix.png\" alt=\"\" class=\"wp-image-284289\" srcset=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2025\/11\/Netflix.png 728w, https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2025\/11\/Netflix-300x99.png 300w, https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2025\/11\/Netflix-150x49.png 150w, https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2025\/11\/Netflix-696x229.png 696w\" sizes=\"(max-width: 728px) 100vw, 728px\" \/><\/a><\/figure>\n\n\n\n<!--nextpage-->\n","protected":false},"excerpt":{"rendered":"<p>\u0110\u1ec3 tr\u00e1nh ng\u01b0\u1eddi kh\u00e1c thay \u0111\u1ed5i th\u00f4ng tin v\u00e0 c\u00e1c gi\u00e1 tr\u1ecb trong b\u1ea3ng Excel th\u00ec vi\u1ec7c kh\u00f3a \u00f4 trong Excel l\u00e0 \u0111i\u1ec1u v\u00f4 c\u00f9ng c\u1ea7n thi\u1ebft. Tuy nhi\u00ean, b\u1ea1n kh\u00f4ng bi\u1ebft l\u00e0m c\u00e1ch n\u00e0o \u0111\u1ec3 kh\u00f3a \u00f4, c\u1ed9t trong Excel nhanh ch\u00f3ng?\u00a0 \u0110\u1ec3 gi\u00fap b\u1ea1n gi\u1ea3i quy\u1ebft v\u1ea5n \u0111\u1ec1 n\u00e0y, Divine Shop s\u1ebd chia [&hellip;]<\/p>\n","protected":false},"author":12,"featured_media":28517,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false},"categories":[148],"tags":[238],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v18.1 (Yoast SEO v18.2) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<meta name=\"description\" content=\"\u0110\u1ec3 tr\u00e1nh ng\u01b0\u1eddi kh\u00e1c thay \u0111\u1ed5i th\u00f4ng tin v\u00e0 c\u00e1c gi\u00e1 tr\u1ecb trong b\u1ea3ng Excel th\u00ec vi\u1ec7c kh\u00f3a \u00f4 trong Excel l\u00e0 \u0111i\u1ec1u v\u00f4 c\u00f9ng c\u1ea7n thi\u1ebft. Tuy nhi\u00ean, b\u1ea1n kh\u00f4ng bi\u1ebft\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/divineshop.vn\/tin-tuc\/bo-tui-cach-khoa-o-trong-excel-nhanh-chong-chi-trong-vai-buoc\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"B\u1ecf t\u00fai c\u00e1ch kh\u00f3a \u00f4 trong Excel nhanh ch\u00f3ng ch\u1ec9 trong v\u00e0i b\u01b0\u1edbc\" \/>\n<meta property=\"og:description\" content=\"\u0110\u1ec3 tr\u00e1nh ng\u01b0\u1eddi kh\u00e1c thay \u0111\u1ed5i th\u00f4ng tin v\u00e0 c\u00e1c gi\u00e1 tr\u1ecb trong b\u1ea3ng Excel th\u00ec vi\u1ec7c kh\u00f3a \u00f4 trong Excel l\u00e0 \u0111i\u1ec1u v\u00f4 c\u00f9ng c\u1ea7n thi\u1ebft. Tuy nhi\u00ean, b\u1ea1n kh\u00f4ng bi\u1ebft\" \/>\n<meta property=\"og:url\" content=\"https:\/\/divineshop.vn\/tin-tuc\/bo-tui-cach-khoa-o-trong-excel-nhanh-chong-chi-trong-vai-buoc\/\" \/>\n<meta property=\"og:site_name\" content=\"Divine News\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/divineshop.vn\" \/>\n<meta property=\"article:published_time\" content=\"2022-04-12T07:57:31+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/bo-tui-cach-khoa-o-trong-excel-nhanh-chong-chi-trong-vai-buoc_6235cb79c9938.jpeg\" \/>\n\t<meta property=\"og:image:width\" content=\"1000\" \/>\n\t<meta property=\"og:image:height\" content=\"563\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"CTV\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"11 ph\u00fat\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#organization\",\"name\":\"Divine News\",\"url\":\"https:\/\/divineshop.vn\/tin-tuc\/\",\"sameAs\":[\"https:\/\/www.facebook.com\/divineshop.vn\",\"https:\/\/www.instagram.com\/divineshop.game\/\",\"https:\/\/www.youtube.com\/DivineTVN\"],\"logo\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#logo\",\"inLanguage\":\"vi\",\"url\":\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/Avatar.jpg\",\"contentUrl\":\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/Avatar.jpg\",\"width\":960,\"height\":960,\"caption\":\"Divine News\"},\"image\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#logo\"}},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#website\",\"url\":\"https:\/\/divineshop.vn\/tin-tuc\/\",\"name\":\"Divine News\",\"description\":\"Tin hay m\u1ed7i ng\u00e0y\",\"publisher\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/divineshop.vn\/tin-tuc\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"vi\"},{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/bo-tui-cach-khoa-o-trong-excel-nhanh-chong-chi-trong-vai-buoc\/#primaryimage\",\"inLanguage\":\"vi\",\"url\":\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/bo-tui-cach-khoa-o-trong-excel-nhanh-chong-chi-trong-vai-buoc_6235cb79c9938.jpeg\",\"contentUrl\":\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/bo-tui-cach-khoa-o-trong-excel-nhanh-chong-chi-trong-vai-buoc_6235cb79c9938.jpeg\",\"width\":1000,\"height\":563},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/bo-tui-cach-khoa-o-trong-excel-nhanh-chong-chi-trong-vai-buoc\/#webpage\",\"url\":\"https:\/\/divineshop.vn\/tin-tuc\/bo-tui-cach-khoa-o-trong-excel-nhanh-chong-chi-trong-vai-buoc\/\",\"name\":\"B\u1ecf t\u00fai c\u00e1ch kh\u00f3a \u00f4 trong Excel nhanh ch\u00f3ng ch\u1ec9 trong v\u00e0i b\u01b0\u1edbc - Divine News\",\"isPartOf\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/bo-tui-cach-khoa-o-trong-excel-nhanh-chong-chi-trong-vai-buoc\/#primaryimage\"},\"datePublished\":\"2022-04-12T07:57:31+00:00\",\"dateModified\":\"2022-04-12T07:57:31+00:00\",\"description\":\"\u0110\u1ec3 tr\u00e1nh ng\u01b0\u1eddi kh\u00e1c thay \u0111\u1ed5i th\u00f4ng tin v\u00e0 c\u00e1c gi\u00e1 tr\u1ecb trong b\u1ea3ng Excel th\u00ec vi\u1ec7c kh\u00f3a \u00f4 trong Excel l\u00e0 \u0111i\u1ec1u v\u00f4 c\u00f9ng c\u1ea7n thi\u1ebft. Tuy nhi\u00ean, b\u1ea1n kh\u00f4ng bi\u1ebft\",\"breadcrumb\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/bo-tui-cach-khoa-o-trong-excel-nhanh-chong-chi-trong-vai-buoc\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/divineshop.vn\/tin-tuc\/bo-tui-cach-khoa-o-trong-excel-nhanh-chong-chi-trong-vai-buoc\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/bo-tui-cach-khoa-o-trong-excel-nhanh-chong-chi-trong-vai-buoc\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/divineshop.vn\/tin-tuc\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"B\u1ecf t\u00fai c\u00e1ch kh\u00f3a \u00f4 trong Excel nhanh ch\u00f3ng ch\u1ec9 trong v\u00e0i b\u01b0\u1edbc\"}]},{\"@type\":\"Article\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/bo-tui-cach-khoa-o-trong-excel-nhanh-chong-chi-trong-vai-buoc\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/bo-tui-cach-khoa-o-trong-excel-nhanh-chong-chi-trong-vai-buoc\/#webpage\"},\"author\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#\/schema\/person\/ab675a5edaf3a6c9f037d16aa192413a\"},\"headline\":\"B\u1ecf t\u00fai c\u00e1ch kh\u00f3a \u00f4 trong Excel nhanh ch\u00f3ng ch\u1ec9 trong v\u00e0i b\u01b0\u1edbc\",\"datePublished\":\"2022-04-12T07:57:31+00:00\",\"dateModified\":\"2022-04-12T07:57:31+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/bo-tui-cach-khoa-o-trong-excel-nhanh-chong-chi-trong-vai-buoc\/#webpage\"},\"wordCount\":1406,\"publisher\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#organization\"},\"image\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/bo-tui-cach-khoa-o-trong-excel-nhanh-chong-chi-trong-vai-buoc\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/bo-tui-cach-khoa-o-trong-excel-nhanh-chong-chi-trong-vai-buoc_6235cb79c9938.jpeg\",\"keywords\":[\"Microsoft Excel\"],\"articleSection\":[\"M\u1eb8O HAY\"],\"inLanguage\":\"vi\",\"copyrightYear\":\"2022\",\"copyrightHolder\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#organization\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#\/schema\/person\/ab675a5edaf3a6c9f037d16aa192413a\",\"name\":\"CTV\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#personlogo\",\"inLanguage\":\"vi\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/99e99dbd029810d7d24fba0cc828c79b?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/99e99dbd029810d7d24fba0cc828c79b?s=96&d=mm&r=g\",\"caption\":\"CTV\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"description":"\u0110\u1ec3 tr\u00e1nh ng\u01b0\u1eddi kh\u00e1c thay \u0111\u1ed5i th\u00f4ng tin v\u00e0 c\u00e1c gi\u00e1 tr\u1ecb trong b\u1ea3ng Excel th\u00ec vi\u1ec7c kh\u00f3a \u00f4 trong Excel l\u00e0 \u0111i\u1ec1u v\u00f4 c\u00f9ng c\u1ea7n thi\u1ebft. Tuy nhi\u00ean, b\u1ea1n kh\u00f4ng bi\u1ebft","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/divineshop.vn\/tin-tuc\/bo-tui-cach-khoa-o-trong-excel-nhanh-chong-chi-trong-vai-buoc\/","og_locale":"vi_VN","og_type":"article","og_title":"B\u1ecf t\u00fai c\u00e1ch kh\u00f3a \u00f4 trong Excel nhanh ch\u00f3ng ch\u1ec9 trong v\u00e0i b\u01b0\u1edbc","og_description":"\u0110\u1ec3 tr\u00e1nh ng\u01b0\u1eddi kh\u00e1c thay \u0111\u1ed5i th\u00f4ng tin v\u00e0 c\u00e1c gi\u00e1 tr\u1ecb trong b\u1ea3ng Excel th\u00ec vi\u1ec7c kh\u00f3a \u00f4 trong Excel l\u00e0 \u0111i\u1ec1u v\u00f4 c\u00f9ng c\u1ea7n thi\u1ebft. Tuy nhi\u00ean, b\u1ea1n kh\u00f4ng bi\u1ebft","og_url":"https:\/\/divineshop.vn\/tin-tuc\/bo-tui-cach-khoa-o-trong-excel-nhanh-chong-chi-trong-vai-buoc\/","og_site_name":"Divine News","article_publisher":"https:\/\/www.facebook.com\/divineshop.vn","article_published_time":"2022-04-12T07:57:31+00:00","og_image":[{"width":1000,"height":563,"url":"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/bo-tui-cach-khoa-o-trong-excel-nhanh-chong-chi-trong-vai-buoc_6235cb79c9938.jpeg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_misc":{"Written by":"CTV","Est. reading time":"11 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Organization","@id":"https:\/\/divineshop.vn\/tin-tuc\/#organization","name":"Divine News","url":"https:\/\/divineshop.vn\/tin-tuc\/","sameAs":["https:\/\/www.facebook.com\/divineshop.vn","https:\/\/www.instagram.com\/divineshop.game\/","https:\/\/www.youtube.com\/DivineTVN"],"logo":{"@type":"ImageObject","@id":"https:\/\/divineshop.vn\/tin-tuc\/#logo","inLanguage":"vi","url":"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/Avatar.jpg","contentUrl":"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/Avatar.jpg","width":960,"height":960,"caption":"Divine News"},"image":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/#logo"}},{"@type":"WebSite","@id":"https:\/\/divineshop.vn\/tin-tuc\/#website","url":"https:\/\/divineshop.vn\/tin-tuc\/","name":"Divine News","description":"Tin hay m\u1ed7i ng\u00e0y","publisher":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/divineshop.vn\/tin-tuc\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"vi"},{"@type":"ImageObject","@id":"https:\/\/divineshop.vn\/tin-tuc\/bo-tui-cach-khoa-o-trong-excel-nhanh-chong-chi-trong-vai-buoc\/#primaryimage","inLanguage":"vi","url":"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/bo-tui-cach-khoa-o-trong-excel-nhanh-chong-chi-trong-vai-buoc_6235cb79c9938.jpeg","contentUrl":"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/bo-tui-cach-khoa-o-trong-excel-nhanh-chong-chi-trong-vai-buoc_6235cb79c9938.jpeg","width":1000,"height":563},{"@type":"WebPage","@id":"https:\/\/divineshop.vn\/tin-tuc\/bo-tui-cach-khoa-o-trong-excel-nhanh-chong-chi-trong-vai-buoc\/#webpage","url":"https:\/\/divineshop.vn\/tin-tuc\/bo-tui-cach-khoa-o-trong-excel-nhanh-chong-chi-trong-vai-buoc\/","name":"B\u1ecf t\u00fai c\u00e1ch kh\u00f3a \u00f4 trong Excel nhanh ch\u00f3ng ch\u1ec9 trong v\u00e0i b\u01b0\u1edbc - Divine News","isPartOf":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/#website"},"primaryImageOfPage":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/bo-tui-cach-khoa-o-trong-excel-nhanh-chong-chi-trong-vai-buoc\/#primaryimage"},"datePublished":"2022-04-12T07:57:31+00:00","dateModified":"2022-04-12T07:57:31+00:00","description":"\u0110\u1ec3 tr\u00e1nh ng\u01b0\u1eddi kh\u00e1c thay \u0111\u1ed5i th\u00f4ng tin v\u00e0 c\u00e1c gi\u00e1 tr\u1ecb trong b\u1ea3ng Excel th\u00ec vi\u1ec7c kh\u00f3a \u00f4 trong Excel l\u00e0 \u0111i\u1ec1u v\u00f4 c\u00f9ng c\u1ea7n thi\u1ebft. Tuy nhi\u00ean, b\u1ea1n kh\u00f4ng bi\u1ebft","breadcrumb":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/bo-tui-cach-khoa-o-trong-excel-nhanh-chong-chi-trong-vai-buoc\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/divineshop.vn\/tin-tuc\/bo-tui-cach-khoa-o-trong-excel-nhanh-chong-chi-trong-vai-buoc\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/divineshop.vn\/tin-tuc\/bo-tui-cach-khoa-o-trong-excel-nhanh-chong-chi-trong-vai-buoc\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/divineshop.vn\/tin-tuc\/"},{"@type":"ListItem","position":2,"name":"B\u1ecf t\u00fai c\u00e1ch kh\u00f3a \u00f4 trong Excel nhanh ch\u00f3ng ch\u1ec9 trong v\u00e0i b\u01b0\u1edbc"}]},{"@type":"Article","@id":"https:\/\/divineshop.vn\/tin-tuc\/bo-tui-cach-khoa-o-trong-excel-nhanh-chong-chi-trong-vai-buoc\/#article","isPartOf":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/bo-tui-cach-khoa-o-trong-excel-nhanh-chong-chi-trong-vai-buoc\/#webpage"},"author":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/#\/schema\/person\/ab675a5edaf3a6c9f037d16aa192413a"},"headline":"B\u1ecf t\u00fai c\u00e1ch kh\u00f3a \u00f4 trong Excel nhanh ch\u00f3ng ch\u1ec9 trong v\u00e0i b\u01b0\u1edbc","datePublished":"2022-04-12T07:57:31+00:00","dateModified":"2022-04-12T07:57:31+00:00","mainEntityOfPage":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/bo-tui-cach-khoa-o-trong-excel-nhanh-chong-chi-trong-vai-buoc\/#webpage"},"wordCount":1406,"publisher":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/#organization"},"image":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/bo-tui-cach-khoa-o-trong-excel-nhanh-chong-chi-trong-vai-buoc\/#primaryimage"},"thumbnailUrl":"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/bo-tui-cach-khoa-o-trong-excel-nhanh-chong-chi-trong-vai-buoc_6235cb79c9938.jpeg","keywords":["Microsoft Excel"],"articleSection":["M\u1eb8O HAY"],"inLanguage":"vi","copyrightYear":"2022","copyrightHolder":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/#organization"}},{"@type":"Person","@id":"https:\/\/divineshop.vn\/tin-tuc\/#\/schema\/person\/ab675a5edaf3a6c9f037d16aa192413a","name":"CTV","image":{"@type":"ImageObject","@id":"https:\/\/divineshop.vn\/tin-tuc\/#personlogo","inLanguage":"vi","url":"https:\/\/secure.gravatar.com\/avatar\/99e99dbd029810d7d24fba0cc828c79b?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/99e99dbd029810d7d24fba0cc828c79b?s=96&d=mm&r=g","caption":"CTV"}}]}},"_links":{"self":[{"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/28516"}],"collection":[{"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/users\/12"}],"replies":[{"embeddable":true,"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/comments?post=28516"}],"version-history":[{"count":2,"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/28516\/revisions"}],"predecessor-version":[{"id":72128,"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/28516\/revisions\/72128"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/media\/28517"}],"wp:attachment":[{"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/media?parent=28516"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/categories?post=28516"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/tags?post=28516"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}