{"id":20788,"date":"2021-03-20T09:38:46","date_gmt":"2021-03-20T02:38:46","guid":{"rendered":"https:\/\/ben.com.vn\/tin-tuc\/?p=20788"},"modified":"2021-11-12T16:08:38","modified_gmt":"2021-11-12T09:08:38","slug":"chen-anh-vao-excel","status":"publish","type":"post","link":"https:\/\/ben.com.vn\/tin-tuc\/chen-anh-vao-excel\/","title":{"rendered":"Chia s\u1ebb 3 c\u00e1ch ch\u00e8n \u1ea3nh v\u00e0o Excel nhanh ch\u00f3ng, \u0111\u01a1n gi\u1ea3n"},"content":{"rendered":"

B\u1ea1n s\u1eed d\u1ee5ng excel \u0111\u00e3 l\u00e2u nh\u01b0ng l\u1ea1i ch\u01b0a bi\u1ebft c\u00e1ch ch\u00e8n \u1ea3nh. B\u1ea1n \u0111ang mu\u1ed1n\u00a0ch\u00e8n \u1ea3nh v\u00e0o Excel<\/strong>\u00a0\u0111\u1ec3 minh h\u1ecda r\u00f5 r\u00e0ng v\u00e0 chi ti\u1ebft n\u1ed9i dung m\u00e0 m\u00ecnh \u0111ang mu\u1ed1n truy\u1ec1n t\u1ea3i. B\u00e0i vi\u1ebft sau \u0111\u00e2y ch\u00fang t\u00f4i s\u1ebd chia s\u1ebb cho b\u1ea1n 3 c\u00e1ch ch\u00e8n \u1ea3nh v\u00e0o trang t\u00ednh Excel <\/strong>\u0111\u01a1n gi\u1ea3n v\u00e0 nhanh ch\u00f3ng. C\u00e1c b\u1ea1n h\u00e3y theo d\u00f5i nh\u00e9.<\/p>\n

Ch\u00e8n \u1ea3nh v\u00e0o Excel b\u1eb1ng ph\u01b0\u01a1ng ph\u00e1p th\u1ee7 c\u00f4ng<\/strong><\/h2>\n

C\u00e1ch ch\u00e8n \u1ea3nh v\u00e0o Excel<\/strong><\/a><\/span> theo ph\u01b0\u01a1ng ph\u00e1p th\u1ee7 c\u00f4ng t\u01b0\u01a1ng \u0111\u1ed1i \u0111\u01a1n gi\u1ea3n v\u00e0 d\u1ec5 d\u00e0ng. \u0110\u1ec3 ch\u00e8n th\u00ec b\u1ea1n th\u1ef1c hi\u1ec7n theo c\u00e1c b\u01b0\u1edbc sau:<\/p>\n

B\u01b0\u1edbc 1:<\/strong> \u0110\u1ea7u ti\u00ean b\u1ea1n m\u1edf trang t\u00ednh Excel c\u1ee7a m\u00ecnh l\u00ean.<\/p>\n

B\u01b0\u1edbc 2:<\/strong> Ch\u1ecdn v\u00e0o m\u1ee5c Insert tr\u00ean thanh c\u00f4ng c\u1ee5, ti\u1ebfp t\u1ee5c ch\u1ecdn Picture \u0111\u1ec3 ch\u00e8n h\u00ecnh v\u00e0o trang t\u00ednh.<\/p>\n

\"Ch\u00e8n<\/p>\n

B\u01b0\u1edbc 3:<\/strong> L\u1ef1a ch\u1ecdn h\u00ecnh m\u00e0 b\u1ea1n mu\u1ed1n ch\u00e8n v\u00e0o r\u1ed3i click chu\u1ed9t v\u00e0o Insert \u0111\u1ec3 ch\u00e8n h\u00ecnh.<\/p>\n

\"Ch\u00e8n<\/p>\n

Nh\u01b0 v\u1eady, ch\u1ec9 v\u1edbi m\u1ed9t v\u00e0i c\u00e1i click chu\u1ed9t r\u1ea5t \u0111\u01a1n gi\u1ea3n b\u1ea1n \u0111\u00e3 ch\u00e8n \u1ea3nh th\u00e0nh c\u00f4ng.<\/p>\n

Ch\u00e8n h\u00e0ng lo\u1ea1t \u1ea3nh v\u00e0o trang t\u00ednh Excel<\/strong><\/h2>\n

\u0110\u1ed1i v\u1edbi ch\u00e8n h\u00e0ng lo\u1ea1t \u1ea3nh v\u00e0o Excel<\/strong> th\u00ec s\u1ebd kh\u00f3 h\u01a1n m\u1ed9t ch\u00fat. Khi n\u00e0y, \u0111\u1ec3 ch\u00e8n \u1ea3nh th\u00ec b\u1ea1n s\u1ebd ph\u1ea3i th\u1ef1c hi\u1ec7n nhi\u1ec1u b\u01b0\u1edbc h\u01a1n.<\/p>\n

B\u01b0\u1edbc 1:<\/strong> Vi\u1ec7c \u0111\u1ea7u ti\u00ean m\u00e0 b\u1ea1n c\u1ea7n ph\u1ea3i l\u00e0m \u0111\u00f3 ch\u00ednh l\u00e0 \u0111\u01b0a t\u1ea5t c\u1ea3 h\u00ecnh \u1ea3nh c\u1ea7n ch\u00e8n v\u00e0o Excel cho trong m\u1ed9t th\u01b0 m\u1ee5c. Ti\u1ebfp theo b\u1ea1n click chu\u1ed9t ph\u1ea3i v\u00e0o \u0111\u01b0\u1eddng d\u1eabn th\u01b0 m\u1ee5c \u0111\u00f3, r\u1ed3i sau \u0111\u00f3 copy \u0111\u01b0\u1eddng d\u1eabn th\u01b0 m\u1ee5c \u1ea3nh.<\/p>\n

\"Ch\u00e8n<\/p>\n

B\u01b0\u1edbc 2:<\/strong> T\u1ea1o c\u1ed9t t\u00ean \u1ea3nh trong file Excel ch\u1ee9a ch\u00ednh x\u00e1c t\u00ean \u1ea3nh v\u00e0 c\u1ea3 ph\u1ea7n \u0111u\u00f4i c\u1ee7a \u1ea3nh.<\/p>\n

\"Ch\u00e8n<\/p>\n

B\u01b0\u1edbc 3:<\/strong> Paste \u0111\u01b0\u1eddng d\u1eabn th\u01b0 m\u1ee5c \u1ea3nh \u0111\u00e3 copy tr\u01b0\u1edbc \u0111\u00f3 v\u00e0o m\u1ed9t \u00f4 b\u1ea5t k\u1ef3 n\u00e0o \u0111\u00f3 trong Excel.<\/p>\n

\"Ch\u00e8n<\/p>\n

B\u01b0\u1edbc 4:<\/strong> Ti\u1ebfp t\u1ee5c t\u1ea1o c\u1ed9t t\u00ean t\u01b0\u01a1ng \u1ee9ng c\u1ea1nh b\u00ean c\u1ed9t T\u00ean \u1ea3nh. Ti\u1ebfp theo sau \u0111\u00f3 d\u00f9ng h\u00e0m Vlookup \u0111\u1ec3 g\u00e1n \u0111\u01b0\u1eddng d\u1eabn th\u01b0 m\u1ee5c \u1ea3nh v\u1edbi t\u00ean \u1ea3nh. C\u00f4ng th\u1ee9c: \u0111\u01b0\u1eddng d\u1eabn th\u01b0 m\u1ee5c \u1ea3nh &\u201d\\\u201d&VLOOKUP(T\u00ean;v\u00f9ng T\u00ean v\u00e0 T\u00ean \u1ea3nh;2;FALSE). T\u1ea1o c\u00f4ng th\u1ee9c xong th\u00ec \u1ea5n enter, sau \u0111\u00f3 ti\u1ebfp t\u1ee5c k\u00e9o \u00f4 \u0111\u1ea7u ti\u00ean xu\u1ed1ng b\u00ean d\u01b0\u1edbi \u0111\u1ec3 sao ch\u00e9p c\u00f4ng th\u1ee9c v\u00e0 \u0111\u1ec3 c\u00f4ng th\u1ee9c \u00e1p d\u1ee5ng cho c\u00e1c \u00f4 ti\u1ebfp theo.<\/p>\n

\"Ch\u00e8n<\/p>\n

B\u01b0\u1edbc 5:<\/strong> Truy c\u1eadp trang t\u1ea3i file Macros \u0111\u1ec3 ch\u00e8n \u1ea3nh t\u1ef1 \u0111\u1ed9ng, r\u1ed3i nh\u1ea5n t\u1ea3i xu\u1ed1ng \u0111\u1ec3 t\u1ea3i Macros v\u1ec1.<\/p>\n

\"Ch\u00e8n<\/p>\n

B\u01b0\u1edbc 6:<\/strong> Sau khi \u0111\u00e3 t\u1ea3i Macros xong th\u00ec t\u1ea1i giao di\u1ec7n file Excel b\u1ea1n click ch\u1ecdn tab View r\u1ed3i nh\u1ea5n ch\u1ecdn Macros.<\/p>\n

\"Ch\u00e8n<\/p>\n

B\u01b0\u1edbc 7:<\/strong> Ti\u1ebfp t\u1ee5c ch\u1ecdn ChenAnhTuDong.xlsm!ChenAnh<\/strong>, sau \u0111\u00f3 nh\u1ea5n ch\u1ecdn Run \u0111\u1ec3 file \u0111\u01b0\u1ee3c k\u00edch ho\u1ea1t.<\/p>\n

\"Ch\u00e8n<\/p>\n

B\u01b0\u1edbc 8:<\/strong> T\u1ea1i \u00f4 Input b\u1ea1n qu\u00e9t to\u00e0n b\u1ed9 c\u00e1c \u00f4 ch\u1ee9a \u0111\u01b0\u1eddng d\u1eabn \u1ea3nh k\u00e8m t\u00ean, r\u1ed3i sau \u0111\u00f3 nh\u1ea5n OK \u0111\u1ec3 ti\u1ebfp t\u1ee5c<\/p>\n

\"Ch\u00e8n<\/p>\n

B\u01b0\u1edbc 9:<\/strong> Ch\u1ecdn v\u00f9ng ch\u1ee9a \u1ea3nh r\u1ed3i ti\u1ebfp t\u1ee5c nh\u1ea5n OK \u0111\u1ec3 ch\u00e8n \u1ea3nh.<\/p>\n

\"Ch\u00e8n<\/p>\n

B\u01b0\u1edbc 10:<\/strong> Trong th\u00f4ng b\u00e1o Xoa anh cu b\u1ea1n ch\u1ecdn yes \u0111\u1ec3 x\u00f3a \u1ea3nh c\u0169 v\u00e0 \u0111\u1ec3 ho\u00e0n t\u1ea5t qu\u00e1 tr\u00ecnh ch\u00e8n \u1ea3nh.<\/p>\n

\"Ch\u00e8n<\/p>\n

V\u00e0 \u0111\u00e2y l\u00e0 k\u1ebft qu\u1ea3<\/p>\n

\"Ch\u00e8n<\/p>\n

C\u00f3 th\u1ec3 b\u1ea1n quan t\u00e2m: C\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 c\u1ed9t trong Excel<\/a><\/strong><\/span><\/p><\/blockquote>\n

C\u00e1ch ch\u00e8n \u1ea3nh v\u00e0o Excel tr\u00ean \u0111i\u1ec7n tho\u1ea1i<\/strong><\/h2>\n

\u0110\u1ec3 ch\u00e8n \u1ea3nh v\u00e0o Excel<\/strong> tr\u00ean \u0111i\u1ec7n tho\u1ea1i<\/strong> th\u00ec c\u0169ng t\u01b0\u01a1ng \u0111\u1ed1i \u0111\u01a1n gi\u1ea3n v\u00e0 kh\u00f4ng qu\u00e1 kh\u00f3 kh\u0103n. C\u00e1ch th\u1ef1c hi\u1ec7n bao g\u1ed3m nh\u1eefng b\u01b0\u1edbc nh\u01b0 sau:<\/p>\n

B\u01b0\u1edbc 1:<\/strong> M\u1edf \u1ee9ng d\u1ee5ng Excel tr\u00ean \u0111i\u1ec7n tho\u1ea1i ra, tr\u00ean thanh c\u00f4ng c\u1ee5 ph\u00eda d\u01b0\u1edbi g\u00f3c ph\u1ea3i m\u00e0n h\u00ecnh b\u1ea1n ch\u1ecdn bi\u1ec3u t\u01b0\u1ee3ng b\u00f3ng \u0111\u00e8n.<\/p>\n

\"C\u00e1ch<\/p>\n

B\u01b0\u1edbc 2:<\/strong> T\u1ea1i thanh c\u00f4ng c\u1ee5 t\u00ecm ki\u1ebfm b\u1ea1n nh\u1eadp \u201cch\u00e8n h\u00ecnh \u1ea3nh\u201d \u0111\u1ec3 ch\u00e8n h\u00ecnh \u1ea3nh v\u00e0o trang t\u00ednh Excel.<\/p>\n

\"C\u00e1ch<\/p>\n

B\u01b0\u1edbc 3:<\/strong> L\u1ef1a ch\u1ecdn h\u00ecnh \u1ea3nh m\u00e0 m\u00ecnh mu\u1ed1n ch\u00e8n v\u00e0o trong b\u1ea3ng Excel r\u1ed3i \u1ea5n \u0111\u00e3 xong \u0111\u1ec3 ch\u00e8n h\u00ecnh.<\/p>\n

\"C\u00e1ch<\/p>\n

Nh\u01b0 v\u1eady, ch\u1ec9 v\u1edbi m\u1ed9t v\u00e0i nh\u1eefng thao t\u00e1c r\u1ea5t \u0111\u01a1n gi\u1ea3n v\u00e0 d\u1ec5 d\u00e0ng l\u00e0 b\u1ea1n \u0111\u00e3 c\u00f3 th\u1ec3 ch\u00e8n \u0111\u01b0\u1ee3c \u1ea3nh v\u00e0o Excel \u1ea3nh v\u00e0o Excel tr\u00ean \u0111i\u1ec7n tho\u1ea1i. Qu\u00e1 tr\u00ecnh ch\u00e8n \u1ea3nh v\u00e0o Excel tr\u00ean \u0111i\u1ec7n tho\u1ea1i<\/strong> s\u1ebd gi\u00fap b\u1ea1n thu\u1eadn ti\u1ec7n v\u00e0 ch\u1ee7 \u0111\u1ed9ng trong qu\u00e1 tr\u00ecnh l\u00e0m vi\u1ec7c v\u1edbi Excel. Khi kh\u00f4ng c\u00f3 m\u00e1y t\u00ednh th\u00ec v\u1eabn c\u00f3 th\u1ec3 ch\u00e8n \u0111\u01b0\u1ee3c h\u00ecnh \u1ea3nh nhanh ch\u00f3ng.<\/p>\n

Tr\u00ean \u0111\u00e2y l\u00e0 t\u1ed5ng h\u1ee3p 3 c\u00e1ch ch\u00e8n \u1ea3nh v\u00e0o Excel <\/strong>\u0111\u01a1n gi\u1ea3n v\u00e0 nhanh ch\u00f3ng cho \u0111i\u1ec7n tho\u1ea1i v\u00e0 m\u00e1y t\u00ednh. C\u00e1c b\u1ea1n h\u00e3y b\u1ecf t\u00fai ngay cho m\u00ecnh nh\u1eefng c\u00e1ch n\u00e0y \u0111\u1ec3 th\u1ef1c hi\u1ec7n d\u1ec5 d\u00e0ng khi c\u1ea7n thi\u1ebft nh\u00e9. Ch\u00fac c\u00e1c b\u1ea1n c\u00f3 qu\u00e1 tr\u00ecnh ch\u00e8n \u1ea3nh v\u00e0o Excel th\u00e0nh c\u00f4ng.<\/p>\n

B\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o th\u00eam: C\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 c\u1ed9t trong Excel\u00a0<\/a><\/strong><\/span><\/p><\/blockquote>\n","protected":false},"excerpt":{"rendered":"

B\u1ea1n s\u1eed d\u1ee5ng excel \u0111\u00e3 l\u00e2u nh\u01b0ng l\u1ea1i ch\u01b0a bi\u1ebft c\u00e1ch ch\u00e8n \u1ea3nh. B\u1ea1n \u0111ang mu\u1ed1n\u00a0ch\u00e8n \u1ea3nh v\u00e0o Excel\u00a0\u0111\u1ec3 minh h\u1ecda r\u00f5 r\u00e0ng v\u00e0 chi ti\u1ebft n\u1ed9i dung m\u00e0 m\u00ecnh \u0111ang mu\u1ed1n truy\u1ec1n t\u1ea3i. B\u00e0i vi\u1ebft sau \u0111\u00e2y ch\u00fang t\u00f4i s\u1ebd chia s\u1ebb cho b\u1ea1n 3 c\u00e1ch ch\u00e8n \u1ea3nh v\u00e0o trang t\u00ednh Excel \u0111\u01a1n gi\u1ea3n […]<\/p>\n","protected":false},"author":39,"featured_media":20789,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_links_to":"","_links_to_target":""},"categories":[10],"tags":[],"class_list":["post-20788","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-thu-thuat-phan-mem"],"_links":{"self":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/20788","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/users\/39"}],"replies":[{"embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/comments?post=20788"}],"version-history":[{"count":2,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/20788\/revisions"}],"predecessor-version":[{"id":43078,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/20788\/revisions\/43078"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/media\/20789"}],"wp:attachment":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/media?parent=20788"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/categories?post=20788"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/tags?post=20788"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}