{"id":7350,"date":"2026-01-06T09:37:13","date_gmt":"2026-01-06T02:37:13","guid":{"rendered":"http:\/\/taingo.ddns.net\/tinhocnhatrang\/?p=7350"},"modified":"2026-01-06T09:37:13","modified_gmt":"2026-01-06T02:37:13","slug":"cach-tao-chinh-sua-header-va-footer-trong-excel-don-gian-chua-chac-ban-da-biet","status":"publish","type":"post","link":"http:\/\/taingo.ddns.net\/tinhocnhatrang\/cach-tao-chinh-sua-header-va-footer-trong-excel-don-gian-chua-chac-ban-da-biet\/","title":{"rendered":"C\u00e1ch t\u1ea1o, ch\u1ec9nh s\u1eeda Header v\u00e0 Footer trong Excel \u0111\u01a1n gi\u1ea3n ch\u01b0a ch\u1eafc b\u1ea1n \u0111\u00e3 bi\u1ebft"},"content":{"rendered":"
\n

T\u1ea1o Header v\u00e0 Footer trong Excel v\u1eeba gi\u00fap truy\u1ec1n t\u1ea3i th\u00eam th\u00f4ng tin v\u1eeba t\u0103ng s\u1ef1 chuy\u00ean nghi\u1ec7p cho b\u1ea3ng t\u00ednh. Nh\u01b0ng kh\u00f4ng ph\u1ea3i ai c\u0169ng bi\u1ebft c\u00e1ch ch\u00e8n, ch\u1ec9nh s\u1eeda Header, Footer trong Excel. N\u1ebfu b\u1ea1n c\u0169ng ch\u01b0a bi\u1ebft th\u00ec \u0111\u1eebng v\u1ed9i l\u01b0\u1edbt qua b\u00e0i vi\u1ebft sau.<\/p>\n

\"\"<\/p>\n

B\u1ea1n r\u01a1i v\u00e0o t\u00ecnh hu\u1ed1ng c\u1ea7n th\u00eam th\u00f4ng tin nh\u01b0 ti\u00eau \u0111\u1ec1, s\u1ed1 trang,\u2026 v\u00e0o trang t\u00ednh c\u1ee7a m\u00ecnh. Excel s\u1ebd gi\u00fap b\u1ea1n l\u00e0m \u0111i\u1ec1u n\u00e0y m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng, nhanh ch\u00f3ng th\u00f4ng qua t\u00ednh n\u0103ng Header, Footer. V\u1eady b\u1ea1n \u0111\u00e3 bi\u1ebft g\u00ec v\u1ec1 Header v\u00e0 Footer trong Excel? C\u00f9ng m\u00ecnh kh\u00e1m ph\u00e1 th\u1ee7 thu\u1eadt Excel h\u1eefu \u00edch n\u00e0y trong n\u1ed9i dung d\u01b0\u1edbi \u0111\u00e2y!<\/p>\n

T\u00ecm hi\u1ec3u Header v\u00e0 Footer trong Excel l\u00e0 g\u00ec?<\/strong><\/h2>\n

T\u01b0\u01a1ng t\u1ef1 nh\u01b0 trong Word, PowerPoint, Header v\u00e0 Footer trong Excel l\u00e0 c\u00e1c ph\u1ea7n th\u00f4ng tin trong m\u1ed7i trang b\u1ea3ng t\u00ednh Excel. Trong \u0111\u00f3, Header l\u00e0 ph\u1ea7n th\u00f4ng tin \u1edf \u0111\u1ea7u trang. C\u00f2n Footer l\u00e0 ph\u1ea7n th\u00f4ng tin \u1edf cu\u1ed1i ho\u1eb7c ch\u00e2n trang.<\/p>\n

S\u1ef1 xu\u1ea5t hi\u1ec7n c\u1ee7a ch\u00fang s\u1ebd g\u00f3p ph\u1ea7n gia t\u0103ng t\u00ednh th\u1ea9m m\u1ef9, s\u1ef1 chuy\u00ean nghi\u1ec7p c\u1ee7a b\u1ea3ng t\u00ednh. \u0110\u1ed3ng th\u1eddi gi\u00fap ng\u01b0\u1eddi \u0111\u1ecdc d\u1ec5 d\u00e0ng nh\u1eadn bi\u1ebft \u0111\u01b0\u1ee3c ti\u00eau \u0111\u1ec1, s\u1ed1 trang,\u2026 trong Excel. Tuy nhi\u00ean, n\u00f3 s\u1ebd kh\u00f4ng hi\u1ec3n th\u1ecb \u1edf d\u1ea1ng xem c\u1ee7a Worksheet b\u00ecnh th\u01b0\u1eddng. Thay v\u00e0o \u0111\u00f3, ch\u00fang \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb \u1edf tr\u00ean c\u00e1c trang in, d\u1ea1ng \u201cXem tr\u01b0\u1edbc khi in v\u00e0 B\u1ed1 c\u1ee5c trang\u201d.<\/p>\n

Ch\u1ee9c n\u0103ng c\u1ee7a Header v\u00e0 Footer trong Excel<\/strong><\/h2>\n

Trong Excel, Header v\u00e0 Footer \u0111\u1ea3m nhi\u1ec7m ch\u1ee9c n\u0103ng nh\u01b0 sau:<\/p>\n

    \n
  • Header<\/strong>: D\u00f9ng \u0111\u1ec3 cung c\u1ea5p th\u00f4ng tin ph\u1ea7n \u0111\u1ea7u trang nh\u01b0 ti\u00eau \u0111\u1ec1, t\u00ean t\u00e1c gi\u1ea3, ng\u00e0y th\u00e1ng. Ho\u1eb7c n\u00f3 c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng \u0111\u1ec3 qu\u1ea3ng b\u00e1 th\u01b0\u01a1ng hi\u1ec7u, h\u00ecnh \u1ea3nh c\u00f4ng ty nh\u01b0 logo, t\u00ean c\u00f4ng ty, \u0111\u1ecba ch\u1ec9, s\u1ed1 \u0111i\u1ec7n tho\u1ea1i,\u2026<\/li>\n
  • Footer<\/strong>: D\u00f9ng \u0111\u1ec3 cung c\u1ea5p th\u00f4ng tin ph\u1ea7n cu\u1ed1i trang, th\u01b0\u1eddng l\u00e0 s\u1ed1 trang. Ngo\u00e0i ra, n\u00f3 c\u0169ng c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 th\u00f4ng b\u00e1o cho ng\u01b0\u1eddi \u0111\u1ecdc bi\u1ebft b\u1ea3ng t\u00ednh \u0111ang \u1edf ph\u1ea7n n\u00e0o, tr\u00e1nh nh\u1ea7m l\u1eabn, ti\u1ebft ki\u1ec7m th\u1eddi gian.<\/li>\n<\/ul>\n

    C\u00e1ch t\u1ea1o Header v\u00e0 Footer trong Excel<\/strong><\/h2>\n

    \u0110\u1ec3 ch\u00e8n Header v\u00e0 Footer v\u00e0o trang t\u00ednh Excel, b\u1ea1n c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n theo 1 trong 3 c\u00e1ch sau:<\/p>\n

    C\u00e1ch 1: T\u1ea1o Header v\u00e0 Footer qua m\u1ee5c Insert<\/strong><\/h3>\n

    B\u01b0\u1edbc 1<\/strong>: Nh\u1ea5n tab\u00a0Insert<\/strong>\u00a0tr\u00ean thanh c\u00f4ng c\u1ee5 > Ch\u1ecdn v\u00e0o m\u1ee5c\u00a0Header & Footer<\/strong>\u00a0\u0111\u1ec3 chuy\u1ec3n b\u1ea3ng t\u00ednh v\u1ec1 d\u1ea1ng\u00a0Layout<\/strong>. N\u1ebfu mu\u1ed1n t\u1ea1o ch\u00e2n trang th\u00ec b\u1ea1n ch\u1ecdn ti\u1ebfp\u00a0Go to Footer<\/strong>\u00a0trong m\u1ee5c\u00a0Design<\/strong>.<\/p>\n

    \"\"<\/p>\n

    B\u01b0\u1edbc 2<\/strong>: Nh\u1eadp n\u1ed9i dung, h\u00ecnh \u1ea3nh, th\u00f4ng tin mong mu\u1ed1n v\u00e0o m\u1ed9t trong 3 \u00f4 Header ho\u1eb7c Footer c\u1ee7a trang. H\u1ec7 th\u1ed1ng m\u1eb7c \u0111\u1ecbnh s\u1ebd ch\u1ecdn \u00f4 gi\u1eefa, n\u1ebfu mu\u1ed1n n\u1ed9i dung xu\u1ea5t hi\u1ec7n \u1edf g\u00f3c b\u00ean tr\u00e1i ho\u1eb7c b\u00ean ph\u1ea3i th\u00ec nh\u1ea5n chu\u1ed9t v\u00e0o h\u1ed9p t\u01b0\u01a1ng \u1ee9ng.<\/p>\n

    \"\"<\/p>\n

    B\u01b0\u1edbc 3<\/strong>: \u0110i\u1ec1n xong, b\u1ea1n nh\u1ea5n v\u00e0o b\u1ea5t c\u1ee9 v\u1ecb tr\u00ed n\u00e0o tr\u00ean trang t\u00ednh c\u0169ng \u0111\u01b0\u1ee3c. C\u00f2n n\u1ebfu mu\u1ed1n tho\u00e1t kh\u1ecfi Header\/Footer m\u00e0 kh\u00f4ng gi\u1eef l\u1ea1i c\u00e1c thay \u0111\u1ed5i th\u00ec b\u1ea1n nh\u1ea5n ph\u00edm\u00a0ESC<\/strong>.<\/p>\n

    C\u00e1ch 2: T\u1ea1o Header v\u00e0 Footer qua Page Setup<\/strong><\/h3>\n

    B\u01b0\u1edbc 1<\/strong>: Nh\u1ea5n tab\u00a0Page Layout<\/strong>\u00a0tr\u00ean thanh c\u00f4ng c\u1ee5 > Click v\u00e0o m\u0169i t\u00ean m\u1edf r\u1ed9ng \u0111\u1ec3 m\u1edf h\u1ed9p tho\u1ea1i\u00a0Page Setup<\/strong>.<\/p>\n

    \"\"<\/p>\n

    B\u01b0\u1edbc 2<\/strong>: L\u00fac n\u00e0y, b\u1ea1n s\u1ebd th\u1ea5y xu\u1ea5t hi\u1ec7n m\u1ed9t h\u1ed9p tho\u1ea1i\u00a0Page Setup<\/strong>. T\u1ea1i \u0111\u00e2y, b\u1ea1n nh\u1ea5n v\u00e0o tab\u00a0Header\/Footer<\/strong>\u00a0> Ch\u1ecdn\u00a0Custom Header<\/strong>\u00a0n\u1ebfu mu\u1ed1n t\u1ea1o ph\u1ea7n \u0111\u1ea7u trang ho\u1eb7c ch\u1ecdn\u00a0Custom Footer<\/strong>\u00a0n\u1ebfu mu\u1ed1n t\u1ea1o ch\u00e2n trang v\u00e0 b\u1eaft \u0111\u1ea7u ch\u1ec9nh s\u1eeda.<\/p>\n

    \"\"<\/p>\n

    C\u00e1ch 3: T\u1ea1o Header v\u00e0 Footer qua Normal View<\/strong><\/h3>\n

    B\u01b0\u1edbc 1<\/strong>: Nh\u1ea5p v\u00e0o tab\u00a0View<\/strong>\u00a0tr\u00ean thanh c\u00f4ng c\u1ee5 \u0111\u1ec3 chuy\u1ec3n Excel sang ch\u1ebf \u0111\u1ed9\u00a0Page Layout<\/strong>.<\/p>\n

    \"\"<\/p>\n

    B\u01b0\u1edbc 2<\/strong>: Ch\u00e8n n\u1ed9i dung v\u00e0o ph\u1ea7n\u00a0Add header<\/strong>\u00a0ho\u1eb7c\u00a0Add footer<\/strong>\u00a0theo \u00fd mu\u1ed1n.<\/p>\n

    \"\"<\/p>\n

    C\u00e1ch ch\u1ec9nh s\u1eeda Header v\u00e0 Footer trong Excel<\/strong><\/h2>\n

    Sau khi \u0111\u00e3 t\u1ea1o \u0111\u01b0\u1ee3c Header, Footer, n\u1ebfu mu\u1ed1n ch\u1ec9nh s\u1eeda, b\u1ea1n thao t\u00e1c theo m\u1ed9t trong 2 c\u00e1ch d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n

    C\u00e1ch 1: Ch\u1ec9nh s\u1eeda trong ch\u1ebf \u0111\u1ed9 Page Layout<\/strong><\/h3>\n

    B\u01b0\u1edbc 1<\/strong>: Click chu\u1ed9t v\u00e0o ti\u00eau \u0111\u1ec1 trang ho\u1eb7c ch\u00e2n trang \u0111\u1ec3 ti\u1ebfn v\u00e0o ch\u1ebf \u0111\u1ed9\u00a0Page Layout<\/strong>.<\/p>\n

    \"\"<\/p>\n

    B\u01b0\u1edbc 2<\/strong>: L\u00fac n\u00e0y, tr\u00ean thanh c\u00f4ng c\u1ee5 s\u1ebd hi\u1ec7n ra m\u1ed9t th\u1ebb\u00a0Design<\/strong>\u00a0v\u1edbi c\u00e1c tu\u1ef3 ch\u1ecdn ch\u1ec9nh s\u1eeda g\u1ed3m:<\/p>\n

      \n
    • Page Number<\/strong>: Hi\u1ec3n th\u1ecb s\u1ed1 trang: Page 1, Page 2, Page 3,\u2026<\/li>\n
    • Current Date<\/strong>: Hi\u1ec3n th\u1ecb ng\u00e0y hi\u1ec7n t\u1ea1i.<\/li>\n
    • Current Time<\/strong>: Hi\u1ec3n th\u1ecb th\u1eddi gian hi\u1ec7n t\u1ea1i.<\/li>\n
    • File Path<\/strong>: Ch\u00e8n \u0111\u01b0\u1eddng d\u1eabn \u0111\u1ebfn file Excel.<\/li>\n
    • File Name<\/strong>: Hi\u1ec3n th\u1ecb t\u00ean s\u1ed5 t\u00ednh Excel.<\/li>\n
    • Sheet Name<\/strong>: Hi\u1ec3n th\u1ecb t\u00ean trang t\u00ednh \u0111ang ch\u1ecdn.<\/li>\n
    • Picture<\/strong>: Ch\u00e8n h\u00ecnh \u1ea3nh, \u0111\u00f3 c\u00f3 th\u1ec3 l\u00e0 logo th\u01b0\u01a1ng hi\u1ec7u, banner,\u2026<\/li>\n
    • Number of Page<\/strong>: Hi\u1ec3n th\u1ecb t\u1ed5ng s\u1ed1 trang trong file Excel.<\/li>\n
    • Different First Page<\/strong>: T\u1ea1o Header\/Footer trang \u0111\u1ea7u ti\u00ean kh\u00e1c v\u1edbi c\u00e1c trang c\u00f2n l\u1ea1i.<\/li>\n
    • Scale with Document<\/strong>: Thay \u0111\u1ed5i, \u0111i\u1ec1u ch\u1ec9nh k\u00edch th\u01b0\u1edbc Header\/Footer theo t\u1ef7 l\u1ec7 co gi\u00e3n c\u1ee7a b\u1ea3ng t\u00ednh khi in.<\/li>\n
    • Different Odd & Even Pages<\/strong>: Header\/Footer trang ch\u1eb5n, l\u1ebb trong danh s\u00e1ch s\u1ebd\u00a0kh\u00e1c nhau.<\/li>\n
    • Align with Page Margins<\/strong>: \u0110i\u1ec1u ch\u1ec9nh, c\u0103n b\u1ec1\u00a0Header\/Footer t\u01b0\u01a1ng \u1ee9ng theo l\u1ec1 gi\u1ea5y.<\/li>\n<\/ul>\n

      \"\"<\/p>\n

      C\u00e1ch 2: Ch\u1ec9nh s\u1eeda v\u1edbi Custom Header ho\u1eb7c Custom Footer<\/strong><\/h3>\n

      Ngo\u00e0i c\u00e1ch tr\u00ean, b\u1ea1n c\u00f3 th\u1ec3 ch\u1ec9nh s\u1eeda Header v\u00e0 Footer v\u1edbi Custom Header ho\u1eb7c Custom Footer.<\/p>\n

      B\u01b0\u1edbc 1<\/strong>: Khi th\u1ef1c hi\u1ec7n thao t\u00e1c t\u1ea1o Header\/Footer th\u00f4ng qua Page Setup (c\u00e1ch 2) \u1edf tr\u00ean, b\u1ea1n s\u1ebd th\u1ea5y xu\u1ea5t hi\u1ec7n h\u1ed9p tho\u1ea1i Header ho\u1eb7c Footer t\u01b0\u01a1ng \u1ee9ng v\u1edbi 3 v\u1ecb tr\u00ed: tr\u00e1i, gi\u1eefa v\u00e0 ph\u1ea3i. B\u1ea1n mu\u1ed1n \u0111\u1ec3 th\u00f4ng tin \u0111\u1ea7u\/ch\u00e2n trang \u1edf v\u1ecb tr\u00ed n\u00e0o th\u00ec \u0111i\u1ec1n v\u00e0o \u00f4 \u0111\u00f3.<\/p>\n

      \"\"<\/p>\n

      B\u01b0\u1edbc 2<\/strong>: Sau \u0111\u00f3, b\u1ea1n tu\u1ef3 ch\u1ec9nh Header\/Footer v\u1edbi c\u00e1c ch\u1ee9c n\u0103ng t\u01b0\u01a1ng t\u1ef1 nh\u01b0 th\u1ebb ng\u1eef c\u1ea3nh\u00a0Design<\/strong>. Ngo\u00e0i ra, b\u1ea1n c\u00f3 th\u1ec3 thay \u0111\u1ed5i thu\u1ed9c t\u00ednh v\u1ec1 c\u1ee1 ch\u1eef, font ch\u1eef,\u2026 b\u1eb1ng\u00a0Format Text<\/strong>. Ch\u1ec9nh xong, b\u1ea1n nh\u1ea5n\u00a0OK<\/strong><\/p>\n

      \"\"<\/p>\n

      B\u01b0\u1edbc 3<\/strong>: B\u1ea1n nh\u1ea5n ti\u1ebfp\u00a0OK<\/strong>\u00a0t\u1ea1i giao di\u1ec7n Page Setup l\u00e0 xong.<\/p>\n

      \"\"<\/p>\n

      K\u1ebft lu\u1eadn<\/strong><\/h2>\n

      V\u1edbi ph\u1ea7n h\u01b0\u1edbng d\u1eabn chi ti\u1ebft \u1edf ph\u00eda tr\u00ean, ch\u1eafc ch\u1eafn gi\u1edd \u0111\u00e2y, b\u1ea1n \u0111\u1ee7 t\u1ef1 tin \u0111\u1ec3 t\u1ea1o ra Header v\u00e0 Footer trong Excel gi\u00fap b\u00e1o c\u00e1o, b\u1ea3ng t\u00ednh c\u1ee7a m\u00ecnh th\u00eam chuy\u00ean nghi\u1ec7p h\u01a1n.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

      T\u1ea1o Header v\u00e0 Footer trong Excel v\u1eeba gi\u00fap truy\u1ec1n t\u1ea3i th\u00eam th\u00f4ng tin v\u1eeba t\u0103ng s\u1ef1 chuy\u00ean nghi\u1ec7p cho b\u1ea3ng<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"_links":{"self":[{"href":"http:\/\/taingo.ddns.net\/tinhocnhatrang\/wp-json\/wp\/v2\/posts\/7350"}],"collection":[{"href":"http:\/\/taingo.ddns.net\/tinhocnhatrang\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/taingo.ddns.net\/tinhocnhatrang\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/taingo.ddns.net\/tinhocnhatrang\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/taingo.ddns.net\/tinhocnhatrang\/wp-json\/wp\/v2\/comments?post=7350"}],"version-history":[{"count":1,"href":"http:\/\/taingo.ddns.net\/tinhocnhatrang\/wp-json\/wp\/v2\/posts\/7350\/revisions"}],"predecessor-version":[{"id":7364,"href":"http:\/\/taingo.ddns.net\/tinhocnhatrang\/wp-json\/wp\/v2\/posts\/7350\/revisions\/7364"}],"wp:attachment":[{"href":"http:\/\/taingo.ddns.net\/tinhocnhatrang\/wp-json\/wp\/v2\/media?parent=7350"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/taingo.ddns.net\/tinhocnhatrang\/wp-json\/wp\/v2\/categories?post=7350"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/taingo.ddns.net\/tinhocnhatrang\/wp-json\/wp\/v2\/tags?post=7350"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}