{"id":7443,"date":"2021-08-10T14:46:46","date_gmt":"2021-08-10T07:46:46","guid":{"rendered":"https:\/\/tct.vn\/blog\/?p=7443"},"modified":"2021-08-18T11:08:35","modified_gmt":"2021-08-18T04:08:35","slug":"nhung-luu-y-khi-in-an-bang-tinh-excel","status":"publish","type":"post","link":"https:\/\/tct.vn\/blog\/nhung-luu-y-khi-in-an-bang-tinh-excel\/","title":{"rendered":"Nh\u1eefng l\u01b0u \u00fd khi in \u1ea5n b\u1ea3ng t\u00ednh Excel"},"content":{"rendered":"

C\u00e1ch in trang Excel c\u01a1 b\u1ea3n<\/h3>\n

\u0110\u1ec3 in m\u1ed9t b\u1ea3ng t\u00ednh Excel th\u00ec b\u1ea1n h\u00e3y th\u1ef1c hi\u1ec7n theo c\u00e1c b\u01b0\u1edbc sau:<\/p>\n

B\u01b0\u1edbc 1:\u00a0<\/strong>Trong tab File tr\u00ean thanh c\u00f4ng c\u1ee5, b\u1ea1n h\u00e3y nh\u1ea5n v\u00e0o t\u00f9y ch\u1ecdn Print.<\/p>\n

B\u01b0\u1edbc 2:\u00a0<\/strong>\u0110\u1ec3 xem tr\u01b0\u1edbc to\u00e0n b\u1ed9 c\u00e1c trang t\u00ednh s\u1ebd \u0111\u01b0\u1ee3c in, b\u1ea1n h\u00e3y nh\u1ea5n v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng m\u0169i t\u00ean cho Next Page ho\u1eb7c Previous Page \u1edf b\u00ean d\u01b0\u1edbi m\u00e0n h\u00ecnh nh\u01b0 h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n

\"\"<\/p>\n

B\u01b0\u1edbc 3:\u00a0<\/strong>\u0110\u1ec3 in c\u00e1c trang t\u00ednh, b\u1ea1n h\u00e3y nh\u1ea5n v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng in (Print), qu\u00e1 tr\u00ecnh in s\u1ebd l\u1eadp t\u1ee9c b\u1eaft \u0111\u1ea7u.<\/p>\n

<\/a><\/p>\n

In m\u1ed9t ph\u1ea7n d\u1eef li\u1ec7u c\u1ea7n thi\u1ebft<\/strong><\/h3>\n

N\u1ebfu ch\u1ec9 c\u1ea7n m\u1ed9t ph\u00e2n \u0111o\u1ea1n d\u1eef li\u1ec7u nh\u1ea5t \u0111\u1ecbnh, b\u1ea1n kh\u00f4ng c\u1ea7n ph\u1ea3i in to\u00e0n b\u1ed9 b\u1ea3ng t\u00ednh m\u00e0 ch\u1ec9 c\u1ea7n in c\u00e1c d\u1eef li\u1ec7u c\u1ee5 th\u1ec3. B\u1ea1n c\u00f3 th\u1ec3 in b\u1ea3ng t\u00ednh \u0111ang xem b\u1eb1ng c\u00e1ch truy c\u1eadp b\u1ea3ng in (nh\u1ea5n t\u1ed5 h\u1ee3p ph\u00edm Ctrl + P) v\u00e0 ch\u1ecdn t\u00f9y ch\u1ecdn Print Active Sheets trong m\u1ee5c Settings,ho\u1eb7c b\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn Print Entire Workbook \u0111\u1ec3 in to\u00e0n b\u1ed9 file.<\/p>\n

\"\"<\/p>\n

Ngo\u00e0i ra, b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 in m\u1ed9t \u0111o\u1ea1n nh\u1ecf d\u1eef li\u1ec7u b\u1eb1ng c\u00e1ch ch\u1ecdn d\u1eef li\u1ec7u \u0111\u00f3, sau \u0111\u00f3 ch\u1ecdn Print Selection trong c\u00e1c t\u00f9y ch\u1ecdn in trong m\u1ee5c Settings.<\/p>\n

<\/a><\/p>\n

T\u1ed1i \u0111a h\u00f3a kh\u00f4ng gian<\/h3>\n

H\u00e3y t\u1eadn d\u1ee5ng t\u1ed1i \u0111a k\u00edch th\u01b0\u1edbc c\u1ee7a gi\u1ea5y in b\u1eb1ng c\u00e1ch thay \u0111\u1ed5i h\u01b0\u1edbng trang (page orientation).\u00a0H\u01b0\u1edbng trang m\u1eb7c \u0111\u1ecbnh l\u00e0 t\u1ed1t nh\u1ea5t cho c\u00e1c d\u1eef li\u1ec7u c\u00f3 nhi\u1ec1u h\u00e0ng h\u01a1n c\u1ed9t, nh\u01b0ng n\u1ebfu b\u1ea3ng t\u00ednh c\u1ee7a b\u1ea1n r\u1ed9ng ch\u1ee9 kh\u00f4ng d\u00e0i, n\u00ean thay \u0111\u1ed5i h\u01b0\u1edbng trang (page orientation) th\u00e0nh landscape.<\/p>\n

N\u1ebfu v\u1eabn c\u1ea7n th\u00eam kh\u00f4ng gian? B\u1ea1n c\u00f3 th\u1ec3 thay \u0111\u1ed5i chi\u1ec1u r\u1ed9ng c\u1ee7a margins tr\u00ean m\u00e9p c\u1ee7a trang gi\u1ea5y. Chi\u1ec1u r\u1ed9ng c\u1ee7a margins tr\u00ean m\u00e9p c\u1ee7a trang gi\u1ea5y c\u00e0ng nh\u1ecf th\u00ec c\u00e0ng c\u00f3 nhi\u1ec1u ch\u1ed7 cho d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n. Cu\u1ed1i c\u00f9ng, n\u1ebfu b\u1ea3ng t\u00ednh c\u1ee7a b\u1ea1n kh\u00f4ng qu\u00e1 l\u1edbn, th\u1eed s\u1eed d\u1ee5ng Custom Scaling Options \u0111\u1ec3 \u0111i\u1ec1u ch\u1ec9nh t\u1ea5t c\u1ea3 c\u00e1c h\u00e0ng, c\u1ed9t ho\u1eb7c to\u00e0n b\u1ed9 b\u1ea3ng t\u00ednh c\u1ee7a b\u1ea1n v\u1eeba kh\u1edbp tr\u00ean m\u1ed9t trang gi\u1ea5y.<\/p>\n

<\/a><\/p>\n

S\u1eed D\u1ee5ng Print Titles<\/strong><\/h3>\n

N\u1ebfu sheet trong b\u1ea3ng t\u00ednh Excel c\u1ee7a b\u1ea1n d\u00e0i h\u01a1n 1 trang, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00e1c ti\u00eau \u0111\u1ec1 tr\u00ean m\u1ed7i sheet c\u1ee7a b\u1ea3ng t\u00ednh \u0111\u1ec3 hi\u1ec3u \u0111\u01b0\u1ee3c n\u1ed9i dung b\u1ea1n \u0111ang xem l\u00e0 g\u00ec.<\/p>\n

\"\"<\/p>\n

L\u1ec7nh Print Titles cho ph\u00e9p b\u1ea1n th\u1ef1c hi\u1ec7n \u0111i\u1ec1u n\u00e0y, bao g\u1ed3m m\u1ed9t d\u00f2ng ti\u00eau \u0111\u1ec1 ho\u1eb7c c\u1ed9t tr\u00ean m\u1ed7i trang c\u1ee7a b\u1ea3ng t\u00ednh. C\u00e1c c\u1ed9t ho\u1eb7c h\u00e0ng b\u1ea1n ch\u1ecdn s\u1ebd hi\u1ec3n th\u1ecb tr\u00ean t\u1ea5t c\u1ea3 c\u00e1c trang c\u1ee7a b\u1ea3n in, \u0111\u1ec3 b\u1ea1n c\u00f3 th\u1ec3 \u0111\u1ecdc c\u00e1c d\u1eef li\u1ec7u c\u1ee7a m\u00ecnh d\u1ec5 d\u00e0ng h\u01a1n.<\/p>\n

<\/a><\/p>\n

S\u1eed D\u1ee5ng Page Break<\/strong><\/h3>\n

N\u1ebfu b\u1ea3ng t\u00ednh c\u1ee7a b\u1ea1n v\u01b0\u1ee3t qu\u00e1 1 trang gi\u1ea5y, b\u1ea1n c\u00f3 th\u1ec3 c\u00e2n nh\u1eafc \u0111\u1ebfn vi\u1ec7c s\u1eed d\u1ee5ng Page Break \u0111\u1ec3 l\u1ef1a ch\u1ecdn ch\u00ednh x\u00e1c c\u00e1c d\u1eef li\u1ec7u n\u00e0o s\u1ebd hi\u1ec3n th\u1ecb tr\u00ean trang n\u00e0o.<\/p>\n

Khi b\u1ea1n ch\u00e8n m\u1ed9t\u00a0Page Break v\u00e0o b\u1ea3ng t\u00ednh, c\u00e1c d\u1eef li\u1ec7u b\u00ean d\u01b0\u1edbi break s\u1ebd \u0111\u01b0\u1ee3c chuy\u1ec3n sang \u0111\u1ea7u m\u1ed9t trang kh\u00e1c. \u0110i\u1ec1u n\u00e0y kh\u00e1 l\u00e0 h\u1eefu \u00edch v\u00ec n\u00f3 cho ph\u00e9p b\u1ea1n chia nh\u1ecf d\u1eef li\u1ec7u theo c\u00e1ch m\u00e0 b\u1ea1n mu\u1ed1n.<\/p>\n

Ch\u00fac b\u1ea1n th\u00e0nh c\u00f4ng.<\/p>\n","protected":false},"excerpt":{"rendered":"

C\u00e1ch in trang Excel c\u01a1 b\u1ea3n \u0110\u1ec3 in m\u1ed9t b\u1ea3ng t\u00ednh Excel th\u00ec b\u1ea1n h\u00e3y th\u1ef1c hi\u1ec7n theo c\u00e1c b\u01b0\u1edbc sau: B\u01b0\u1edbc 1:\u00a0Trong tab File tr\u00ean thanh c\u00f4ng c\u1ee5, b\u1ea1n h\u00e3y nh\u1ea5n v\u00e0o t\u00f9y ch\u1ecdn Print. B\u01b0\u1edbc 2:\u00a0\u0110\u1ec3 xem tr\u01b0\u1edbc to\u00e0n b\u1ed9 c\u00e1c trang t\u00ednh s\u1ebd \u0111\u01b0\u1ee3c in, b\u1ea1n h\u00e3y nh\u1ea5n v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng m\u0169i […]<\/p>\n","protected":false},"author":3,"featured_media":7448,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16,508],"tags":[],"class_list":["post-7443","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tin-tuc","category-office"],"_links":{"self":[{"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/posts\/7443","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/comments?post=7443"}],"version-history":[{"count":0,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/posts\/7443\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/media\/7448"}],"wp:attachment":[{"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/media?parent=7443"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/categories?post=7443"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/tags?post=7443"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}