{"id":11898,"date":"2025-01-15T05:55:51","date_gmt":"2025-01-15T05:55:51","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/huong-dan-dien-cong-thuc-vao-nhieu-o-voi-mot-thao-tac-duy-nhat-ctrl-enter\/"},"modified":"2025-01-15T05:55:51","modified_gmt":"2025-01-15T05:55:51","slug":"huong-dan-dien-cong-thuc-vao-nhieu-o-voi-mot-thao-tac-duy-nhat-ctrl-enter","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/huong-dan-dien-cong-thuc-vao-nhieu-o-voi-mot-thao-tac-duy-nhat-ctrl-enter\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn \u0111i\u1ec1n c\u00f4ng th\u1ee9c v\u00e0o nhi\u1ec1u \u00f4 v\u1edbi m\u1ed9t thao t\u00e1c duy nh\u1ea5t (Ctrl + Enter)"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\">Trong tr\u01b0\u1eddng h\u1ee3p b\u1ea1n c\u1ea7n \u0111i\u1ec1n m\u1ed9t c\u00f4ng th\u1ee9c v\u00e0o nhi\u1ec1u h\u01a1n m\u1ed9t \u00f4 trong trang t\u00ednh (d\u00f9 l\u00e0 li\u1ec1n k\u1ec1 hay kh\u00f4ng li\u1ec1n k\u1ec1), c\u00e1ch th\u1ee9c n\u00e0y c\u00f3 th\u1ec3 ti\u1ebft ki\u1ec7m nhi\u1ec1u th\u1eddi gian.<\/p>\n<ul style=\"text-align: justify\">\n<li>Ch\u1ecdn t\u1ea5t c\u1ea3 c\u00e1c \u00f4 b\u1ea1n mu\u1ed1n \u0111i\u1ec1n c\u00f4ng th\u1ee9c v\u00e0 gi\u1eef Ctrl \u0111\u1ec3 ch\u1ecdn nh\u1eefng \u00f4 kh\u00f4ng li\u1ec1n nhau.<\/li>\n<li>Nh\u1ea5n F2 \u0111\u1ec3 edit c\u00e1c \u00f4 n\u00e0y.<\/li>\n<li>\u0110i\u1ec1n c\u00f4ng th\u1ee9c v\u00e0o m\u1ed9t \u00f4, nh\u1ea5n Ctrl + Enter v\u00e0 c\u00f4ng th\u1ee9c s\u1ebd \u0111\u01b0\u1ee3c \u0111i\u1ec1n v\u00e0o to\u00e0n b\u1ed9 nh\u1eefng \u00f4 \u0111\u01b0\u1ee3c ch\u1ecdn, theo \u0111\u00f3 Excel s\u1ebd \u0111i\u1ec1u ch\u1ec9nh tham chi\u1ebfu \u00f4 t\u01b0\u01a1ng \u0111\u1ed1i.<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5413 size-full\" src=\"\/\/www.w3.org\/2000\/svg'%20viewBox='0%200%20460%20260'%3E%3C\/svg%3E\" alt=\"\" width=\"460\" height=\"260\" data-lazy-srcset=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/9-1-e1494582942934.png 460w, https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2017\/05\/9-1-e1494582942934-300x170.png 300w\" data-lazy-sizes=\"(max-width: 460px) 100vw, 460px\" data-lazy-src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/9-1-e1494582942934.png\"><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5413 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/9-1-e1494582942934.png\" width=\"460\" height=\"260\" title=\"9-1-e1494582942934\"><\/p>\n<p style=\"text-align: justify\"><strong>M\u1eb9o.<\/strong> <em>B\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00e1ch th\u1ee9c n\u00e0y v\u1edbi b\u1ea5t c\u1ee9 d\u1eef li\u1ec7u n\u00e0o, kh\u00f4ng ch\u1ec9 v\u1edbi c\u00f4ng th\u1ee9c \u0111\u1ed1i v\u1edbi nhi\u1ec1u \u00f4 c\u00f9ng l\u00fac. M\u1ed9t v\u00e0i k\u1ef9 thu\u1eadt s\u1ebd \u0111\u01b0\u1ee3c chia s\u1ebb \u1edf b\u00e0i vi\u1ebft: C\u00e1ch \u0111i\u1ec1n data t\u01b0\u01a1ng t\u1ef1 v\u00e0o nhi\u1ec1u \u00f4 \u0111\u01b0\u1ee3c ch\u1ecdn c\u00f9ng l\u00fac.<\/em><\/p>\n<blockquote>\n<p style=\"text-align: justify\">Xem th\u00eam: <a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\" target=\"_blank\">Th\u00e0nh th\u1ea1o Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi n\u00e2ng cao trong 7 ng\u00e0y<\/a><\/p>\n<\/blockquote>\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>Trong tr\u01b0\u1eddng h\u1ee3p b\u1ea1n c\u1ea7n \u0111i\u1ec1n m\u1ed9t c\u00f4ng th\u1ee9c v\u00e0o nhi\u1ec1u h\u01a1n m\u1ed9t \u00f4 trong..<\/p>\n","protected":false},"author":1,"featured_media":11899,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-11898","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\/11898","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=11898"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/11898\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/11899"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=11898"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=11898"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=11898"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}