{"id":37293,"date":"2022-08-13T13:37:46","date_gmt":"2022-08-13T06:37:46","guid":{"rendered":"https:\/\/jobsgo.vn\/blog\/?p=37293"},"modified":"2024-11-01T08:49:31","modified_gmt":"2024-11-01T01:49:31","slug":"cach-in-2-mat-trong-excel","status":"publish","type":"post","link":"https:\/\/jobsgo.vn\/blog\/cach-in-2-mat-trong-excel\/","title":{"rendered":"C\u00e1ch in 2 m\u1eb7t trong excel \u0111\u01a1n gi\u1ea3n nh\u1ea5t v\u00e0 c\u1ef1c chi ti\u1ebft"},"content":{"rendered":"\n
C\u00e1ch in 2 m\u1eb7t trong Excel<\/strong><\/a> kh\u00f4ng kh\u00f3. Tuy nhi\u00ean, n\u1ebfu \u0111\u00e2y l\u00e0 l\u1ea7n \u0111\u1ea7u b\u1ea1n l\u00e0m \u0111i\u1ec1u n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 c\u1ea3m th\u1ea5y h\u01a1i b\u1ed1i r\u1ed1i v\u00ec: m\u00e1y in kh\u00f4ng h\u1ed7 tr\u1ee3 in 2 m\u1eb7t, in b\u1ecb ng\u01b0\u1ee3c,… Nh\u01b0ng \u0111\u1eebng qu\u00e1 lo l\u1eafng, JobsGO c\u00f3 th\u1ec3 gi\u00fap b\u1ea1n!<\/i><\/p>\n M\u1ee5c l\u1ee5c<\/p> B\u1ea1n h\u00e3y th\u1ef1c hi\u1ec7n tu\u1ea7n t\u1ef1 c\u00e1c b\u01b0\u1edbc sau \u0111\u1ec3 in 2 m\u1eb7t trong Excel<\/strong> (gi\u1ea3 s\u1eed m\u00e1y in \u0111\u00e3 \u0111\u01b0\u1ee3c k\u1ebft n\u1ed1i s\u1eb5n v\u1edbi m\u00e1y t\u00ednh).<\/p>\n \u0110\u1ec3 t\u00ecm hi\u1ec3u xem m\u00e1y in c\u1ee7a b\u1ea1n c\u00f3 h\u1ed7 tr\u1ee3 in hai m\u1eb7t hay kh\u00f4ng, b\u1ea1n c\u00f3 th\u1ec3 ki\u1ec3m tra h\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng m\u00e1y in ho\u1eb7c tham kh\u1ea3o \u00fd ki\u1ebfn nh\u00e0 s\u1ea3n xu\u1ea5t.<\/p>\n Kh\u00f4ng gi\u1ed1ng nh\u01b0 Word, Excel c\u00f3 \u0111\u1ecbnh d\u1ea1ng b\u1ea3ng t\u00ednh m\u1edf r\u1ed9ng theo chi\u1ec1u ngang v\u00e0 chi\u1ec1u d\u1ecdc. Do \u0111\u00f3, khi mu\u1ed1n in m\u1ed9t t\u00e0i li\u1ec7u file Excel, b\u1ea1n c\u1ea7n c\u0103n ch\u1ec9nh l\u1ec1 sao cho d\u1eef li\u1ec7u n\u1eb1m trong kh\u1ed5 gi\u1ea5y A4.<\/p>\n C\u00f3 nhi\u1ec1u ph\u01b0\u01a1ng ph\u00e1p \u0111\u1ec3 c\u0103n ch\u1ec9nh trang Excel cho v\u1eeba v\u1edbi trang A4. C\u00e1c ph\u01b0\u01a1ng ph\u00e1p n\u00e0y s\u1ebd kh\u00e1c nhau v\u1ec1 ph\u01b0\u01a1ng ph\u00e1p t\u00f9y thu\u1ed9c v\u00e0o b\u1ed1 c\u1ee5c c\u1ee7a d\u1eef li\u1ec7u trang t\u00ednh. B\u1ea1n c\u00f3 th\u1ec3 xem x\u00e9t t\u1eebng lo\u1ea1i ph\u01b0\u01a1ng ph\u00e1p sau \u0111\u00e2y \u0111\u1ec3 xem lo\u1ea1i ph\u01b0\u01a1ng ph\u00e1p n\u00e0o ph\u00f9 h\u1ee3p nh\u1ea5t v\u1edbi b\u1ea3ng t\u00ednh Excel c\u1ee7a b\u1ea1n.<\/p>\n B\u1ea3ng d\u1eef li\u1ec7u Excel khi in ra th\u01b0\u1eddng l\u00e0 trang m\u1eb7c \u0111\u1ecbnh n\u1eb1m d\u1ecdc. Nh\u01b0ng n\u1ebfu d\u1eef li\u1ec7u trang t\u00ednh c\u1ee7a b\u1ea1n tr\u1ea3i d\u00e0i theo chi\u1ec1u ngang v\u00ec c\u00f3 nhi\u1ec1u c\u1ed9t ho\u1eb7c c\u1ed9t c\u00f3 \u0111\u1ed9 r\u1ed9ng l\u1edbn th\u00ec b\u1ea1n c\u1ea7n xoay ngang b\u1ea3ng t\u00ednh.<\/p>\n C\u00e1c b\u01b0\u1edbc b\u1ea1n c\u1ea7n th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/p>\n Nh\u01b0 v\u1eady kh\u1ed5 gi\u1ea5y \u0111\u00e3 \u0111\u01b0\u1ee3c xoay ngang.<\/p>\n N\u1ebfu kh\u00f4ng mu\u1ed1n s\u1eed d\u1ee5ng c\u00e1c ki\u1ec3u c\u0103n ch\u1ec9nh c\u00f3 s\u1eb5n, b\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn Custom Margins<\/strong> \u0111\u1ec3 \u0111i\u1ec1u ch\u1ec9nh l\u1ec1 theo th\u00f4ng s\u1ed1 c\u1ee7a ri\u00eang m\u00ecnh.<\/p>\n Trong ph\u1ea7n n\u00e0y, JobsGO s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch in 2 m\u1eb7t trong excel<\/strong> v\u1edbi m\u00e1y in h\u1ed7 tr\u1ee3 in 2 m\u1eb7t v\u00e0 m\u00e1y in kh\u00f4ng h\u1ed7 tr\u1ee3 t\u00ednh n\u0103ng n\u00e0y.<\/p>\n C\u00e1ch in 2 m\u1eb7t trong excel<\/strong> tr\u00ean PC\/ Laptop Window v\u00e0 Macbook c\u00f3 h\u01a1i kh\u00e1c nhau m\u1ed9t ch\u00fat.<\/p><\/blockquote>\n Tr\u00ean PC v\u00e0 Laptop Window<\/strong><\/p>\n Tr\u00ean m\u00e1y Mac<\/strong><\/p>\n Add-ins l\u00e0 m\u1ed9t \u0111o\u1ea1n m\u00e3 do ng\u01b0\u1eddi d\u00f9ng, nh\u00e0 ph\u00e1t tri\u1ec3n t\u1ea1o ra \u0111\u1ec3 th\u00eam v\u00e0o Excel<\/a> m\u1ed9t s\u1ed1 ti\u1ec7n \u00edch nh\u01b0 h\u00e0m, c\u00e1c form ho\u1eb7c t\u00ednh n\u0103ng in 2 m\u1eb7t.<\/p>\n1. C\u00e1c b\u01b0\u1edbc in 2 m\u1eb7t trong excel<\/strong><\/span><\/h2>\n
1.1 B\u01b0\u1edbc 1: Ki\u1ec3m tra m\u00e1y in c\u00f3 h\u1ed7 tr\u1ee3 in 2 m\u1eb7t hay kh\u00f4ng<\/strong><\/span><\/h3>\n
1.2 B\u01b0\u1edbc 2: C\u0103n ch\u1ec9nh l\u1ec1 tr\u01b0\u1edbc khi in 2 m\u1eb7t trong Excel<\/strong><\/span><\/h3>\n
1.2.1 Xoay ngang b\u1ea3ng t\u00ednh Excel tr\u01b0\u1edbc khi in<\/strong><\/span><\/h4>\n
\n
<\/p>\n
\n
<\/p>\n
1.2.2 C\u0103n ch\u1ec9nh l\u1ec1 trang<\/strong><\/span><\/h4>\n
\n
<\/p>\n
\n
\n
<\/p>\n
1.3 B\u01b0\u1edbc 3: Th\u1ef1c hi\u1ec7n in 2 m\u1eb7t trong Excel<\/strong><\/span><\/h3>\n
1.3.1 In v\u1edbi m\u00e1y c\u00f3 h\u1ed7 tr\u1ee3 in 2 m\u1eb7t<\/strong><\/span><\/h4>\n
\n
<\/p>\n
\n
<\/p>\n
\n
1.3.2 In v\u1edbi m\u00e1y kh\u00f4ng h\u1ed7 tr\u1ee3 in 2 m\u1eb7t – C\u00e0i th\u00eam Add-ins<\/strong><\/span><\/h4>\n