{"id":10283,"date":"2025-01-12T12:00:47","date_gmt":"2025-01-12T12:00:47","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/12\/su-dung-paste-special-trong-bai-thi-mos-excel-hieu-qua-nhat\/"},"modified":"2025-01-12T12:00:47","modified_gmt":"2025-01-12T12:00:47","slug":"su-dung-paste-special-trong-bai-thi-mos-excel-hieu-qua-nhat","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/12\/su-dung-paste-special-trong-bai-thi-mos-excel-hieu-qua-nhat\/","title":{"rendered":"S\u1eed d\u1ee5ng Paste Special trong b\u00e0i thi MOS Excel hi\u1ec7u qu\u1ea3 nh\u1ea5t"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>T\u00ednh n\u0103ng Cut, Copy v\u00e0 Paste \u0111\u00e3 qu\u00e1 quen thu\u1ed9c v\u1edbi m\u1ecdi ng\u01b0\u1eddi d\u00f9ng Excel v\u00e0 \u0111ang \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng r\u1ed9ng r\u00e3i. Tuy nhi\u00ean c\u00f2n m\u1ed9t ch\u1ee9c n\u0103ng li\u00ean quan v\u00f4 c\u00f9ng \u201cquy\u1ec1n l\u1ef1c\u201d m\u00e0 kh\u00f4ng ph\u1ea3i ai c\u0169ng bi\u1ebft. Ch\u1ee9c n\u0103ng \u0111\u00f3 l\u00e0 g\u00ec? H\u00e3y c\u00f9ng <a href=\"http:\/\/blog.ezworkapp.com\">Hocexcel.online<\/a> t\u00ecm hi\u1ec3u: S\u1eed d\u1ee5ng Paste Special m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3 nh\u1ea5t.<\/p>\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-6783aeee9c848\" 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\/su-dung-paste-special-trong-bai-thi-mos-excel-hieu-qua-nhat.html#Su_dung_Paste_Special_hieu_qua\" title=\"S\u1eed d\u1ee5ng Paste Special hi\u1ec7u qu\u1ea3\">S\u1eed d\u1ee5ng Paste Special hi\u1ec7u qu\u1ea3<\/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\/su-dung-paste-special-trong-bai-thi-mos-excel-hieu-qua-nhat.html#Them_va_xoa_du_lieu\" title=\"Th\u00eam v\u00e0 x\u00f3a d\u1eef li\u1ec7u\">Th\u00eam v\u00e0 x\u00f3a d\u1eef li\u1ec7u<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Su_dung_Paste_Special_hieu_qua\"><\/span>S\u1eed d\u1ee5ng Paste Special hi\u1ec7u qu\u1ea3<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><em>\u0110\u1ec3 \u0111\u1ea3o chi\u1ec1u c\u1ed9t v\u00e0 h\u00e0ng<\/em><\/p>\n<ol>\n<li>Ch\u1ecdn c\u1ed9t ho\u1eb7c h\u00e0ng (ho\u1eb7c m\u1ea3ng d\u1eef li\u1ec7u) mu\u1ed1n \u0111\u1ea3o.<\/li>\n<li>T\u1ea1i th\u1ebb<strong> Home,<\/strong> trong nh\u00f3m <strong>Clipboard<\/strong>, ch\u1ecdn <strong>Copy <\/strong>(ho\u1eb7c s\u1eed d\u1ee5ng t\u1ed5 h\u1ee3p ph\u00edm Ctrl+C).<\/li>\n<li>Ch\u1ecdn \u00f4 mu\u1ed1n \u0111\u1eb7t d\u1eef li\u1ec7u \u0111\u1ea7u ti\u00ean.<\/li>\n<li>T\u1ea1i th\u1ebb <strong>Home,<\/strong> trong nh\u00f3m <strong>Clipboard<\/strong>, t\u1ea1i danh s\u00e1ch drop-down c\u1ee7a <strong>Paste<\/strong>, click v\u00e0o n\u00fat <strong>Transpose <\/strong>trong ph\u1ea7n<\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-20195 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/mos-excel-2010-paste-transpose.png\" alt=\"paste transpose\" width=\"921\" height=\"231\" title=\"mos-excel-2010-paste-transpose\"><\/p>\n<p><em>\u0110\u1ec3 paste gi\u00e1 tr\u1ecb c\u1ee7a c\u00f4ng th\u1ee9c t\u1eeb m\u1ed9t v\u00f9ng sang v\u00f9ng kh\u00e1c<\/em><\/p>\n<ol>\n<li>Ch\u1ecdn v\u00e0 copy v\u00f9ng ch\u1ee9a c\u00f4ng th\u1ee9c.<\/li>\n<li>Ch\u1ecdn \u00f4 mu\u1ed1n \u0111\u1eb7t gi\u00e1 tr\u1ecb \u0111\u1ea7u ti\u00ean khi d\u00e1n.<\/li>\n<li>T\u1ea1i th\u1ebb <strong>Home,<\/strong> trong nh\u00f3m <strong>Clipboard,<\/strong> t\u1ea1i danh s\u00e1ch drop-down c\u1ee7a <strong>Paste<\/strong>, click v\u00e0o n\u00fat <strong>Values<\/strong> trong ph\u1ea7n <strong>Paste Values.<\/strong><\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-20196 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/mos-excel-2010-paste-value.png\" alt=\"paste value\" width=\"412\" height=\"339\" title=\"mos-excel-2010-paste-value\"><\/p>\n<p><em>\u0110\u1ec3 c\u1ed9ng, tr\u1eeb, nh\u00e2n ho\u1eb7c chia cho v\u00f9ng d\u1eef li\u1ec7u<\/em><\/p>\n<ol>\n<li>Ch\u1ecdn v\u00e0 copy v\u00f9ng d\u1eef li\u1ec7u th\u1ee9 nh\u1ea5t (bao g\u1ed3m c\u00e1c s\u1ed1 s\u1eed d\u1ee5ng \u0111\u1ec3 thao t\u00e1c v\u1edbi v\u00f9ng d\u1eef li\u1ec7u th\u1ee9 hai).<\/li>\n<li>Ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u th\u1ee9 hai.<\/li>\n<li>T\u1ea1i th\u1ebb <strong>Home,<\/strong> trong nh\u00f3m <strong>Clipboard,<\/strong> t\u1ea1i danh s\u00e1ch <strong>Paste <\/strong>ch\u1ecdn <strong>Paste Special.<\/strong><\/li>\n<li>Trong h\u1ed9p tho\u1ea1i <strong>Paste Special<\/strong>, t\u1ea1i v\u00f9ng <strong>Operation<\/strong>, ch\u1ecdn <strong>Add (c\u1ed9ng),<\/strong> <strong>Subtract (tr\u1eeb), Multiply (nh\u00e2n), Divide (chia)<\/strong>, sau \u0111\u00f3 \u1ea5n OK.<\/li>\n<\/ol>\n<blockquote>\n<p><strong>Xem th\u00eam:<\/strong> <a href=\"http:\/\/blog.ezworkapp.com\/cong-tru-nhan-chia-vung-voi-cung-1-paste-special.html\">C\u1ed9ng tr\u1eeb nh\u00e2n chia v\u00f9ng d\u1eef li\u1ec7u v\u1edbi c\u00f9ng m\u1ed9t s\u1ed1 b\u1eb1ng Paste Special<\/a><\/p>\n<\/blockquote>\n<h3><span class=\"ez-toc-section\" id=\"Them_va_xoa_du_lieu\"><\/span>Th\u00eam v\u00e0 x\u00f3a d\u1eef li\u1ec7u<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Th\u00eam v\u00e0 b\u1edbt c\u00e1c d\u00f2ng\/c\u1ed9t l\u00e0 c\u00f4ng vi\u1ec7c t\u1ea5t y\u1ebfu trong vi\u1ec7c ph\u00e1t tri\u1ec3n m\u1ed9t trang t\u00ednh. T\u1ea1i Excel 2010, nhi\u1ec1u l\u1ef1a ch\u1ecdn h\u01a1n \u0111\u01b0\u1ee3c \u0111\u01b0a ra gi\u00fap ng\u01b0\u1eddi s\u1eed d\u1ee5ng c\u00f3 th\u1ec3 thao t\u00e1c d\u1ec5 d\u00e0ng. C\u1ee5 th\u1ec3:<\/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\/2025\/01\/ex101_92019-nho-151.gif\" title=\"ex101_92019-nho-151\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><em>\u0110\u1ec3 th\u00eam h\u00e0ng ho\u1eb7c c\u1ed9t<\/em><\/p>\n<ol>\n<li>Ch\u1ecdn s\u1ed1 l\u01b0\u1ee3ng d\u00f2ng ho\u1eb7c c\u1ed9t mu\u1ed1n th\u00eam v\u00e0o b\u1eb1ng c\u00e1ch k\u00e9o th\u1ea3 chu\u1ed9t, b\u1eaft \u0111\u1ea7u b\u1eb1ng d\u00f2ng ho\u1eb7c c\u1ed9t ph\u00eda tr\u00ean n\u01a1i b\u1ea1n mu\u1ed1n xu\u1ea5t hi\u1ec7n.<\/li>\n<li>T\u1ea1i th\u1ebb <strong>Home<\/strong>, trong nh\u00f3m <strong>Cells<\/strong>, ch\u1ecdn danh s\u00e1ch drop-down <strong>Insert<\/strong>, ch\u1ecdn <strong>Insert Sheet Rows<\/strong> \u0111\u1ed1i v\u1edbi d\u00f2ng v\u00e0 <strong>Insert Sheet Column<\/strong> \u0111\u1ed1i v\u1edbi c\u1ed9t.<\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-20193 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/mos-excel-2010-insert.png\" width=\"220\" height=\"204\" title=\"mos-excel-2010-insert\"><\/p>\n<p><em>\u0110\u1ec3 th\u00eam \u00f4<\/em><\/p>\n<ol>\n<li>Ch\u1ecdn s\u1ed1 l\u01b0\u1ee3ng \u00f4 mu\u1ed1n th\u00eam v\u00e0o.<\/li>\n<li>T\u1ea1i th\u1ebb <strong>Home, <\/strong>trong nh\u00f3m <strong>Cells<\/strong>, click v\u00e0o n\u00fat <strong>Insert (<\/strong>m\u1eb7c \u0111\u1ecbnh s\u1ebd \u0111\u1ea9y nh\u1eefng \u00f4 c\u00f3 tr\u01b0\u1edbc sang b\u00ean <strong>ph\u1ea3i). <\/strong>\u0110\u1ec3 thay \u0111\u1ed5i v\u1ecb tr\u00ed<strong>, <\/strong>ch\u1ecdn danh s\u00e1ch drop-down <strong>Insert<\/strong>, ch\u1ecdn <strong>Insert Cells\u2026<\/strong> v\u00e0 ch\u1ecdn <strong>Shift cell down.<\/strong><\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-20194 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/mos-excel-2010-insert-cell.png\" width=\"188\" height=\"186\" title=\"mos-excel-2010-insert-cell\"><\/p>\n<p><em>\u0110\u1ec3 x\u00f3a h\u00e0ng\/c\u1ed9t\/\u00f4<\/em><\/p>\n<p>T\u1ea1i th\u1ebb <strong>Home,<\/strong> trong nh\u00f3m <strong>Cells<\/strong>, ch\u1ecdn <strong>Delete.<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-20192 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/mos-excel-2010-delete.png\" width=\"245\" height=\"186\" title=\"mos-excel-2010-delete\"><\/p>\n<p><strong>Ho\u1eb7c b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng danh s\u00e1ch drop-down Delete (h\u00ecnh tr\u00ean) \u0111\u1ec3 x\u00f3a c\u00e1c c\u1ed9t, c\u00e1c d\u00f2ng m\u1ed9t c\u00e1ch chi ti\u1ebft h\u01a1n.<\/strong><\/p>\n<p>Ch\u00fac c\u00e1c b\u1ea1n h\u1ecdc t\u1ed1t c\u00f9ng Hocexcel.online. V\u00e0 \u0111\u1eebng qu\u00ean theo d\u00f5i b\u00e0i vi\u1ebft ti\u1ebfp theo trong series b\u00e0i h\u1ecdc Excel MOS 2010: S\u1eed d\u1ee5ng v\u00e0 thi\u1ebft l\u1eadp Autofill hi\u1ec7u qu\u1ea3.<\/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\/2025\/01\/ex101_92019-nho-151.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":10284,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-10283","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\/10283","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=10283"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/10283\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/10284"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=10283"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=10283"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=10283"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}