{"id":10542,"date":"2019-12-22T09:23:18","date_gmt":"2019-12-22T09:23:18","guid":{"rendered":"https:\/\/hocvienit.vn\/?p=10542"},"modified":"2024-07-03T15:14:08","modified_gmt":"2024-07-03T08:14:08","slug":"sua-loi-file-excel-bi-mat-dinh-dang","status":"publish","type":"post","link":"https:\/\/hocvienit.vn\/?p=10542","title":{"rendered":"Th\u1ee7 thu\u1eadt s\u1eeda l\u1ed7i file excel b\u1ecb m\u1ea5t \u0111\u1ecbnh d\u1ea1ng"},"content":{"rendered":"

Trong nh\u1eefng c\u00f4ng c\u1ee5 h\u1ed7 tr\u1ee3 v\u0103n ph\u00f2ng c\u1ee7a Microsoft, kh\u00f4ng th\u1ec3 kh\u00f4ng k\u1ec3 \u0111\u1ebfn Excel – m\u1ed9t c\u00f4ng c\u1ee5 v\u00f4 c\u00f9ng h\u1eefu \u00edch \u0111\u1ed1i v\u1edbi d\u00e2n v\u0103n ph\u00f2ng c\u0169ng nh\u01b0 h\u1ecdc sinh, sinh vi\u00ean trong qu\u00e1 tr\u00ecnh l\u00e0m vi\u1ec7c li\u00ean quan \u0111\u1ebfn s\u1ed1 li\u1ec7u v\u00e0 t\u00ednh to\u00e1n.<\/span><\/p>\n

\u0110i\u1ec1u n\u00e0y c\u0169ng \u0111\u1ed3ng ngh\u0129a v\u1edbi vi\u1ec7c ch\u00fang ta n\u00f3i chung v\u00e0 h\u1ecdc sinh, sinh vi\u00ean, d\u00e2n v\u0103n ph\u00f2ng n\u00f3i ri\u00eang c\u1ea7n trang b\u1ecb cho m\u00ecnh nh\u1eefng ki\u1ebfn th\u1ee9c v\u1ec1 c\u00e1c l\u1ed7i excel \u0111\u1ec3 c\u00f3 bi\u1ec7n ph\u00e1p kh\u1eafc ph\u1ee5c k\u1ecbp th\u1eddi.<\/span><\/p>\n

Cho n\u00ean, trong b\u00e0i vi\u1ebft n\u00e0y, HOCVIENiT.vn s\u1ebd chia s\u1ebb t\u1edbi c\u00e1c b\u1ea1n c\u00e1ch s\u1eeda l\u1ed7i file excel b\u1ecb m\u1ea5t \u0111\u1ecbnh d\u1ea1ng.<\/span><\/p>\n

\"Th\u1ee7
Th\u1ee7 thu\u1eadt s\u1eeda l\u1ed7i file excel b\u1ecb m\u1ea5t \u0111\u1ecbnh d\u1ea1ng<\/figcaption><\/figure>\n

L\u1ed7i file excel b\u1ecb m\u1ea5t \u0111\u1ecbnh d\u1ea1ng l\u00e0 g\u00ec?<\/strong><\/h2>\n

Bi\u1ec3u hi\u1ec7n c\u1ee7a l\u1ed7i file excel b\u1ecb m\u1ea5t \u0111\u1ecbnh d\u1ea1ng \u0111\u00f3 l\u00e0 b\u1ea1n kh\u00f4ng th\u1ec3 thi\u1ebft l\u1eadp \u0111\u01b0\u1ee3c c\u00e1c \u0111\u1ecbnh d\u1ea1ng c\u1ee7a Excel v\u1ec1 m\u00e0u s\u1eafc, k\u00fd t\u1ef1, vi\u1ec1n \u00f4 (t\u1ee9c l\u00e0 c\u00e1c \u0111\u1ecbnh d\u1ea1ng b\u1ecb m\u1ea5t h\u1ebft) sau khi l\u01b0u v\u00e0 \u0111\u00f3ng l\u1ea1i. Th\u00eam v\u00e0o \u0111\u00f3, khi l\u1ed7i x\u1ea3y ra s\u1ebd khi\u1ebfn b\u1ea1n kh\u00f4ng c\u00f3 kh\u1ea3 n\u0103ng \u0111\u1ecdc hay kh\u00f4i ph\u1ee5c file v\u1ec1 \u0111\u1ecbnh d\u1ea1ng ban \u0111\u1ea7u tr\u01b0\u1edbc khi m\u1ea5t \u0111\u1ecbnh d\u1ea1ng.<\/span><\/p>\n

H\u01b0\u1edbng d\u1eabn kh\u1eafc ph\u1ee5c l\u1ed7i file excel b\u1ecb m\u1ea5t \u0111\u1ecbnh d\u1ea1ng<\/strong><\/h2>\n

Nguy\u00ean nh\u00e2n ph\u1ed5 bi\u1ebfn nh\u1ea5t g\u00e2y ra l\u1ed7i file excel b\u1ecb m\u1ea5t \u0111\u1ecbnh d\u1ea1ng l\u00e0 do b\u1ea1n \u0111\u00e3 v\u00f4 t\u00ecnh l\u01b0u file excel d\u01b0\u1edbi d\u1ea1ng Microsoft Excel 5.0\/95 Workbook (m\u1ed9t \u0111\u1ecbnh d\u1ea1ng file excel thu\u1ed9c phi\u00ean b\u1ea3n Office t\u1eeb th\u1ebf h\u1ec7 \u0111\u1ea7u ti\u00ean cho ra m\u1eaft n\u00ean n\u00f3 ch\u01b0a \u0111\u01b0\u1ee3c h\u1ed7 tr\u1ee3 \u0111\u1ea7y \u0111\u1ee7 c\u00e1c t\u00ednh n\u0103ng c\u1ee7a c\u00e1c phi\u00ean b\u1ea3n Office th\u1ebf h\u1ec7 sau) m\u00e0 kh\u00f4ng h\u1ec1 hay bi\u1ebft.\u00a0<\/span><\/p>\n

V\u1eady n\u00ean c\u00e1ch kh\u1eafc ph\u1ee5c khi g\u1eb7p ph\u1ea3i l\u1ed7i file excel b\u1ecb m\u1ea5t \u0111\u1ecbnh d\u1ea1ng ch\u00ednh l\u00e0 l\u01b0u file excel d\u01b0\u1edbi \u0111\u1ecbnh d\u1ea1ng file kh\u00e1c l\u00e0 \u0111\u01b0\u1ee3c.<\/span><\/p>\n

L\u01b0u \u00fd: C\u00e1c \u0111\u1ecbnh d\u1ea1ng file \u0111\u01b0\u1ee3c \u0111\u1ec1 xu\u1ea5t b\u1ea1n n\u00ean s\u1eed d\u1ee5ng l\u00e0 Excel 97-2003 Workbook (*.xls) ho\u1eb7c Excel Workbook (*.xlsx) n\u1ebfu file c\u1ee7a b\u1ea1n kh\u00f4ng ch\u1ee9a Macro.<\/span><\/i><\/p>\n

 <\/p>\n

Tr\u00ean \u0111\u00e2y l\u00e0 chia s\u1ebb c\u1ee7a HOCVIENiT.vn<\/a> v\u1ec1 th\u1ee7 thu\u1eadt s\u1eeda l\u1ed7i file excel b\u1ecb m\u1ea5t \u0111\u1ecbnh d\u1ea1ng. Ch\u00fac b\u1ea1n th\u00e0nh c\u00f4ng!<\/span><\/p>\n

N\u1ebfu c\u00f3 b\u1ea5t c\u1ee9 th\u1eafc m\u1eafc n\u00e0o v\u1ec1 c\u00e1c ki\u1ebfn th\u1ee9c li\u00ean quan \u0111\u1ebfn m\u00e1y t\u00ednh th\u00ec b\u1ea1n c\u00f3 th\u1ec3 \u0111\u1ec3 l\u1ea1i b\u00ecnh lu\u1eadn b\u00ean d\u01b0\u1edbi b\u00e0i vi\u1ebft n\u00e0y. V\u00e0 \u0111\u1eebng qu\u00ean \u0111\u00f3n \u0111\u1ecdc c\u00e1c b\u00e0i vi\u1ebft h\u1eefu \u00edch kh\u00e1c c\u1ee7a HOCVIENiT.vn nh\u00e9.<\/span><\/p>\n

 <\/p>\n

M\u1ecdi chi ti\u1ebft xin vui l\u00f2ng li\u00ean h\u1ec7:<\/i><\/p>\n

C\u00d4NG TY C\u1ed4 PH\u1ea6N H\u1eccC VI\u1ec6N IT<\/strong>
\nMST: 0108733789<\/strong>
\nT\u1ed5ng \u0111\u00e0i h\u1ed7 tr\u1ee3: 024 3566 8686 \u2013 Hotline: 0981 223 001<\/strong>
\nFacebook:<\/strong>\u00a0www.fb.com\/hocvienit<\/a><\/p>\n

\u0110\u0103ng k\u00fd k\u00eanh Youtube \u0111\u1ec3 theo d\u00f5i c\u00e1c b\u00e0i h\u1ecdc c\u1ee7a Hu\u1ea5n luy\u1ec7n vi\u00ean t\u1ed1t nh\u1ea5t:<\/strong>\u00a0http:\/\/bit.ly\/Youtube_HOCVIENiT<\/a><\/p>\n

Tham gia c\u1ed9ng \u0111\u1ed3ng H\u1ecdc vi\u1ec7n IT.vn t\u1ea1i:<\/strong>\u00a0https:\/\/www.facebook.com\/groups\/www.hocvienit.vn\/<\/a><\/p>\n

Tr\u1ee5 s\u1edf H\u00e0 N\u1ed9i:<\/strong>\u00a0S\u1ed1 8 ng\u00f5 117 Th\u00e1i H\u00e0, \u0110\u1ed1ng \u0110a, H\u00e0 N\u1ed9i<\/p>\n

H\u1ed3 Ch\u00ed Minh:<\/strong>\u00a0S\u1ed1 283\/45 C\u00e1ch M\u1ea1ng Th\u00e1ng T\u00e1m, Ph\u01b0\u1eddng 12, Qu\u1eadn 10,\u00a0TP.HCM
\nH\u1ea3i Ph\u00f2ng:<\/strong>\u00a0S\u1ed1 94 Qu\u00e1n Nam, L\u00ea Ch\u00e2n, H\u1ea3i Ph\u00f2ng<\/p>\n

Th\u00e1i Nguy\u00ean:<\/strong>\u00a0S\u1ed1 297 L\u01b0\u01a1ng Ng\u1ecdc Quy\u1ebfn, TP. Th\u00e1i Nguy\u00ean
\nH\u1ecdc vi\u1ec7n IT.vn \u2013 Truy\u1ec1n ngh\u1ec1 th\u1ef1c t\u1ebf c\u00f9ng b\u1ea1n \u0111\u1ebfn th\u00e0nh c\u00f4ng!\u00a0<\/i><\/strong><\/p>\n

\n","protected":false},"excerpt":{"rendered":"

Khi b\u1ea1n b\u1ecb l\u1ed7i file excel b\u1ecb m\u1ea5t \u0111\u1ecbnh d\u1ea1ng th\u00ec b\u1ea1n kh\u00f4ng th\u1ec3 thi\u1ebft l\u1eadp \u0111\u01b0\u1ee3c c\u00e1c \u0111\u1ecbnh d\u1ea1ng c\u1ee7a Excel v\u1ec1 m\u00e0u s\u1eafc, k\u00fd t\u1ef1, vi\u1ec1n \u00f4 (t\u1ee9c l\u00e0 c\u00e1c \u0111\u1ecbnh d\u1ea1ng b\u1ecb m\u1ea5t h\u1ebft) sau khi l\u01b0u v\u00e0 \u0111\u00f3ng l\u1ea1i. Ngo\u00e0i ra, l\u1ed7i s\u1ebd khi\u1ebfn b\u1ea1n kh\u00f4ng c\u00f3 kh\u1ea3 n\u0103ng \u0111\u1ecdc hay kh\u00f4i ph\u1ee5c file v\u1ec1 \u0111\u1ecbnh d\u1ea1ng ban \u0111\u1ea7u tr\u01b0\u1edbc khi m\u1ea5t \u0111\u1ecbnh d\u1ea1ng.<\/p>\n","protected":false},"author":95,"featured_media":10543,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[96,94],"tags":[481,482],"_links":{"self":[{"href":"https:\/\/hocvienit.vn\/index.php?rest_route=\/wp\/v2\/posts\/10542"}],"collection":[{"href":"https:\/\/hocvienit.vn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hocvienit.vn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hocvienit.vn\/index.php?rest_route=\/wp\/v2\/users\/95"}],"replies":[{"embeddable":true,"href":"https:\/\/hocvienit.vn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=10542"}],"version-history":[{"count":0,"href":"https:\/\/hocvienit.vn\/index.php?rest_route=\/wp\/v2\/posts\/10542\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hocvienit.vn\/index.php?rest_route=\/wp\/v2\/media\/10543"}],"wp:attachment":[{"href":"https:\/\/hocvienit.vn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=10542"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hocvienit.vn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=10542"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hocvienit.vn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=10542"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}