{"id":12321,"date":"2025-01-15T08:05:44","date_gmt":"2025-01-15T08:05:44","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/cac-phim-tat-thuong-dung-trong-excel-ap-dung-cho-2007-2010-2013-2016\/"},"modified":"2025-01-15T08:05:44","modified_gmt":"2025-01-15T08:05:44","slug":"cac-phim-tat-thuong-dung-trong-excel-ap-dung-cho-2007-2010-2013-2016","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/cac-phim-tat-thuong-dung-trong-excel-ap-dung-cho-2007-2010-2013-2016\/","title":{"rendered":"C\u00e1c ph\u00edm t\u1eaft th\u01b0\u1eddng d\u00f9ng trong Excel, \u00e1p d\u1ee5ng cho 2007, 2010, 2013, 2016"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n search Google t\u1eeb kh\u00f3a: \u2018Ph\u00edm t\u1eaft trong Excel\u2019 th\u00ec k\u1ebft qu\u1ea3 l\u1ea1i l\u1ea1i s\u1ebd l\u00e0 m\u1ed9t t\u00e1 c\u00e1c b\u00e0i vi\u1ebft n\u00e0o l\u00e0 <strong>99 ph\u00edm t\u1eaft th\u01b0\u1eddng d\u00f9ng<\/strong>, n\u00e0o l\u00e0 <strong>108 ph\u00edm t\u1eaft h\u1eefu \u00edch<\/strong> .v.v. v\u00e0 \u0111\u1ee7 ki\u1ec3u c\u00e1c b\u00e0i vi\u1ebft chia s\u1ebb ph\u00edm t\u1eaft kh\u00e1c. Tuy nhi\u00ean, B\u00e1ch c\u00e1 v\u1edbi c\u00e1c b\u1ea1n r\u1eb1ng trong 10 n\u0103m l\u00e0m vi\u1ec7c li\u00ean t\u1ee5c v\u1edbi Excel, b\u1ea1n s\u1ebd kh\u00f4ng x\u1eed d\u1ee5ng t\u1edbi 20 ph\u00edm t\u1eaft th\u01b0\u1eddng xuy\u00ean \u0111\u00e2u, m\u00e0 b\u1ea1n c\u0169ng kh\u00f4ng th\u1ec3 nh\u1edb n\u1ed5i qu\u00e1 20 ph\u00edm t\u1eaft, th\u1ebf n\u00ean b\u1ea1n kh\u00f4ng c\u1ea7n ph\u1ea3i \u0111\u1ecdc h\u1ebft v\u00e0 c\u0169ng kh\u00f4ng c\u1ea7n ph\u1ea3i nh\u1edb h\u1ebft l\u00e0m g\u00ec cho Full b\u1ed9 nh\u1edb c\u1ee7a b\u1ea1n, b\u1ea1n ch\u1ec9 c\u1ea7n nh\u1edb 20% ph\u00edm t\u1eaft d\u01b0\u1edbi \u0111\u00e2y l\u00e0 \u0111\u00e3 \u0111\u00e1p \u1ee9ng 90% nhu c\u1ea7u c\u00f4ng vi\u1ec7c h\u00e0ng ng\u00e0y c\u1ee7a b\u1ea1n r\u1ed3i. B\u00e1ch s\u1ebd s\u1eafp x\u1ebfp t\u1eeb d\u00f9ng ph\u1ed5 bi\u1ebfn d\u1ec5 nh\u1edb t\u1edbi kh\u00f3 nh\u1edb h\u01a1n x\u00edu nh\u00e9.<\/p>\n<p style=\"text-align: justify\"><strong>1. C\u00e1c ph\u00edm t\u1eaft s\u1eed d\u1ee5ng k\u1ebft h\u1ee3p gi\u1eefa Ctrl (Command trong Mac Os) v\u00e0 m\u1ed9t ph\u00edm b\u1ea5t k\u1ef3 kh\u00e1c<\/strong>.<\/p>\n<ul style=\"text-align: justify\">\n<li><strong>Ctrl + A:<\/strong> \u0110\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 b\u00f4i \u0111en (Ch\u1ecdn t\u1ea5t c\u1ea3 n\u1ed9i dung trong b\u1ea3ng t\u00ednh).<\/li>\n<li><strong>Ctrl + C:<\/strong> Qu\u00e1 quen \u0111\u00fang kh\u00f4ng, \u0111\u00e2y ch\u00ednh l\u00e0 ph\u00edm Copy \u0111\u1ec3 sao ch\u00e9p n\u1ed9i dung b\u1ea1n c\u1ea7n sao ch\u00e9p.<\/li>\n<li><strong>Ctrl + V:<\/strong> B\u1ea1n \u0111\u00e3 Copy th\u00ec ch\u1eafc ch\u1eafn ph\u1ea3i Paste, th\u00ec \u0111\u00e2y ch\u00ednh l\u00e0 Paste n\u1ed9i dung.<\/li>\n<li><strong>Ctrl + Z:<\/strong> Trong tr\u01b0\u1eddng h\u1ee3p b\u1ea1n l\u1ee1 tay x\u00f3a hay l\u00e0m g\u00ec \u0111\u00f3 b\u1ecb sai nh\u01b0ng kh\u00f4ng nh\u1edb \u0111\u1ec3 s\u1eeda l\u1ea1i, b\u1ea1n c\u00f3 th\u1ec3 d\u1ee5ng d\u1ee5ng Ctrl + Z \u0111\u1ec3 Undo (Quay l\u1ea1i) b\u01b0\u1edbc tr\u01b0\u1edbc \u0111\u00f3.<\/li>\n<li><strong>Ctrl + Y:<\/strong> B\u1ea1n v\u1eeba Undo v\u00e0 mu\u1ed1n Redo, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng t\u1ed5 h\u1ee3p ph\u00edm n\u00e0y.<\/li>\n<li><strong>Ctrl + S:<\/strong> B\u00e1ch c\u00f3 m\u1ed9t th\u00f3i quen s\u1eed d\u1ee5ng Office t\u1eeb x\u01b0a l\u00e0 c\u1ee9 1 ph\u00fat B\u00e1ch \u1ea5n Ctrl + S m\u1ed9t l\u1ea7n \u0111\u1ec3 Save l\u1ea1i n\u1ed9i dung v\u1eeba bi\u00ean so\u1ea1n, m\u1ee5c \u0111\u00edch l\u00e0 tr\u00e1nh b\u1ecb m\u1ea5t \u0111i\u1ec7n l\u00e0m m\u1ea5t n\u1ed9i dung ch\u01b0a k\u1ecbp Save, t\u1ed5 h\u01a1p ph\u00edm n\u00e0y r\u1ea5t h\u1eefu \u00edch cho nh\u1eefng b\u1ea1n n\u00e0o m\u00e1y hay b\u1ecb s\u1ee5t ngu\u1ed3n \u0111\u1ed9t ng\u1ed9t nha.<\/li>\n<li><strong>Ctrl + O<\/strong>: Ch\u1eef O \u1edf \u0111\u00e2y B\u00e1ch ngh\u0129 ch\u00ednh l\u00e0 Open, c\u00f3 ngh\u0129a l\u00e0 m\u1edf m\u1ed9t b\u1ea3ng t\u00ednh m\u1edbi.<\/li>\n<li><strong>Ctrl + X:<\/strong>\u00a0Nh\u00ecn ch\u1eef X B\u00e1ch h\u00ecnh dung ra \u0111\u00e2y l\u00e0 d\u1ea5u hi\u1ec7u x\u00f3a d\u1eef li\u1ec7u, nh\u01b0ng trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y th\u00ec \u0111\u00e2u l\u00e0 t\u1ed5 h\u1ee3p ph\u00edm Cut gi\u00fap b\u1ea1n v\u1eeba X\u00f3a, v\u1eeba Copy n\u1ed9i dung v\u1eeba X\u00f3a.<\/li>\n<li><strong>Ctrl + F<\/strong>: Ch\u1eef F ch\u1eafc l\u00e0 ch\u1eef Find (T\u00ecm ki\u1ebfm), \u0111\u00e2y l\u00e0 T\u1ed5 h\u1ee3p ph\u00edm gi\u00fap b\u1ea1n m\u1edf Box t\u00ecm ki\u1ebfm m\u1ed9t n\u1ed9i dung n\u00e0o \u0111\u00f3 trong Sheet l\u00e0m vi\u1ec7c c\u1ee7a Excel, T\u1ed5 h\u1ee3p ph\u00edm n\u00e0y kh\u00e1 h\u1eefu d\u1ee5ng \u0111\u1ec3 b\u1ea1n t\u00ecm nhanh m\u1ed9t d\u1eef li\u1ec7u n\u00e0o \u0111\u00f3 trong b\u1ea3ng t\u00ednh m\u00e0 kh\u00f4ng c\u1ea7n m\u00f2 t\u1eebng d\u00f2ng t\u1eebng c\u1ed9t. B\u00e1ch th\u00ec hay d\u00f9ng ph\u00edm n\u00e0y \u0111\u1ec3 search t\u00ean B\u00e1ch trong b\u1ea3ng l\u01b0\u01a1ng v\u1edbi danh s\u00e1ch 3,000 ng\u01b0\u1eddi c\u1ee7a c\u00f4ng ty.<\/li>\n<li><strong>Ctrl + 9:<\/strong> S\u1eed d\u1ee5ng \u0111\u1ec3 \u1ea9n h\u00e0ng b\u1ea1n mu\u1ed1n ch\u1ecdn, c\u00f2n mu\u1ed1n \u1ea9n c\u1ed9t th\u00ec ch\u1ecdn<\/li>\n<li><strong>Ctrl + 0<\/strong> (s\u1ed1 O): \u1ea8n c\u1ed9t \u0111\u00e3 ch\u1ecdn, v\u1eady mu\u1ed1n hi\u1ec3n th\u1ecb h\u00e0ng v\u00e0 c\u1ed9t \u0111\u00e3 \u1ea9n th\u00ec l\u00e0m nh\u01b0 th\u1ebf n\u00e0o?<\/li>\n<li><strong>Ctrl + Shift + 9<\/strong>: Hi\u1ec3n th\u1ecb h\u00e0ng \u0111\u00e3 \u1ea9n trong v\u00f9ng \u0111\u00e3 ch\u1ecdn.<\/li>\n<li><strong>Ctrl + Shift + 0<\/strong>: Hi\u1ec3n th\u1ecb c\u1ed9t \u0111\u00e3 \u1ea9n trong v\u00f9ng b\u1ea1n ch\u1ecdn.<\/li>\n<li><strong>Ctrl + 1:<\/strong> L\u00e0 g\u1ecdi nhanh\u00a0h\u1ed9p tho\u1ea1i Format.<\/li>\n<li><strong>Ctrl + Space<\/strong> (Ph\u00edm c\u00e1ch \u0111\u00f3 b\u1ea1n): L\u00e0 \u0111\u1ec3 ch\u1ecdn nhanh\u00a0d\u1eef li\u1ec7u trong c\u1ed9t.<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><strong>2. Ph\u00edm t\u1eaft k\u1ebft h\u1ee3p gi\u1eefa Shift, Alt v\u00e0 c\u00e1c ph\u00edm kh\u00e1c<\/strong>.<\/p>\n<ul style=\"text-align: justify\">\n<li><strong>Shift + Space:<\/strong> Ch\u1ecdn to\u00e0n b\u1ed9 d\u1eef li\u1ec7u trong h\u00e0ng<\/li>\n<li><strong>Alt + Enter:<\/strong> Xu\u1ed1ng d\u00f2ng trong \u00f4, \u0111\u00e2y l\u00e0 t\u00ednh n\u0103ng m\u00ecnh th\u01b0\u1eddng xuy\u00ean x\u1eed d\u1ee5ng khi l\u00e0m quy tr\u00ecnh tr\u00ean excel<\/li>\n<li><strong>Alt + F1:<\/strong> Ch\u00e8n \u0111i\u1ec3u \u0111\u1ed3 cho d\u1eef li\u1ec7u \u0111\u00e3 ch\u1ecdn<\/li>\n<li><strong>Shift + Home:<\/strong> M\u1edf r\u1ed9ng v\u00f9ng \u0111\u01b0\u1ee3c ch\u1ecdn v\u1ec1 ph\u00eda \u00f4 \u0111\u1ea7u ti\u00ean c\u1ee7a h\u00e0ng<\/li>\n<li><strong>Shift + F3:<\/strong> Ch\u00e8n m\u1ed9t h\u00e0m th\u00e0nh m\u1ed9t c\u00f4ng\u00a0th\u1ee9c.<\/li>\n<\/ul>\n<p style=\"text-align: justify\">V\u1edbi Ctrl, Shift v\u00e0 Alt m\u00ecnh ngh\u0129 nh\u01b0 th\u1ebf l\u00e0 \u0111\u1ee7 r\u1ed3i v\u00ec nhi\u1ec1u qu\u00e1 v\u00e0 ph\u1ee9c t\u1ea1p qu\u00e1 b\u1ea1n ch\u01b0a ch\u1eafc \u0111\u00e3 nh\u1edb h\u1ebft \u0111\u01b0\u1ee3c, b\u1ea3n th\u00e2n m\u00ecnh c\u0169ng ph\u1ea3i nhi\u1ec1u n\u0103m l\u00e0m vi\u1ec7c v\u1edbi Excel m\u1edbi th\u1ef1c s\u1ef1 nh\u1edb \u0111\u01b0\u1ee3c c\u00e1c t\u1ed5 h\u1ee3p ph\u00edm t\u1eaft tr\u00ean, n\u00ean m\u00ecnh c\u00f3 chia s\u1ebb th\u00eam n\u1eefa th\u00ec ch\u01b0a ch\u1eafc c\u00e1c b\u1ea1n \u0111\u00e3 nh\u1edb \u0111\u01b0\u1ee3c. Trong b\u00e0i ti\u1ebfp theo m\u00ecnh s\u1ebd chia s\u1ebb m\u1ed9t s\u1ed1 th\u1ee7 thu\u1eadt t\u00ednh nhanh trong Excel m\u00e0 kh\u00f4ng c\u1ea7n c\u00f4ng th\u1ee9c \u0111\u1ec3 c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng l\u00e0m nh\u00e1p trong qu\u00e1 tr\u00ecnh h\u1ecdp ho\u1eb7c trao \u0111\u1ed5i v\u1edbi ng\u01b0\u1eddi kh\u00e1c.<\/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":"<p>N\u1ebfu b\u1ea1n search Google t\u1eeb kh\u00f3a: \u2018Ph\u00edm t\u1eaft trong Excel\u2019 th\u00ec k\u1ebft qu\u1ea3 l\u1ea1i l\u1ea1i..<\/p>\n","protected":false},"author":1,"featured_media":12322,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-12321","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\/12321","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=12321"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/12321\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/12322"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=12321"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=12321"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=12321"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}