{"id":5486,"date":"2024-12-16T02:48:46","date_gmt":"2024-12-16T02:48:46","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/16\/huong-dan-cach-su-dung-phim-tat-de-thuc-hien-viec-xoa-du-lieu-trung-lap-trong-excel\/"},"modified":"2024-12-16T02:48:46","modified_gmt":"2024-12-16T02:48:46","slug":"huong-dan-cach-su-dung-phim-tat-de-thuc-hien-viec-xoa-du-lieu-trung-lap-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/16\/huong-dan-cach-su-dung-phim-tat-de-thuc-hien-viec-xoa-du-lieu-trung-lap-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng ph\u00edm t\u1eaft \u0111\u1ec3 th\u1ef1c hi\u1ec7n vi\u1ec7c x\u00f3a d\u1eef li\u1ec7u tr\u00f9ng l\u1eb7p trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>X\u00f3a d\u1eef li\u1ec7u tr\u00f9ng l\u1eb7p l\u00e0 m\u1ed9t trong nh\u1eefng y\u00eau c\u1ea7u th\u01b0\u1eddng g\u1eb7p khi l\u00e0m vi\u1ec7c tr\u00ean\u00a0Excel. \u0110\u1ec3 thao t\u00e1c n\u00e0y\u00a0\u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n nhanh h\u01a1n, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng ph\u00edm t\u1eaft\u00a0\u0111\u1ec3 g\u1ecdi ch\u1ee9c n\u0103ng n\u00e0y. V\u1eady ph\u00edm t\u1eaft l\u00e0 ph\u00edm n\u00e0o? Thao t\u00e1c c\u1ee5 th\u1ec3 ra sao? Ch\u00fang ta h\u00e3y c\u00f9ng t\u00ecm hi\u1ec3u qua b\u00e0i vi\u1ebft <strong><a href=\"http:\/\/blog.ezworkapp.com\/nhung-phim-tat-excel-thanh-cua-dan-ke-toan.html\">c\u00e1ch s\u1eed d\u1ee5ng ph\u00edm t\u1eaft<\/a> \u0111\u1ec3 th\u1ef1c hi\u1ec7n vi\u1ec7c x\u00f3a d\u1eef li\u1ec7u tr\u00f9ng l\u1eb7p trong Excel<\/strong> n\u00e0y nh\u00e9.<\/p>\n<p>C\u00e1c b\u01b0\u1edbc th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/p>\n<p><strong>B\u01b0\u1edbc 1: Ch\u1ecdn c\u1ed9t d\u1eef li\u1ec7u c\u1ea7n lo\u1ea1i b\u1ecf gi\u00e1 tr\u1ecb tr\u00f9ng<\/strong><\/p>\n<p>Ph\u00edm t\u1eaft c\u01a1 b\u1ea3n cho thao t\u00e1c n\u00e0y l\u00e0 Ctrl + Space (ph\u00edm Ctrl v\u00e0 ph\u00edm C\u00e1ch) s\u1ebd gi\u00fap b\u1ea1n ch\u1ecdn to\u00e0n b\u1ed9 c\u1ea3 c\u1ed9t d\u1eef li\u1ec7u.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-24391\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/hot-key-ctrl-space-1024x338-1.png\" width=\"800\" height=\"264\" title=\"hot-key-ctrl-space-1024x338-1\"><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24392\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ket-qua-ctrl-space.png\" width=\"451\" height=\"339\" title=\"ket-qua-ctrl-space\"><\/p>\n<p><strong>B\u01b0\u1edbc 2: D\u00f9ng ph\u00edm t\u1eaft g\u1ecdi ch\u1ee9c n\u0103ng Remove Duplicates<\/strong><\/p>\n<p>V\u00ec\u00a0Excel kh\u00f4ng c\u00f3 ph\u00edm t\u1eaft\u00a0\u0111\u1ec3 g\u1ecdi tr\u1ef1c ti\u1ebfp ch\u1ee9c n\u0103ng n\u00e0y, n\u00ean ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng ph\u01b0\u01a1ng ph\u00e1p d\u00f9ng ph\u00edm t\u1eaft th\u00f4ng qua n\u00fat Alt:<\/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-475.gif\" title=\"ex101_92019-nho-475\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<ul>\n<li>Nh\u1ea5n n\u00fat Alt tr\u00ean b\u00e0n ph\u00edm, tr\u00ean thanh c\u00f4ng c\u1ee5 c\u1ee7a\u00a0Excel s\u1ebd xu\u1ea5t hi\u1ec7n c\u00e1c k\u00fd t\u1ef1 ph\u00edm t\u01b0\u01a1ng\u00a0\u1ee9ng:<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24393\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/icon-phim-alt-2.png\" width=\"70\" height=\"58\" title=\"icon-phim-alt-2\"><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-24394\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/phim-alt-goi-phim-tat-thanh-cong-cu-1024x196-3.png\" width=\"800\" height=\"153\" title=\"phim-alt-goi-phim-tat-thanh-cong-cu-1024x196-3\"><\/p>\n<ul>\n<li>C\u00f4ng c\u1ee5 lo\u1ea1i b\u1ecf gi\u00e1 tr\u1ecb tr\u00f9ng l\u00e0 Remove Duplicates, n\u1eb1m trong th\u1ebb Data. Do\u00a0\u0111\u00f3 ch\u00fang ta nh\u1ea5n ti\u1ebfp <strong>ph\u00edm A<\/strong>\u00a0\u0111\u1ec3 v\u00e0o th\u1ebb Data<\/li>\n<li>Trong th\u1ebb Data, nh\u1ea5n ti\u1ebfp <strong>ph\u00edm M<\/strong>\u00a0\u0111\u1ec3 g\u1ecdi c\u00f4ng c\u1ee5 n\u00e0y<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-24395\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/data-remove-duplicates-hotkey-1024x136-1.png\" width=\"800\" height=\"106\" title=\"data-remove-duplicates-hotkey-1024x136-1\"><\/p>\n<p>Nh\u01b0 v\u1eady, v\u1edbi t\u1ed5 h\u1ee3p <strong>ph\u00edm Alt + A + M<\/strong>, ch\u00fang ta\u00a0\u0111\u00e3 c\u00f3 th\u1ec3 g\u1ecdi ra c\u00f4ng c\u1ee5 Remove Duplicates<\/p>\n<p><strong>B\u01b0\u1edbc 3: Ho\u00e0n t\u1ea5t thao t\u00e1c lo\u1ea1i b\u1ecf gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24396\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ket-qua-remove-duplicates.png\" width=\"567\" height=\"355\" title=\"ket-qua-remove-duplicates\"><\/p>\n<p>Thao t\u00e1c n\u00e0y r\u1ea5t\u00a0\u0111\u01a1n gi\u1ea3n: ch\u1ec9 c\u1ea7n nh\u1ea5n <strong>ph\u00edm Enter<\/strong> thay v\u00ec click chu\u1ed9t v\u00e0o n\u00fat OK (t\u01b0\u01a1ng\u00a0\u0111\u01b0\u01a1ng nhau)<\/p>\n<p>T\u1ed5ng k\u1ebft l\u1ea1i: To\u00e0n b\u1ed9 ph\u00edm t\u1eaft cho thao t\u00e1c lo\u1ea1i b\u1ecf gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p l\u00e0:<\/p>\n<ul>\n<li>B1: <strong>Ctrl + Space<\/strong>\u00a0\u0111\u1ec3 ch\u1ecdn c\u1ed9t c\u00f3 gi\u00e1 tr\u1ecb tr\u00f9ng c\u1ea7n lo\u1ea1i b\u1ecf<\/li>\n<li>B2: <strong>Alt + A + M<\/strong>\u00a0\u0111\u1ec3 g\u1ecdi ch\u1ee9c n\u0103ng Remove Duplicates<\/li>\n<li>B3: <strong>Enter<\/strong>\u00a0\u0111\u1ec3 k\u1ebft th\u00fac thao t\u00e1c<\/li>\n<\/ul>\n<p>Hy v\u1ecdng r\u1eb1ng qua b\u00e0i vi\u1ebft n\u00e0y c\u00e1c b\u1ea1n s\u1ebd c\u00f3 th\u00eam nhi\u1ec1u ki\u1ebfn th\u1ee9c b\u1ed5\u00a0\u00edch\u00a0\u0111\u1ec3\u00a0\u00e1p d\u1ee5ng v\u00e0o c\u00f4ng vi\u1ec7c cho hi\u1ec7u qu\u1ea3.<\/p>\n<p>Ngo\u00e0i ra c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o th\u00eam m\u1ed9t s\u1ed1 b\u00e0i vi\u1ebft kh\u00e1c nh\u01b0:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/phim-tat\">Tra c\u1ee9u ph\u00edm t\u1eaft Excel nhanh v\u1edbi H\u1ecdc Excel Online<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-su-dung-toi-uu-cac-phim-tat-trong-excel.html\">H\u01b0\u1edbng D\u1eabn S\u1eed D\u1ee5ng T\u1ed1i \u01afu C\u00e1c Ph\u00edm T\u1eaft Trong\u00a0 Excel<\/a><\/p>\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-475.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":5487,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-5486","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/5486","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=5486"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/5486\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/5487"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=5486"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=5486"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=5486"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}