{"id":4680,"date":"2024-12-08T06:20:30","date_gmt":"2024-12-08T06:20:30","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/08\/bi-kip-giam-can-cho-file-excel-tap-1\/"},"modified":"2024-12-08T06:20:30","modified_gmt":"2024-12-08T06:20:30","slug":"bi-kip-giam-can-cho-file-excel-tap-1","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/08\/bi-kip-giam-can-cho-file-excel-tap-1\/","title":{"rendered":"B\u00ed k\u00edp gi\u1ea3m c\u00e2n cho file Excel \u2013 T\u1eadp 1"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>B\u1ea1n c\u00f3 m\u1ed9t file Excel, n\u00f3 ng\u00e0y c\u00e0ng \u201cb\u00e9o ph\u00ec\u201d qu\u00e1 c\u00e2n, dung l\u01b0\u1ee3ng th\u00ec ng\u00e0y m\u1ed9t t\u0103ng l\u00ean, x\u1eed l\u00fd c\u00f4ng vi\u1ec7c ng\u00e0y c\u00e0ng ch\u1eadm ch\u1ea1p. C\u00e2u h\u1ecfi \u0111\u1eb7t ra l\u00e0? L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 gi\u1ea3m c\u00e2n cho file Excel \u0111\u00f3? L\u1ed7i n\u00e0y t\u1eeb \u0111\u00e2u ra?<\/p>\n<p>K\u1ebb th\u00f9 duy nh\u1ea5t c\u1ee7a vi\u1ec7c t\u0103ng c\u00e2n b\u00e9o ph\u00ec n\u00e0y, ch\u00ednh l\u00e0 do <strong>\u0103n nhi\u1ec1u qu\u00e1 \u0111\u1ed9 v\u00e0 l\u01b0\u1eddi luy\u1ec7n t\u1eadp th\u1ec3 thao.<\/strong> Nghe gi\u1ed1ng con ng\u01b0\u1eddi qu\u00e1 nh\u1ec9? Th\u1ef1c ra vi\u1ec7c \u0103n nhi\u1ec1u \u1edf trong Excel, ch\u00ednh l\u00e0 thao t\u00e1c <strong>COPY &amp; PASTE<\/strong> c\u1ee7a b\u1ea1n g\u00e2y n\u00ean.<\/p>\n<p><strong>C\u00c1C NGUY\u00caN NH\u00c2N:<\/strong><\/p>\n<ul>\n<li>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-67553aadcd039\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/file-excel-bi-nang-lam-sao-de-giam-dung-luong.html#Objects\" title=\"Objects:\">Objects:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/file-excel-bi-nang-lam-sao-de-giam-dung-luong.html#Data_Links\" title=\"Data Links:\">Data Links:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/file-excel-bi-nang-lam-sao-de-giam-dung-luong.html#Named_Range\" title=\"Named Range:\">Named Range:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/file-excel-bi-nang-lam-sao-de-giam-dung-luong.html#Styles\" title=\"Styles:\">Styles:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/file-excel-bi-nang-lam-sao-de-giam-dung-luong.html#Excel_Binary_Workbook_giup_giam_dung_luong\" title=\"Excel Binary Workbook gi\u00fap gi\u1ea3m dung l\u01b0\u1ee3ng\">Excel Binary Workbook gi\u00fap gi\u1ea3m dung l\u01b0\u1ee3ng<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Objects\"><\/span>Objects:<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>C\u00e1c h\u00ecnh shape, hay n\u00fat b\u1ea1n ch\u00e8n trong \u00f4, khi b\u1ea1n sao ch\u00e9p xu\u1ed1ng (Fill Down), th\u00ec n\u00f3 c\u0169ng t\u1ef1 sao ch\u00e9p ra. Ho\u1eb7c b\u1ea1n sao ch\u00e9p n\u1ed9i dung tr\u00ean 1 trang web n\u00e0o \u0111\u00f3, ho\u1eb7c t\u1eeb file n\u00e0o \u0111\u00f3 kh\u00e1c, v\u00e0 d\u00e1n v\u00e0o file c\u1ee7a m\u00ecnh, \u0111i k\u00e8m l\u00e0 nh\u1eefng Object m\u00e0 b\u1ea1n kh\u00f4ng th\u1ec3 th\u1ea5y b\u1eb1ng m\u1eaft th\u01b0\u1eddng.<\/p>\n<p><strong>V\u1eady l\u00e0m sao \u0111\u1ec3 x\u00f3a b\u1ecf c\u00e1c Object trong file Excel?<\/strong><\/p>\n<\/li>\n<\/ul>\n<p><em><strong>C\u00e1ch th\u00f4ng th\u01b0\u1eddng:<\/strong><\/em><\/p>\n<ul style=\"list-style-type: circle\">\n<li>B\u01b0\u1edbc 1: Ch\u1ecdn Sheet ch\u1ee9a Object c\u1ea7n x\u00f3a, <strong>nh\u1ea5n F5<\/strong> \u0111\u1ec3 hi\u1ec7n ra c\u1eeda s\u1ed5 <strong>Go to<\/strong>\u2026 (ho\u1eb7c v\u00e0o tab <strong>Home<\/strong>, ch\u1ecdn <strong>Find &amp; Select<\/strong>).<\/li>\n<li>B\u01b0\u1edbc 2: Ch\u1ecdn <strong>Specials<\/strong><\/li>\n<li>B\u01b0\u1edbc 3: Ch\u1ecdn <strong>Objects<\/strong> v\u00e0 nh\u1ea5n OK.<\/li>\n<li>B\u01b0\u1edbc 4: Nh\u1ea5n <strong>Delete<\/strong> \u0111\u1ec3 x\u00f3a t\u1ea5t c\u1ea3.<br \/>\n<strong>L\u01b0u \u00fd:<\/strong> T\u1ea5t c\u1ea3 c\u00e1c Object trong Sheet s\u1ebd \u0111\u01b0\u1ee3c ch\u1ecdn, tuy nhi\u00ean n\u1ebfu b\u1ea1n mu\u1ed1n gi\u1eef l\u1ea1i 1 object n\u00e0o \u0111\u00f3, v\u00ed d\u1ee5 nh\u01b0 l\u00e0 c\u00e1i n\u00fat ch\u1ea1y macro, th\u00ec b\u1ea1n c\u00f3 th\u1ec3 \u1ea5n gi\u1eef SHIFT v\u00e0 ch\u1ecdn v\u00e0o n\u00fat \u0111\u00f3 \u0111\u1ec3 b\u1ecf ch\u1ecdn, r\u1ed3i b\u1ea1n c\u00f3 th\u1ec3 x\u00f3a c\u00e1c object c\u00f2n l\u1ea1i. T\u01b0\u01a1ng t\u1ef1 ch\u00fang ta s\u1ebd l\u00e0m cho t\u1eebng sheet kh\u00e1c.<\/li>\n<\/ul>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/06\/object-sheet.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-19723 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/object-sheet.jpg\" width=\"824\" height=\"608\" title=\"object-sheet\"><\/a><\/p>\n<p>Ho\u1eb7c b\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn tab <strong>Home<\/strong>, sau \u0111\u00f3 ch\u1ecdn <strong>Find &amp; Select<\/strong> &gt; Ch\u1ecdn ti\u1ebfp <strong>Selection Pane\u2026<\/strong> L\u00fac n\u00e0y b\u1ea1n s\u1ebd th\u1ea5y c\u00f3 nh\u1eefng Object ch\u00e8n trong\u00a0sheet hi\u1ec7n t\u1ea1i c\u1ee7a b\u1ea1n, v\u00ed d\u1ee5 nh\u01b0 trong \u1ea3nh sau, b\u1ea1n ch\u1ec9 c\u1ea7n ch\u1ecdn t\u1ea5t c\u1ea3 r\u1ed3i x\u00f3a.<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/06\/selection-panel.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-22770\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/selection-panel.jpg\" width=\"1363\" height=\"677\" title=\"selection-panel\"><\/a><\/p>\n<p><em>D\u00f9ng <strong>ASAP\u00a0Utilities\u00a0Add-in<\/strong>:<\/em><\/p>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-380.gif\" title=\"ex101_92019-nho-380\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>\u2013 B\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn Tab ASAP Utilites, v\u00e0 ch\u1ecdn nh\u00f3m menu <strong>Objects &amp; Comments<\/strong>, ch\u1ecdn m\u1ee5c 3.\u00a0<strong>Select All Objects<\/strong> \u0111\u1ec3 ch\u1ecdn t\u1ea5t c\u1ea3, sau \u0111\u00f3 c\u00f3 th\u1ec3 b\u1ecf ch\u1ecdn c\u00e1i m\u00ecnh c\u1ea7n gi\u1eef l\u1ea1i (Shift + Click chu\u1ed9t ch\u1ecdn, \u0111\u1ec3 gi\u1eef l\u1ea1i object m\u00ecnh c\u1ea7n), sau \u0111\u00f3 th\u00ec x\u00f3a t\u1ea5t c\u1ea3.<\/p>\n<p>\u2013 Ho\u1eb7c b\u1ea1n kh\u00f4ng c\u1ea7n gi\u1eef g\u00ec, th\u00ec c\u00f3 th\u1ec3 ch\u1ecdn m\u1ee5c 4.\u00a0<strong>Delete all objects in selected worksheets.<\/strong><br \/>\nV\u1edbi ASAP Utilities b\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn nhi\u1ec1u Sheets \u0111\u1ed3ng th\u1eddi v\u00e0 l\u00e0m thao t\u00e1c x\u00f3a t\u1ea5t c\u1ea3 c\u00e1c Objects c\u00f3 trong c\u00e1c sheet m\u1ed9t c\u00e1ch nhanh ch\u00f3ng.<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/06\/asap-objects.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-19724\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/asap-objects.jpg\" width=\"884\" height=\"389\" title=\"asap-objects\"><\/a><\/p>\n<p>[divider]<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Data_Links\"><\/span>Data Links:<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Khi b\u1ea1n sao ch\u00e9p d\u1eef li\u1ec7u t\u1eeb file kh\u00e1c\u00a0v\u00e0o file \u0111ang l\u00e0m, v\u00e0 paste c\u00f4ng th\u1ee9c b\u00ecnh th\u01b0\u1eddng, khi \u0111\u00f3 d\u1eef li\u1ec7u s\u1ebd th\u1ec3 hi\u1ec7n l\u00e0 k\u1ebft n\u1ed1i d\u1eef li\u1ec7u t\u1eeb file n\u00e0y sang file kh\u00e1c. V\u00e0 v\u1edbi nhi\u1ec1u thao t\u00e1c nh\u01b0 v\u1eady, th\u00ec b\u1ea1n v\u00f4 t\u00ecnh t\u1ea1o ra r\u1ea5t nhi\u1ec1u k\u1ebft n\u1ed1i. Khi \u0111\u00f3,\u00a0b\u1ea1n s\u1ebd lu\u00f4n th\u1ea5y xu\u1ea5t hi\u1ec7n th\u00f4ng b\u00e1o, r\u1eb1ng file c\u1ee7a b\u1ea1n \u0111ang k\u1ebft n\u1ed1i t\u1edbi file kh\u00e1c, b\u1ea1n c\u00f3 mu\u1ed1n C\u1eadp nh\u1eadt (Update Link) d\u1eef li\u1ec7u hay kh\u00f4ng?<\/p>\n<p>V\u00e0 khi l\u00e0m b\u00e1o c\u00e1o, t\u1ed5ng h\u1ee3p d\u1eef li\u1ec7u\u00a0ch\u00fang ta c\u1ea7n d\u1eef li\u1ec7u ban \u0111\u1ea7u l\u00e0 s\u1ed1 li\u1ec7u, kh\u00f4ng c\u00f3 t\u00ednh li\u00ean k\u1ebft\u00a0 th\u00ec kh\u00f4ng c\u1ea7n thi\u1ebft ph\u1ea3i Links. N\u1ebfu b\u1ea1n \u0111\u1eb7t Link, th\u00ec khi t\u00ednh to\u00e1n Excel s\u1ebd t\u00ecm \u0111\u1ebfn link v\u00e0 c\u1eadp nh\u1eadt gi\u00e1 tr\u1ecb, khi \u0111\u00f3 m\u00e1y t\u00ednh c\u1ee7a b\u1ea1n s\u1ebd ph\u1ea3i ch\u1ea1y kh\u1eafp n\u01a1i t\u00ecm \u0111\u1ebfn c\u00e1i file trong link c\u1ee7a b\u1ea1n.<\/p>\n<p><strong>V\u1eady l\u00e0m sao \u0111\u1ec3 x\u00f3a b\u1ecf c\u00e1c links trong file Excel?<\/strong><\/p>\n<p><em><strong>C\u00e1ch th\u00f4ng th\u01b0\u1eddng:<\/strong><\/em><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/06\/data-links.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-19728 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/data-links.jpg\" width=\"774\" height=\"551\" title=\"data-links\"><\/a><\/p>\n<p>\u2013 B\u1ea1n ch\u1ecdn tab <strong>DATA<\/strong> &gt; Ch\u1ecdn <strong>Edit Links<\/strong>.<\/p>\n<p>\u2013 Ki\u1ec3m tra l\u1ea1i c\u00e1c file b\u1ea1n \u0111\u00e3 li\u00ean k\u1ebft, n\u1ebfu kh\u00f4ng c\u1ea7n thi\u1ebft li\u00ean k\u1ebft n\u1eefa. Ngh\u0129a l\u00e0 b\u1ea1n ch\u1ec9 c\u1ea7n l\u1ea5y k\u1ebft qu\u1ea3 t\u00ednh t\u1eeb file kh\u00e1c. B\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn Break Link \u0111\u1ec3 b\u1ecf li\u00ean k\u1ebft.<\/p>\n<p>\u2013 Khi \u0111\u00f3 s\u1ebd xu\u1ea5t hi\u1ec7n b\u1ea3ng th\u00f4ng b\u00e1o, s\u1ebd chuy\u1ec3n \u0111\u1ed5i c\u00e1c h\u00e0m li\u00ean k\u1ebft th\u00e0nh gi\u00e1 tr\u1ecb k\u1ebft qu\u1ea3 c\u1ee7a n\u00f3, v\u00e0 thao t\u00e1c n\u00e0y kh\u00f4ng th\u1ec3 ho\u00e0n t\u00e1c khi th\u1ef1c hi\u1ec7n. V\u00ec v\u1eady, b\u1ea1n n\u00ean l\u01b0u file v\u1edbi 1 t\u00ean m\u1edbi \u0111\u1ec3 sao l\u01b0u d\u1ef1 ph\u00f2ng, \u0111\u1ec3 th\u1ef1c hi\u1ec7n sao l\u01b0u, b\u1ea1n ch\u1ecdn Cancel, r\u1ed3i Save as \u0111\u1ec3 l\u01b0u t\u00ean m\u1edbi.<\/p>\n<p>\u2013 Sau \u0111\u00f3, c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n vi\u1ec7c <strong>Break Links<\/strong> l\u00e0 \u0111\u1ec3 chuy\u1ec3n \u0111\u1ed5i.<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/06\/break-links.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-19729\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/break-links.jpg\" width=\"870\" height=\"130\" title=\"break-links\"><\/a><\/p>\n<p><em>D\u00f9ng <strong>ASAP\u00a0Utilities\u00a0Add-in<\/strong>:<\/em><\/p>\n<ul style=\"list-style-type: circle\">\n<li>B\u01b0\u1edbc 1: B\u1ea1n ch\u1ecdn tab <strong>ASAP Utilities<\/strong> &gt; Ch\u1ecdn <strong>7. Find and Remove External Links\u2026<\/strong><\/li>\n<li>B\u01b0\u1edbc 2: B\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn c\u00e1c Data Links c\u1ea7n lo\u1ea1i b\u1ecf, b\u1eb1ng c\u00e1ch ch\u1ecdn All, ho\u1eb7c l\u1ef1a ch\u1ecdn t\u1eebng c\u00e1i. Sau \u0111\u00f3 nh\u1ea5n OK. ASAP s\u1ebd xu\u1ea5t hi\u1ec7n th\u00f4ng b\u00e1o, s\u1ebd chuy\u1ec3n c\u00e1c h\u00e0m c\u00f4ng th\u1ee9c sang gi\u00e1 tr\u1ecb c\u1ee7a n\u00f3. B\u1ea1n ch\u1ecdn OK, khi \u0111\u00f3 ASAP s\u1ebd th\u1ef1c hi\u1ec7n vi\u1ec7c lo\u1ea1i b\u1ecf, v\u00e0 chuy\u1ec3n \u0111\u1ed5i cho b\u1ea1n.<\/li>\n<\/ul>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/06\/asap-data-link.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-19732\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/asap-data-link.jpg\" width=\"984\" height=\"658\" title=\"asap-data-link\"><\/a><\/p>\n<p>[divider]<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Named_Range\"><\/span>Named Range:<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>C\u00f9ng v\u1edbi vi\u1ec7c sao ch\u00e9p d\u1eef li\u1ec7u, \u0111i k\u00e8m \u0111\u00f3 l\u00e0 c\u00e1c NAMED RANGE \u0111\u00e3 \u00e1p d\u1ee5ng cho file, v\u00e0 n\u00f3 t\u1ea1o ra r\u1ea5t nhi\u1ec1u Named\u00a0Range trong file c\u1ee7a b\u1ea1n.<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/06\/name-manager-named-range.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-19733\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/name-manager-named-range.jpg\" width=\"984\" height=\"568\" title=\"name-manager-named-range\"><\/a><\/p>\n<p><strong>V\u1eady l\u00e0m sao \u0111\u1ec3 x\u00f3a b\u1ecf c\u00e1c named range trong file Excel?<\/strong><\/p>\n<p><em><strong>C\u00e1ch th\u00f4ng th\u01b0\u1eddng:<\/strong><\/em><\/p>\n<ol>\n<li>B\u01b0\u1edbc 1: B\u1ea1n\u00a0c\u00f3 th\u1ec3 ch\u1ecdn Filter \u0111\u1ec3 ch\u1ecdn ra c\u00e1c Name b\u1ecb l\u1ed7i \u0111\u1ec3 x\u00f3a l\u1ea7n l\u01b0\u1ee3t, \u0111\u1ec3 ch\u1ecdn nhi\u1ec1u Name c\u00f9ng 1 l\u00fac, b\u1ea1n ch\u1ecdn Name \u0111\u1ea7u ti\u00ean trong danh s\u00e1ch.<\/li>\n<li>B\u01b0\u1edbc 2: Gi\u1eef k\u00e9o thanh cu\u1ed9n t\u1edbi cu\u1ed1i c\u00f9ng, v\u00e0 gi\u1eef SHIFT, ch\u1ecdn c\u00e1i name cu\u1ed1i c\u00f9ng.<\/li>\n<li>B\u01b0\u1edbc 3: B\u1ea1n ch\u1ecdn <strong>nh\u1ea5n ph\u00edm Delete<\/strong> \u0111\u1ec3 x\u00f3a.<\/li>\n<\/ol>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/06\/chon-name-range-de-xoa.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-19762\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/chon-name-range-de-xoa.jpg\" width=\"1124\" height=\"440\" title=\"chon-name-range-de-xoa\"><\/a><\/p>\n<p><em><strong>D\u00f9ng ASAP Utilities\u00a0Add-in:<\/strong><\/em><\/p>\n<ol>\n<li>B\u1ea1n ch\u1ecdn tab <strong>ASAP Utilites<\/strong>, ch\u1ecdn m\u1ee5c <strong>RANGE<\/strong>, b\u1ea1n s\u1ebd t\u00ecm th\u1ea5y ph\u1ea7n <strong>27. Delete all name range with an invalid cell references\u2026<\/strong><\/li>\n<li>V\u00e0 b\u1ea1n c\u00f3 th\u1ec3 x\u00f3a t\u1ea5t c\u1ea3. Ngo\u00e0i ra, b\u1ea1n c\u00f3 th\u1ec3 chuy\u1ec3n \u0111\u1ed5i c\u00e1c Named Range th\u00e0nh \u0111\u1ecba ch\u1ec9 c\u1ee7a tham chi\u1ebfu, b\u1eb1ng c\u00e1ch ch\u1ecdn m\u1ee5c <strong>24. Replace the name range used in formulas with their cell references\u2026<\/strong><\/li>\n<\/ol>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/06\/asap-named-range-ref.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-19736 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/asap-named-range-ref.jpg\" width=\"885\" height=\"692\" title=\"asap-named-range-ref\"><\/a><\/p>\n<p>[divider]<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Styles\"><\/span>Styles:<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul>\n<li style=\"list-style-type: none\">\n<ul>\n<li>C\u00f9ng v\u1edbi vi\u1ec7c sao ch\u00e9p d\u1eef li\u1ec7u, \u0111i k\u00e8m \u0111\u00f3 l\u00e0 c\u00e1c\u00a0style \u0111\u00e3 \u00e1p d\u1ee5ng cho file, v\u00e0 n\u00f3 t\u1ea1o ra r\u1ea5t nhi\u1ec1u Style trong file c\u1ee7a b\u1ea1n.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/06\/style-rac-delete.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-19739 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/style-rac-delete.jpg\" width=\"1363\" height=\"648\" title=\"style-rac-delete\"><\/a><strong>V\u1eady l\u00e0m sao \u0111\u1ec3 x\u00f3a b\u1ecf c\u00e1c\u00a0style r\u00e1c\u00a0trong file Excel?<\/strong><\/p>\n<p>\u2013 C\u00e1ch th\u00f4ng th\u01b0\u1eddng: B\u1ea1n c\u00f3 th\u1ec3 click ph\u1ea3i v\u00e0o t\u00ean t\u1eebng Style r\u00e1c, ch\u1ecdn Delete \u0111\u1ec3 x\u00f3a \u0111i. N\u1ebfu th\u1ea5y l\u00e2u qu\u00e1, b\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng Add-in b\u00ean d\u01b0\u1edbi.<\/p>\n<p>\u2013 D\u00f9ng <strong>Remove Style<\/strong> Add-in, \u0111\u00e2y l\u00e0 addin \u0111\u01b0\u1ee3c cung c\u1ea5p b\u1edfi Microsoft. T\u1ea3i v\u1ec1 t\u1eeb\u00a0<a href=\"https:\/\/archive.codeplex.com\/?p=removestyles\" target=\"_blank\" rel=\"noopener noreferrer\">archive.codeplex.com<\/a>\u00a0ho\u1eb7c b\u1ea3n d\u1ef1 ph\u00f2ng t\u1ea1i <a href=\"http:\/\/www.mediafire.com\/file\/hr8twd6hxr61mof\/RemoveStyles.zip\/file\">RemoveStyles qua Mediafire<\/a>. Khi c\u00e0i \u0111\u1eb7t xong, b\u1ea1n s\u1ebd th\u1ea5y m\u1ee5c <strong>Remove Styles<\/strong> xu\u1ea5t hi\u1ec7n trong tab Home, b\u00ean c\u1ea1nh <strong>Cell Styles<\/strong> nh\u01b0 trong \u1ea3nh b\u00ean tr\u00ean.\u00a0B\u1ea1n ch\u01b0a bi\u1ebft c\u00e1ch c\u00e0i addin nh\u01b0 th\u1ebf n\u00e0o? H\u00e3y tham kh\u1ea3o b\u00e0i vi\u1ebft <strong><a href=\"http:\/\/blog.ezworkapp.com\/cach-cai-dat-va-xoa-tep-add-vba-danh-cho-microsoft-office.html\">h\u01b0\u1edbng d\u1eabn c\u00e0i \u0111\u1eb7t add-in trong Excel<\/a><\/strong> sau nh\u00e9!<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/06\/remove-style-addin.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-19740\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/remove-style-addin.jpg\" width=\"1350\" height=\"527\" title=\"remove-style-addin\"><\/a><\/p>\n<p>\u2013 Ngo\u00e0i ra v\u1eabn c\u00f3 1 addin\u00a0<a href=\"https:\/\/support.office.com\/en-us\/article\/clean-excess-cell-formatting-on-a-worksheet-e744c248-6925-4e77-9d49-4874f7474738\">Inquire<\/a>\u00a0c\u00f3 s\u1eb5n trong Office 365, v\u1edbi c\u00f4ng c\u1ee5:\u00a0<b class=\"ocpUI\">Clean Excess Cell Formatting<\/b>.<\/p>\n<p>[divider]<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Excel_Binary_Workbook_giup_giam_dung_luong\"><\/span><strong>Excel Binary Workbook<\/strong> gi\u00fap gi\u1ea3m dung l\u01b0\u1ee3ng<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Sau c\u00e1c b\u01b0\u1edbc tr\u00ean, b\u1ea1n s\u1ebd c\u00f3 k\u1ebft qu\u1ea3 nh\u01b0 sau:<a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/06\/Binary-Workbook.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-19742\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/binary-workbook.jpg\" width=\"874\" height=\"106\" title=\"binary-workbook\"><\/a><\/p>\n<p>Nh\u01b0 b\u1ea1n th\u1ea5y, ch\u00fang ta c\u00f3 file ban \u0111\u1ea7u l\u00e0 7Mb, sau khi c\u00e1c thao t\u00e1c tr\u00ean, ch\u00fang ta gi\u1ea3m dung l\u01b0\u1ee3ng xu\u1ed1ng c\u00f2n 1Mb, v\u1eady mu\u1ed1n gi\u1ea3m n\u1eefa th\u00ec l\u00e0m th\u1ebf n\u00e0o? B\u1ea1n ch\u1ecdn <strong>File &gt; Save as\u2026<\/strong> Ch\u1ecdn L\u01b0u d\u01b0\u1edbi d\u1ea1ng <strong>Microsoft Excel Binary Workbook<\/strong>, khi \u0111\u00f3 b\u1ea1n s\u1ebd\u00a0th\u1ea5y file ti\u1ebfp t\u1ee5c gi\u1ea3m \u0111i m\u1ed9t n\u1eeda ch\u1ec9 c\u00f2n 500Kb.<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/06\/SAVE-AS-BINARY.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-19747\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/save-as-binary.jpg\" width=\"999\" height=\"563\" title=\"save-as-binary\"><\/a><\/p>\n<p>[divider]<\/p>\n<p>Cu\u1ed1i c\u00f9ng, b\u1ea1n c\u00f3 th\u1ec3\u00a0th\u1ef1c hi\u1ec7n c\u00e1c thao t\u00e1c sau, nh\u1eb1m gi\u00fap gi\u1ea3m th\u00eam dung l\u01b0\u1ee3ng c\u1ee7a file: X\u00f3a \u0111i c\u00e1c Worksheet tr\u1ed1ng, X\u00f3a \u0111i nh\u1eefng d\u00f2ng tr\u1ed1ng \u1edf cu\u1ed1i, v\u00e0 <strong>Reset Last Cell<\/strong> trong Excel v\u1edbi c\u00f4ng c\u1ee5 c\u1ee7a <strong>ASAP Utilities<\/strong>.<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/06\/reset-excel-last-cell.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-19754\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/reset-excel-last-cell.jpg\" width=\"1037\" height=\"697\" title=\"reset-excel-last-cell\"><\/a><\/p>\n<p><strong>L\u1eddi K\u1ebft:<\/strong><\/p>\n<p>Nh\u01b0 b\u1ea1n th\u1ea5y r\u1ed3i \u0111\u00f3, c\u00e1c thao t\u00e1c b\u00ecnh th\u01b0\u1eddng <strong>COPY &amp; PASTE<\/strong> c\u0169ng g\u00e2y ra nhi\u1ec1u tai h\u1ea1i, v\u1eady l\u00e0m sao h\u1ea1n ch\u1ebf vi\u1ec7c n\u00e0y? Khi ch\u00fang ta COPY, v\u00e0 thay v\u00ec nh\u1ea5n Ctrl + V \u0111\u1ec3 Paste ra, th\u00ec ch\u00fang ta c\u00f3 l\u1ef1a ch\u1ecdn <strong>PASTE SPECIAL \u2026<\/strong> khi \u0111\u00f3 b\u1ea1n c\u00f3 th\u1ec3 l\u1ef1a ch\u1ecdn <strong>PASTE VALUE<\/strong>, thay v\u00ec d\u00e1n lu\u00f4n c\u00f4ng th\u1ee9c sang.<\/p>\n<p>N\u1ebfu t\u1ea5t c\u1ea3 c\u00e1c tr\u01b0\u1eddng h\u1ee3p tr\u00ean, b\u1ea1n \u0111\u1ec1u kh\u00f4ng m\u1eafc ph\u1ea3i, nh\u01b0ng file v\u1eabn n\u1eb7ng, v\u1eady s\u1ebd l\u00e0m c\u00e1ch n\u00e0o? Do n\u1ed9i dung b\u00e0i vi\u1ebft d\u00e0i, n\u00ean m\u00ecnh s\u1ebd chia ri\u00eang ph\u1ea7n \u0111\u00f3 sang t\u1eadp 2 c\u1ee7a b\u00ed k\u00edp v\u00f5 c\u00f4ng n\u00e0y \u2026 C\u1ea3m \u01a1n c\u00e1c b\u1ea1n \u0111\u00e3 quan t\u00e2m!<\/p>\n<p>Hi\u1ec7n t\u1ea1i,\u00a0Blog Ho\u0323c Excel Online \u0111a\u0303 m\u01a1\u0309 r\u00e2\u0301t nhi\u00ea\u0300u ca\u0301c kho\u0301a ho\u0323c \u0111a\u0300o ta\u0323o v\u00ea\u0300\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc-excel-co-ban\">H\u1ecdc Excel c\u01a1 b\u1ea3n \u0111\u1ebfn n\u00e2ng cao<\/a>\u00a0v\u01a1\u0301i ca\u0301c chuy\u00ean gia ha\u0300ng \u0111\u00e2\u0300u ta\u0323i Vi\u00ea\u0323t Nam. Ch\u00fang t\u00f4i se\u0303 mang \u0111\u00ea\u0301n cho ba\u0323n nh\u01b0\u0303ng bu\u00f4\u0309i ho\u0323c b\u00f4\u0309 i\u0301ch, hi\u1ec7u qua\u0309 co\u0301 th\u00ea\u0309 s\u01b0\u0309 du\u0323ng tha\u0300nh tha\u0323o Excel \u0111\u00ea\u0309 a\u0301p du\u0323ng trong c\u00f4ng vi\u00ea\u0323c. Ngoa\u0300i ra, chu\u0301ng t\u00f4i \u0111ang co\u0301 nhi\u00ea\u0300u ch\u01b0\u01a1ng tri\u0300nh khuy\u00ea\u0301n ma\u0323i l\u01a1\u0301n cho ca\u0301c ho\u0323c vi\u00ean \u0111\u0103ng ki\u0301 trong tha\u0301ng na\u0300y, v\u00e2\u0323y co\u0300n tr\u1ea7n tr\u01b0\u0300 gi\u0300 n\u01b0\u0303a ma\u0300 kh\u00f4ng \u0111\u0103ng ki\u0301 ngay th\u00f4i.<\/p>\n<p>\u0110\u1ecdc ti\u1ebfp t\u1eadp 2: <strong><a href=\"http:\/\/blog.ezworkapp.com\/cach-sua-file-excel-bi-nang-cham-va-go-bo-mat-khau-bao-ve.html\" target=\"_blank\" rel=\"noopener noreferrer\">C\u00e1ch s\u1eeda file Excel b\u1ecb n\u1eb7ng ch\u1eadm &amp; g\u1ee1 b\u1ecf m\u1eadt kh\u1ea9u b\u1ea3o v\u1ec7 khi qu\u00ean m\u1eadt kh\u1ea9u<\/a><\/strong>.<\/p>\n<p style=\"text-align: justify\">\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-380.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":4681,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-4680","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-nang-cao"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/4680","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=4680"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/4680\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/4681"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=4680"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=4680"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=4680"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}