{"id":7805,"date":"2024-12-21T18:33:13","date_gmt":"2024-12-21T18:33:13","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cach-chen-va-xoa-so-trang-trong-nhieu-trang-tinh-cua-excel-2010-2013-2016\/"},"modified":"2024-12-21T18:33:13","modified_gmt":"2024-12-21T18:33:13","slug":"cach-chen-va-xoa-so-trang-trong-nhieu-trang-tinh-cua-excel-2010-2013-2016","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cach-chen-va-xoa-so-trang-trong-nhieu-trang-tinh-cua-excel-2010-2013-2016\/","title":{"rendered":"C\u00e1ch ch\u00e8n v\u00e0 x\u00f3a s\u1ed1 trang trong nhi\u1ec1u trang t\u00ednh c\u1ee7a Excel 2010, 2013, 2016"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\"><em>Trong b\u00e0i vi\u1ebft n\u00e0y, <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong><\/a> s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n <a href=\"http:\/\/blog.ezworkapp.com\/cach-chen-va-xoa-so-trang-trong-nhieu-trang-tinh-cua-excel-2010-2013-2016.html\"><strong>c\u00e1ch ch\u00e8n v\u00e0 x\u00f3a s\u1ed1 trang trong Excel<\/strong> <\/a>n\u1ebfu trang t\u00ednh c\u1ee7a b\u1ea1n ch\u1ee9a m\u1ed9t ho\u1eb7c nhi\u1ec1u trang, l\u00e0m th\u1ebf n\u00e0o ch\u1ecdn s\u1ed1 \u0111\u1ec3 b\u1eaft \u0111\u1ea7u trang t\u00ednh v\u00e0 x\u00f3a k\u00fd hi\u1ec7u s\u1ed1 ch\u00e8n sai.<\/em><\/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-676709e82b597\" 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-xoa-so-trang-trong-nhieu-trang-tinh-cua-excel-2010-2013-2016.html#Chen_so_trang_tren_mot_trang_tinh_Excel\" title=\"Ch\u00e8n s\u1ed1 trang tr\u00ean m\u1ed9t trang t\u00ednh Excel\">Ch\u00e8n s\u1ed1 trang tr\u00ean m\u1ed9t trang t\u00ednh Excel<\/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-xoa-so-trang-trong-nhieu-trang-tinh-cua-excel-2010-2013-2016.html#Lam_the_nao_de_chen_so_trang_vao_nhieu_trang_tinh_Excel\" title=\"L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 ch\u00e8n s\u1ed1 trang v\u00e0o nhi\u1ec1u trang t\u00ednh Excel\">L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 ch\u00e8n s\u1ed1 trang v\u00e0o nhi\u1ec1u trang t\u00ednh Excel<\/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-xoa-so-trang-trong-nhieu-trang-tinh-cua-excel-2010-2013-2016.html#Tuy_chinh_viec_danh_so_trang_cho_trang_bat_dau\" title=\"T\u00f9y ch\u1ec9nh vi\u1ec7c \u0111\u00e1nh s\u1ed1 trang cho trang b\u1eaft \u0111\u1ea7u:\">T\u00f9y ch\u1ec9nh vi\u1ec7c \u0111\u00e1nh s\u1ed1 trang cho trang b\u1eaft \u0111\u1ea7u:<\/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-xoa-so-trang-trong-nhieu-trang-tinh-cua-excel-2010-2013-2016.html#Thay_doi_thu_tu_so_trang_duoc_them_vao\" title=\"Thay \u0111\u1ed5i th\u1ee9 t\u1ef1 s\u1ed1 trang \u0111\u01b0\u1ee3c th\u00eam v\u00e0o:\">Thay \u0111\u1ed5i th\u1ee9 t\u1ef1 s\u1ed1 trang \u0111\u01b0\u1ee3c th\u00eam v\u00e0o:<\/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-xoa-so-trang-trong-nhieu-trang-tinh-cua-excel-2010-2013-2016.html#Xoa_so_trang_trong_Excel\" title=\"X\u00f3a s\u1ed1 trang trong Excel\">X\u00f3a s\u1ed1 trang trong Excel<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Chen_so_trang_tren_mot_trang_tinh_Excel\"><\/span><strong>Ch\u00e8n s\u1ed1 trang tr\u00ean m\u1ed9t trang t\u00ednh Excel<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">\u0110\u00e1nh d\u1ea5u trang lu\u00f4n h\u1eefu d\u1ee5ng n\u1ebfu b\u1ea3ng t\u00ednh c\u1ee7a b\u1ea1n qu\u00e1 l\u1edbn v\u00e0 bu\u1ed9c ph\u1ea3i in nhi\u1ec1u trang gi\u1ea5y. B\u1ea1n c\u00f3 th\u1ec3 \u0111\u1eb7t s\u1ed1 trang cho m\u1ed7i trang t\u00ednh b\u1eb1ng <strong><em>Page Layout<\/em><\/strong>.<\/p>\n<p style=\"text-align: justify\">1. M\u1edf b\u1ea3ng t\u00ednh Excel c\u1ea7n ch\u00e8n s\u1ed1 trang.<\/p>\n<p style=\"text-align: justify\">2. V\u00e0o th\u1ebb\u00a0<em><strong>Insert<\/strong><\/em>, ch\u1ecdn\u00a0<em><strong>Header &amp; Footer\u00a0<\/strong><\/em>trong nh\u00f3m\u00a0<em><strong>Text<\/strong><\/em>.<\/p>\n<figure style=\"width: 422px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"Ch\u00e8n s\u1ed1 trang tr\u00ean m\u1ed9t trang t\u00ednh Excel\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-header-footer-icon.png\" alt=\"Click on the Header &amp; Footer in the Text group\" width=\"422\" height=\"94\"><figcaption class=\"wp-caption-text\">Ch\u00e8n s\u1ed1 trang tr\u00ean m\u1ed9t trang t\u00ednh Excel<\/figcaption><\/figure>\n<p style=\"text-align: justify\"><strong>Ch\u00fa \u00fd.\u00a0<\/strong>B\u1ea1n c\u00f3 th\u1ec3 nh\u1ea5p ch\u1ecdn n\u00fat\u00a0<em><strong>Page Layout Button\u00a0<\/strong><\/em>tr\u00ean thanh tr\u1ea1ng th\u00e1i Excel.<\/p>\n<figure style=\"width: 390px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"B\u1ea1n c\u00f3 th\u1ec3 nh\u1ea5p ch\u1ecdn n\u00fat\u00a0Page Layout Button\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-page-layout-view.png\" alt=\"Click on the Page Layout Button image on the status bar in Excel\" width=\"390\" height=\"127\"><figcaption class=\"wp-caption-text\">B\u1ea1n c\u00f3 th\u1ec3 nh\u1ea5p ch\u1ecdn n\u00fat\u00a0Page Layout Button<\/figcaption><\/figure>\n<p style=\"text-align: justify\">3. B\u1ea1n c\u00f3 th\u1ec3 xem trang t\u00ednh theo ch\u1ebf \u0111\u1ed9\u00a0<em><strong>Page Layout<\/strong><\/em>. Nh\u1ea5p v\u00e0o v\u00f9ng\u00a0<em><strong>Click to add header<\/strong><\/em><strong>\u00a0<\/strong>ho\u1eb7c<em><strong>\u00a0Click to add Footer.<\/strong><\/em><\/p>\n<figure style=\"width: 507px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"Click to add header\u00a0ho\u1eb7c\u00a0Click to add Footer\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-click-add-header.png\" alt=\"Place your mouse cursor to the field Click to add header\" width=\"507\" height=\"143\"><figcaption class=\"wp-caption-text\">Click to add header\u00a0ho\u1eb7c\u00a0Click to add Footer<\/figcaption><\/figure>\n<p style=\"text-align: justify\">4. V\u00e0o th\u1ebb\u00a0<em><strong>Design,\u00a0<\/strong><\/em>ch\u00fa \u00fd\u00a0<em><strong>Header &amp; Footer Tools<\/strong><\/em>.<\/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-319.gif\" title=\"vba101_92019-nho-319\"><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-702.gif\" title=\"ex101_92019-nho-702\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"text-align: justify\">C\u1ea3 hai v\u00f9ng header v\u00e0 footer \u0111\u1ec1u g\u1ed3m ba ph\u1ea7n: tr\u00e1i, ph\u1ea3i v\u00e0 gi\u1eefa. B\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn b\u1ea5t k\u1ef3 ph\u1ea7n n\u00e0o b\u1eb1ng c\u00e1ch nh\u1ea5p v\u00e0o ph\u1ea7n mu\u1ed1n ch\u1ecdn.<\/p>\n<figure id=\"attachment_5312\" aria-describedby=\"caption-attachment-5312\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-5312 size-full\" title=\"Design,\u00a0ch\u00fa \u00fd\u00a0Header &amp; Footer Tools\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/header-footer-section-box.png\" alt=\"Design,\u00a0ch\u00fa \u00fd\u00a0Header &amp; Footer Tools\" width=\"600\" height=\"132\"><figcaption id=\"caption-attachment-5312\" class=\"wp-caption-text\">Design,\u00a0ch\u00fa \u00fd\u00a0Header &amp; Footer Tools<\/figcaption><\/figure>\n<p style=\"text-align: left\">5. Nh\u1ea5n ch\u1ecdn bi\u1ec3u t\u01b0\u1ee3ng\u00a0<em><strong>Page Number\u00a0<\/strong><\/em>trong nh\u00f3m\u00a0<strong>Header &amp; Footer Elements<\/strong><em>.<\/em><\/p>\n<figure style=\"width: 597px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"Page Number\u00a0trong nh\u00f3m\u00a0Header &amp; Footer Elements\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/header-footer-page-number.png\" alt=\"Go to the Header &amp; Footer Elements group and click on the Page Number icon\" width=\"597\" height=\"143\"><figcaption class=\"wp-caption-text\">Page Number\u00a0trong nh\u00f3m\u00a0Header &amp; Footer Elements<\/figcaption><\/figure>\n<p style=\"text-align: justify\">6.\u00a0<em><strong>&amp;[Page]\u00a0<\/strong><\/em>s\u1ebd xu\u1ea5t hi\u1ec7n \u1edf ph\u1ea7n \u0111\u01b0\u1ee3c ch\u1ecdn.<\/p>\n<p style=\"text-align: center\"><img decoding=\"async\" src=\"https:\/\/blog.hocexcel.online\/wp-content\/uploads\/img-blog\/header-footer-placeholder.png\" alt=\"You'll see the placeholder &amp;[Page] appear in the selected section\"><\/p>\n<p style=\"text-align: justify\">7. N\u1ebfu b\u1ea1n mu\u1ed1n th\u00eam v\u00e0o t\u1ed5ng s\u1ed1 trang, g\u00f5 d\u1ea5u c\u00e1ch v\u00e0o sau\u00a0<em><strong>&amp;[Page]<\/strong>.\u00a0<\/em>Sau \u0111\u00f3 g\u00f5 t\u1eeb\u00a0<em><strong>of\u00a0<\/strong><\/em>sau kho\u1ea3ng tr\u1ed1ng.<\/p>\n<figure style=\"width: 238px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"t\u1ed5ng s\u1ed1 trang, g\u00f5 d\u1ea5u c\u00e1ch v\u00e0o sau\u00a0&amp;[Page]\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/header-footer-placeholder-excel.png\" alt=\"Enter &amp;[Page] + space + of + space in the selected section\" width=\"238\" height=\"102\"><figcaption class=\"wp-caption-text\">t\u1ed5ng s\u1ed1 trang, g\u00f5 d\u1ea5u c\u00e1ch\u00a0 &amp;[Page]<\/figcaption><\/figure>\n<p style=\"text-align: justify\">\u00a08. Nh\u1ea5p ch\u1ecdn bi\u1ec3u t\u01b0\u1ee3ng\u00a0<em><strong>Number of Pages\u00a0<\/strong><\/em>trong nh\u00f3m\u00a0<em><strong>Header &amp; Footer Elements\u00a0<\/strong><\/em>\u0111\u1ec3 th\u1ea5y\u00a0<em><strong>&amp;[Page] of &amp;[Pages]\u00a0<\/strong><\/em>\u0111\u01b0\u1ee3c thay th\u1ebf trong ph\u1ea7n \u0111\u01b0\u1ee3c ch\u1ecdn.<\/p>\n<p style=\"text-align: center\"><img decoding=\"async\" src=\"https:\/\/blog.hocexcel.online\/wp-content\/uploads\/img-blog\/header-footer-placeholder-results.png\" alt=\"See the placeholder &amp;[Page] of &amp;[Pages] in the selected section\"><\/p>\n<p style=\"text-align: justify\">9. Nh\u1ea5p v\u00e0o b\u1ea5t c\u1ee9 \u0111\u00e2u ngo\u00e0i v\u00f9ng header v\u00e0 footer \u0111\u1ec3 th\u1ea5y hi\u1ec3n th\u1ecb s\u1ed1 trang.<\/p>\n<figure style=\"width: 300px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"V\u00f9ng header v\u00e0 footer\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/header-footer-page-number1.png\" alt=\"Display the page numbers by clicking anywhere outside the header area\" width=\"300\" height=\"197\"><figcaption class=\"wp-caption-text\">V\u00f9ng header v\u00e0 footer<\/figcaption><\/figure>\n<p style=\"text-align: justify\">B\u00e2y gi\u1edd b\u1ea1n c\u00f3 th\u1ec3 tr\u1edf l\u1ea1i ch\u1ebf \u0111\u1ed9 xem b\u00ecnh th\u01b0\u1eddng b\u1eb1ng c\u00e1ch nh\u1ea5p v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng\u00a0<em><strong>Normal\u00a0<\/strong><\/em>trong th\u1ebb\u00a0<em><strong>View<\/strong><\/em>. B\u1ea1n c\u0169ng c\u00f3 th\u1ec3 nh\u1ea5n bi\u1ec3u t\u01b0\u1ee3ng <em><strong>Normal <\/strong><\/em>tr\u00ean thanh tr\u1ea1ng th\u00e1i.<\/p>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n m\u1edf ch\u1ebf \u0111\u1ed9\u00a0<em><strong>Print Preview<\/strong><\/em>, b\u1ea1n s\u1ebd th\u1ea5y s\u1ed1 trang \u0111\u00e3 \u0111\u01b0\u1ee3c ch\u00e8n v\u00e0o c\u00e1c trang t\u00ednh.<\/p>\n<blockquote>\n<p style=\"text-align: justify\">Xem th\u00eam:<a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc-excel-tu-co-ban-toi-nang-cao-danh-cho-dan-van-phong-2010-20132016\"><strong> Excel c\u01a1 b\u1ea3n t\u1edbi chuy\u00ean gia d\u00e0nh cho ng\u01b0\u1eddi chu\u1ea9n b\u1ecb xin vi\u1ec7c<\/strong><\/a><\/p>\n<\/blockquote>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Lam_the_nao_de_chen_so_trang_vao_nhieu_trang_tinh_Excel\"><\/span><strong>L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 ch\u00e8n s\u1ed1 trang v\u00e0o nhi\u1ec1u trang t\u00ednh Excel<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">B\u1ea1n c\u00f3 m\u1ed9t b\u1ea3ng t\u00ednh v\u1edbi ba trang t\u00ednh. M\u1ed7i trang t\u00ednh c\u00f3 c\u00e1c trang 1, 2, v\u00e0 3. B\u1ea1n c\u00f3 th\u1ec3 ch\u00e8n s\u1ed1 trang tr\u00ean nhi\u1ec1u trang t\u00ednh \u0111\u1ec3 t\u1ea5t c\u1ea3 c\u00e1c trang \u0111\u1ec1u \u0111\u01b0\u1ee3c \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng h\u1ed9p tho\u1ea1i <em><strong>Page Setup<\/strong><\/em>.<\/p>\n<p style=\"text-align: justify\">1. M\u1edf file Excel v\u1edbi b\u1ea3ng t\u00ednh c\u1ea7n \u0111\u00e1nh s\u1ed1 trang.<\/p>\n<p style=\"text-align: justify\">2. Chuy\u1ec3n \u0111\u1ebfn th\u1ebb <em><strong>Page Layout<\/strong><\/em>. Nh\u1ea5p chu\u1ed9t v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng m\u1edf r\u1ed9ng trong nh\u00f3m <strong>Page Setup<\/strong>..<\/p>\n<figure id=\"attachment_5313\" aria-describedby=\"caption-attachment-5313\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-5313 size-full\" title=\"L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 ch\u00e8n s\u1ed1 trang v\u00e0o nhi\u1ec1u trang t\u00ednh Excel\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1.png\" alt=\"L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 ch\u00e8n s\u1ed1 trang v\u00e0o nhi\u1ec1u trang t\u00ednh Excel\" width=\"600\" height=\"113\"><figcaption id=\"caption-attachment-5313\" class=\"wp-caption-text\">L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 ch\u00e8n s\u1ed1 trang v\u00e0o nhi\u1ec1u trang t\u00ednh Excel<\/figcaption><\/figure>\n<p style=\"text-align: justify\">3. Di chuy\u1ec3n \u0111\u1ebfn th\u1ebb\u00a0<strong><em>Header\/Footer\u00a0<\/em><\/strong>trong h\u1ed9p tho\u1ea1i\u00a0<em><strong>Page Setup<\/strong><\/em>. Nh\u1ea5n v\u00e0o n\u00fat\u00a0<em><strong>Custom Header\u00a0<\/strong><\/em>ho\u1eb7c\u00a0<em><strong>Custom Footer<\/strong><\/em>.<\/p>\n<figure style=\"width: 452px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"Custom Header\u00a0ho\u1eb7c\u00a0Custom Footer\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/setup-custom-footer-header.png\" alt=\"Press the Custom Header or Custom Footer button\" width=\"452\" height=\"459\"><figcaption class=\"wp-caption-text\">Custom Header\u00a0ho\u1eb7c\u00a0Custom Footer<\/figcaption><\/figure>\n<p style=\"text-align: justify\">4. C\u1eeda s\u1ed5 <em><strong>Page Setup<\/strong><\/em> xu\u1ea5t hi\u1ec7n. X\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed cho s\u1ed1 trang b\u1eb1ng c\u00e1ch nh\u1ea5p v\u00e0o \u00a0c\u00e1c h\u1ed9p\u00a0<em><strong>Left<\/strong> <strong>section:, Center section:,<\/strong> <strong>\u00a0Right Section:.<\/strong><\/em><\/p>\n<figure id=\"attachment_5314\" aria-describedby=\"caption-attachment-5314\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-5314 size-full\" title=\"C\u1eeda s\u1ed5 Page Setup xu\u1ea5t hi\u1ec7n\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/footer-sections-excel.png\" alt=\"C\u1eeda s\u1ed5 Page Setup xu\u1ea5t hi\u1ec7n\" width=\"600\" height=\"318\"><figcaption id=\"caption-attachment-5314\" class=\"wp-caption-text\">C\u1eeda s\u1ed5 Page Setup xu\u1ea5t hi\u1ec7n<\/figcaption><\/figure>\n<p style=\"text-align: justify\">5. Nh\u1ea5p v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng <em><strong>Insert Page Number Button<\/strong><\/em>.<\/p>\n<figure style=\"width: 569px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"Insert Page Number Button\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/insert-page-number-button.png\" alt=\"Click on the Insert Page Number Button image\" width=\"569\" height=\"311\"><figcaption class=\"wp-caption-text\">Insert Page Number Button<\/figcaption><\/figure>\n<p style=\"text-align: justify\">6. Khi <strong><em>&amp;[Page]<\/em>\u00a0<\/strong>xu\u1ea5t hi\u1ec7n, g\u00f5 d\u1ea5u c\u00e1ch v\u00e0 <em><strong>of<\/strong><\/em>\u00a0v\u00e0o sau <strong>&amp;[Page]. <\/strong>Sau \u0111\u00f3 nh\u1ea5p ch\u1ecdn bi\u1ec3u t\u01b0\u1ee3ng\u00a0<em><strong>Insert Number of Pages.<\/strong><\/em><\/p>\n<p style=\"text-align: justify\"><strong><em>&amp;[Page] of &amp;[Pages]\u00a0<\/em><\/strong>s\u1ebd \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb.<\/p>\n<p style=\"text-align: center\"><img decoding=\"async\" src=\"https:\/\/blog.hocexcel.online\/wp-content\/uploads\/img-blog\/insert-page-placeholder-displayed.png\" alt=\"The placeholder &amp;[Page] of &amp;[Pages] is displayed\"><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Tuy_chinh_viec_danh_so_trang_cho_trang_bat_dau\"><\/span><span lang=\"vi\"><strong>T\u00f9y ch\u1ec9nh vi\u1ec7c \u0111\u00e1nh s\u1ed1 trang cho trang b\u1eaft \u0111\u1ea7u:<\/strong><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\"><span lang=\"vi\">Theo m\u1eb7c \u0111\u1ecbnh, c\u00e1c trang \u0111\u01b0\u1ee3c \u0111\u00e1nh s\u1ed1 tu\u1ea7n t\u1ef1 b\u1eaft \u0111\u1ea7u t\u1eeb trang 1, nh\u01b0ng b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 b\u1eaft \u0111\u1ea7u th\u1ee9 t\u1ef1 v\u1edbi m\u1ed9t s\u1ed1 kh\u00e1c.<\/span><\/p>\n<blockquote>\n<p style=\"text-align: justify\">N\u00ean xem th\u00eam:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\">H\u1ecdc excel \u1edf \u0111\u00e2u t\u1ed1t<\/a> ?<\/p>\n<\/blockquote>\n<p style=\"text-align: justify\"><span lang=\"vi\">1. L\u00e0m theo c\u00e1c b\u01b0\u1edbc <em>L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 ch\u00e8n s\u1ed1 trang v\u00e0o nhi\u1ec1u trang t\u00ednh Excel<\/em>.<\/span><\/p>\n<p style=\"text-align: justify\"><span lang=\"vi\">2. Chuy\u1ec3n \u0111\u1ebfn th\u1ebb <em><strong>Page Layout<\/strong><\/em>. Nh\u1ea5p chu\u1ed9t v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng m\u1edf r\u1ed9ng trong nh\u00f3m <strong>Page Setup<\/strong>..<\/span><\/p>\n<figure id=\"attachment_5325\" aria-describedby=\"caption-attachment-5325\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-5325 size-full\" title=\"T\u00f9y ch\u1ec9nh vi\u1ec7c \u0111\u00e1nh s\u1ed1 trang cho trang b\u1eaft \u0111\u1ea7u\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1-1.png\" alt=\"T\u00f9y ch\u1ec9nh vi\u1ec7c \u0111\u00e1nh s\u1ed1 trang cho trang b\u1eaft \u0111\u1ea7u\" width=\"600\" height=\"113\"><figcaption id=\"caption-attachment-5325\" class=\"wp-caption-text\">T\u00f9y ch\u1ec9nh vi\u1ec7c \u0111\u00e1nh s\u1ed1 trang cho trang b\u1eaft \u0111\u1ea7u<\/figcaption><\/figure>\n<p style=\"text-align: justify\">3. Th\u1ebb\u00a0<em><strong>Page\u00a0<\/strong><\/em>\u1edf ch\u1ebf \u0111\u1ed9 m\u1eb7c \u0111\u1ecbnh. G\u00f5 s\u1ed1 b\u1ea1n mu\u1ed1n b\u1eaft \u0111\u1ea7u v\u00e0o h\u1ed9p\u00a0<em><strong>First page number<\/strong><\/em>.<\/p>\n<figure style=\"width: 452px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"\u00a0First page number\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-first-page-number.png\" alt=\"Enter the needed number in the First page number box\" width=\"452\" height=\"459\"><figcaption class=\"wp-caption-text\">\u00a0First page number<\/figcaption><\/figure>\n<p style=\"text-align: left\">B\u00e2y gi\u1edd b\u1ea1n c\u00f3 th\u1ec3 in ph\u1ea7n th\u1ee9 hai c\u1ee7a v\u0103n b\u1ea3n v\u1edbi s\u1ed1 trang ch\u00ednh x\u00e1c m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng.<\/p>\n<h2 style=\"text-align: left\"><span class=\"ez-toc-section\" id=\"Thay_doi_thu_tu_so_trang_duoc_them_vao\"><\/span><span lang=\"vi\"><strong>Thay \u0111\u1ed5i th\u1ee9 t\u1ef1 s\u1ed1 trang \u0111\u01b0\u1ee3c th\u00eam v\u00e0o:<\/strong><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: left\"><span lang=\"vi\">Theo m\u1eb7c \u0111\u1ecbnh, Excel in c\u00e1c trang t\u1eeb tr\u00ean xu\u1ed1ng d\u01b0\u1edbi, t\u1eeb tr\u00e1i qua ph\u1ea3i, nh\u01b0ng b\u1ea1n c\u00f3 th\u1ec3 thay \u0111\u1ed5i h\u01b0\u1edbng v\u00e0 in c\u00e1c trang t\u1eeb tr\u00e1i sang ph\u1ea3i v\u00e0 sau \u0111\u00f3 t\u1eeb tr\u00ean xu\u1ed1ng d\u01b0\u1edbi. <\/span><\/p>\n<p style=\"text-align: left\"><span lang=\"vi\">1. M\u1edf b\u1ea3ng t\u00ednh b\u1ea1n c\u1ea7n s\u1eeda \u0111\u1ed5i. <\/span><\/p>\n<p style=\"text-align: left\"><span lang=\"vi\">2. Chuy\u1ec3n \u0111\u1ebfn tab <strong>Page Layout<\/strong>. Nh\u1ea5p chu\u1ed9t v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng m\u1edf r\u1ed9ng trong nh\u00f3m <strong>Page Setup<\/strong>.<\/span><\/p>\n<figure id=\"attachment_5313\" aria-describedby=\"caption-attachment-5313\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-5313 size-full\" title=\"L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 ch\u00e8n s\u1ed1 trang v\u00e0o nhi\u1ec1u trang t\u00ednh Excel\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1.png\" alt=\"L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 ch\u00e8n s\u1ed1 trang v\u00e0o nhi\u1ec1u trang t\u00ednh Excel\" width=\"600\" height=\"113\"><figcaption id=\"caption-attachment-5313\" class=\"wp-caption-text\">Thay \u0111\u1ed5i th\u1ee9 t\u1ef1 s\u1ed1 trang \u0111\u01b0\u1ee3c th\u00eam v\u00e0o<\/figcaption><\/figure>\n<figure id=\"attachment_5340\" aria-describedby=\"caption-attachment-5340\" style=\"width: 296px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-5340 size-medium\" title=\"H\u1ed9p xem tr\u01b0\u1edbc s\u1ebd m\u00f4 t\u1ea3 b\u1ea1n th\u1ea5y h\u01b0\u1edbng m\u00e0 b\u1ea1n ch\u1ecdn\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1-2-296x300-1.png\" alt=\"H\u1ed9p xem tr\u01b0\u1edbc s\u1ebd m\u00f4 t\u1ea3 b\u1ea1n th\u1ea5y h\u01b0\u1edbng m\u00e0 b\u1ea1n ch\u1ecdn\" width=\"296\" height=\"300\"><figcaption id=\"caption-attachment-5340\" class=\"wp-caption-text\">H\u1ed9p xem tr\u01b0\u1edbc s\u1ebd m\u00f4 t\u1ea3 b\u1ea1n th\u1ea5y h\u01b0\u1edbng m\u00e0 b\u1ea1n ch\u1ecdn<\/figcaption><\/figure>\n<p style=\"text-align: left\">\n3. Ch\u1ecdn Tab <strong>Sheet.<\/strong> Trong ph\u1ea7n <strong>Page order\u00a0<\/strong>ch\u1ecdn <strong>Down, then over<\/strong> ho\u1eb7c <strong>Over, then down.\u00a0<\/strong>H\u1ed9p xem tr\u01b0\u1edbc s\u1ebd m\u00f4 t\u1ea3 b\u1ea1n th\u1ea5y h\u01b0\u1edbng m\u00e0 b\u1ea1n ch\u1ecdn.<\/p>\n<h2 style=\"text-align: left\"><span class=\"ez-toc-section\" id=\"Xoa_so_trang_trong_Excel\"><\/span><span lang=\"vi\"><strong>X\u00f3a s\u1ed1 trang trong Excel<\/strong><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: left\"><span lang=\"vi\">Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 m\u1ed9t t\u00e0i li\u1ec7u Excel \u0111\u00e3 \u0111\u00e1nh s\u1ed1 trang nh\u01b0ng kh\u00f4ng c\u1ea7n ch\u00fang \u0111\u01b0\u1ee3c in. B\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u1ed9p tho\u1ea1i Page Setup \u0111\u1ec3 lo\u1ea1i b\u1ecf s\u1ed1 trang. <\/span><\/p>\n<p style=\"text-align: left\"><span lang=\"vi\">1. Nh\u1ea5p v\u00e0o b\u1ea3ng t\u00ednh m\u00e0 b\u1ea1n mu\u1ed1n x\u00f3a s\u1ed1 trang. <\/span><\/p>\n<p style=\"text-align: left\"><span lang=\"vi\">2. Chuy\u1ec3n \u0111\u1ebfn tab <strong>Page Layout<\/strong>. Nh\u1ea5p chu\u1ed9t v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng m\u1edf r\u1ed9ng trong nh\u00f3m <strong>Page Setup<\/strong>.<\/span><\/p>\n<figure id=\"attachment_5342\" aria-describedby=\"caption-attachment-5342\" style=\"width: 300px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-5342 size-medium\" title=\"X\u00f3a s\u1ed1 trang c\u1ee7a Excel\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1-3-300x58-1.png\" alt=\"X\u00f3a s\u1ed1 trang c\u1ee7a Excel\" width=\"300\" height=\"58\"><figcaption id=\"caption-attachment-5342\" class=\"wp-caption-text\">X\u00f3a s\u1ed1 trang c\u1ee7a Excel<\/figcaption><\/figure>\n<p style=\"text-align: left\">3. Ch\u1ecdn tab <strong>Header\/Footer<\/strong>. Trong h\u1ed9p <strong>Header<\/strong> ho\u1eb7c <strong>Footer<\/strong> b\u00ean d\u01b0\u1edbi ch\u1ecdn <strong>(none)<\/strong><\/p>\n<figure id=\"attachment_5343\" aria-describedby=\"caption-attachment-5343\" style=\"width: 294px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-5343 size-medium\" title=\"Trong h\u1ed9p Header ho\u1eb7c Footer b\u00ean d\u01b0\u1edbi ch\u1ecdn\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1-4-294x300-1.png\" alt=\"Trong h\u1ed9p Header ho\u1eb7c Footer b\u00ean d\u01b0\u1edbi ch\u1ecdn\" width=\"294\" height=\"300\"><figcaption id=\"caption-attachment-5343\" class=\"wp-caption-text\">Trong h\u1ed9p Header ho\u1eb7c Footer b\u00ean d\u01b0\u1edbi ch\u1ecdn<\/figcaption><\/figure>\n<p style=\"text-align: left\"><em><strong>Ngu\u1ed3n:<\/strong> Ablebits, d\u1ecbch v\u00e0 bi\u00ean t\u1eadp b\u1edfi blog.excel.online<\/em><\/p>\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<\/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-319.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":7806,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-7805","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\/7805","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=7805"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/7805\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/7806"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=7805"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=7805"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=7805"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}