{"id":1552,"date":"2020-10-20T02:17:39","date_gmt":"2020-10-19T19:17:39","guid":{"rendered":"https:\/\/hoctin.vn\/?p=1552"},"modified":"2020-10-20T02:17:42","modified_gmt":"2020-10-19T19:17:42","slug":"danh-so-trang-trong-excel","status":"publish","type":"post","link":"https:\/\/hoctin.vn\/danh-so-trang-trong-excel\/","title":{"rendered":"C\u00e1ch \u0110\u00e1nh S\u1ed1 Trang Trong Excel"},"content":{"rendered":"\t\t
\u0110\u1ec3 d\u1ec5 d\u00e0ng s\u1eafp x\u1ebfp c\u00e1c trang t\u00ednh \u0111\u00e3 in ra gi\u1ea5y theo \u0111\u00fang th\u1ee9 t\u1ef1, b\u1ea1n c\u1ea7n \u0111\u00e1nh s\u1ed1 trang trong Excel tr\u01b0\u1edbc khi th\u1ef1c hi\u1ec7n thao t\u00e1c in.<\/span><\/p> \u00a0<\/span><\/p> Tuy nhi\u00ean, kh\u00f4ng gi\u1ed1ng nh\u01b0 ch\u00e8n s\u1ed1 trang trong Word, tr\u00ean Excel kh\u00f4ng c\u00f3 s\u1eb5n t\u00f9y ch\u1ecdn Page Number \u0111\u1ec3 th\u00eam s\u1ed1 trang ch\u1ec9 b\u1eb1ng 1 thao t\u00e1c, do v\u1eady b\u1ea1n s\u1ebd ph\u1ea3i s\u1eed d\u1ee5ng t\u00ednh n\u0103ng kh\u00e1c \u0111\u1ec3 th\u00eam s\u1ed1 trang trong Excel.<\/span><\/p> V\u00e0o tab <\/span>Page Layout <\/span>>> ch\u1ecdn m\u0169i t\u00ean b\u00ean g\u00f3c b\u00ean ph\u1ea3i \u0111\u1ec3 m\u1edf h\u1ed9p tho\u1ea1i <\/span>Page Setup<\/span>:<\/span><\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t \u00a0<\/span><\/p> H\u1ed9p tho\u1ea1i Page Setup xu\u1ea5t hi\u1ec7n, b\u1ea1n c\u1ea7n chuy\u1ec3n \u0111\u1ebfn tab <\/span>Header\/Footer<\/span>.<\/span><\/p> L\u00fac n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 l\u1ef1a ch\u1ecdn ch\u00e8n s\u1ed1 trang trong Excel \u1edf \u0111\u1ea7u trang (header) ho\u1eb7c cu\u1ed1i trang (footer) b\u1eb1ng c\u00e1ch ch\u1ecdn Custom t\u01b0\u01a1ng \u1ee9ng.<\/span><\/p> \u1ede v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y, hoctin.vn ch\u1ecdn th\u00eam s\u1ed1 trang \u1edf cu\u1ed1i ch\u00e2n trang b\u1eb1ng c\u00e1ch ch\u1ecdn <\/span>Custom Footer<\/span>:<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t \u00a0<\/span><\/p> H\u1ed9p tho\u1ea1i Footer hi\u1ec7n ra, b\u1ea1n ch\u1ec9 c\u1ea7n di chuy\u1ec3n con tr\u1ecf chu\u1ed9t \u0111\u1ebfn c\u00e1c v\u1ecb tr\u00ed: Left section\/ Center section\/ Right section l\u1ea7n l\u01b0\u1ee3t t\u01b0\u01a1ng \u1ee9ng v\u1ecb tr\u00ed \u0111\u1eb7t s\u1ed1 trang \u1edf b\u00ean tr\u00e1i\/ \u1edf gi\u1eefa\/ b\u00ean ph\u1ea3i ch\u00e2n trang gi\u1ea5y.<\/span><\/p> \u00a0<\/span><\/p> \u1ede h\u00ecnh \u1ea3nh minh h\u1ecda ph\u00eda tr\u00ean, con tr\u1ecf chu\u1ed9t n\u1eb1m \u1edf Left Section n\u00ean sau khi b\u1ea5m Insert Page Number (th\u00eam s\u1ed1 trang) th\u00ec k\u00ed hi\u1ec7u &[Page] xu\u1ea5t hi\u1ec7n \u1edf v\u1ecb tr\u00ed con tr\u1edf chu\u1ed9t tr\u01b0\u1edbc \u0111\u00f3 – th\u1ec3 hi\u1ec7n s\u1ed1 trang s\u1ebd n\u1eb1m b\u00ean tr\u00e1i footer trang gi\u1ea5y.<\/span><\/p> \u1ea4n OK \u0111\u1ec3 ho\u00e0n th\u00e0nh.<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t \u00a0<\/span><\/p> L\u00fac n\u00e0y, giao di\u1ec7n Page Setup s\u1ebd hi\u1ec3n th\u1ecb nh\u01b0 sau, \u0111\u1ec3 ki\u1ec3m tra xem s\u1ed1 trang \u0111\u00e3 \u0111\u01b0\u1ee3c th\u00eam v\u00e0o Excel hay ch\u01b0a, b\u1ea1n c\u00f3 th\u1ec3 \u1ea5n v\u00e0o \u00f4 <\/span>Print Preview<\/span>:<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t Vi\u1ec7c ki\u1ec3m tra s\u1ed1 trang \u0111\u00e3 \u0111\u01b0\u1ee3c th\u00eam v\u00e0o trang t\u00ednh hay ch\u01b0a, ngo\u00e0i c\u00e1ch \u1ea5n v\u00e0o Print Preview nh\u01b0 \u0111\u00e3 h\u01b0\u1edbng d\u1eabn \u1edf tr\u00ean, b\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng ph\u00edm t\u1eaft in trong Excel l\u00e0 <\/span>Ctrl + P<\/span>, k\u1ebft qu\u1ea3 kh\u00f4ng kh\u00e1c bi\u1ec7t:<\/span><\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t \u00a0<\/p> Ngo\u00e0i vi\u1ec7c th\u00eam s\u1ed1 trang trong Excel, nhi\u1ec1u l\u00fac b\u1ea1n mu\u1ed1n ki\u1ec3m tra c\u1ea3 vi\u1ec7c khi in sheet ra gi\u1ea5y th\u00ec c\u00e1c trang \u0111\u01b0\u1ee3c ph\u00e2n chia nh\u01b0 th\u1ebf n\u00e0o, b\u1ea1n ch\u1ec9 c\u1ea7n v\u00e0o tab <\/span>View <\/span>>> ch\u1ecdn <\/span>Page Break Preview<\/span>:<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
B\u00e0i vi\u1ebft n\u00e0y h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n c\u00e1ch \u0111\u00e1nh s\u1ed1 trang b\u1eb1ng t\u00f9y ch\u1ecdn <\/span>Page Setup<\/span> c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng tr\u00ean m\u1ecdi phi\u00ean b\u1ea3n c\u1ee7a Excel (365, 2019, 2016, 2013, 2010, 2007,…).<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\tM\u1ee5c L\u1ee5c B\u00e0i Vi\u1ebft<\/h4>\t\t\t\t\t\t\t
1, C\u00e1ch \u0110\u00e1nh S\u1ed1 Trang Trong Excel B\u1eb1ng Page Setup<\/span><\/span><\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
1.1, C\u00e1c B\u01b0\u1edbc \u0110\u00e1nh D\u1ea5u Trang Trong Excel<\/span><\/span><\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
Sau \u0111\u00f3, b\u1ea1n c\u1ea7n b\u1ea5m v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng <\/span>Insert Page Number<\/span>:<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
1.2, Ki\u1ec3m Tra S\u1ed1 Trang \u0110\u00e3 \u0110\u01b0\u1ee3c Th\u00eam V\u00e0o Trang T\u00ednh V\u00e0 Chia Trang Trong Excel<\/span><\/span><\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t