{"id":6431,"date":"2024-12-21T15:19:47","date_gmt":"2024-12-21T15:19:47","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cach-de-chen-hang-trong-khi-du-lieu-thay-doi-trong-excel\/"},"modified":"2024-12-21T15:19:47","modified_gmt":"2024-12-21T15:19:47","slug":"cach-de-chen-hang-trong-khi-du-lieu-thay-doi-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cach-de-chen-hang-trong-khi-du-lieu-thay-doi-trong-excel\/","title":{"rendered":"C\u00e1ch \u0111\u1ec3 ch\u00e8n h\u00e0ng tr\u1ed1ng khi d\u1eef li\u1ec7u thay \u0111\u1ed5i trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-dQf5b79p#1\">\n<p>\u00a0<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-32402 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/1-9-300x234-1.png\" alt=\"range-date\" width=\"444\" height=\"346\" title=\"1-9-300x234-1\"><\/p>\n<p>Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 m\u1ed9t d\u00e3y d\u1eef li\u1ec7u, v\u00e0 b\u1ea1n mu\u1ed1n ch\u00e8n c\u00e1c d\u00f2ng tr\u1ed1ng gi\u1eefa d\u1eef li\u1ec7u khi ch\u00fang thay \u0111\u1ed5i, \u0111\u1ec3 c\u00f3 th\u1ec3 t\u00e1ch bi\u1ec7t c\u00e1c gi\u00e1 tr\u1ecb gi\u1ed1ng nhau nh\u01b0 h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y. Trong b\u00e0i vi\u1ebft n\u00e0y, H\u1ecdc Excel Online s\u1ebd h\u01b0\u1edbng d\u1eabn m\u1ed9t s\u1ed1 m\u1eb9o \u0111\u1ec3 b\u1ea1n c\u00f3 th\u1ec3 gi\u1ea3i quy\u1ebft v\u1ea5n \u0111\u1ec1 n\u00e0y.<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-6766dc922aefe\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-1\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/cach-de-chen-hang-trong-khi-du-lieu-thay-doi-trong-excel.html#Chen_hang_trong_khi_gia_tri_thay_doi_bang_chuc_nang_Subtotal\" title=\"Ch\u00e8n h\u00e0ng tr\u1ed1ng khi gi\u00e1 tr\u1ecb thay \u0111\u1ed5i b\u1eb1ng ch\u1ee9c n\u0103ng Subtotal.\">Ch\u00e8n h\u00e0ng tr\u1ed1ng khi gi\u00e1 tr\u1ecb thay \u0111\u1ed5i b\u1eb1ng ch\u1ee9c n\u0103ng Subtotal.<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-1\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/cach-de-chen-hang-trong-khi-du-lieu-thay-doi-trong-excel.html#Chen_hang_trong_khi_du_lieu_thay_doi_bang_ma_VBA\" title=\"Ch\u00e8n h\u00e0ng tr\u1ed1ng khi d\u1eef li\u1ec7u thay \u0111\u1ed5i b\u1eb1ng m\u00e3 VBA\">Ch\u00e8n h\u00e0ng tr\u1ed1ng khi d\u1eef li\u1ec7u thay \u0111\u1ed5i b\u1eb1ng m\u00e3 VBA<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h1><span class=\"ez-toc-section\" id=\"Chen_hang_trong_khi_gia_tri_thay_doi_bang_chuc_nang_Subtotal\"><\/span><strong>Ch\u00e8n h\u00e0ng tr\u1ed1ng khi gi\u00e1 tr\u1ecb thay \u0111\u1ed5i b\u1eb1ng ch\u1ee9c n\u0103ng Subtotal.<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p>V\u1edbi ch\u1ee9c n\u0103ng Subtotal, b\u1ea1n c\u00f3 th\u1ec3 ch\u00e8n h\u00e0ng tr\u1ed1ng gi\u1eefa d\u1eef li\u1ec7u khi ch\u00fang c\u00f3 thay \u0111\u1ed5i v\u1edbi c\u00e1c b\u01b0\u1edbc sau:<\/p>\n<p>1. Ch\u1ecdn d\u00e3y d\u1eef li\u1ec7u b\u1ea1n mu\u1ed1n d\u00f9ng.<\/p>\n<p>2. Ch\u1ecdn\u00a0<strong>Data<\/strong> &gt; <strong>Subtotal\u00a0<\/strong>\u0111\u1ec3 m\u1edf h\u1ed9p tho\u1ea1i <strong>Subtotal,\u00a0<\/strong>v\u00e0 l\u00e0m theo h\u01b0\u1edbng d\u1eabn sau:<\/p>\n<p>A: Ch\u1ecdn t\u00ean c\u1ed9t m\u00e0 b\u1ea1n mu\u1ed1n ch\u00e8n h\u00e0ng tr\u1ed1ng d\u1ef1a v\u00e0o s\u1ef1 thay \u0111\u1ed5i gi\u00e1 tr\u1ecb t\u1ea1i \u00f4 ph\u00eda d\u01b0\u1edbi <strong>At each change.<\/strong><\/p>\n<div class=\"code-block code-block-2\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-249.gif\" title=\"vba101_92019-nho-249\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-577.gif\" title=\"ex101_92019-nho-577\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>B: Ch\u1ecdn <strong>Count<\/strong> t\u1eeb danh s\u00e1ch t\u00f9y ch\u1ecdn <strong>Use function.<\/strong><\/p>\n<p>C: \u0110\u00e1nh d\u1ea5u ch\u1ecdn t\u00ean c\u1ed9t b\u1ea1n mu\u1ed1n ch\u00e8n Subtotal t\u1ea1i danh s\u00e1ch <strong>Add subtotal to<\/strong><\/p>\n<p>3. Nh\u1ea5n<strong> OK,\u00a0<\/strong>h\u00e0ng subtotal \u0111\u00e3 \u0111\u01b0\u1ee3c ch\u00e8n gi\u1eefa c\u00e1c d\u00e3y d\u1eef li\u1ec7u, v\u00e0 c\u00e1c k\u00fd hi\u1ec7u outline b\u00ean tr\u00e1i b\u1ea3ng nh\u01b0 h\u00ecnh d\u01b0\u1edbi:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-32403 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/doc-insert-blank-rows-value-changes-4-300x270-1.png\" alt=\"docs-insert-row\" width=\"427\" height=\"384\" title=\"doc-insert-blank-rows-value-changes-4-300x270-1\"><\/p>\n<p>\u00a0<\/p>\n<p>4. Nh\u1ea5p v\u00e0o s\u1ed1 2 ph\u00eda tr\u00ean c\u00f9ng c\u1ee7a c\u00e1c k\u00fd hi\u1ec7u outline \u0111\u1ec3 ch\u1ec9 th\u1ec3 hi\u1ec7n d\u00f2ng subtotal.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-32404 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/doc-insert-blank-rows-value-changes-5-300x114-1.png\" alt=\"doc-insert-blank-rows-value-changes-5\" width=\"495\" height=\"188\" title=\"doc-insert-blank-rows-value-changes-5-300x114-1\"><\/p>\n<p>\u00a0<\/p>\n<p>5. C\u0169ng c\u00f3 th\u1ec3 ch\u1ecdn ph\u1ea7n d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c subtotal, nh\u1ea5n ph\u00edm t\u1eaft\u00a0<strong>Alt+;\u00a0<\/strong>\u0111\u1ec3 ch\u1ecdn d\u00f2ng t\u1ed5ng nh\u01b0 h\u00ecnh<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-32405 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/doc-insert-blank-rows-value-changes-6-300x118-1.png\" alt=\"doc-insert-blank-rows-value-changes-6\" width=\"491\" height=\"193\" title=\"doc-insert-blank-rows-value-changes-6-300x118-1\"><\/p>\n<p>6. Sau khi ch\u1ecdn ph\u1ea7n \u00a0t\u1ed5ng nh\u1ea5n ph\u00edm <strong>Delete\u00a0<\/strong>\u0111\u1ec3 lo\u1ea1i b\u1ecf c\u00e1c d\u00f2ng subtotal<\/p>\n<p>7. Sau \u0111\u00f3 nh\u1ea5p v\u00e0o b\u1ea5t c\u1ee9 \u00f4 d\u1eef li\u1ec7u n\u00e0o, Ch\u1ecdn\u00a0<strong>Data<\/strong> &gt; <strong>Ungroup<\/strong> &gt; <strong>Clear Outline\u00a0<\/strong>\u0111\u1ec3 b\u1ecf c\u00e1c outlines, nh\u01b0 h\u00ecnh<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-32406 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/doc-insert-blank-rows-value-changes-7-300x104-1.png\" alt=\"doc-insert-blank-rows-value-changes-7\" width=\"471\" height=\"163\" title=\"doc-insert-blank-rows-value-changes-7-300x104-1\"><\/p>\n<p>\u00a0<\/p>\n<p>8. C\u00e1c k\u00fd hi\u1ec7u outline \u0111\u00e3 \u0111\u01b0\u1ee3c lo\u1ea1i b\u1ecf, v\u00e0 b\u1ea1n c\u00f3 c\u00e1c h\u00e0ng tr\u1ed1ng \u0111\u01b0\u1ee3c ch\u00e8n gi\u1eefa d\u1eef li\u1ec7u khi ch\u00fang c\u00f3 s\u1ef1 thay \u0111\u1ed5i gi\u00e1 tr\u1ecb nh\u01b0 trong h\u00ecnh:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-32407 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/doc-insert-blank-rows-value-changes-8-277x300-1.png\" alt=\"doc-insert-blank-rows-value-changes-8\" width=\"407\" height=\"441\" title=\"doc-insert-blank-rows-value-changes-8-277x300-1\"><\/p>\n<p>\u00a0<\/p>\n<p>9. Cu\u1ed1i c\u00f9ng, b\u1ea1n c\u00f3 th\u1ec3 x\u00f3a c\u1ed9t A n\u1ebfu c\u1ea7n.<br \/>\n<strong>Ch\u00e8n d\u00f2ng tr\u1ed1ng khi gi\u00e1 tr\u1ecb thay \u0111\u1ed5i v\u1edbi c\u1ed9t ph\u1ee5.<\/strong><\/p>\n<p>T\u1ea1i c\u1ed9t ph\u1ee5, \u0111\u1ea7u ti\u00ean b\u1ea1n c\u00f3 th\u1ec3 ch\u00e8n c\u00f4ng th\u1ee9c, v\u00e0 s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng\u00a0<strong>Find and Replace, <\/strong>cu\u1ed1i c\u00f9ng ch\u00e8n h\u00e0ng tr\u1ed1ng t\u1ea1i n\u01a1i d\u1eef li\u1ec7u thay \u0111\u1ed5i. H\u00e3y l\u00e0m c\u00e1c b\u01b0\u1edbc sau:<\/p>\n<p>1. Trong \u00f4 C3, nh\u1eadp c\u00f4ng th\u1ee9c =A3=A2, v\u00e0 trong \u00f4 D4 nh\u1eadp c\u00f4ng th\u1ee9c =A4=A3, nh\u01b0 h\u00ecnh<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-32408 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/doc-insert-blank-rows-value-changes-9-300x98-1.png\" alt=\"doc-insert-blank-rows-value-changes-9\" width=\"407\" height=\"133\" title=\"doc-insert-blank-rows-value-changes-9-300x98-1\"><\/p>\n<p>\u00a0<\/p>\n<p>2. K\u00e9o c\u00f4ng th\u1ee9c cho to\u00e0n b\u1ed9 d\u00e3y C3:D4, \u0111\u1ec3 c\u00f3 \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 <strong>True<\/strong> ho\u1eb7c <strong>False <\/strong>trong c\u00e1c \u00f4, nh\u01b0 h\u00ecnh:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-32409 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/doc-insert-blank-rows-value-changes-10-300x214-1.png\" alt=\"doc-insert-blank-rows-value-changes-10\" width=\"456\" height=\"325\" title=\"doc-insert-blank-rows-value-changes-10-300x214-1\"><\/p>\n<p>\u00a0<\/p>\n<p>3. Nh\u1ea5n <strong>Ctrl+F<\/strong> \u0111\u1ec3 m\u1edf h\u1ed9p tho\u1ea1i <strong>Find and Replace,\u00a0<\/strong>trong h\u1ed9p tho\u1ea1i, nh\u1eadp <strong>FALSE<\/strong> v\u00e0o <strong>Find what\u00a0<\/strong>trong tab <strong>Find,\u00a0<\/strong>v\u00e0 nh\u1ea5n n\u00fat <strong>Option<\/strong> \u0111\u1ec3 m\u1edf r\u1ed9ng h\u1ed9p tho\u1ea1i, ch\u1ecdn <strong>Value<\/strong> t\u1eeb danh s\u00e1ch t\u00f9y ch\u1ecdn <strong>Look in, <\/strong>nh\u01b0 h\u00ecnh:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-32410 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/doc-insert-blank-rows-value-changes-11-300x117-1.png\" alt=\"doc-insert-blank-rows-value-changes-11\" width=\"528\" height=\"206\" title=\"doc-insert-blank-rows-value-changes-11-300x117-1\"><\/p>\n<p>\u00a0<\/p>\n<p>4. Ch\u1ecdn <strong>Find All,\u00a0<\/strong> nh\u1ea5n Ctrl+A \u0111\u1ec3 ch\u1ecdn t\u1ea5t c\u1ea3 c\u00e1c k\u1ebft qu\u1ea3 \u0111\u01b0\u1ee3c t\u00ecm th\u1ea5y nh\u01b0 h\u00ecnh:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-32412 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/doc-insert-blank-rows-value-changes-12-300x121-1.png\" alt=\"doc-insert-blank-rows-value-changes-12\" width=\"598\" height=\"241\" title=\"doc-insert-blank-rows-value-changes-12-300x121-1\"><\/p>\n<p>\u00a0<\/p>\n<p>5. T\u1ea5t c\u1ea3 c\u00e1c \u00f4 False \u0111\u00e3 \u0111\u01b0\u1ee3c ch\u1ecdn, t\u1eaft h\u1ed9p tho\u1ea1i <strong>Find and Replace<\/strong><\/p>\n<p>\u00a0<\/p>\n<p>6. B\u01b0\u1edbc ti\u1ebfp theo, b\u1ea1n c\u00f3 th\u1ec3 ch\u00e8n h\u00e0ng tr\u1ed1ng b\u1eb1ng c\u00e1ch ch\u1ecdn\u00a0<strong>Home<\/strong> &gt; <strong>Insert<\/strong> &gt;<strong> Insert Sheet Rows,\u00a0<\/strong>nh\u01b0 h\u00ecnh:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-32413 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/capture-300x178-1.png\" alt=\"Capture\" width=\"511\" height=\"303\" title=\"capture-300x178-1\"><\/p>\n<p>\u00a0<\/p>\n<p>7. Cu\u1ed1i c\u00f9ng, b\u1ea1n c\u00f3 th\u1ec3 x\u00f3a c\u1ed9t ph\u1ee5 C v\u00e0 D n\u1ebfu c\u1ea7n.<\/p>\n<h1><span class=\"ez-toc-section\" id=\"Chen_hang_trong_khi_du_lieu_thay_doi_bang_ma_VBA\"><\/span><strong>Ch\u00e8n h\u00e0ng tr\u1ed1ng khi d\u1eef li\u1ec7u thay \u0111\u1ed5i b\u1eb1ng m\u00e3 VBA<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p>N\u1ebfu b\u1ea1n m\u1ec7t m\u1ecfi v\u00ec c\u00e1c ph\u01b0\u01a1ng ph\u00e1p tr\u00ean, \u0111\u00e2y l\u00e0 c\u00e1ch gi\u00fap b\u1ea1n ch\u00e8n h\u00e0ng tr\u1ed1ng gi\u1eefa c\u00e1c d\u1eef li\u1ec7u khi c\u00f3 s\u1ef1 thay \u0111\u1ed5i b\u1eb1ng <a href=\"http:\/\/blog.ezworkapp.com\/cach-chen-va-chay-ma-vba-trong-excel-2010-2016-huong-dan-cho-nguoi-moi-bat-dau.html\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>m\u00e3 VBA<\/strong><\/a>.<\/p>\n<p>1. Nh\u1ea5n gi\u1eef <strong>ALT+F11\u00a0<\/strong>\u0111\u1ec3 m\u1edf\u00a0<strong>Microsoft Visual Basic for Applications window<\/strong>.<\/p>\n<p>2. Nh\u1ea5n\u00a0<strong>Insert<\/strong> &gt; <strong>Module, <\/strong>v\u00e0 d\u00e1n \u0111o\u1ea1n m\u00e3 sau v\u00e0o<strong>\u00a0Module Window.<\/strong><\/p>\n<\/p>\n<div class=\"oembed-gist\">View the code on <a href=\"https:\/\/gist.github.com\/ndthanh\/df68f248adbf03197ab376100af46dcf\">Gist<\/a>.<\/div>\n<div class=\"line number1 index0 alt2\"><\/div>\n<div class=\"line number16 index15 alt1\">3. Nh\u1ea5n F5 \u0111\u1ec3 ch\u1ea1y m\u00e3, m\u1ed9t h\u1ed9p tho\u1ea1i s\u1ebd xu\u1ea5t hi\u1ec7n \u0111\u1ec3 b\u1ea1n ch\u1ecdn 1 c\u1ed9t d\u1eef li\u1ec7u m\u00e0 b\u1ea1n mu\u1ed1n ch\u00e8n h\u00e0ng tr\u1ed1ng khi gi\u00e1 tr\u1ecb thay \u0111\u1ed5i, nh\u01b0 h\u00ecnh sau<\/div>\n<div><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-32414 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/doc-insert-blank-rows-value-changes-15-300x219-1.png\" alt=\"doc-insert-blank-rows-value-changes-15\" width=\"425\" height=\"310\" title=\"doc-insert-blank-rows-value-changes-15-300x219-1\"><\/div>\n<div class=\"line number16 index15 alt1\"><\/div>\n<div class=\"line number16 index15 alt1\">4. Nh\u1ea5p <strong>OK, <\/strong>d\u00f2ng tr\u1ed1ng \u0111\u00e3 \u0111\u01b0\u1ee3c ch\u00e8n d\u1ef1a v\u00e0o c\u1ed9t d\u1eef li\u1ec7u A.<\/div>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-249.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":6432,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-6431","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-nang-cao"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/6431","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=6431"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/6431\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/6432"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=6431"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=6431"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=6431"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}