{"id":6877,"date":"2024-12-21T16:21:35","date_gmt":"2024-12-21T16:21:35","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cach-chen-nhieu-hang-trong-hoac-cot-trong-vao-excel\/"},"modified":"2024-12-21T16:21:35","modified_gmt":"2024-12-21T16:21:35","slug":"cach-chen-nhieu-hang-trong-hoac-cot-trong-vao-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cach-chen-nhieu-hang-trong-hoac-cot-trong-vao-excel\/","title":{"rendered":"C\u00e1ch ch\u00e8n nhi\u1ec1u h\u00e0ng tr\u1ed1ng ho\u1eb7c c\u1ed9t tr\u1ed1ng v\u00e0o Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Khi b\u1ea1n c\u1ea7n ch\u00e8n 10 h\u00e0ng tr\u1eafng gi\u1eefa h\u00e0ng 2 v\u00e0 h\u00e0ng 3, ho\u1eb7c ch\u00e8n 10 h\u00e0ng tr\u1eafng \u0111\u1eb1ng tr\u01b0\u1edbc m\u1ed9t h\u00e0ng c\u1ee5 th\u1ec3, b\u1ea1n l\u00e0m th\u1ebf n\u00e0o? Th\u00f4ng th\u01b0\u1eddng b\u1ea1n s\u1ebd ch\u00e8n t\u1eebng h\u00e0ng m\u1ed9t. Trong b\u00e0i vi\u1ebft n\u00e0y, <a href=\"https:\/\/hocexcel.online\/\" target=\"_blank\" rel=\"noopener noreferrer\">H\u1ecdc Excel Online<\/a> s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n c\u00e1ch ch\u00e8n nhi\u1ec1u h\u00e0ng tr\u1ed1ng ho\u1eb7c c\u1ed9t tr\u1ed1ng v\u00e0o trong Excel.<\/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-6766eb0e45d6c\" 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-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/cach-chen-nhieu-hang-trong-hoac-cot-trong-vao-excel.html#Cach_chen_nhieu_hang_va_cot_trong_bang_lenh_Insert\" title=\"C\u00e1ch ch\u00e8n nhi\u1ec1u h\u00e0ng v\u00e0 c\u1ed9t tr\u1ed1ng b\u1eb1ng l\u1ec7nh Insert\">C\u00e1ch ch\u00e8n nhi\u1ec1u h\u00e0ng v\u00e0 c\u1ed9t tr\u1ed1ng b\u1eb1ng l\u1ec7nh Insert<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/cach-chen-nhieu-hang-trong-hoac-cot-trong-vao-excel.html#Chen_nhieu_hang_va_cot_trong_bang_phim_tat\" title=\"Ch\u00e8n nhi\u1ec1u h\u00e0ng v\u00e0 c\u1ed9t tr\u1ed1ng b\u1eb1ng ph\u00edm t\u1eaft\">Ch\u00e8n nhi\u1ec1u h\u00e0ng v\u00e0 c\u1ed9t tr\u1ed1ng b\u1eb1ng ph\u00edm t\u1eaft<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Cach_chen_nhieu_hang_va_cot_trong_bang_lenh_Insert\"><\/span><strong>C\u00e1ch ch\u00e8n nhi\u1ec1u h\u00e0ng v\u00e0 c\u1ed9t tr\u1ed1ng b\u1eb1ng l\u1ec7nh Insert<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: left\">B\u1ea1n c\u00f3 th\u1ec3 ch\u00e8n 10 h\u00e0ng tr\u1ed1ng gi\u1eefa h\u00e0ng 2 v\u00e0 h\u00e0ng 3 theo c\u00e1c b\u01b0\u1edbc sau:<\/p>\n<p style=\"text-align: left\"><strong>B\u01b0\u1edbc 1: Ch\u1ecdn to\u00e0n b\u1ed9 10 h\u00e0ng b\u00ean d\u01b0\u1edbi t\u1eeb h\u00e0ng 3 (bao g\u1ed3m c\u1ea3 h\u00e0ng 3).<\/strong><\/p>\n<p style=\"text-align: left\"><strong>B\u01b0\u1edbc 2: S\u1eed d\u1ee5ng hai c\u00e1ch sau \u0111\u00e2y \u0111\u1ec3 ch\u00e8n h\u00e0ng:<\/strong><\/p>\n<p style=\"text-align: left\">(1) Nh\u1ea5p ph\u1ea3i v\u00e0o c\u00e1c h\u00e0ng \u0111\u01b0\u1ee3c ch\u1ecdn, ch\u1ecdn <strong><em>Insert<\/em><\/strong> t\u1eeb danh s\u00e1ch t\u00f9y ch\u1ecdn.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/doc-insert-multiple-rows1-1.png\" alt=\"doc-insert-multiple-rows1\" title=\"doc-insert-multiple-rows1-1\"><\/p>\n<p>(2) Ho\u1eb7c b\u1ea1n c\u00f3 th\u1ec3 nh\u1ea5p <strong><em>Home &gt; Insert &gt; Insert Sheet Rows.<\/em><\/strong><\/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\/2024\/12\/vba101_92019-nho-274.gif\" title=\"vba101_92019-nho-274\"><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\/2024\/12\/ex101_92019-nho-617.gif\" title=\"ex101_92019-nho-617\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/doc-insert-multiple-rows2-1.png\" alt=\"doc-insert-multiple-rows2\" title=\"doc-insert-multiple-rows2-1\"><\/p>\n<p>Sau \u0111\u00f3 10 h\u00e0ng tr\u1eafng s\u1ebd \u0111\u01b0\u1ee3c ch\u00e8n v\u00e0o gi\u1eefa h\u00e0ng 2 v\u00e0 h\u00e0ng 3. B\u1ea1n c\u00f3 th\u1ec3 ch\u00e8n nhi\u1ec1u c\u1ed9t tr\u1ed1ng theo c\u00e1ch t\u01b0\u01a1ng t\u1ef1. V\u00ed d\u1ee5, b\u1ea1n c\u00f3 th\u1ec3 ch\u00e8n 10 c\u1ed9t tr\u1eafng tr\u01b0\u1edbc c\u1ed9t 3.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Chen_nhieu_hang_va_cot_trong_bang_phim_tat\"><\/span><strong>Ch\u00e8n nhi\u1ec1u h\u00e0ng v\u00e0 c\u1ed9t tr\u1ed1ng b\u1eb1ng ph\u00edm t\u1eaft<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>D\u0129 nhi\u00ean, ch\u00fang ta c\u00f3 th\u1ec3 nh\u1ea5n ph\u00edm <strong><em>F4 <\/em><\/strong>\u0111\u1ec3 ch\u00e8n nhi\u1ec1u h\u00e0ng tr\u1ed1ng ho\u1eb7c c\u1ed9t tr\u1ed1ng.<\/p>\n<p>\u0110\u1ea7u ti\u00ean, ch\u00e8n m\u1ed9t h\u00e0ng tr\u1ed1ng ph\u00eda tr\u00ean h\u00e0ng 3, nh\u1ea5n <strong>F4<\/strong> 9 l\u1ea7n \u0111\u1ec3 ch\u00e8n 10 h\u00e0ng tr\u1ed1ng gi\u1eefa h\u00e0ng 2 v\u00e0 h\u00e0ng 3. C\u00e1ch n\u00e0y c\u0169ng c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng \u0111\u1ec3 ch\u00e8n nhi\u1ec1u c\u1ed9t.<\/p>\n<p>R\u1ea5t nhi\u1ec1u ki\u1ebfn th\u1ee9c ph\u1ea3i kh\u00f4ng n\u00e0o? Nh\u1eefng ki\u1ebfn th\u1ee9c n\u00e0y tuy r\u1ea5t \u0111\u01a1n gi\u1ea3n, nh\u01b0ng n\u1ebfu kh\u00f4ng bi\u1ebft, b\u1ea1n s\u1ebd m\u1ea5t nhi\u1ec1u th\u1eddi gian v\u00e0 c\u00f4ng s\u1ee9c \u0111\u1ec3 x\u1eed l\u00fd file Excel c\u1ee7a m\u00ecnh.<\/p>\n<p>To\u00e0n b\u1ed9 nh\u1eefng ki\u1ebfn th\u1ee9c n\u00e0y c\u00e1c b\u1ea1n \u0111\u1ec1u c\u00f3 th\u1ec3 h\u1ecdc \u0111\u01b0\u1ee3c trong kh\u00f3a h\u1ecdc\u00a0<a href=\"http:\/\/bit.ly\/2w6YAe8\">EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi chuy\u00ean gia<\/a>\u00a0c\u1ee7a H\u1ecdc Excel Online. \u0110\u00e2y l\u00e0 kh\u00f3a h\u1ecdc gi\u00fap b\u1ea1n h\u1ec7 th\u1ed1ng ki\u1ebfn th\u1ee9c m\u1ed9t c\u00e1ch \u0111\u1ea7y \u0111\u1ee7, chi ti\u1ebft. H\u01a1n n\u1eefa kh\u00f4ng h\u1ec1 c\u00f3 gi\u1edbi h\u1ea1n v\u1ec1 th\u1eddi gian h\u1ecdc t\u1eadp n\u00ean b\u1ea1n c\u00f3 th\u1ec3 tho\u1ea3i m\u00e1i h\u1ecdc b\u1ea5t c\u1ee9 l\u00fac n\u00e0o, d\u1ec5 d\u00e0ng tra c\u1ee9u l\u1ea1i ki\u1ebfn th\u1ee9c khi c\u1ea7n. Hi\u1ec7n nay h\u1ec7 th\u1ed1ng \u0111ang c\u00f3 \u01b0u \u0111\u00e3i r\u1ea5t l\u1edbn cho b\u1ea1n khi \u0111\u0103ng k\u00fd tham gia kh\u00f3a h\u1ecdc. Chi ti\u1ebft xem t\u1ea1i: <a href=\"https:\/\/hocexcel.online\" target=\"_blank\" rel=\"noopener\">HocExcel.Online<\/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\/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\/2024\/12\/vba101_92019-nho-274.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":6878,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-6877","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-nang-cao"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/6877","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=6877"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/6877\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/6878"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=6877"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=6877"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=6877"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}