{"id":10677,"date":"2025-01-14T23:00:11","date_gmt":"2025-01-14T23:00:11","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/14\/bi-mat-cua-excel-trong-phim-ctrl\/"},"modified":"2025-01-14T23:00:11","modified_gmt":"2025-01-14T23:00:11","slug":"bi-mat-cua-excel-trong-phim-ctrl","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/14\/bi-mat-cua-excel-trong-phim-ctrl\/","title":{"rendered":"B\u00ed m\u1eadt c\u1ee7a Excel trong ph\u00edm Ctrl"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>H\u00f4m qua\u00a0trong l\u00fac d\u1ecdn d\u1eb9p nh\u00e0 kho c\u0169, v\u00f4 t\u00ecnh m\u00ecnh ph\u00e1t hi\u1ec7n\u00a0\u0111\u01b0\u1ee3c m\u1ed9t b\u00ed m\u1eadt.\u00a0\u0110\u00f3 ch\u00ednh l\u00e0 b\u00ed m\u1eadt c\u1ee7a\u00a0Excel trong ph\u00edm Ctrl.<\/p>\n<p>Ch\u00fang ta c\u00f9ng kh\u00e1m ph\u00e1 b\u00ed m\u1eadt n\u00e0y nh\u00e9:<\/p>\n<p>H\u00e3y gi\u1eef ph\u00edm Ctrl v\u00e0 sau\u00a0\u0111\u00f3:<\/p>\n<p><strong>Ctrl v\u00e0 click chu\u1ed9t<\/strong>:\u00a0C\u00f3 th\u1ec3 ch\u1ecdn\u00a0\u0111\u01b0\u1ee3c c\u00f9ng l\u00fac nh\u1eefng\u00a0\u00f4 kh\u00f4ng li\u1ec1n k\u1ec1 nhau. Gi\u1eef Ctrl v\u00e0 ti\u1ebfp t\u1ee5c click\u00a0\u0111\u1ec3 ch\u1ecdn\u00a0\u00f4. Khi\u00a0\u0111\u00f3 ch\u00fang ta c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n\u00a0\u0111\u1ecbnh d\u1ea1ng tr\u00ean nhi\u1ec1u\u00a0\u00f4 kh\u00f4ng li\u1ec1n k\u1ec1 nhau.<\/p>\n<p><strong>Ctrl + A<\/strong>: L\u1ef1a ch\u1ecdn to\u00e0n b\u1ed9 c\u00e1c\u00a0\u00f4 trong Sheet (n\u1ebfu sheet kh\u00f4ng ch\u1ee9a d\u1eef li\u1ec7u), ho\u1eb7c ch\u1ecdn to\u00e0n b\u1ed9 b\u1ea3ng t\u00ednh (n\u1ebfu ch\u00fang ta\u00a0\u0111ang ch\u1ecdn 1\u00a0\u00f4 n\u1eb1m trong b\u1ea3ng t\u00ednh\u00a0\u0111\u00f3<\/p>\n<p>V\u00ed d\u1ee5: Ch\u1ecdn\u00a0\u00f4 B3 r\u1ed3i b\u1ea5m Ctrl + A =&gt; Ch\u1ecdn to\u00e0n b\u1ed9 b\u1ea3ng t\u00ednh B2:C9<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-14070 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/heo-ctrl_01.png\" width=\"356\" height=\"262\" title=\"heo-ctrl_01\"><\/p>\n<p><strong>Ctrl + Home<\/strong>: di chuy\u1ec3n t\u1edbi\u00a0\u00f4 A1 trong Sheet\u00a0\u0111ang l\u00e0m vi\u1ec7c<\/p>\n<div class=\"code-block code-block-2\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/vba101_92019-nho-9.gif\" title=\"vba101_92019-nho-9\"><br \/>\n<\/a>\n<\/div>\n<\/div>\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-209.gif\" title=\"ex101_92019-nho-209\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><strong>Ctrl + End<\/strong>: di chuy\u1ec3n t\u1edbi\u00a0\u00f4 cu\u1ed1i c\u00f9ng trong b\u1ea3ng d\u1eef li\u1ec7u\u00a0\u0111ang l\u00e0m vi\u1ec7c (c\u1ed9t cu\u1ed1i c\u00f9ng v\u00e0 h\u00e0ng cu\u1ed1i c\u00f9ng).<\/p>\n<ul>\n<li>Trong h\u00ecnh tr\u00ean, n\u1ebfu b\u1ea5m Ctrl + End th\u00ec s\u1ebd di chuy\u1ec3n t\u1edbi v\u1ecb tr\u00ed\u00a0\u00f4 C9<\/li>\n<li>N\u1ebfu b\u1ea3ng t\u00ednh kh\u00f4ng ch\u1ee9a d\u1eef li\u1ec7u th\u00ec s\u1ebd kh\u00f4ng c\u00f3 g\u00ec x\u1ea3y ra<\/li>\n<\/ul>\n<p><strong>Ctrl + M\u0169i t\u00ean h\u01b0\u1edbng xu\u1ed1ng d\u01b0\u1edbi (Down\u00a0Arrow): X\u00e9t trong c\u00f9ng 1 c\u1ed9t<\/strong><\/p>\n<ul>\n<li>N\u1ebfu\u00a0\u0111ang trong b\u1ea3ng t\u00ednh c\u00f3 d\u1eef li\u1ec7u: Di chuy\u1ec3n t\u1edbi d\u00f2ng cu\u1ed1i c\u1ee7a b\u1ea3ng t\u00ednh\u00a0\u0111\u00f3<\/li>\n<li>N\u1ebfu\u00a0\u1edf b\u00ean ngo\u00e0i (ph\u00eda tr\u00ean) b\u1ea3ng t\u00ednh\u00a0\u0111\u00f3: Di chuy\u1ec3n t\u1edbi d\u00f2ng ti\u00eau\u00a0\u0111\u1ec1 (Header) c\u1ee7a b\u1ea3ng t\u00ednh<\/li>\n<li>N\u1ebfu\u00a0\u1edf b\u00ean ngo\u00e0i (ph\u00eda d\u01b0\u1edbi) b\u1ea3ng t\u00ednh\u00a0\u0111\u00f3: Di chuy\u1ec3n t\u1edbi d\u00f2ng cu\u1ed1i c\u00f9ng c\u1ee7a Sheet<\/li>\n<li>N\u1ebfu kh\u00f4ng c\u00f3 d\u1eef li\u1ec7u: Di chuy\u1ec3n t\u1edbi d\u00f2ng cu\u1ed1i c\u00f9ng c\u1ee7a Sheet<\/li>\n<\/ul>\n<p><strong>Ctrl + M\u0169i t\u00ean h\u01b0\u1edbng l\u00ean tr\u00ean (Up\u00a0Arrow): X\u00e9t trong c\u00f9ng 1 c\u1ed9t<\/strong><\/p>\n<ul>\n<li>N\u1ebfu\u00a0\u1edf trong b\u1ea3ng t\u00ednh c\u00f3 d\u1eef li\u1ec7u: Di chuy\u1ec3n t\u1edbi ph\u1ea7n Ti\u00eau\u00a0\u0111\u1ec1 (Header) c\u1ee7a b\u1ea3ng t\u00ednh<\/li>\n<li>N\u1ebfu\u00a0\u1edf b\u00ean ngo\u00e0i (ph\u00eda d\u01b0\u1edbi) b\u1ea3ng t\u00ednh: Di chuy\u1ec3n t\u1edbi d\u00f2ng cu\u1ed1i c\u00f9ng c\u00f3 ch\u1ee9a d\u1eef li\u1ec7u<\/li>\n<li>N\u1ebfu\u00a0\u1edf b\u00ean ngo\u00e0i (ph\u00eda tr\u00ean) b\u1ea3ng t\u00ednh: Di chuy\u1ec3n t\u1edbi d\u00f2ng \u0111\u1ea7u ti\u00ean trong Sheet (d\u00f2ng 1)<\/li>\n<li>N\u1ebfu sheet kh\u00f4ng ch\u1ee9a d\u1eef li\u1ec7u: Di chuy\u1ec3n t\u1edbi d\u00f2ng\u00a0\u0111\u1ea7u ti\u00ean (d\u00f2ng 1) trong Sheet<\/li>\n<\/ul>\n<p><strong>Ctrl + PageUp<\/strong>: Ch\u1ecdn t\u1edbi Sheet n\u1eb1m tr\u01b0\u1edbc\u00a0sheet\u00a0\u0111ang l\u00e0m vi\u1ec7c (Next Sheet)<\/p>\n<p><strong>Ctrl + PageDown<\/strong>: Ch\u1ecdn t\u1edbi Sheet n\u1eb1m ph\u00eda sau sheet\u00a0\u0111ang l\u00e0m vi\u1ec7c (Previous Sheet)<\/p>\n<p><strong>Ctrl + d\u1ea5u ~<\/strong> (ph\u00edm\u00a0\u1edf c\u1ea1nh ph\u00edm s\u1ed1 1): Chuy\u1ec3n sang ch\u1ebf\u00a0\u0111\u1ed9 xem v\u00e0 s\u1eeda c\u00f4ng th\u1ee9c. B\u1ea5m ti\u1ebfp 1 l\u1ea7n n\u1eefa\u00a0\u0111\u1ec3 tr\u1edf v\u1ec1 ch\u1ebf\u00a0\u0111\u1ed9 xem b\u00ecnh th\u01b0\u1eddng<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-14071 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/heo-ctrl_02.png\" width=\"620\" height=\"248\" title=\"heo-ctrl_02\"><\/p>\n<p style=\"text-align: center\">Ch\u1ebf\u00a0\u0111\u1ed9 xem b\u00ecnh th\u01b0\u1eddng<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-14072 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/heo-ctrl_03.png\" width=\"864\" height=\"253\" title=\"heo-ctrl_03\"><\/p>\n<p style=\"text-align: center\">Ch\u1ebf\u00a0\u0111\u1ed9 xem v\u1edbi Ctrl + ~<\/p>\n<p style=\"text-align: left\">Ch\u00fac c\u00e1c b\u1ea1n h\u1ecdc t\u1ed1t c\u00f9ng H\u1ecdc\u00a0Excel Online!<\/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\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/vba101_92019-nho-9.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":10678,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-10677","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\/10677","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=10677"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/10677\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/10678"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=10677"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=10677"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=10677"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}