{"id":226909,"date":"2023-07-20T15:44:34","date_gmt":"2023-07-20T08:44:34","guid":{"rendered":"https:\/\/hoanghamobile.com\/tin-tuc\/?p=226909"},"modified":"2023-07-20T15:44:34","modified_gmt":"2023-07-20T08:44:34","slug":"cac-cach-co-dinh-o-trong-excel","status":"publish","type":"post","link":"https:\/\/hoanghamobile.com\/tin-tuc\/cac-cach-co-dinh-o-trong-excel\/","title":{"rendered":"C\u00e1c c\u00e1ch c\u1ed1 \u0111\u1ecbnh \u00f4 trong excel"},"content":{"rendered":"<p>Khi l\u00e0m vi\u1ec7c v\u1edbi b\u1ea3ng t\u00ednh Excel, b\u1ea1n th\u01b0\u1eddng xuy\u00ean g\u1eb7p ph\u1ea3i nh\u1eefng tr\u01b0\u1eddng h\u1ee3p ph\u1ea3i \u0111\u1ecbnh d\u1ea1ng c\u00e1c \u00f4 \u0111\u1ec3 gi\u1eef gi\u00e1 tr\u1ecb c\u1ee7a ch\u00fang lu\u00f4n c\u1ed1 \u0111\u1ecbnh. \u0110i\u1ec1u n\u00e0y gi\u00fap c\u1ed1 \u0111\u1ecbnh d\u1eef li\u1ec7u ngay c\u1ea3 khi b\u1ea1n th\u1ef1c hi\u1ec7n c\u00e1c ph\u00e9p t\u00ednh ho\u1eb7c di chuy\u1ec3n c\u00e1c \u00f4 \u0111\u00f3. Trong b\u00e0i vi\u1ebft n\u00e0y, ch\u00fang ta s\u1ebd t\u00ecm hi\u1ec3u c\u00e1ch c\u1ed1 \u0111\u1ecbnh \u00f4 trong Excel \u0111\u1ec3 \u0111\u1ea3m b\u1ea3o c\u00e1c gi\u00e1 tr\u1ecb quan tr\u1ecdng c\u1ee7a b\u1ea3ng t\u00ednh lu\u00f4n \u0111\u01b0\u1ee3c b\u1ea3o to\u00e0n.<\/p>\n<h2><strong>C\u00e1ch c\u1ed1 \u0111\u1ecbnh \u00f4 trong Excel<\/strong><\/h2>\n<p>N\u1ebfu b\u1ea1n ch\u1ec9 l\u00e0m vi\u1ec7c v\u1edbi m\u1ed9t b\u1ea3ng t\u00ednh nh\u1ecf c\u00f3 v\u00e0i d\u00f2ng ho\u1eb7c c\u1ed9t, th\u00ec vi\u1ec7c ki\u1ec3m tra th\u00f4ng tin s\u1ebd t\u01b0\u01a1ng \u0111\u1ed1i \u0111\u01a1n gi\u1ea3n. Tuy nhi\u00ean, khi b\u1ea3ng t\u00ednh c\u1ee7a b\u1ea1n c\u00f3 \u0111\u1ebfn h\u00e0ng ch\u1ee5c, h\u00e0ng tr\u0103m ho\u1eb7c h\u00e0ng ngh\u00ecn d\u00f2ng, c\u1ed9t, vi\u1ec7c k\u00e9o l\u00ean xu\u1ed1ng ho\u1eb7c sang tr\u00e1i, ph\u1ea3i \u0111\u1ec3 ki\u1ec3m tra d\u1eef li\u1ec7u s\u1ebd tr\u1edf n\u00ean m\u1ea5t th\u1eddi gian h\u01a1n r\u1ea5t nhi\u1ec1u. Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, n\u1ebfu b\u1ea1n bi\u1ebft c\u00e1ch c\u1ed1 \u0111\u1ecbnh d\u00f2ng ho\u1eb7c c\u1ed9t m\u1ee5c ti\u00eau, b\u1ea1n ti\u1ebft ki\u1ec7m \u0111\u01b0\u1ee3c kha kh\u00e1 th\u1eddi gian trong vi\u1ec7c ki\u1ec3m tra xem c\u00e1c d\u1eef li\u1ec7u c\u00f3 \u0111\u00e1p \u1ee9ng y\u00eau c\u1ea7u hay ch\u1ee9a th\u00f4ng tin m\u00e0 m\u00ecnh c\u1ea7n hay kh\u00f4ng.<\/p>\n<h3><strong>D\u00f9ng k\u00fd hi\u1ec7u $ \u0111\u1ec3 c\u1ed1 \u0111\u1ecbnh \u00f4 trong Excel\u00a0<\/strong><\/h3>\n<div class=\"ChatMessage_messageRow__7yIr2\" data-complete=\"true\">\n<div class=\"ChatMessage_messageWrapper__Zf87D\">\n<div class=\"Message_row___ur0Y\">\n<div class=\"Message_botMessageBubble__CPGMI \">\n<div class=\"Markdown_markdownContainer__UyYrv\">\n<p>Vi\u1ec7c c\u1ed1 \u0111\u1ecbnh \u00f4 trong Excel l\u00e0m vi\u1ec7c sao ch\u00e9p c\u00f4ng th\u1ee9c tr\u1edf n\u00ean d\u1ec5 d\u00e0ng h\u01a1n r\u1ea5t nhi\u1ec1u, \u0111\u1eb7c bi\u1ec7t khi c\u00f3 m\u1ed9t s\u1ed1 \u0111\u1ecba ch\u1ec9 \u00f4 c\u1ea7n gi\u1eef nguy\u00ean ho\u1eb7c thay \u0111\u1ed5i trong qu\u00e1 tr\u00ecnh sao ch\u00e9p. Hi\u1ec3u r\u00f5 c\u00e1ch c\u1ed1 \u0111\u1ecbnh \u00f4 trong Excel s\u1ebd gi\u00fap b\u1ea1n linh ho\u1ea1t h\u01a1n r\u1ea5t nhi\u1ec1u trong vi\u1ec7c th\u1ef1c hi\u1ec7n c\u00e1c y\u00eau c\u1ea7u c\u1ee7a m\u00ecnh.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"Message_botOptimisticFooter__aQiG9\">Khi s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c trong Excel, nhi\u1ec1u khi ch\u00fang ta c\u1ea7n c\u1ed1 \u0111\u1ecbnh m\u1ed9t ho\u1eb7c nhi\u1ec1u \u00f4 \u0111\u1ec3 t\u00ednh to\u00e1n. \u0110\u1ec3 c\u1ed1 \u0111\u1ecbnh \u00f4, ch\u00fang ta s\u1eed d\u1ee5ng k\u00fd hi\u1ec7u $ tr\u01b0\u1edbc t\u00ean c\u1ed9t v\u00e0 s\u1ed1 h\u00e0ng c\u1ee7a \u00f4 \u0111\u00f3. V\u00ed d\u1ee5: n\u1ebfu ch\u00fang ta mu\u1ed1n c\u1ed1 \u0111\u1ecbnh \u00f4 <strong>A1<\/strong> trong c\u00f4ng th\u1ee9c, ch\u00fang ta s\u1ebd s\u1eed d\u1ee5ng <strong>$A$1<\/strong>.<\/div>\n<div><\/div>\n<div><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/co-dinh-o-trong-excel-13-1.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/co-dinh-o-trong-excel-13-1-300x113.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/co-dinh-o-trong-excel-13-1-768x288.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img fetchpriority=\"high\" decoding=\"async\" class=\"size-full wp-image-233246 aligncenter webpexpress-processed\" src=\"http:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/co-dinh-o-trong-excel-13-1.jpg\" alt=\"\" width=\"800\" height=\"300\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/co-dinh-o-trong-excel-13-1.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/co-dinh-o-trong-excel-13-1-300x113.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/co-dinh-o-trong-excel-13-1-768x288.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/div>\n<\/div>\n<\/div>\n<h3><strong>C\u1ed1 \u0111\u1ecbnh \u00f4 khi k\u00e9o chu\u1ed9t<\/strong><\/h3>\n<p>Khi ch\u00fang ta k\u00e9o c\u00f4ng th\u1ee9c t\u1eeb m\u1ed9t \u00f4 \u0111\u1ebfn m\u1ed9t \u00f4 kh\u00e1c, Excel s\u1ebd t\u1ef1 \u0111\u1ed9ng thay \u0111\u1ed5i c\u00e1c \u00f4 trong c\u00f4ng th\u1ee9c. Tuy nhi\u00ean, c\u00f3 nh\u1eefng tr\u01b0\u1eddng h\u1ee3p ch\u00fang ta mu\u1ed1n c\u1ed1 \u0111\u1ecbnh m\u1ed9t \u00f4 trong c\u00f4ng th\u1ee9c v\u00e0 kh\u00f4ng mu\u1ed1n Excel thay \u0111\u1ed5i \u00f4 \u0111\u00f3 khi k\u00e9o chu\u1ed9t. \u0110\u1ec3 c\u1ed1 \u0111\u1ecbnh \u00f4 khi k\u00e9o chu\u1ed9t, ch\u00fang ta s\u1eed d\u1ee5ng ph\u00edm F4. Khi ch\u00fang ta nh\u1ea5n ph\u00edm F4 khi ch\u1ecdn m\u1ed9t \u00f4 trong c\u00f4ng th\u1ee9c, Excel s\u1ebd t\u1ef1 \u0111\u1ed9ng th\u00eam k\u00fd hi\u1ec7u $ tr\u01b0\u1edbc t\u00ean c\u1ed9t v\u00e0 s\u1ed1 h\u00e0ng c\u1ee7a \u00f4 \u0111\u00f3.<\/p>\n<h2><strong>C\u00e1ch c\u1ed1 \u0111\u1ecbnh c\u1ed9t trong Excel<\/strong><\/h2>\n<p>Ngo\u00e0i vi\u1ec7c c\u1ed1 \u0111\u1ecbnh \u00f4 trong Excel th\u00ec vi\u1ec7c c\u1ed1 \u0111\u1ecbnh c\u1ed9t s\u1ebd gi\u00fap ng\u01b0\u1eddi d\u00f9ng d\u1ec5 d\u00e0ng theo d\u00f5i c\u00e1c th\u00f4ng tin quan tr\u1ecdng trong b\u1ea3ng t\u00ednh m\u00e0 kh\u00f4ng c\u1ea7n ph\u1ea3i cu\u1ed9n tr\u00e1i ho\u1eb7c cu\u1ed9n ph\u1ea3i qu\u00e1 nhi\u1ec1u. \u0110i\u1ec1u n\u00e0y \u0111\u1eb7c bi\u1ec7t h\u1eefu \u00edch khi b\u1ea1n l\u00e0m vi\u1ec7c v\u1edbi c\u00e1c b\u1ea3ng t\u00ednh l\u1edbn ho\u1eb7c c\u1ea7n theo d\u00f5i nhi\u1ec1u th\u00f4ng tin c\u00f9ng l\u00fac. C\u00f3 2 c\u00e1ch \u0111\u1ec3 c\u1ed1 \u0111\u1ecbnh c\u1ed9t trong Excel nh\u01b0 sau:<\/p>\n<h3><strong>C\u00e1ch c\u1ed1 \u0111\u1ecbnh c\u1ed9t \u0111\u1ea7u ti\u00ean<\/strong><\/h3>\n<p>\u0110\u1ec3 c\u1ed1 \u0111\u1ecbnh c\u1ed9t \u0111\u1ea7u ti\u00ean trong Excel, b\u1ea1n c\u00f3 th\u1ec3 l\u00e0m theo c\u00e1c b\u01b0\u1edbc sau:<\/p>\n<p><strong>B\u01b0\u1edbc 1:<\/strong> M\u1edf b\u1ea3ng t\u00ednh v\u00e0 ch\u1ecdn m\u1ed9t \u00f4 b\u1ea5t k\u1ef3 trong c\u1ed9t \u0111\u1ea7u ti\u00ean.<\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/co-dinh-o-trong-excel-6-1.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/co-dinh-o-trong-excel-6-1-300x113.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/co-dinh-o-trong-excel-6-1-768x288.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"size-full wp-image-233239 aligncenter webpexpress-processed\" src=\"http:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/co-dinh-o-trong-excel-6-1.jpg\" alt=\"\" width=\"800\" height=\"300\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/co-dinh-o-trong-excel-6-1.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/co-dinh-o-trong-excel-6-1-300x113.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/co-dinh-o-trong-excel-6-1-768x288.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><strong>B\u01b0\u1edbc 2:<\/strong> Nh\u1ea5n v\u00e0o tab <strong>View, <\/strong>ch\u1ecdn <strong>Freeze Panes, <\/strong>ti\u1ebfp t\u1ee5c ch\u1ecdn<strong> Freeze First Column<\/strong>.<\/p>\n<p>Khi th\u1ef1c hi\u1ec7n th\u00e0nh c\u00f4ng, c\u1ed9t \u0111\u1ea7u ti\u00ean s\u1ebd \u0111\u01b0\u1ee3c c\u1ed1 \u0111\u1ecbnh, b\u1ea1n s\u1ebd th\u1ea5y n\u00f3 \u0111\u01b0\u1ee3c \u0111\u00e1nh d\u1ea5u b\u1eb1ng m\u1ed9t \u0111\u01b0\u1eddng k\u1ebb \u0111\u1eadm h\u01a1n so v\u1edbi c\u00e1c d\u00f2ng v\u00e0 c\u1ed9t kh\u00e1c.<\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/co-dinh-o-trong-excel-7-1.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/co-dinh-o-trong-excel-7-1-300x113.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/co-dinh-o-trong-excel-7-1-768x288.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"size-full wp-image-233240 aligncenter webpexpress-processed\" src=\"http:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/co-dinh-o-trong-excel-7-1.jpg\" alt=\"\" width=\"800\" height=\"300\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/co-dinh-o-trong-excel-7-1.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/co-dinh-o-trong-excel-7-1-300x113.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/co-dinh-o-trong-excel-7-1-768x288.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3><strong>C\u00e1ch c\u1ed1 \u0111\u1ecbnh nhi\u1ec1u c\u1ed9t<\/strong><\/h3>\n<p>N\u1ebfu b\u1ea1n mu\u1ed1n c\u1ed1 \u0111\u1ecbnh nhi\u1ec1u c\u1ed9t, b\u1ea1n c\u00f3 th\u1ec3 l\u00e0m theo c\u00e1c b\u01b0\u1edbc sau:<\/p>\n<p><strong>B\u01b0\u1edbc 1:<\/strong> \u0110\u1ea7u ti\u00ean, h\u00e3y x\u00e1c \u0111\u1ecbnh nh\u00f3m c\u1ed9t m\u00e0 b\u1ea1n mu\u1ed1n c\u1ed1 \u0111\u1ecbnh. Sau \u0111\u00f3, ch\u1ecdn \u00f4 n\u1eb1m \u1edf d\u00f2ng \u0111\u1ea7u ti\u00ean c\u1ee7a c\u1ed9t b\u00ean ph\u1ea3i c\u1ee7a nh\u00f3m c\u1ed9t \u0111\u00f3 \u0111\u1ec3 c\u1ed1 \u0111\u1ecbnh c\u00e1c c\u1ed9t trong nh\u00f3m \u0111\u00f3. V\u00ed d\u1ee5: \u0111\u1ec3 c\u1ed1 \u0111\u1ecbnh hai c\u1ed9t \u0111\u1ea7u ti\u00ean trong b\u1ea3ng t\u00ednh, b\u1ea1n c\u1ea7n ch\u1ecdn \u00f4 <strong>C1<\/strong>.<\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/co-dinh-o-trong-excel-8-1.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/co-dinh-o-trong-excel-8-1-300x113.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/co-dinh-o-trong-excel-8-1-768x288.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-233241 aligncenter webpexpress-processed\" src=\"http:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/co-dinh-o-trong-excel-8-1.jpg\" alt=\"\" width=\"800\" height=\"300\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/co-dinh-o-trong-excel-8-1.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/co-dinh-o-trong-excel-8-1-300x113.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/co-dinh-o-trong-excel-8-1-768x288.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><strong>B\u01b0\u1edbc 2:<\/strong> Nh\u1ea5n v\u00e0o tab <strong>View, <\/strong>b\u1ea1n ch\u1ecdn<strong> Freeze Panes,<\/strong> nh\u1ea5n ch\u1ecdn ti\u1ebfp<strong>\u00a0Freeze Panes<\/strong>.<\/p>\n<p>Khi th\u1ef1c hi\u1ec7n th\u00e0nh c\u00f4ng, c\u1ed9t \u0111\u1ea7u ti\u00ean s\u1ebd \u0111\u01b0\u1ee3c c\u1ed1 \u0111\u1ecbnh, b\u1ea1n s\u1ebd th\u1ea5y n\u00f3 \u0111\u01b0\u1ee3c \u0111\u00e1nh d\u1ea5u b\u1eb1ng m\u1ed9t \u0111\u01b0\u1eddng k\u1ebb \u0111\u1eadm h\u01a1n so v\u1edbi c\u00e1c d\u00f2ng v\u00e0 c\u1ed9t kh\u00e1c.<\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/co-dinh-o-trong-excel-9-1.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/co-dinh-o-trong-excel-9-1-300x113.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/co-dinh-o-trong-excel-9-1-768x288.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-233242 aligncenter webpexpress-processed\" src=\"http:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/co-dinh-o-trong-excel-9-1.jpg\" alt=\"\" width=\"800\" height=\"300\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/co-dinh-o-trong-excel-9-1.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/co-dinh-o-trong-excel-9-1-300x113.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/co-dinh-o-trong-excel-9-1-768x288.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h2><strong>C\u00e1ch c\u1ed1 \u0111\u1ecbnh d\u00f2ng trong Excel<\/strong><\/h2>\n<p>Trong Excel, n\u1ebfu b\u1ea1n c\u1ea7n l\u00e0m vi\u1ec7c v\u1edbi c\u00e1c b\u1ea3ng t\u00ednh c\u00f3 nhi\u1ec1u th\u00f4ng tin v\u00e0 d\u1eef li\u1ec7u, vi\u1ec7c c\u1ed1 \u0111\u1ecbnh d\u00f2ng s\u1ebd gi\u00fap b\u1ea1n ti\u1ebft ki\u1ec7m th\u1eddi gian v\u00e0 d\u1ec5 d\u00e0ng theo d\u00f5i c\u00e1c th\u00f4ng tin quan tr\u1ecdng m\u00e0 kh\u00f4ng c\u1ea7n ph\u1ea3i cu\u1ed9n trang l\u00ean ho\u1eb7c xu\u1ed1ng. V\u1edbi t\u00ednh n\u0103ng n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 c\u1ed1 \u0111\u1ecbnh c\u00e1c d\u00f2ng ti\u00eau \u0111\u1ec1 ho\u1eb7c d\u1eef li\u1ec7u quan tr\u1ecdng \u0111\u1ec3 d\u1ec5 d\u00e0ng theo d\u00f5i khi di chuy\u1ec3n trang. V\u1eady l\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 c\u1ed1 \u0111\u1ecbnh d\u00f2ng trong Excel? N\u00f3 c\u00f3 gi\u1ed1ng v\u1edbi c\u00e1ch th\u1ef1c hi\u1ec7n c\u1ed1 \u0111\u1ecbnh \u00f4 trong Excel kh\u00f4ng?<\/p>\n<h3><strong>C\u00e1ch c\u1ed1 \u0111\u1ecbnh d\u00f2ng \u0111\u1ea7u ti\u00ean<\/strong><\/h3>\n<p><strong>B\u01b0\u1edbc 1:<\/strong> M\u1edf b\u1ea3ng t\u00ednh v\u00e0 ch\u1ecdn m\u1ed9t \u00f4 b\u1ea5t k\u1ef3 trong d\u00f2ng \u0111\u1ea7u ti\u00ean.<\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/co-dinh-o-trong-excel-1-1.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/co-dinh-o-trong-excel-1-1-300x113.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/co-dinh-o-trong-excel-1-1-768x288.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-233234 aligncenter webpexpress-processed\" src=\"http:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/co-dinh-o-trong-excel-1-1.jpg\" alt=\"\" width=\"800\" height=\"300\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/co-dinh-o-trong-excel-1-1.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/co-dinh-o-trong-excel-1-1-300x113.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/co-dinh-o-trong-excel-1-1-768x288.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><strong>B\u01b0\u1edbc 2: <\/strong>Nh\u1ea5n v\u00e0o tab <strong>View,<\/strong> t\u00f9y ch\u1ecdn<strong> Freeze Panes, <\/strong>sau \u0111\u00f3 ch\u1ecdn<strong> Freeze Top Row.<\/strong><\/p>\n<p>Sau khi ho\u00e0n t\u1ea5t, d\u00f2ng d\u1eef li\u1ec7u \u0111\u00e3 \u0111\u01b0\u1ee3c c\u1ed1 \u0111\u1ecbnh s\u1ebd \u0111\u01b0\u1ee3c \u0111\u00e1nh d\u1ea5u b\u1eb1ng m\u1ed9t \u0111\u01b0\u1eddng k\u1ebb \u0111en \u0111\u1eadm h\u01a1n so v\u1edbi c\u00e1c d\u00f2ng kh\u00e1c, n\u1eb1m ph\u00eda d\u01b0\u1edbi \u00f4 d\u1eef li\u1ec7u \u0111\u00e3 \u0111\u01b0\u1ee3c c\u1ed1 \u0111\u1ecbnh.<\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/co-dinh-o-trong-excel-2-1.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/co-dinh-o-trong-excel-2-1-300x113.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/co-dinh-o-trong-excel-2-1-768x288.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-233235 aligncenter webpexpress-processed\" src=\"http:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/co-dinh-o-trong-excel-2-1.jpg\" alt=\"\" width=\"800\" height=\"300\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/co-dinh-o-trong-excel-2-1.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/co-dinh-o-trong-excel-2-1-300x113.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/co-dinh-o-trong-excel-2-1-768x288.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3><strong>C\u00e1ch c\u1ed1 \u0111\u1ecbnh nhi\u1ec1u d\u00f2ng<\/strong><\/h3>\n<p><strong>B\u01b0\u1edbc 1: <\/strong>\u0110\u1ec3 c\u1ed1 \u0111\u1ecbnh nhi\u1ec1u d\u00f2ng trong b\u1ea3ng t\u00ednh, tr\u01b0\u1edbc h\u1ebft b\u1ea1n c\u1ea7n x\u00e1c \u0111\u1ecbnh nh\u00f3m d\u00f2ng \u0111\u00f3. Ti\u1ebfp theo, h\u00e3y ch\u1ecdn \u00f4 \u1edf d\u00f2ng \u0111\u1ea7u ti\u00ean c\u1ee7a nh\u00f3m d\u00f2ng c\u1ea7n c\u1ed1 \u0111\u1ecbnh, n\u1eb1m ph\u00eda d\u01b0\u1edbi nh\u00f3m \u0111\u00f3, v\u00e0 s\u1eed d\u1ee5ng t\u00ednh n\u0103ng c\u1ed1 \u0111\u1ecbnh d\u00f2ng \u0111\u1ec3 c\u1ed1 \u0111\u1ecbnh c\u00e1c d\u00f2ng trong nh\u00f3m \u0111\u00f3. V\u00ed d\u1ee5, trong b\u1ea3ng b\u00ean d\u01b0\u1edbi, \u0111\u1ec3 c\u1ed1 \u0111\u1ecbnh 2 d\u00f2ng \u0111\u1ea7u \u0111i\u1ec1u \u0111\u1ea7u ti\u00ean b\u1ea1n c\u1ea7n l\u00e0m l\u00e0 ch\u1ecdn v\u00e0o \u00f4 <strong>A3<\/strong>.<\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/co-dinh-o-trong-excel-3-1.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/co-dinh-o-trong-excel-3-1-300x113.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/co-dinh-o-trong-excel-3-1-768x288.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-233236 aligncenter webpexpress-processed\" src=\"http:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/co-dinh-o-trong-excel-3-1.jpg\" alt=\"\" width=\"800\" height=\"300\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/co-dinh-o-trong-excel-3-1.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/co-dinh-o-trong-excel-3-1-300x113.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/co-dinh-o-trong-excel-3-1-768x288.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><strong>B\u01b0\u1edbc 2:<\/strong> Nh\u1ea5n ch\u1ecdn tab <strong>View, <\/strong>nh\u1ea5n ch\u1ecdn<strong> Freeze Panes v\u00e0 <\/strong>sau \u0111\u00f3 ch\u1ecdn<strong> Freeze Panes<\/strong>.<\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/co-dinh-o-trong-excel-4-1.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/co-dinh-o-trong-excel-4-1-300x113.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/co-dinh-o-trong-excel-4-1-768x288.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-233237 aligncenter webpexpress-processed\" src=\"http:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/co-dinh-o-trong-excel-4-1.jpg\" alt=\"\" width=\"800\" height=\"300\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/co-dinh-o-trong-excel-4-1.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/co-dinh-o-trong-excel-4-1-300x113.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/co-dinh-o-trong-excel-4-1-768x288.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p>V\u1edbi c\u00e1c thao t\u00e1c ng\u1eafn g\u1ecdn, \u0111\u01a1n gi\u1ea3n v\u00e0 d\u1ec5 nh\u1edb, b\u1ea1n \u0111\u00e3 th\u1ef1c hi\u1ec7n xong vi\u1ec7c c\u1ed1 \u0111\u1ecbnh d\u00f2ng r\u1ed3i \u0111\u1ea5y. Khi b\u1ea1n c\u1ed1 \u0111\u1ecbnh c\u00e1c d\u00f2ng trong Excel, c\u00e1c d\u00f2ng \u0111\u00f3 s\u1ebd \u0111\u01b0\u1ee3c ph\u00e2n bi\u1ec7t b\u1eb1ng m\u1ed9t \u0111\u01b0\u1eddng in \u0111\u1eadm h\u01a1n (m\u00e0u \u0111en) so v\u1edbi c\u00e1c d\u00f2ng kh\u00e1c, n\u1eb1m ngay ph\u00eda d\u01b0\u1edbi \u00f4 d\u1eef li\u1ec7u \u0111\u00e3 \u0111\u01b0\u1ee3c c\u1ed1 \u0111\u1ecbnh.<\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/co-dinh-o-trong-excel-2-1.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/co-dinh-o-trong-excel-2-1-300x113.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/co-dinh-o-trong-excel-2-1-768x288.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-233235 aligncenter webpexpress-processed\" src=\"http:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/co-dinh-o-trong-excel-2-1.jpg\" alt=\"\" width=\"800\" height=\"300\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/co-dinh-o-trong-excel-2-1.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/co-dinh-o-trong-excel-2-1-300x113.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/co-dinh-o-trong-excel-2-1-768x288.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h2><strong>C\u00e1ch c\u1ed1 \u0111\u1ecbnh nhi\u1ec1u d\u00f2ng, nhi\u1ec1u c\u1ed9t trong Excel<\/strong><\/h2>\n<p>Khi b\u1ea1n l\u00e0m vi\u1ec7c v\u1edbi c\u00e1c b\u1ea3ng t\u00ednh trong Excel, vi\u1ec7c c\u1ed1 \u0111\u1ecbnh nhi\u1ec1u d\u00f2ng ho\u1eb7c nhi\u1ec1u c\u1ed9t s\u1ebd gi\u00fap b\u1ea1n ti\u1ebft ki\u1ec7m th\u1eddi gian v\u00ec kh\u00f4ng c\u1ea7n ph\u1ea3i di chuy\u1ec3n trang l\u00ean ho\u1eb7c xu\u1ed1ng ho\u1eb7c sang tr\u00e1i, sang ph\u1ea3i qu\u00e1 nhi\u1ec1u. V\u1eady l\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 c\u1ed1 \u0111\u1ecbnh nhi\u1ec1u d\u00f2ng, nhi\u1ec1u c\u1ed9t trong Excel? C\u00e1ch th\u1ef1c hi\u1ec7n c\u00f3 gi\u1ed1ng v\u1edbi vi\u1ec7c c\u1ed1 \u0111\u1ecbnh \u00f4 trong Excel kh\u00f4ng?<\/p>\n<p>\u0110\u1ec3 c\u1ed1 \u0111\u1ecbnh nhi\u1ec1u c\u1ed9t v\u00e0 d\u00f2ng trong Excel, b\u1ea1n c\u1ea7n th\u1ef1c hi\u1ec7n c\u00e1c b\u01b0\u1edbc sau \u0111\u00e2y:<\/p>\n<p><strong>B\u01b0\u1edbc 1:<\/strong> \u0110\u1ec3 c\u1ed1 \u0111\u1ecbnh c\u00e1c c\u1ed9t v\u00e0 d\u00f2ng trong b\u1ea3ng t\u00ednh, \u0111i\u1ec1u \u0111\u1ea7u ti\u00ean b\u1ea1n c\u1ea7n l\u00e0m l\u00e0 x\u00e1c \u0111\u1ecbnh tr\u01b0\u1edbc c\u00e1c d\u00f2ng v\u00e0 c\u1ed9t \u0111\u00f3. \u0110\u1ec3 ti\u1ebfp t\u1ee5c, h\u00e3y ch\u1ecdn \u00f4 n\u1eb1m d\u01b0\u1edbi c\u00f9ng b\u00ean ph\u1ea3i c\u00f9ng c\u1ee7a d\u00f2ng cu\u1ed1i c\u00f9ng v\u00e0 c\u1ed9t cu\u1ed1i c\u00f9ng m\u00e0 b\u1ea1n mu\u1ed1n c\u1ed1 \u0111\u1ecbnh. Sau \u0111\u00f3, s\u1eed d\u1ee5ng t\u00ednh n\u0103ng c\u1ed1 \u0111\u1ecbnh c\u1ed9t v\u00e0 c\u1ed1 \u0111\u1ecbnh d\u00f2ng \u0111\u1ec3 c\u1ed1 \u0111\u1ecbnh c\u00e1c d\u00f2ng v\u00e0 c\u1ed9t trong b\u1ea3ng t\u00ednh trong b\u01b0\u1edbc ti\u1ebfp theo.<\/p>\n<p>V\u00ed d\u1ee5, trong b\u1ea3ng t\u00ednh d\u01b0\u1edbi \u0111\u00e2y, \u0111\u1ec3 c\u1ed1 \u0111\u1ecbnh 2 c\u1ed9t \u0111\u1ea7u ti\u00ean v\u00e0 2 d\u00f2ng \u0111\u1ea7u ti\u00ean c\u1ee7a b\u1ea3ng, h\u00e3y ch\u1ecdn \u00f4 <strong>C3<\/strong>, th\u1ecfa m\u00e3n v\u1ecb tr\u00ed \u00f4 n\u1eb1m b\u00ean d\u01b0\u1edbi d\u00f2ng cu\u1ed1i c\u00f9ng v\u00e0 b\u00ean ph\u1ea3i c\u00f9ng c\u1ee7a c\u1ed9t cu\u1ed1i c\u00f9ng c\u00e1c c\u1ed9t v\u00e0 d\u00f2ng m\u00e0 b\u1ea1n mu\u1ed1n c\u1ed1 \u0111\u1ecbnh.<\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/co-dinh-o-trong-excel-10-1.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/co-dinh-o-trong-excel-10-1-300x113.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/co-dinh-o-trong-excel-10-1-768x288.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-233243 aligncenter webpexpress-processed\" src=\"http:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/co-dinh-o-trong-excel-10-1.jpg\" alt=\"\" width=\"800\" height=\"300\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/co-dinh-o-trong-excel-10-1.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/co-dinh-o-trong-excel-10-1-300x113.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/co-dinh-o-trong-excel-10-1-768x288.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><strong>B\u01b0\u1edbc 2:<\/strong> Sau \u0111\u00f3, ch\u1ecdn th\u1ebb <strong>View, <\/strong>sau \u0111\u00f3 ch\u1ecdn<strong> Freeze Panes <\/strong>v\u00e0 cu\u1ed1i c\u00f9ng l\u00e0<strong> Freeze Panes<\/strong>.<\/p>\n<p>N\u1ebfu b\u1ea1n \u0111\u00e3 th\u1ef1c hi\u1ec7n \u0111\u00fang c\u00e1c b\u01b0\u1edbc tr\u00ean, th\u00ec \u0111\u01b0\u1eddng vi\u1ec1n s\u1eabm m\u00e0u s\u1ebd xu\u1ea5t hi\u1ec7n b\u00ean ph\u1ea3i v\u00e0 ngay d\u01b0\u1edbi nh\u1eefng c\u1ed9t, d\u00f2ng m\u00e0 b\u1ea1n mu\u1ed1n c\u1ed1 \u0111\u1ecbnh. \u0110i\u1ec1u n\u00e0y cho th\u1ea5y b\u1ea1n \u0111\u00e3 c\u1ed1 \u0111\u1ecbnh th\u00e0nh c\u00f4ng c\u00e1c d\u00f2ng v\u00e0 c\u1ed9t trong b\u1ea3ng t\u00ednh c\u1ee7a m\u00ecnh.<\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/co-dinh-o-trong-excel-11-1.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/co-dinh-o-trong-excel-11-1-300x113.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/co-dinh-o-trong-excel-11-1-768x288.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-233244 aligncenter webpexpress-processed\" src=\"http:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/co-dinh-o-trong-excel-11-1.jpg\" alt=\"\" width=\"800\" height=\"300\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/co-dinh-o-trong-excel-11-1.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/co-dinh-o-trong-excel-11-1-300x113.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/co-dinh-o-trong-excel-11-1-768x288.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h2><strong>C\u00e1ch b\u1ecf c\u1ed1 \u0111\u1ecbnh \u00f4, c\u1ed9t, d\u00f2ng trong Excel<\/strong><\/h2>\n<p>N\u1ebfu b\u1ea1n mu\u1ed1n b\u1ecf c\u1ed1 \u0111\u1ecbnh m\u1ed9t d\u00f2ng ho\u1eb7c c\u1ed9t trong Excel, h\u00e3y l\u00e0m theo c\u00e1c b\u01b0\u1edbc sau: V\u00e0o tab <strong>View<\/strong> tr\u00ean thanh c\u00f4ng c\u1ee5, ch\u1ecdn <strong>Freeze Panes<\/strong>, sau \u0111\u00f3 ch\u1ecdn <strong>Unfreeze Panes<\/strong>.<\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/co-dinh-o-trong-excel-12-1.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/co-dinh-o-trong-excel-12-1-300x113.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/co-dinh-o-trong-excel-12-1-768x288.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-233245 aligncenter webpexpress-processed\" src=\"http:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/co-dinh-o-trong-excel-12-1.jpg\" alt=\"\" width=\"800\" height=\"300\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/co-dinh-o-trong-excel-12-1.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/co-dinh-o-trong-excel-12-1-300x113.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/co-dinh-o-trong-excel-12-1-768x288.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p>Sau khi th\u1ef1c hi\u1ec7n c\u00e1c b\u01b0\u1edbc tr\u00ean, c\u00e1c d\u00f2ng ho\u1eb7c c\u1ed9t s\u1ebd kh\u00f4ng c\u00f2n \u0111\u01b0\u1ee3c c\u1ed1 \u0111\u1ecbnh v\u00e0 b\u1ea1n c\u00f3 th\u1ec3 t\u1ef1 do di chuy\u1ec3n trang b\u1ea3ng t\u00ednh c\u1ee7a m\u00ecnh. M\u1eb7c d\u00f9 vi\u1ec7c c\u1ed1 \u0111\u1ecbnh \u00f4 trong Excel r\u1ea5t h\u1eefu \u00edch, nh\u01b0ng c\u0169ng c\u00f3 nh\u1eefng tr\u01b0\u1eddng h\u1ee3p b\u1ea1n c\u1ea7n b\u1ecf c\u1ed1 \u0111\u1ecbnh \u0111\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1c thao t\u00e1c kh\u00e1c tr\u00ean b\u1ea3ng t\u00ednh. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t s\u1ed1 l\u00fd do v\u00ec sao b\u1ea1n n\u00ean b\u1ecf c\u1ed1 \u0111\u1ecbnh \u00f4 trong Excel:<\/p>\n<ul>\n<li>Th\u1ef1c hi\u1ec7n c\u00e1c ph\u00e9p t\u00ednh kh\u00e1c nhau: N\u1ebfu b\u1ea1n mu\u1ed1n th\u1ef1c hi\u1ec7n c\u00e1c ph\u00e9p t\u00ednh kh\u00e1c nhau tr\u00ean c\u00e1c \u00f4, c\u1ed9t, d\u00f2ng kh\u00e1c nhau trong b\u1ea3ng t\u00ednh, b\u1ea1n s\u1ebd c\u1ea7n b\u1ecf c\u1ed1 \u0111\u1ecbnh \u0111\u1ec3 di chuy\u1ec3n v\u00e0 s\u1eed d\u1ee5ng c\u00e1c \u00f4, c\u1ed9t, d\u00f2ng \u0111\u00f3 t\u00f9y \u00fd.<\/li>\n<li>Th\u1ef1c hi\u1ec7n c\u00e1c thao t\u00e1c di chuy\u1ec3n: N\u1ebfu b\u1ea1n mu\u1ed1n di chuy\u1ec3n c\u00e1c \u00f4, c\u1ed9t, d\u00f2ng trong b\u1ea3ng t\u00ednh, b\u1ea1n s\u1ebd c\u1ea7n b\u1ecf c\u1ed1 \u0111\u1ecbnh \u0111\u1ec3 c\u00f3 th\u1ec3 di chuy\u1ec3n ch\u00fang \u0111\u1ebfn v\u1ecb tr\u00ed m\u1edbi.<\/li>\n<li>Th\u1ef1c hi\u1ec7n c\u00e1c thao t\u00e1c ch\u00e8n v\u00e0 x\u00f3a: N\u1ebfu b\u1ea1n mu\u1ed1n ch\u00e8n ho\u1eb7c x\u00f3a c\u00e1c \u00f4, c\u1ed9t, d\u00f2ng trong b\u1ea3ng t\u00ednh, b\u1ea1n s\u1ebd c\u1ea7n b\u1ecf c\u1ed1 \u0111\u1ecbnh \u0111\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1c thao t\u00e1c n\u00e0y m\u1ed9t c\u00e1ch t\u1ef1 ch\u1ee7 h\u01a1n.<\/li>\n<li>Th\u1ef1c hi\u1ec7n c\u00e1c thao t\u00e1c sao ch\u00e9p v\u00e0 d\u00e1n: N\u1ebfu b\u1ea1n mu\u1ed1n sao ch\u00e9p v\u00e0 d\u00e1n c\u00e1c \u00f4, c\u1ed9t, d\u00f2ng trong b\u1ea3ng t\u00ednh, b\u1ea1n s\u1ebd c\u1ea7n b\u1ecf c\u1ed1 \u0111\u1ecbnh \u0111\u1ec3 sao ch\u00e9p v\u00e0 d\u00e1n ch\u00fang \u0111\u1ebfn v\u1ecb tr\u00ed m\u1edbi.<\/li>\n<\/ul>\n<h2><strong>Nh\u1eefng l\u1ee3i \u00edch c\u1ee7a vi\u1ec7c c\u1ed1 \u0111\u1ecbnh \u00f4 trong Excel<\/strong><\/h2>\n<p>C\u1ed1 \u0111\u1ecbnh \u00f4 trong Excel l\u00e0 m\u1ed9t k\u1ef9 n\u0103ng quan tr\u1ecdng m\u00e0 b\u1ea1n n\u00ean bi\u1ebft \u0111\u1ec3 s\u1eed d\u1ee5ng t\u1ed1i \u0111a ti\u1ec1m n\u0103ng c\u1ee7a b\u1ea3ng t\u00ednh. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 nh\u1eefng l\u1ee3i \u00edch c\u1ee7a vi\u1ec7c c\u1ed1 \u0111\u1ecbnh \u00f4, d\u00f2ng, c\u1ed9t trong Excel:<\/p>\n<ul>\n<li>B\u1ea3o v\u1ec7 d\u1eef li\u1ec7u: Khi b\u1ea1n c\u1ed1 \u0111\u1ecbnh m\u1ed9t \u00f4 trong Excel, \u0111i\u1ec1u \u0111\u00f3 s\u1ebd gi\u00fap gi\u1eef gi\u00e1 tr\u1ecb c\u1ee7a \u00f4 nguy\u00ean v\u1eb9n, ngay c\u1ea3 khi b\u1ea1n th\u1ef1c hi\u1ec7n c\u00e1c ph\u00e9p t\u00ednh ho\u1eb7c di chuy\u1ec3n c\u00e1c \u00f4 kh\u00e1c. \u0110i\u1ec1u n\u00e0y gi\u00fap b\u1ea3o v\u1ec7 d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n kh\u1ecfi b\u1ecb thay \u0111\u1ed5i ho\u1eb7c m\u1ea5t m\u00e1t.<\/li>\n<li>L\u00e0m cho b\u1ea3ng t\u00ednh d\u1ec5 \u0111\u1ecdc h\u01a1n: Khi b\u1ea1n c\u1ed1 \u0111\u1ecbnh c\u00e1c \u00f4, d\u00f2ng, c\u1ed9t quan tr\u1ecdng trong b\u1ea3ng t\u00ednh, n\u00f3 gi\u00fap cho b\u1ea3ng t\u00ednh c\u1ee7a b\u1ea1n d\u1ec5 \u0111\u1ecdc v\u00e0 d\u1ec5 hi\u1ec3u h\u01a1n. B\u1ea1n c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng t\u00ecm th\u1ea5y c\u00e1c gi\u00e1 tr\u1ecb quan tr\u1ecdng m\u00e0 kh\u00f4ng c\u1ea7n ph\u1ea3i t\u00ecm ki\u1ebfm trong to\u00e0n b\u1ed9 b\u1ea3ng t\u00ednh.<\/li>\n<li>Gi\u1ea3m thi\u1ec3u sai s\u00f3t: Khi b\u1ea1n c\u1ed1 \u0111\u1ecbnh c\u00e1c \u00f4 trong Excel, n\u00f3 gi\u00fap gi\u1ea3m thi\u1ec3u sai s\u00f3t do c\u00e1c gi\u00e1 tr\u1ecb b\u1ecb thay \u0111\u1ed5i ho\u1eb7c m\u1ea5t m\u00e1t. \u0110i\u1ec1u n\u00e0y gi\u00fap cho b\u1ea3ng t\u00ednh c\u1ee7a b\u1ea1n ch\u00ednh x\u00e1c h\u01a1n.<\/li>\n<li>T\u0103ng t\u1ed1c \u0111\u1ed9 l\u00e0m vi\u1ec7c: Khi b\u1ea1n c\u1ed1 \u0111\u1ecbnh c\u00e1c \u00f4 quan tr\u1ecdng, b\u1ea1n c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1c ph\u00e9p t\u00ednh v\u00e0 thao t\u00e1c v\u1edbi b\u1ea3ng t\u00ednh nhanh h\u01a1n m\u00e0 kh\u00f4ng ph\u1ea3i lo l\u1eafng v\u1ec1 vi\u1ec7c m\u1ea5t d\u1eef li\u1ec7u hay ph\u1ea3i t\u00ecm ki\u1ebfm c\u00e1c gi\u00e1 tr\u1ecb quan tr\u1ecdng trong b\u1ea3ng t\u00ednh.<\/li>\n<li>L\u00e0m vi\u1ec7c v\u1edbi b\u1ea3ng t\u00ednh l\u1edbn h\u01a1n: Khi b\u1ea1n l\u00e0m vi\u1ec7c v\u1edbi c\u00e1c b\u1ea3ng t\u00ednh l\u1edbn, vi\u1ec7c c\u1ed1 \u0111\u1ecbnh c\u00e1c \u00f4, d\u00f2ng, c\u1ed9t quan tr\u1ecdng s\u1ebd gi\u00fap cho b\u1ea1n qu\u1ea3n l\u00fd d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng h\u01a1n v\u00e0 gi\u1ea3m thi\u1ec3u sai s\u00f3t.<\/li>\n<\/ul>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/co-dinh-o-trong-excel-14.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/co-dinh-o-trong-excel-14-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/co-dinh-o-trong-excel-14-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-232982 aligncenter webpexpress-processed\" src=\"http:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/co-dinh-o-trong-excel-14.jpg\" alt=\"cac-cach-co-dinh-o-trong-excel-14\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/co-dinh-o-trong-excel-14.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/co-dinh-o-trong-excel-14-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/co-dinh-o-trong-excel-14-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h2><strong>Nh\u1eefng l\u1ed7i th\u01b0\u1eddng g\u1eb7p ph\u1ea3i khi c\u1ed1 \u0111\u1ecbnh \u00f4 trong Excel v\u00e0 c\u00e1ch kh\u1eafc ph\u1ee5c<\/strong><\/h2>\n<p>M\u1eb7c d\u00f9 vi\u1ec7c c\u1ed1 \u0111\u1ecbnh \u00f4, d\u00f2ng, c\u1ed9t trong Excel r\u1ea5t h\u1eefu \u00edch, nh\u01b0ng c\u0169ng c\u00f3 th\u1ec3 g\u1eb7p ph\u1ea3i m\u1ed9t s\u1ed1 l\u1ed7i khi th\u1ef1c hi\u1ec7n. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t s\u1ed1 l\u1ed7i th\u01b0\u1eddng g\u1eb7p ph\u1ea3i khi c\u1ed1 \u0111\u1ecbnh \u00f4, d\u00f2ng, c\u1ed9t trong Excel:<\/p>\n<h3><strong>L\u1ed7i th\u01b0\u1eddng g\u1eb7p ph\u1ea3i khi c\u1ed1 \u0111\u1ecbnh \u00f4 trong excel m\u00e1y t\u00ednh<\/strong><\/h3>\n<ul>\n<li>L\u1ed7i #REF!: Khi b\u1ea1n c\u1ed1 \u0111\u1ecbnh \u00f4, n\u1ebfu b\u1ea1n di chuy\u1ec3n c\u00e1c d\u1eef li\u1ec7u thu\u1ed9c \u00f4 li\u00ean quan \u0111\u1ebfn \u00f4 \u0111\u00f3, b\u1ea1n c\u00f3 th\u1ec3 g\u1eb7p ph\u1ea3i l\u1ed7i #REF!, Excel s\u1ebd hi\u1ec3n th\u1ecb c\u1ea3nh b\u00e1o kh\u00f4ng th\u1ec3 \u0111\u1ecbnh v\u1ecb \u00f4 \u0111\u00f3.<\/li>\n<li>L\u1ed7i #VALUE!: Trong khi th\u1ef1c hi\u1ec7n vi\u1ec7c c\u1ed1 \u0111\u1ecbnh \u00f4, n\u1ebfu b\u1ea1n c\u1ed1 t\u00ecnh thay \u0111\u1ed5i gi\u00e1 tr\u1ecb c\u1ee7a n\u00f3, b\u1ea1n c\u00f3 th\u1ec3 g\u1eb7p ph\u1ea3i l\u1ed7i #VALUE!, Excel th\u00f4ng b\u00e1o gi\u00e1 tr\u1ecb c\u1ee7a \u00f4 kh\u00f4ng h\u1ee3p l\u1ec7.<\/li>\n<li>L\u1ed7i #DIV\/0!: Khi b\u1ea1n c\u1ed1 \u0111\u1ecbnh \u00f4 v\u00e0 s\u1eed d\u1ee5ng n\u00f3 \u0111\u1ec3 chia cho s\u1ed1 0, b\u1ea1n c\u00f3 th\u1ec3 g\u1eb7p ph\u1ea3i l\u1ed7i #DIV\/0!, Excel s\u1ebd th\u00f4ng b\u00e1o l\u1ed7i ph\u00e9p t\u00ednh kh\u00f4ng h\u1ee3p l\u1ec7.<\/li>\n<li>L\u1ed7i #NAME?: Khi th\u1ef1c hi\u1ec7n c\u1ed1 \u0111\u1ecbnh \u00f4, n\u1ebfu b\u1ea1n nh\u1eadp sai t\u00ean ho\u1eb7c c\u00f4ng th\u1ee9c c\u1ee7a \u00f4, b\u1ea1n c\u00f3 th\u1ec3 g\u1eb7p ph\u1ea3i l\u1ed7i #NAME?, c\u00f3 ngh\u0129a l\u00e0 Excel kh\u00f4ng th\u1ec3 x\u00e1c \u0111\u1ecbnh t\u00ean ho\u1eb7c c\u00f4ng th\u1ee9c c\u1ee7a \u00f4.<\/li>\n<li>L\u1ed7i #NUM!: Khi b\u1ea1n s\u1eed d\u1ee5ng m\u1ed9t \u00f4 \u0111\u00e3 c\u1ed1 \u0111\u1ecbnh trong m\u1ed9t ph\u00e9p t\u00ednh b\u1ea5t k\u1ef3, n\u1ebfu gi\u00e1 tr\u1ecb c\u1ee7a \u00f4 kh\u00f4ng ph\u1ea3i l\u00e0 s\u1ed1, b\u1ea1n c\u00f3 th\u1ec3 g\u1eb7p ph\u1ea3i l\u1ed7i #NUM!, l\u1ed7i b\u00e1o ph\u00e9p t\u00ednh kh\u00f4ng h\u1ee3p l\u1ec7.<\/li>\n<\/ul>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/co-dinh-o-trong-excel-15.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/co-dinh-o-trong-excel-15-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/co-dinh-o-trong-excel-15-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-232981 aligncenter webpexpress-processed\" src=\"http:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/co-dinh-o-trong-excel-15.jpg\" alt=\"cac-cach-co-dinh-o-trong-excel-15\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/co-dinh-o-trong-excel-15.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/co-dinh-o-trong-excel-15-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/co-dinh-o-trong-excel-15-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3><strong>C\u00e1ch kh\u1eafc ph\u1ee5c l\u1ed7i khi c\u1ed1 \u0111\u1ecbnh \u00f4 trong excel m\u00e1y t\u00ednh<\/strong><\/h3>\n<ul>\n<li>L\u1ed7i #REF!: B\u1ea1n c\u1ea7n ki\u1ec3m tra l\u1ea1i c\u00e1c \u00f4 li\u00ean quan \u0111\u1ebfn \u00f4 b\u1ecb l\u1ed7i v\u00e0 xem x\u00e9t xem li\u1ec7u c\u00f3 b\u1ecb di chuy\u1ec3n hay x\u00f3a b\u1ecf kh\u00f4ng. Sau \u0111\u00f3, h\u00e3y s\u1eeda l\u1ea1i c\u00f4ng th\u1ee9c \u0111\u1ec3 tr\u1ecf \u0111\u1ebfn \u00f4 ch\u00ednh x\u00e1c. N\u1ebfu \u00f4 b\u1ecb di chuy\u1ec3n, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng t\u00ecm ki\u1ebfm v\u00e0 thay th\u1ebf \u0111\u1ec3 s\u1eeda l\u1ea1i.<\/li>\n<li>L\u1ed7i #VALUE!: H\u00e3y ki\u1ec3m tra l\u1ea1i gi\u00e1 tr\u1ecb c\u1ee7a \u00f4 v\u00e0 \u0111\u1ea3m b\u1ea3o r\u1eb1ng n\u00f3 h\u1ee3p l\u1ec7. N\u1ebfu gi\u00e1 tr\u1ecb kh\u00f4ng h\u1ee3p l\u1ec7, h\u00e3y s\u1eeda l\u1ea1i gi\u00e1 tr\u1ecb ho\u1eb7c s\u1eed d\u1ee5ng h\u00e0m IFERROR \u0111\u1ec3 x\u1eed l\u00fd l\u1ed7i.<\/li>\n<li>L\u1ed7i #DIV\/0!: \u0110\u1ec3 kh\u1eafc ph\u1ee5c l\u1ed7i n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m IFERROR \u0111\u1ec3 x\u1eed l\u00fd l\u1ed7i ho\u1eb7c ki\u1ec3m tra l\u1ea1i ph\u00e9p t\u00ednh \u0111\u1ec3 \u0111\u1ea3m b\u1ea3o r\u1eb1ng b\u1ea1n \u0111ang kh\u00f4ng chia n\u00f3 cho s\u1ed1 0.<\/li>\n<li>L\u1ed7i #NAME?: Xem l\u1ea1i t\u00ean ho\u1eb7c c\u00f4ng th\u1ee9c c\u1ee7a \u00f4 v\u00e0 \u0111\u1ea3m b\u1ea3o r\u1eb1ng ch\u00fang \u0111\u00e3 \u0111\u01b0\u1ee3c nh\u1eadp \u0111\u00fang. S\u1eeda l\u1ea1i n\u1ebfu t\u00ean ho\u1eb7c c\u00f4ng th\u1ee9c ch\u01b0a ch\u00ednh x\u00e1c.<\/li>\n<li>L\u1ed7i #NUM!: \u0110\u1ec3 kh\u1eafc ph\u1ee5c l\u1ed7i n\u00e0y, b\u1ea1n c\u1ea7n ki\u1ec3m tra l\u1ea1i gi\u00e1 tr\u1ecb c\u1ee7a \u00f4 v\u00e0 \u0111\u1ea3m b\u1ea3o r\u1eb1ng n\u00f3 l\u00e0 s\u1ed1. N\u1ebfu kh\u00f4ng ph\u1ea3i, h\u00e3y s\u1eeda l\u1ea1i gi\u00e1 tr\u1ecb ho\u1eb7c s\u1eed d\u1ee5ng h\u00e0m IFERROR \u0111\u1ec3 x\u1eed l\u00fd l\u1ed7i.<\/li>\n<\/ul>\n<h2><strong>T\u1ea1m k\u1ebft<\/strong><\/h2>\n<p>Vi\u1ec7c c\u1ed1 \u0111\u1ecbnh \u00f4, d\u00f2ng, c\u1ed9t trong <a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/tong-hop-cac-cach-tu-hoc-excel-online\">Excel<\/a> m\u00e1y t\u00ednh l\u00e0 m\u1ed9t k\u1ef9 n\u0103ng c\u1ea7n thi\u1ebft \u0111\u1ec3 l\u00e0m vi\u1ec7c hi\u1ec7u qu\u1ea3 v\u1edbi Excel. C\u00f3 nhi\u1ec1u c\u00e1ch \u0111\u1ec3 c\u1ed1 \u0111\u1ecbnh \u00f4, d\u00f2ng, c\u1ed9t trong Excel m\u00e0 <a href=\"https:\/\/hoanghamobile.com\/\">Ho\u00e0ng H\u00e0 Mobile<\/a>\u00a0\u0111\u00e3 gi\u1edbi thi\u1ec7u trong b\u00e0i vi\u1ebft h\u01b0\u1edbng d\u1eabn chi ti\u1ebft b\u00ean tr\u00ean. Vi\u1ec7c c\u1ed1 \u0111\u1ecbnh \u00f4 trong Excel gi\u00fap ti\u1ebft ki\u1ec7m th\u1eddi gian v\u00e0 t\u0103ng \u0111\u1ed9 ch\u00ednh x\u00e1c trong t\u00ednh to\u00e1n, gi\u1ea3m thi\u1ec3u c\u00e1c l\u1ed7i trong qu\u00e1 tr\u00ecnh nh\u1eadp li\u1ec7u v\u00e0 t\u00ednh to\u00e1n, gi\u00fap b\u1ea1n l\u00e0m vi\u1ec7c hi\u1ec7u qu\u1ea3 h\u01a1n trong Excel. Hy v\u1ecdng b\u00e0i vi\u1ebft n\u00e0y s\u1ebd gi\u00fap b\u1ea1n hi\u1ec3u r\u00f5 h\u01a1n v\u1ec1 c\u00e1ch c\u1ed1 \u0111\u1ecbnh \u00f4 trong Excel v\u00e0 \u00e1p d\u1ee5ng th\u00e0nh th\u1ea1o trong c\u00f4ng vi\u1ec7c v\u00e0 h\u1ecdc t\u1eadp c\u1ee7a m\u00ecnh.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Khi l\u00e0m vi\u1ec7c v\u1edbi b\u1ea3ng t\u00ednh Excel, b\u1ea1n th\u01b0\u1eddng xuy\u00ean g\u1eb7p ph\u1ea3i nh\u1eefng tr\u01b0\u1eddng h\u1ee3p ph\u1ea3i \u0111\u1ecbnh d\u1ea1ng c\u00e1c \u00f4 \u0111\u1ec3 gi\u1eef gi\u00e1 tr\u1ecb c\u1ee7a ch\u00fang lu\u00f4n c\u1ed1 \u0111\u1ecbnh. \u0110i\u1ec1u n\u00e0y gi\u00fap c\u1ed1 \u0111\u1ecbnh d\u1eef li\u1ec7u ngay c\u1ea3 khi b\u1ea1n th\u1ef1c hi\u1ec7n c\u00e1c ph\u00e9p t\u00ednh ho\u1eb7c di chuy\u1ec3n c\u00e1c \u00f4 \u0111\u00f3. Trong b\u00e0i vi\u1ebft n\u00e0y, [&hellip;]<\/p>\n","protected":false},"author":75,"featured_media":233233,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28955,412],"tags":[],"class_list":["post-226909","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","category-thu-thuat-may-tinh"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v24.2 (Yoast SEO v24.2) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>H\u01b0\u1edbng d\u1eabn c\u00e1ch c\u1ed1 \u0111\u1ecbnh \u00f4 trong Excel chi ti\u1ebft t\u1eeb A \u0111\u1ebfn Z<\/title>\n<meta name=\"description\" content=\"Vi\u1ec7c c\u1ed1 \u0111\u1ecbnh \u00f4 trong Excel gi\u00fap ti\u1ebft ki\u1ec7m th\u1eddi gian v\u00e0 t\u0103ng \u0111\u1ed9 ch\u00ednh x\u00e1c trong t\u00ednh to\u00e1n, ki\u1ec3m tra s\u1ed1 li\u1ec7u, gi\u00fap b\u1ea1n l\u00e0m vi\u1ec7c hi\u1ec7u qu\u1ea3 h\u01a1n.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/hoanghamobile.com\/tin-tuc\/cac-cach-co-dinh-o-trong-excel\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"C\u00e1c c\u00e1ch c\u1ed1 \u0111\u1ecbnh \u00f4 trong excel\" \/>\n<meta property=\"og:description\" content=\"Vi\u1ec7c c\u1ed1 \u0111\u1ecbnh \u00f4 trong Excel gi\u00fap ti\u1ebft ki\u1ec7m th\u1eddi gian v\u00e0 t\u0103ng \u0111\u1ed9 ch\u00ednh x\u00e1c trong t\u00ednh to\u00e1n, ki\u1ec3m tra s\u1ed1 li\u1ec7u, gi\u00fap b\u1ea1n l\u00e0m vi\u1ec7c hi\u1ec7u qu\u1ea3 h\u01a1n.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/cac-cach-co-dinh-o-trong-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/hoanghamobilecom\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-20T08:44:34+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/co-dinh-o-trong-excel-14-1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Vo Lan\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi\" \/>\n\t<meta name=\"twitter:data1\" content=\"Vo Lan\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"17 ph\u00fat\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cac-cach-co-dinh-o-trong-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cac-cach-co-dinh-o-trong-excel\/\"},\"author\":{\"name\":\"Vo Lan\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/bc2d94dde92f5ae5c9cfdd919216cd98\"},\"headline\":\"C\u00e1c c\u00e1ch c\u1ed1 \u0111\u1ecbnh \u00f4 trong excel\",\"datePublished\":\"2023-07-20T08:44:34+00:00\",\"dateModified\":\"2023-07-20T08:44:34+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cac-cach-co-dinh-o-trong-excel\/\"},\"wordCount\":3721,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cac-cach-co-dinh-o-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/co-dinh-o-trong-excel-14-1.jpg\",\"articleSection\":[\"Excel\",\"Th\u1ee7 thu\u1eadt m\u00e1y t\u00ednh\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/hoanghamobile.com\/tin-tuc\/cac-cach-co-dinh-o-trong-excel\/#respond\"]}],\"copyrightYear\":\"2023\",\"copyrightHolder\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cac-cach-co-dinh-o-trong-excel\/\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cac-cach-co-dinh-o-trong-excel\/\",\"name\":\"H\u01b0\u1edbng d\u1eabn c\u00e1ch c\u1ed1 \u0111\u1ecbnh \u00f4 trong Excel chi ti\u1ebft t\u1eeb A \u0111\u1ebfn Z\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cac-cach-co-dinh-o-trong-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cac-cach-co-dinh-o-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/co-dinh-o-trong-excel-14-1.jpg\",\"datePublished\":\"2023-07-20T08:44:34+00:00\",\"dateModified\":\"2023-07-20T08:44:34+00:00\",\"description\":\"Vi\u1ec7c c\u1ed1 \u0111\u1ecbnh \u00f4 trong Excel gi\u00fap ti\u1ebft ki\u1ec7m th\u1eddi gian v\u00e0 t\u0103ng \u0111\u1ed9 ch\u00ednh x\u00e1c trong t\u00ednh to\u00e1n, ki\u1ec3m tra s\u1ed1 li\u1ec7u, gi\u00fap b\u1ea1n l\u00e0m vi\u1ec7c hi\u1ec7u qu\u1ea3 h\u01a1n.\",\"breadcrumb\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cac-cach-co-dinh-o-trong-excel\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/hoanghamobile.com\/tin-tuc\/cac-cach-co-dinh-o-trong-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cac-cach-co-dinh-o-trong-excel\/#primaryimage\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/co-dinh-o-trong-excel-14-1.jpg\",\"contentUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/co-dinh-o-trong-excel-14-1.jpg\",\"width\":1200,\"height\":628},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cac-cach-co-dinh-o-trong-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Trang ch\u1ee7\",\"item\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Th\u1ee7 thu\u1eadt\",\"item\":\"https:\/\/hoanghamobile.com\/tin-tuc\/category\/thu-thuat\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Th\u1ee7 thu\u1eadt m\u00e1y t\u00ednh\",\"item\":\"https:\/\/hoanghamobile.com\/tin-tuc\/category\/thu-thuat\/thu-thuat-may-tinh\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"C\u00e1c c\u00e1ch c\u1ed1 \u0111\u1ecbnh \u00f4 trong excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#website\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\",\"name\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/hoanghamobile.com\/tin-tuc\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"vi\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\",\"name\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png\",\"contentUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png\",\"width\":256,\"height\":37,\"caption\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/hoanghamobilecom\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/bc2d94dde92f5ae5c9cfdd919216cd98\",\"name\":\"Vo Lan\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/fd70d1838a6fc3aa34a3a78f6253c3d4?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/fd70d1838a6fc3aa34a3a78f6253c3d4?s=96&d=mm&r=g\",\"caption\":\"Vo Lan\"},\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/author\/vo-lan\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"H\u01b0\u1edbng d\u1eabn c\u00e1ch c\u1ed1 \u0111\u1ecbnh \u00f4 trong Excel chi ti\u1ebft t\u1eeb A \u0111\u1ebfn Z","description":"Vi\u1ec7c c\u1ed1 \u0111\u1ecbnh \u00f4 trong Excel gi\u00fap ti\u1ebft ki\u1ec7m th\u1eddi gian v\u00e0 t\u0103ng \u0111\u1ed9 ch\u00ednh x\u00e1c trong t\u00ednh to\u00e1n, ki\u1ec3m tra s\u1ed1 li\u1ec7u, gi\u00fap b\u1ea1n l\u00e0m vi\u1ec7c hi\u1ec7u qu\u1ea3 h\u01a1n.","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:\/\/hoanghamobile.com\/tin-tuc\/cac-cach-co-dinh-o-trong-excel\/","og_locale":"vi_VN","og_type":"article","og_title":"C\u00e1c c\u00e1ch c\u1ed1 \u0111\u1ecbnh \u00f4 trong excel","og_description":"Vi\u1ec7c c\u1ed1 \u0111\u1ecbnh \u00f4 trong Excel gi\u00fap ti\u1ebft ki\u1ec7m th\u1eddi gian v\u00e0 t\u0103ng \u0111\u1ed9 ch\u00ednh x\u00e1c trong t\u00ednh to\u00e1n, ki\u1ec3m tra s\u1ed1 li\u1ec7u, gi\u00fap b\u1ea1n l\u00e0m vi\u1ec7c hi\u1ec7u qu\u1ea3 h\u01a1n.","og_url":"https:\/\/hoanghamobile.com\/tin-tuc\/cac-cach-co-dinh-o-trong-excel\/","og_site_name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","article_publisher":"https:\/\/www.facebook.com\/hoanghamobilecom","article_published_time":"2023-07-20T08:44:34+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/co-dinh-o-trong-excel-14-1.jpg","type":"image\/jpeg"}],"author":"Vo Lan","twitter_card":"summary_large_image","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"Vo Lan","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"17 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cac-cach-co-dinh-o-trong-excel\/#article","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cac-cach-co-dinh-o-trong-excel\/"},"author":{"name":"Vo Lan","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/bc2d94dde92f5ae5c9cfdd919216cd98"},"headline":"C\u00e1c c\u00e1ch c\u1ed1 \u0111\u1ecbnh \u00f4 trong excel","datePublished":"2023-07-20T08:44:34+00:00","dateModified":"2023-07-20T08:44:34+00:00","mainEntityOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cac-cach-co-dinh-o-trong-excel\/"},"wordCount":3721,"commentCount":0,"publisher":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cac-cach-co-dinh-o-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/co-dinh-o-trong-excel-14-1.jpg","articleSection":["Excel","Th\u1ee7 thu\u1eadt m\u00e1y t\u00ednh"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/hoanghamobile.com\/tin-tuc\/cac-cach-co-dinh-o-trong-excel\/#respond"]}],"copyrightYear":"2023","copyrightHolder":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"}},{"@type":"WebPage","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cac-cach-co-dinh-o-trong-excel\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/cac-cach-co-dinh-o-trong-excel\/","name":"H\u01b0\u1edbng d\u1eabn c\u00e1ch c\u1ed1 \u0111\u1ecbnh \u00f4 trong Excel chi ti\u1ebft t\u1eeb A \u0111\u1ebfn Z","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#website"},"primaryImageOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cac-cach-co-dinh-o-trong-excel\/#primaryimage"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cac-cach-co-dinh-o-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/co-dinh-o-trong-excel-14-1.jpg","datePublished":"2023-07-20T08:44:34+00:00","dateModified":"2023-07-20T08:44:34+00:00","description":"Vi\u1ec7c c\u1ed1 \u0111\u1ecbnh \u00f4 trong Excel gi\u00fap ti\u1ebft ki\u1ec7m th\u1eddi gian v\u00e0 t\u0103ng \u0111\u1ed9 ch\u00ednh x\u00e1c trong t\u00ednh to\u00e1n, ki\u1ec3m tra s\u1ed1 li\u1ec7u, gi\u00fap b\u1ea1n l\u00e0m vi\u1ec7c hi\u1ec7u qu\u1ea3 h\u01a1n.","breadcrumb":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cac-cach-co-dinh-o-trong-excel\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/hoanghamobile.com\/tin-tuc\/cac-cach-co-dinh-o-trong-excel\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cac-cach-co-dinh-o-trong-excel\/#primaryimage","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/co-dinh-o-trong-excel-14-1.jpg","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/co-dinh-o-trong-excel-14-1.jpg","width":1200,"height":628},{"@type":"BreadcrumbList","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cac-cach-co-dinh-o-trong-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Trang ch\u1ee7","item":"https:\/\/hoanghamobile.com\/tin-tuc\/"},{"@type":"ListItem","position":2,"name":"Th\u1ee7 thu\u1eadt","item":"https:\/\/hoanghamobile.com\/tin-tuc\/category\/thu-thuat\/"},{"@type":"ListItem","position":3,"name":"Th\u1ee7 thu\u1eadt m\u00e1y t\u00ednh","item":"https:\/\/hoanghamobile.com\/tin-tuc\/category\/thu-thuat\/thu-thuat-may-tinh\/"},{"@type":"ListItem","position":4,"name":"C\u00e1c c\u00e1ch c\u1ed1 \u0111\u1ecbnh \u00f4 trong excel"}]},{"@type":"WebSite","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#website","url":"https:\/\/hoanghamobile.com\/tin-tuc\/","name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","description":"","publisher":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/hoanghamobile.com\/tin-tuc\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"vi"},{"@type":"Organization","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization","name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","url":"https:\/\/hoanghamobile.com\/tin-tuc\/","logo":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png","width":256,"height":37,"caption":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/hoanghamobilecom"]},{"@type":"Person","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/bc2d94dde92f5ae5c9cfdd919216cd98","name":"Vo Lan","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/fd70d1838a6fc3aa34a3a78f6253c3d4?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/fd70d1838a6fc3aa34a3a78f6253c3d4?s=96&d=mm&r=g","caption":"Vo Lan"},"url":"https:\/\/hoanghamobile.com\/tin-tuc\/author\/vo-lan\/"}]}},"_links":{"self":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/226909","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/users\/75"}],"replies":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/comments?post=226909"}],"version-history":[{"count":0,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/226909\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media\/233233"}],"wp:attachment":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media?parent=226909"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/categories?post=226909"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/tags?post=226909"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}