{"id":1186,"date":"2024-12-02T04:22:38","date_gmt":"2024-12-02T04:22:38","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/cach-chen-va-bo-chen-ngat-trang-trong-excel-moi-nhat\/"},"modified":"2024-12-02T04:22:38","modified_gmt":"2024-12-02T04:22:38","slug":"cach-chen-va-bo-chen-ngat-trang-trong-excel-moi-nhat","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/cach-chen-va-bo-chen-ngat-trang-trong-excel-moi-nhat\/","title":{"rendered":"C\u00e1ch ch\u00e8n v\u00e0 b\u1ecf ch\u00e8n ng\u1eaft trang trong Excel m\u1edbi nh\u1ea5t"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<blockquote id=\"b\u1ecf-ng\u1eaft-trang-trong-excel\" cite=\"https:\/\/blog.hocexcel.online\/cach-chen-va-bo-chen-ngat-trang-trong-excel.html?bo-ngat-trang-trong-excel\">\n<p style=\"text-align: justify\">T\u00f9y ch\u1ecdn Page Break trong Excel gi\u00fap b\u1ea1n xem v\u1ecb tr\u00ed ng\u1eaft trang s\u1ebd xu\u1ea5t hi\u1ec7n khi in b\u1ea3ng t\u00ednh. Trong b\u00e0i vi\u1ebft n\u00e0y, <strong>H\u1ecdc Excel Online<\/strong> s\u1ebd ch\u1ec9 cho b\u1ea1n v\u00e0i c\u00e1ch \u0111\u1ec3 ch\u00e8n ch\u00fang theo c\u00e1ch th\u1ee7 c\u00f4ng ho\u1eb7c theo \u0111i\u1ec1u ki\u1ec7n. B\u1ea1n c\u0169ng s\u1ebd t\u00ecm hi\u1ec3u l\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 <strong>lo\u1ea1i b\u1ecf c\u00e1c<a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-ngat-trang-truoc-khi-trong-excel.html\"> ng\u1eaft trang trong Excel<\/a><\/strong> 2010-2016, n\u01a1i \u0111\u1ec3 t\u00ecm Page Break Preview, \u1ea9n v\u00e0 hi\u1ec3n th\u1ecb d\u00f2ng \u0111\u00e1nh d\u1ea5u.<\/p>\n<\/blockquote>\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-674d360d948ce\" 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-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/cach-chen-va-bo-chen-ngat-trang-trong-excel.html#Lam_the_nao_de_chen_ngat_trang_trong_Excel_bang_cach_thu_cong\" title=\"L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 ch\u00e8n ng\u1eaft trang trong Excel b\u1eb1ng c\u00e1ch th\u1ee7 c\u00f4ng:\">L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 ch\u00e8n ng\u1eaft trang trong Excel b\u1eb1ng c\u00e1ch th\u1ee7 c\u00f4ng:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/cach-chen-va-bo-chen-ngat-trang-trong-excel.html#Chen_ngat_trang_trong_Excel_theo_dieu_kien\" title=\"Ch\u00e8n ng\u1eaft trang trong Excel theo \u0111i\u1ec1u ki\u1ec7n:\">Ch\u00e8n ng\u1eaft trang trong Excel theo \u0111i\u1ec1u ki\u1ec7n:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/cach-chen-va-bo-chen-ngat-trang-trong-excel.html#Su_dung_macro_de_ngat_trang\" title=\"S\u1eed d\u1ee5ng macro \u0111\u1ec3 ng\u1eaft trang:\">S\u1eed d\u1ee5ng macro \u0111\u1ec3 ng\u1eaft trang:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/cach-chen-va-bo-chen-ngat-trang-trong-excel.html#Su_dung_subtotal_de_chen_cac_ngat_trang\" title=\"S\u1eed d\u1ee5ng subtotal \u0111\u1ec3 ch\u00e8n c\u00e1c ng\u1eaft trang:\">S\u1eed d\u1ee5ng subtotal \u0111\u1ec3 ch\u00e8n c\u00e1c ng\u1eaft trang:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/cach-chen-va-bo-chen-ngat-trang-trong-excel.html#Lam_the_nao_de_loai_bo_ngat_trang_trong_Excel\" title=\"L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 lo\u1ea1i b\u1ecf ng\u1eaft trang trong Excel:\">L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 lo\u1ea1i b\u1ecf ng\u1eaft trang trong Excel:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/cach-chen-va-bo-chen-ngat-trang-trong-excel.html#Loai_bo_tat_ca_cac_ngat_trang\" title=\"Lo\u1ea1i b\u1ecf t\u1ea5t c\u1ea3 c\u00e1c ng\u1eaft trang:\">Lo\u1ea1i b\u1ecf t\u1ea5t c\u1ea3 c\u00e1c ng\u1eaft trang:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/cach-chen-va-bo-chen-ngat-trang-trong-excel.html#Di_chuyen_mot_ngat_trang_trong_Excel\" title=\"Di chuy\u1ec3n m\u1ed9t ng\u1eaft trang trong Excel:\">Di chuy\u1ec3n m\u1ed9t ng\u1eaft trang trong Excel:<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Lam_the_nao_de_chen_ngat_trang_trong_Excel_bang_cach_thu_cong\"><\/span><strong>L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 ch\u00e8n ng\u1eaft trang trong Excel b\u1eb1ng c\u00e1ch th\u1ee7 c\u00f4ng:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n \u1edf ch\u1ebf \u0111\u1ed9 xem tr\u01b0\u1edbc khi in v\u00e0 kh\u00f4ng th\u00edch c\u00e1ch ng\u1eaft d\u1eef li\u1ec7u \u0111\u1ec3 in, b\u1ea1n c\u00f3 th\u1ec3 t\u1ef1 ch\u00e8n c\u00e1c ng\u1eaft trang v\u00e0o n\u01a1i b\u1ea1n mu\u1ed1n. \u0110\u00e2y l\u00e0 c\u00e1c b\u01b0\u1edbc h\u01b0\u1edbng d\u1eabn c\u00e1ch th\u1ef1c hi\u1ec7n.<\/p>\n<ol style=\"text-align: justify\">\n<li>Ch\u1ecdn b\u1ea3ng t\u00ednh Excel c\u1ee7a b\u1ea1n, n\u01a1i b\u1ea1n c\u1ea7n ch\u00e8n c\u00e1c ng\u1eaft trang.<\/li>\n<li>Chuy\u1ec3n \u0111\u1ebfn tab View v\u00e0 nh\u1ea5p v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng Page Break Preview trong Workbook Views.<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5316 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-find-replace-highlight-26.png\" width=\"427\" height=\"122\" title=\"excel-find-replace-highlight-26\"><\/p>\n<p style=\"text-align: justify\"><strong>M\u1eb9o:<\/strong> B\u1ea1n c\u0169ng c\u00f3 th\u1ec3 xem v\u1ecb tr\u00ed ng\u1eaft trang n\u1ebfu b\u1ea1n nh\u1ea5p v\u00e0o n\u00fat xem tr\u01b0\u1edbc ng\u1eaft trang tr\u00ean thanh tr\u1ea1ng th\u00e1i c\u1ee7a Excel.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5317 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-find-replace-highlight-27.png\" width=\"504\" height=\"153\" title=\"excel-find-replace-highlight-27\"><\/p>\n<p style=\"text-align: justify\"><strong>Ch\u00fa th\u00edch<\/strong>. N\u1ebfu b\u1ea1n nh\u1eadn \u0111\u01b0\u1ee3c h\u1ed9p tho\u1ea1i <em>Welcome to Page Break Preview<\/em>, k\u00edch <em>OK<\/em>. \u0110\u00e1nh d\u1ea5u v\u00e0o h\u1ed9p <em>Do not show this dialog again<\/em>\u00a0n\u00e0y \u0111\u1ec3 tr\u00e1nh g\u1eb7p l\u1ea1i th\u00f4ng b\u00e1o.<\/p>\n<p style=\"text-align: justify\">3. B\u00e2y gi\u1edd b\u1ea1n c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng xem v\u1ecb tr\u00ed c\u1ee7a c\u00e1c ng\u1eaft trang trong b\u1ea3ng t\u00ednh c\u1ee7a b\u1ea1n.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5318 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-find-replace-highlight-28.png\" width=\"427\" height=\"615\" title=\"excel-find-replace-highlight-28\"><\/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-28.gif\" title=\"vba101_92019-nho-28\"><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-83.gif\" title=\"ex101_92019-nho-83\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"text-align: justify\">\u0110\u1ec3 th\u00eam m\u1ed9t ng\u1eaft trang ngang, ch\u1ecdn d\u00f2ng n\u01a1i \u0111\u01b0\u1eddng \u0111\u00e1nh d\u1ea5u s\u1ebd xu\u1ea5t hi\u1ec7n. Nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o h\u00e0ng n\u00e0y v\u00e0 ch\u1ecdn <em>Insert Page Break<\/em> t\u1eeb danh s\u00e1ch tr\u00ecnh \u0111\u01a1n.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5319 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-find-replace-highlight-29.png\" width=\"427\" height=\"615\" title=\"excel-find-replace-highlight-29\"><\/p>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n c\u1ea7n ch\u00e8n m\u1ed9t ng\u1eaft trang d\u1ecdc, h\u00e3y ch\u1ecdn c\u1ed9t c\u1ea7n thi\u1ebft \u1edf b\u00ean ph\u1ea3i. Nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o n\u00f3 v\u00e0 ch\u1ecdn Insert Page Break.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5320 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-find-replace-highlight-30.png\" width=\"367\" height=\"383\" title=\"excel-find-replace-highlight-30\"><\/p>\n<p style=\"text-align: justify\"><strong>M\u1eb9o<\/strong>. M\u1ed9t c\u00e1ch kh\u00e1c ch\u00e8n ng\u1eaft trang l\u00e0 v\u00e0o tab Page Layout, nh\u1ea5p v\u00e0o Breaks trong nh\u00f3m Page Setup v\u00e0 ch\u1ecdn t\u00f9y ch\u1ecdn t\u01b0\u01a1ng \u1ee9ng t\u1eeb danh s\u00e1ch th\u1ea3 xu\u1ed1ng.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5321 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-find-replace-highlight-31.png\" width=\"515\" height=\"178\" title=\"excel-find-replace-highlight-31\"><\/p>\n<p style=\"text-align: justify\"><strong>Ch\u00fa \u00fd<\/strong>. N\u1ebfu c\u00e1c ng\u1eaft trang th\u1ee7 c\u00f4ng m\u00e0 b\u1ea1n th\u00eam kh\u00f4ng ho\u1ea1t \u0111\u1ed9ng, b\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn t\u00f9y ch\u1ecdn <em>Fit To<\/em> (Tab Page <em><strong>Layout -&gt; Page Setup group -&gt; ch\u1ecdn Dialog Box Launcher Button -&gt; Page<\/strong><\/em>). Thay \u0111\u1ed5i th\u00e0nh <em>Adjust<\/em>.<\/p>\n<p style=\"text-align: justify\">Tr\u00ean h\u00ecnh b\u00ean d\u01b0\u1edbi, b\u1ea1n c\u00f3 th\u1ec3 th\u1ea5y 3 kho\u1ea3ng ng\u1eaft trang n\u1eb1m ngang. Do \u0111\u00f3, n\u1ebfu b\u1ea1n ch\u1ecdn Print Preview, b\u1ea1n s\u1ebd th\u1ea5y c\u00e1c ph\u1ea7n kh\u00e1c nhau c\u1ee7a d\u1eef li\u1ec7u tr\u00ean c\u00e1c trang t\u00ednh ri\u00eang bi\u1ec7t.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5322 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-find-replace-highlight-32.png\" width=\"443\" height=\"282\" title=\"excel-find-replace-highlight-32\"><\/p>\n<blockquote>\n<p style=\"text-align: justify\">Xem th\u00eam:\u00a0<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\">Kh\u00f3a h\u1ecdc Excel Online <\/a><\/p>\n<\/blockquote>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Chen_ngat_trang_trong_Excel_theo_dieu_kien\"><\/span><strong>Ch\u00e8n ng\u1eaft trang trong Excel theo \u0111i\u1ec1u ki\u1ec7n:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n th\u01b0\u1eddng in b\u1ea3ng d\u1eef li\u1ec7u c\u1ee7a m\u00ecnh, b\u1ea1n c\u00f3 th\u1ec3 mu\u1ed1n t\u00ecm hi\u1ec3u c\u00e1ch t\u1ef1 \u0111\u1ed9ng ch\u00e8n c\u00e1c ng\u1eaft trang theo \u0111i\u1ec1u ki\u1ec7n, v\u00ed d\u1ee5 khi m\u1ed9t gi\u00e1 tr\u1ecb trong c\u1ed9t nh\u1ea5t \u0111\u1ecbnh thay \u0111\u1ed5i. Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 c\u1ed9t t\u00ean Category v\u00e0 b\u1ea1n mu\u1ed1n m\u1ed7i lo\u1ea1i \u0111\u01b0\u1ee3c in tr\u00ean m\u1ed9t trang m\u1edbi.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5323 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-find-replace-highlight-33.png\" width=\"217\" height=\"349\" title=\"excel-find-replace-highlight-33\"><\/p>\n<p style=\"text-align: justify\">D\u01b0\u1edbi \u0111\u00e2y, b\u1ea1n s\u1ebd t\u00ecm th\u1ea5y m\u1ed9t s\u1ed1 macro h\u1eefu \u00edch v\u00e0 c\u00e1c b\u01b0\u1edbc c\u00e1ch th\u00eam ng\u1eaft trang b\u1eb1ng ch\u1ee9c n\u0103ng <strong>Subtotal<\/strong>.<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Su_dung_macro_de_ngat_trang\"><\/span><strong>S\u1eed d\u1ee5ng macro \u0111\u1ec3 <\/strong><strong>ng\u1eaft trang:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">D\u01b0\u1edbi \u0111\u00e2y l\u00e0 hai macro h\u1eefu \u00edch. Ch\u00fang s\u1ebd x\u00f3a t\u1ea5t c\u1ea3 c\u00e1c ng\u1eaft trang m\u1eb7c \u0111\u1ecbnh trong b\u1ea3ng c\u1ee7a b\u1ea1n v\u00e0 s\u1ebd d\u1ec5 d\u00e0ng th\u00eam c\u00e1c \u0111\u01b0\u1eddng \u0111\u00e1nh d\u1ea5u m\u1edbi t\u1ea1i c\u00e1c v\u1ecb tr\u00ed th\u00edch h\u1ee3p.<\/p>\n<blockquote>\n<p style=\"text-align: justify\">Xem th\u00eam:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc-lap-trinh-vba-trong-excel\">Kho\u0301a ho\u0323c excel vba online<\/a><\/p>\n<\/blockquote>\n<p style=\"text-align: justify\">Ch\u1ec9 c\u1ea7n ch\u1ecdn v\u00f9ng m\u00e0 b\u1ea1n mu\u1ed1n s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00e1ch v\u00e0 tr\u00e1nh ti\u00eau \u0111\u1ec1.<\/p>\n<p style=\"text-align: justify\"><strong>InsertPageBreaksIfValueChanged<\/strong> \u2013 ch\u00e8n trang ng\u1eaft n\u1ebfu gi\u00e1 tr\u1ecb trong c\u1ed9t thay \u0111\u1ed5i.<\/p>\n<p style=\"text-align: justify\"><strong>InsertPageBreaksByKeyphrase<\/strong> \u2013 th\u00eam ng\u1eaft trang m\u1ed7i khi n\u00f3 t\u00ecm th\u1ea5y m\u1ed9t \u00f4 c\u00f3 ch\u1ee9a \u201cgi\u00e1 tr\u1ecb \u00f4\u201d (to\u00e0n b\u1ed9 n\u1ed9i dung \u00f4, kh\u00f4ng ph\u1ea3i l\u00e0 m\u1ed9t ph\u1ea7n n\u1ed9i dung).<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5324 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-find-replace-highlight-34.png\" width=\"600\" height=\"494\" title=\"excel-find-replace-highlight-34\"><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Su_dung_subtotal_de_chen_cac_ngat_trang\"><\/span><strong>S\u1eed d\u1ee5ng subtotal \u0111\u1ec3 ch\u00e8n c\u00e1c ng\u1eaft trang:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">\u0110\u00e3 bao gi\u1edd b\u1ea1n ngh\u0129 \u0111\u1ebfn <a href=\"http:\/\/blog.ezworkapp.com\/ham-subtotal-cac-ung-dung-cua-subtotal-trong-excel.html\" target=\"_blank\" rel=\"noopener noreferrer\">Subtotal<\/a> nh\u01b0 l\u00e0 m\u1ed9t l\u1ef1a ch\u1ecdn \u0111\u1ec3 ch\u00e8n c\u00e1c ng\u1eaft trang trong Excel? T\u00ednh n\u0103ng n\u00e0y th\u1ef1c s\u1ef1 l\u00e0m cho qu\u00e1 tr\u00ecnh kh\u00e1 d\u1ec5 d\u00e0ng.<\/p>\n<ol style=\"text-align: justify\">\n<li>\u0110\u1ea3m b\u1ea3o r\u1eb1ng b\u1ea3ng c\u1ee7a b\u1ea1n c\u00f3 ti\u00eau \u0111\u1ec1. V\u00ed d\u1ee5: n\u1ebfu c\u1ed9t A ch\u1ee9a t\u00ean danh m\u1ee5c, th\u00ec \u00f4 A1 c\u1ea7n c\u00f3 nh\u00e3n \u201cLo\u1ea1i\u201d. \u0110\u1ea3m b\u1ea3o t\u1ea5t c\u1ea3 c\u00e1c c\u1ed9t trong b\u1ea3ng c\u1ee7a b\u1ea1n c\u00f3 ch\u1ee9a ti\u00eau \u0111\u1ec1.<\/li>\n<li>Ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u. Chuy\u1ec3n \u0111\u1ebfn <strong><em>Data<\/em><em> -&gt; <\/em><em>Sort<\/em><em> -&gt; <\/em><em>Sort by Category<\/em><\/strong>. Nh\u1ea5p OK \u0111\u1ec3 xem c\u00e1c b\u1ed9 ph\u1eadn d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n \u0111\u00e3 \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp.<\/li>\n<li>Ch\u1ecdn b\u1ea5t k\u1ef3 \u00f4 n\u00e0o trong b\u1ea3ng c\u1ee7a b\u1ea1n, \u0111i t\u1edbi tab <strong>Data<\/strong> v\u00e0 nh\u1ea5p v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng <strong>Subtotal<\/strong>.<\/li>\n<li>B\u1ea1n s\u1ebd th\u1ea5y h\u1ed9p tho\u1ea1i <em>Subtotal<\/em>.<\/li>\n<\/ol>\n<ul>\n<li style=\"text-align: justify\">Ch\u1ecdn c\u1ed9t ch\u00ednh c\u1ee7a b\u1ea1n t\u1eeb danh s\u00e1ch th\u1ea3 xu\u1ed1ng <strong>At each change in<\/strong>. Trong v\u00ed d\u1ee5, \u0111\u00f3 l\u00e0 Category.<\/li>\n<li style=\"text-align: justify\">Ch\u1ecdn t\u1eeb danh s\u00e1ch <strong><em>Use function<\/em><\/strong>. (H\u00e0m s\u1ebd s\u1eed d\u1ee5ng: sum, count\u2026)<\/li>\n<li style=\"text-align: justify\">\u0110\u00e1nh d\u1ea5u ch\u1ecdn trong <strong>Add subtotal to<\/strong>. (C\u1ed9t s\u1ebd th\u1ef1c hi\u1ec7n subtotal)<\/li>\n<li style=\"text-align: justify\">Nh\u1edb ch\u1ecdn <strong>Page break between groups<\/strong><\/li>\n<li style=\"text-align: justify\">Nh\u1ea5p chu\u1ed9t v\u00e0o <strong>OK<\/strong>.<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5326 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-find-replace-highlight-35.png\" width=\"503\" height=\"365\" title=\"excel-find-replace-highlight-35\"><\/p>\n<p style=\"text-align: justify\">B\u1ea1n c\u00f3 th\u1ec3 x\u00f3a c\u00e1c h\u00e0ng v\u00e0 \u00f4 t\u00ednh t\u1ed5ng n\u1ebfu b\u1ea1n kh\u00f4ng c\u1ea7n ch\u00fang v\u00e0 b\u1ea3ng c\u1ee7a b\u1ea1n t\u1ef1 \u0111\u1ed9ng ch\u00e8n trang theo c\u00e1c c\u00e0i \u0111\u1eb7t \u0111\u00e3 ch\u1ecdn.<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Lam_the_nao_de_loai_bo_ngat_trang_trong_Excel\"><\/span><strong>L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 lo\u1ea1i b\u1ecf ng\u1eaft trang trong Excel:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">M\u1eb7c d\u00f9 kh\u00f4ng th\u1ec3 xo\u00e1 c\u00e1c ng\u1eaft trang m\u00e0 Excel t\u1ef1 \u0111\u1ed9ng th\u00eam v\u00e0o, b\u1ea1n c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng x\u00f3a b\u1ecf nh\u1eefng ph\u1ea7n b\u1ea1n ch\u00e8n b\u1eb1ng tay. B\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn lo\u1ea1i b\u1ecf m\u1ed9t s\u1ed1 d\u00f2ng \u0111\u00e1nh d\u1ea5u nh\u1ea5t \u0111\u1ecbnh ho\u1eb7c lo\u1ea1i b\u1ecf t\u1ea5t c\u1ea3 c\u00e1c ng\u1eaft trang ch\u00e8n th\u1ee7 c\u00f4ng.<\/p>\n<p style=\"text-align: justify\"><strong>X\u00f3a m\u1ed9t ng\u1eaft trang<\/strong><\/p>\n<p style=\"text-align: justify\">H\u00e3y l\u00e0m theo c\u00e1c b\u01b0\u1edbc d\u01b0\u1edbi \u0111\u00e2y \u0111\u1ec3 lo\u1ea1i b\u1ecf m\u1ed9t ng\u1eaft trang trong Excel.<\/p>\n<ol style=\"text-align: justify\">\n<li>Ch\u1ecdn b\u1ea3ng t\u00ednh m\u00e0 b\u1ea1n mu\u1ed1n x\u00f3a d\u1ea5u ng\u1eaft trang.<\/li>\n<li>Nh\u1ea5p v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng <em>Page Break Preview<\/em> b\u00ean d\u01b0\u1edbi tab <em>View<\/em> ho\u1eb7c nh\u1ea5p v\u00e0o <em>Page Break Preview Button<\/em> tr\u00ean thanh tr\u1ea1ng th\u00e1i.<\/li>\n<li>B\u00e2y gi\u1edd h\u00e3y ch\u1ecdn ph\u1ea7n ng\u1eaft trang m\u00e0 b\u1ea1n c\u1ea7n x\u00f3a:<\/li>\n<\/ol>\n<ul style=\"text-align: justify\">\n<li>\u0110\u1ec3 x\u00f3a ng\u1eaft trang d\u1ecdc, h\u00e3y ch\u1ecdn c\u1ed9t b\u00ean ph\u1ea3i c\u1ee7a ng\u1eaft trang. Sau \u0111\u00f3 k\u00edch chu\u1ed9t ph\u1ea3i v\u00e0o n\u00f3 v\u00e0 ch\u1ecdn <strong><em>Remove Page Break<\/em><\/strong>.<\/li>\n<li>\u0110\u1ec3 lo\u1ea1i b\u1ecf m\u1ed9t ng\u1eaft trang ngang, h\u00e3y ch\u1ecdn h\u00e0ng b\u00ean d\u01b0\u1edbi d\u00f2ng m\u00e0 b\u1ea1n mu\u1ed1n x\u00f3a. Nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o h\u00e0ng n\u00e0y v\u00e0 ch\u1ecdn <strong><em>Remove Page Break<\/em><\/strong> t\u1eeb danh s\u00e1ch.<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5327 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-find-replace-highlight-36.png\" width=\"254\" height=\"463\" title=\"excel-find-replace-highlight-36\"><\/p>\n<p style=\"text-align: justify\"><strong>M\u1eb9o<\/strong>. B\u1ea1n c\u0169ng c\u00f3 th\u1ec3 x\u00f3a m\u1ed9t ng\u1eaft trang b\u1eb1ng c\u00e1ch k\u00e9o n\u00f3 b\u00ean ngo\u00e0i khu v\u1ef1c xem tr\u01b0\u1edbc.<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Loai_bo_tat_ca_cac_ngat_trang\"><\/span><strong>Lo\u1ea1i b\u1ecf t\u1ea5t c\u1ea3 c\u00e1c ng\u1eaft trang:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n c\u1ea7n xo\u00e1 t\u1ea5t c\u1ea3 c\u00e1c ng\u1eaft trang, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng <em>Reset All Page Breaks<\/em>.<\/p>\n<ol style=\"text-align: justify\">\n<li style=\"list-style-type: none\">\n<ol>\n<li>M\u1edf b\u1ea3ng t\u00ednh b\u1ea1n mu\u1ed1n s\u1eeda \u0111\u1ed5i.<\/li>\n<li>Nh\u1ea5p v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng <strong><em>Page Break Preview<\/em><\/strong> b\u00ean d\u01b0\u1edbi tab <strong>View<\/strong> ho\u1eb7c nh\u1ea5p v\u00e0o h\u00ecnh <strong>Page Break Preview Button<\/strong> tr\u00ean thanh tr\u1ea1ng th\u00e1i.<\/li>\n<li>\u0110i t\u1edbi tab <strong>Page Layout<\/strong> trong nh\u00f3m <strong>Page Setup<\/strong> v\u00e0 nh\u1ea5p v\u00e0o <strong>Breaks<\/strong>.<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5328 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-find-replace-highlight-37.png\" width=\"432\" height=\"118\" title=\"excel-find-replace-highlight-37\"><\/p>\n<p style=\"text-align: justify\">4. Ch\u1ecdn t\u00f9y ch\u1ecdn <strong>Reset All Page Breaks<\/strong>.<\/p>\n<p style=\"text-align: justify\"><strong>M\u1eb9o.<\/strong> B\u1ea1n c\u0169ng c\u00f3 th\u1ec3 nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o b\u1ea5t k\u1ef3 \u00f4 n\u00e0o trong worksheet v\u00e0 ch\u1ecdn Reset All Page Breaks t\u1eeb danh s\u00e1ch.<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Di_chuyen_mot_ngat_trang_trong_Excel\"><\/span><strong>Di chuy\u1ec3n m\u1ed9t ng\u1eaft trang trong Excel:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">M\u1ed9t tu\u1ef3 ch\u1ecdn kh\u00e1c c\u00f3 th\u1ec3 h\u1eefu \u00edch l\u00e0 k\u00e9o ng\u1eaft trang sang v\u1ecb tr\u00ed kh\u00e1c trong b\u1ea3ng t\u00ednh.<\/p>\n<ol style=\"text-align: justify\">\n<li>Nh\u1ea5p v\u00e0o <strong><em>Page Break Preview<\/em><\/strong> b\u00ean d\u01b0\u1edbi tab <strong>View<\/strong> ho\u1eb7c nh\u1ea5p v\u00e0o h\u00ecnh <strong>Page Break Preview Button<\/strong> tr\u00ean thanh tr\u1ea1ng th\u00e1i.<\/li>\n<li>\u0110\u1ec3 di chuy\u1ec3n m\u1ed9t ng\u1eaft trang, ch\u1ec9 c\u1ea7n k\u00e9o m\u1ed9t v\u1ecb tr\u00ed m\u1edbi.<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5329 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-find-replace-highlight-38.png\" width=\"399\" height=\"281\" title=\"excel-find-replace-highlight-38\"><\/p>\n<p style=\"text-align: justify\"><strong>Ch\u00fa \u00fd<\/strong>. Sau khi b\u1ea1n di chuy\u1ec3n m\u1ed9t ng\u1eaft trang t\u1ef1 \u0111\u1ed9ng, n\u00f3 s\u1ebd tr\u1edf th\u00e0nh ng\u1eaft trang th\u1ee7 c\u00f4ng.<\/p>\n<p style=\"text-align: justify\"><strong>\u1ea8n ho\u1eb7c hi\u1ec3n th\u1ecb d\u1ea5u ph\u00e2n c\u00e1ch trang<\/strong><\/p>\n<p style=\"text-align: justify\">D\u01b0\u1edbi \u0111\u00e2y b\u1ea1n s\u1ebd th\u1ea5y c\u00e1ch hi\u1ec3n th\u1ecb ho\u1eb7c \u1ea9n c\u00e1c ng\u1eaft trang trong ch\u1ebf \u0111\u1ed9 xem b\u00ecnh th\u01b0\u1eddng<\/p>\n<ol style=\"text-align: justify\">\n<li>Nh\u1ea5p v\u00e0o tab <strong>File<\/strong>.<\/li>\n<li>Chuy\u1ec3n \u0111\u1ebfn <strong>Options -&gt; Advanced<\/strong>.<\/li>\n<li>K\u00e9o xu\u1ed1ng c\u00e1c t\u00f9y ch\u1ecdn <strong><em>Display options for this worksheet<\/em><\/strong> v\u00e0 \u0111\u00e1nh d\u1ea5u ho\u1eb7c x\u00f3a h\u1ed9p ki\u1ec3m <strong><em>Show page breaks<\/em><\/strong>.<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5330 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-find-replace-highlight-39.png\" width=\"557\" height=\"465\" title=\"excel-find-replace-highlight-39\"><\/p>\n<p style=\"text-align: justify\">B\u00e2y gi\u1edd b\u1ea1n \u0111\u00e3 bi\u1ebft c\u00e1ch b\u1eadt ho\u1eb7c t\u1eaft trang trong ch\u1ebf \u0111\u1ed9 xem B\u00ecnh th\u01b0\u1eddng.<\/p>\n<p style=\"text-align: justify\"><strong>\u0110\u1eb7t l\u1ea1i v\u1ec1 ch\u1ebf \u0111\u1ed9 xem B\u00ecnh th\u01b0\u1eddng<\/strong><\/p>\n<p style=\"text-align: justify\">B\u00e2y gi\u1edd t\u1ea5t c\u1ea3 c\u00e1c trang c\u1ee7a b\u1ea1n \u0111\u00e3 t\u00ecm th\u1ea5y v\u1ecb tr\u00ed ch\u00ednh x\u00e1c, b\u1ea1n c\u00f3 th\u1ec3 tr\u1edf l\u1ea1i ch\u1ebf \u0111\u1ed9 xem b\u00ecnh th\u01b0\u1eddng. \u0110\u01a1n gi\u1ea3n l\u00e0 nh\u1ea5p v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng <strong>Normal <\/strong>b\u00ean d\u01b0\u1edbi tab <strong>View<\/strong> trong Excel.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5331 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-find-replace-highlight-40.png\" width=\"426\" height=\"114\" title=\"excel-find-replace-highlight-40\"><\/p>\n<p style=\"text-align: justify\">B\u1ea1n c\u0169ng c\u00f3 th\u1ec3 nh\u1ea5p v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng <strong>Normal<\/strong> tr\u00ean thanh tr\u1ea1ng th\u00e1i.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5332 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-find-replace-highlight-41.png\" width=\"398\" height=\"225\" title=\"excel-find-replace-highlight-41\"><\/p>\n<p style=\"text-align: justify\"><em><strong>Ngu\u1ed3n:<\/strong> Ablebits, d\u1ecbch v\u00e0 bi\u00ean t\u1eadp b\u1edfi Hocexcel Online.<\/em><\/p>\n<blockquote>\n<p style=\"text-align: justify\">T\u00f4\u0309ng h\u01a1\u0323p gia\u0301o tri\u0300nh\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/excel-co-ban\">h\u01b0\u1edbng d\u1eabn h\u1ecdc Excel c\u01a1 b\u1ea3n<\/a><\/p>\n<\/blockquote>\n<p>\u0110\u1ec3 c\u00f3 th\u1ec3 \u1ee9ng d\u1ee5ng t\u1ed1t Excel v\u00e0o trong c\u00f4ng vi\u1ec7c, ch\u00fang ta kh\u00f4ng ch\u1ec9 n\u1eafm v\u1eefng \u0111\u01b0\u1ee3c c\u00e1c h\u00e0m m\u00e0 c\u00f2n ph\u1ea3i s\u1eed d\u1ee5ng t\u1ed1t c\u1ea3 c\u00e1c c\u00f4ng c\u1ee5 c\u1ee7a Excel. Nh\u1eefng h\u00e0m n\u00e2ng cao gi\u00fap \u00e1p d\u1ee5ng t\u1ed1t v\u00e0o c\u00f4ng vi\u1ec7c nh\u01b0 SUMIFS, COUNTIFS, SUMPRODUCT, INDEX + MATCH\u2026 Nh\u1eefng c\u00f4ng c\u1ee5 th\u01b0\u1eddng s\u1eed d\u1ee5ng l\u00e0 Data validation, Conditional formatting, Pivot table\u2026<\/p>\n<p>To\u00e0n b\u1ed9 nh\u1eefng ki\u1ebfn th\u1ee9c n\u00e0y c\u00e1c b\u1ea1n \u0111\u1ec1u c\u00f3 th\u1ec3 h\u1ecdc \u0111\u01b0\u1ee3c trong kh\u00f3a h\u1ecdc\u00a0<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\">EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi chuy\u00ean gia<\/a>\u00a0c\u1ee7a H\u1ecdc Excel Online. Hi\u1ec7n nay h\u1ec7 th\u1ed1ng \u0111ang c\u00f3 \u01b0u \u0111\u00e3i r\u1ea5t l\u1edbn cho b\u1ea1n khi \u0111\u0103ng k\u00fd tham gia kh\u00f3a h\u1ecdc. Chi ti\u1ebft xem t\u1ea1i: <a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\" target=\"_blank\" rel=\"noopener noreferrer\">HocExcel.Online<\/a><\/p>\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-28.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":1187,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-1186","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\/1186","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=1186"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/1186\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/1187"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=1186"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=1186"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=1186"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}