{"id":4743,"date":"2024-12-08T07:56:43","date_gmt":"2024-12-08T07:56:43","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/08\/huong-dan-3-cach-danh-so-trang-trong-excel\/"},"modified":"2024-12-08T07:56:43","modified_gmt":"2024-12-08T07:56:43","slug":"huong-dan-3-cach-danh-so-trang-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/08\/huong-dan-3-cach-danh-so-trang-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn 3 c\u00e1ch \u0111\u00e1nh s\u1ed1 trang trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>\u0110\u1ec3 s\u1eafp x\u1ebfp c\u00e1c trang b\u1ea3ng t\u00ednh tr\u00ean\u00a0Excel sau khi in \u0111\u01b0\u1ee3c\u00a0\u0111\u00fang th\u1ee9 t\u1ef1, ch\u00fang ta c\u1ea7n t\u1edbi vi\u1ec7c\u00a0\u0111\u00e1nh s\u1ed1 trang tr\u00ean t\u1eebng trang gi\u1ea5y. V\u1eady trong\u00a0Excel vi\u1ec7c\u00a0\u0111\u00e1nh s\u1ed1 trang\u00a0\u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n nh\u01b0 th\u1ebf n\u00e0o? H\u00e3y c\u00f9ng <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc\u00a0Excel Online<\/strong><\/a> t\u00ecm hi\u1ec3u\u00a0c\u00e1ch <strong>\u0111\u00e1nh s\u1ed1 trang trong Excel<\/strong> nh\u00e9. C\u00e1ch l\u00e0m n\u00e0y c\u00f3 th\u1ec3\u00a0\u00e1p d\u1ee5ng tr\u00ean m\u1ecdi phi\u00ean b\u1ea3n c\u1ee7a\u00a0Excel<\/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-6755513a57e3d\" 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\/huong-dan-3-cach-danh-so-trang-trong-excel-tren-moi-phien-ban.html#3_Cach_danh_so_trang_trong_Excel\" title=\"3 C\u00e1ch \u0111\u00e1nh s\u1ed1 trang trong Excel\">3 C\u00e1ch \u0111\u00e1nh s\u1ed1 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-2\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-3-cach-danh-so-trang-trong-excel-tren-moi-phien-ban.html#Cach_thu_2_Them_HeaderFooter_thong_qua_the_Insert\" title=\"C\u00e1ch th\u1ee9 2: Th\u00eam\u00a0Header\/Footer\u00a0th\u00f4ng qua\u00a0th\u1ebb\u00a0Insert\">C\u00e1ch th\u1ee9 2: Th\u00eam\u00a0Header\/Footer\u00a0th\u00f4ng qua\u00a0th\u1ebb\u00a0Insert<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"3_Cach_danh_so_trang_trong_Excel\"><\/span>3 C\u00e1ch \u0111\u00e1nh s\u1ed1 trang trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Th\u00f4ng th\u01b0\u1eddng trong 1 sheet, ch\u00fang ta ch\u1ec9 th\u1ea5y 1 d\u00e3y c\u00e1c\u00a0\u00f4 li\u1ec1n nhau theo h\u00e0ng, c\u1ed9t. D\u00f9 c\u00f3 sang trang kh\u00e1c th\u00ec ch\u00fang ta c\u0169ng kh\u00f4ng r\u00f5 s\u1ed1 trang s\u1ebd\u00a0\u0111\u1eb7t\u00a0\u1edf\u00a0\u0111\u00e2u.\u00a0B\u1edfi v\u00ec ph\u1ea7n s\u1ed1 trang s\u1ebd\u00a0\u0111\u01b0\u1ee3c\u00a0\u0111\u1eb7t trong Header ho\u1eb7c Footer c\u1ee7a trang gi\u1ea5y.<\/p>\n<p>C\u00f3 3 c\u00e1ch\u00a0\u0111\u1ec3 b\u1ea1n m\u1edf Header &amp; Footer r\u1ed3i th\u1ef1c hi\u1ec7n \u0111\u00e1ng s\u1ed1 trang\u00a0trong\u00a0Excel nh\u01b0 sau:<\/p>\n<p><strong>C\u00e1ch th\u1ee9 1: M\u1edf trong Page Setup<\/strong><\/p>\n<p>Khi m\u1edf c\u1eeda s\u1ed5 Page Setup, ch\u00fang ta c\u00f3 th\u1ec3 nh\u00ecn th\u1ea5y th\u1ebb Header\/Footer.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-25201\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/header-footer-trong-page-setup.png\" width=\"500\" height=\"401\" title=\"header-footer-trong-page-setup\"><\/p>\n<p>T\u1ea1i\u00a0\u0111\u00e2y b\u1ea1n c\u00f3 th\u1ec3 thi\u1ebft l\u1eadp s\u1ed1 trang trong Header ho\u1eb7c Footer nh\u01b0 sau:<\/p>\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-386.gif\" title=\"ex101_92019-nho-386\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>V\u00ed d\u1ee5 th\u00eam s\u1ed1 trang v\u00e0o gi\u1eefa c\u1ee7a Footer, ch\u00fang ta ch\u1ecdn Custom Footer:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-25202\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/insert-page-number-footer-center.png\" width=\"800\" height=\"370\" title=\"insert-page-number-footer-center\"><\/p>\n<ul>\n<li>B\u01b0\u1edbc 1: B\u1ea5m v\u00e0o\u00a0\u00f4\u00a0\u1edf gi\u1eefa<\/li>\n<li>B\u01b0\u1edbc 2: B\u1ea5m v\u00e0o v\u1ecb tr\u00ed\u00a0<strong>Insert Page Number<\/strong><\/li>\n<\/ul>\n<p>Xem th\u00eam: <strong><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-chi-tiet-cach-danh-so-trang-trong-word-2010-2013-2016.html\">C\u00e1ch \u0111\u00e1nh s\u1ed1 trang trong Word 2013<\/a>, 2016, 2019 m\u1edbi nh\u1ea5t<\/strong><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cach_thu_2_Them_HeaderFooter_thong_qua_the_Insert\"><\/span><strong>C\u00e1ch th\u1ee9 2: Th\u00eam\u00a0Header\/Footer\u00a0th\u00f4ng qua\u00a0th\u1ebb\u00a0Insert<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Trong th\u1ebb\u00a0Insert, b\u1ea1n t\u00ecm\u00a0\u0111\u1ebfn c\u00f4ng c\u1ee5 <strong>Header &amp; Footer <\/strong>(trong nh\u00f3m Text)\u00a0\u0111\u1ec3 g\u1ecdi ra Header v\u00e0 Footer trong trang in.<\/p>\n<p>T\u1ea1i v\u1ecb tr\u00ed mu\u1ed1n\u00a0\u0111\u00e1nh s\u1ed1 trang (v\u00ed d\u1ee5\u00a0\u1edf gi\u1eefa c\u1ee7a Footer), b\u1ea1n b\u1ea5m ti\u1ebfp v\u00e0o m\u1ee5c Page Number =&gt; K\u1ebft qu\u1ea3 l\u00e0 hi\u1ec7n ra k\u00fd t\u1ef1\u00a0<strong>&amp;[Page]<\/strong>.\u00a0\u0110i\u1ec1u n\u00e0y c\u00f3\u00a0\u00fd ngh\u0129a l\u00e0 m\u1ed7i trang khi in ra\u00a0\u0111\u1ec1u\u00a0\u0111\u01b0\u1ee3c\u00a0\u0111\u00e1nh s\u1ed1 trang.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-25203\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/danh-so-trang-trong-the-insert-header-footer.png\" width=\"800\" height=\"288\" title=\"danh-so-trang-trong-the-insert-header-footer\"><\/p>\n<p><strong>C\u00e1ch th\u1ee9 3: Ch\u1ecdn ch\u1ebf\u00a0\u0111\u1ed9 xem Page Layout r\u1ed3i th\u00eam Header\/Footer<\/strong><\/p>\n<p>Khi ch\u1ecdn ch\u1ebf\u00a0\u0111\u1ed9 hi\u1ec3n th\u1ecb trong th\u1ebb View l\u00e0 Page Layout:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-25204\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/view-page-layout.png\" width=\"690\" height=\"156\" title=\"view-page-layout\"><\/p>\n<p>ch\u00fang ta s\u1ebd th\u1ea5y xu\u1ea5t hi\u1ec7n m\u1ee5c Add Header\u00a0\u1edf\u00a0\u0111\u1ea7u trang, v\u00e0 Add Footer\u00a0\u1edf cu\u1ed1i trang.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-25205\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/header-footer-trong-che-do-view-page-layout-1024x543-1.png\" width=\"800\" height=\"424\" title=\"header-footer-trong-che-do-view-page-layout-1024x543-1\"><\/p>\n<p>Khi mu\u1ed1n\u00a0\u0111\u00e1nh s\u1ed1 trang\u00a0\u1edf v\u1ecb tr\u00ed n\u00e0o, b\u1ea1n ch\u1ec9 c\u1ea7n b\u1ea5m v\u00e0o v\u1ecb tr\u00ed\u00a0\u0111\u00f3.<\/p>\n<p>V\u00ed d\u1ee5 ch\u1ecdn Add Footer,\u00a0\u00f4\u00a0\u1edf gi\u1eefa:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-25206\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/them-page-number-vao-footer.png\" width=\"960\" height=\"455\" title=\"them-page-number-vao-footer\"><\/p>\n<ul>\n<li>B\u01b0\u1edbc 1: B\u1ea5m v\u00e0o\u00a0\u00f4\u00a0\u1edf gi\u1eefa Footer<\/li>\n<li>B\u01b0\u1edbc 2: b\u1ea5m ch\u1ecdn th\u1ebb Design c\u1ee7a Header &amp; Footer (ch\u1ec9 c\u00f3 khi b\u1ea1n\u00a0\u0111ang ch\u1ecdn Header ho\u1eb7c Footer)<\/li>\n<li>B\u01b0\u1edbc 3: b\u1ea5m v\u00e0o Page Number\u00a0\u0111\u1ec3 th\u00eam s\u1ed1 trang<\/li>\n<\/ul>\n<p>Nh\u01b0 v\u1eady b\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng 1 trong 3 c\u00e1ch tr\u00ean\u00a0\u0111\u1ec3\u00a0\u0111\u00e1nh s\u1ed1 trang trong\u00a0Excel m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng. Ch\u00fac b\u1ea1n\u00a0\u00e1p d\u1ee5ng t\u1ed1t ki\u1ebfn th\u1ee9c n\u00e0y v\u00e0o c\u00f4ng vi\u1ec7c nh\u00e9.<\/p>\n<p><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-386.gif\" title=\"ex101_92019-nho-386\"><br \/>\n<\/a><\/p>\n<p>Ngo\u00e0i ra c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o m\u1ed9t s\u1ed1 b\u00e0i vi\u1ebft c\u00f9ng ch\u1ee7\u00a0\u0111\u1ec1:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/cach-chen-va-xoa-so-trang-trong-nhieu-trang-tinh-cua-excel-2010-2013-2016.html\">C\u00e1ch ch\u00e8n v\u00e0 x\u00f3a s\u1ed1 trang trong nhi\u1ec1u trang t\u00ednh c\u1ee7a Excel 2010, 2013, 2016<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/thiet-lap-custom-views-3-che-hien-thi-trang-tinh.html\">Thi\u1ebft l\u1eadp custom views t\u1eeb 3 ch\u1ebf \u0111\u1ed9 hi\u1ec3n th\u1ecb c\u1ee7a m\u1ed9t trang t\u00ednh Excel<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/thiet-lap-header-footer-trong-mos-excel.html\">C\u00e1ch thi\u1ebft l\u1eadp Header and Footer trong b\u00e0i thi MOS Excel<\/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\/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-386.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":4744,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-4743","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/4743","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=4743"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/4743\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/4744"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=4743"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=4743"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=4743"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}