{"id":1419,"date":"2014-07-26T05:17:02","date_gmt":"2014-07-25T22:17:02","guid":{"rendered":"http:\/\/www.itersdesktop.com\/?p=1419"},"modified":"2014-07-27T02:17:20","modified_gmt":"2014-07-26T19:17:20","slug":"co-dinh-nhung-hang-va-cot-tieu-de-trong-bang-tinh","status":"publish","type":"post","link":"https:\/\/www.itersdesktop.com\/vi\/2014\/07\/26\/co-dinh-nhung-hang-va-cot-tieu-de-trong-bang-tinh\/","title":{"rendered":"C\u1ed1 \u0111\u1ecbnh nh\u1eefng h\u00e0ng v\u00e0 c\u1ed9t ti\u00eau \u0111\u1ec1 trong b\u1ea3ng t\u00ednh"},"content":{"rendered":"<p>Khi l\u00e0m vi\u1ec7c v\u1edbi nh\u1eefng b\u1ea3ng t\u00ednh c\u00f3 \u0111\u1ebfn h\u00e0ng tr\u0103m h\u00e0ng d\u1eef li\u1ec7u v\u00e0 c\u00f3 nhi\u1ec1u c\u1ed9t, t\u00f4i ch\u1eafc b\u1ea1n s\u1ebd c\u1ea3m th\u1ea5y kh\u00f3 ch\u1ecbu khi ph\u1ea3i th\u1ef1c hi\u1ec7n cu\u1ed9n t\u1eebng trang m\u00e0n h\u00ecnh v\u00e0 kh\u00f4ng nh\u00ecn th\u1ea5y \u0111\u01b0\u1ee3c nh\u1eefng h\u00e0ng ti\u00eau \u0111\u1ec1 n\u1eb1m tr\u00ean c\u00f9ng ho\u1eb7c c\u00e1c c\u1ed9t d\u1eef li\u1ec7u ghi th\u00f4ng tin n\u1eb1m b\u00ean tr\u00e1i nh\u1ea5t c\u1ee7a b\u1ea3ng t\u00ednh. L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 c\u00f3 th\u1ec3 gi\u1eef nguy\u00ean nh\u1eefng h\u00e0ng v\u00e0 c\u1ed9t \u0111\u00f3? T\u00ednh n\u0103ng n\u00e0y trong Excel c\u0169ng nh\u01b0 LibreOffice v\u00e0 k\u1ec3 c\u1ea3 Google Spreadsheet g\u1ecdi t\u00ean l\u00e0 <strong>Freeze<\/strong>. B\u1ea3n th\u00e2n t\u1eeb Freeze c\u00f3 ngh\u0129a l\u00e0 <em>\u0111\u00f3ng b\u0103ng<\/em>, t\u1ee9c l\u00e0 gi\u1eef c\u1ed1 \u0111\u1ecbnh, kh\u00f4ng cho tr\u00f4i \u0111i m\u1ed9t th\u1ee9 g\u00ec \u0111\u00f3 c\u00e1c b\u1ea1n \u00e0.<\/p>\n<p>C\u1ee5 th\u1ec3, c\u00e1c b\u1ea1n theo d\u00f5i h\u00ecnh b\u00ean d\u01b0\u1edbi. S\u1ed1 l\u01b0\u1ee3ng c\u1ed9t kh\u00e1 nhi\u1ec1u, kh\u00f3 \u0111\u1ec3 hi\u1ec3n th\u1ecb to\u00e0n b\u1ed9 t\u1ea5t c\u1ea3 c\u00e1c c\u1ed9t trong m\u1ed9t khung m\u00e0n h\u00ecnh duy nh\u1ea5t. T\u01b0\u01a1ng t\u1ef1, s\u1ed1 l\u01b0\u1ee3ng d\u00f2ng d\u1eef li\u1ec7u kh\u00f4ng nh\u1ecf \u0111\u1ec3 c\u00f3 th\u1ec3 show all trong m\u1ed9t khung m\u00e0n h\u00ecnh. N\u1ebfu mu\u1ed1n xem c\u00e1c c\u1ed9t n\u1eb1m sau c\u1ed9t c\u00f3 t\u00ean <strong>ACoA<\/strong> ch\u00fang ta ph\u1ea3i di chuy\u1ec3n thanh cu\u1ed9n ngang sang ph\u1ea3i. T\u01b0\u01a1ng t\u1ef1 \u0111\u1ec3 xem c\u00e1c d\u00f2ng t\u1eeb th\u1ee9 t\u1ef1 21 tr\u1edf \u0111i b\u1ea1n phai di chuy\u1ec3n thanh cu\u1ed9n d\u1ecdc xu\u1ed1ng d\u01b0\u1edbi v\u00e0 ng\u01b0\u1ee3c l\u1ea1i. Khi \u0111\u00f3, c\u00e1c n\u1ed9i dung \u1edf c\u00e1c c\u1ed9t t\u1eeb C \u0111\u1ebfn S ho\u1eb7c c\u00e1c d\u00f2ng th\u1ee9 1 \u0111\u1ebfn 20 c\u00f3 th\u1ec3 s\u1ebd kh\u00f4ng th\u1ea5y \u0111\u01b0\u1ee3c. Trong tr\u01b0\u1eddng h\u1ee3p ch\u00fang ta mu\u1ed1n xem nh\u1eefng s\u1ed1 li\u1ec7u kh\u00e1c nhau \u0111\u1ec3 so s\u00e1nh tr\u00ean c\u00f9ng m\u1ed9t khung m\u00e0n h\u00ecnh th\u00ec vi\u1ec7c cu\u1ed9n n\u00e0y kh\u00f4ng \u0111\u00e1p \u1ee9ng \u0111\u01b0\u1ee3c. \u0110\u00f3 l\u00e0 l\u00ed do ch\u00fang ta mu\u1ed1n c\u1ed1 \u0111\u1ecbnh m\u1ed9t v\u00e0i d\u1eef li\u1ec7u n\u00e0o \u0111\u00f3.<\/p>\n<p>Trong v\u00ed d\u1ee5 n\u00e0y, t\u00f4i mu\u1ed1n c\u1ed1 \u0111\u1ecbnh d\u1eef li\u1ec7u n\u1eb1m tr\u00ean c\u00e1c h\u00e0ng s\u1ed1 1 \u0111\u1ebfn s\u1ed1 9; c\u00e1c c\u1ed9t A, B. \u0110\u1ec3 th\u1ef1c hi\u1ec7n nh\u1eefng g\u00ec v\u1eeba tr\u00ecnh b\u00e0y tr\u00ean, t\u00f4i s\u1ebd th\u1ef1c hi\u1ec7n m\u1ed9t v\u00ed d\u1ee5 trong LibreOffice version 3.6.\u00a0C\u00f3 ba tr\u01b0\u1eddng h\u1ee3p:<\/p>\n<p>(1) Gi\u1eef c\u1ed1 \u0111\u1ecbnh m\u1ed9t s\u1ed1 h\u00e0ng ti\u00eau \u0111\u1ec1 (n\u1eb1m tr\u00ean c\u00f9ng) c\u1ee7a b\u1ea3ng t\u00ednh. Xem h\u00ecnh b\u00ean d\u01b0\u1edbi, n\u1ebfu ch\u00fang ta mu\u1ed1n c\u1ed1 \u0111\u1ecbnh c\u00e1c h\u00e0ng s\u1ed1 1 \u0111\u1ebfn s\u1ed1 9, th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/p>\n<ul>\n<li>Ch\u1ecdn to\u00e0n b\u1ed9 c\u00e1c h\u00e0ng t\u1eeb s\u1ed1 1 \u0111\u1ebfn s\u1ed1 9.<\/li>\n<li>Ch\u1ecdn ch\u1ee9c n\u0103ng <strong>Freeze<\/strong> trong <strong>Window<\/strong>.<\/li>\n<\/ul>\n<p>(2) Gi\u1eef c\u1ed1 \u0111\u1ecbnh m\u1ed9t s\u1ed1 c\u1ed9t b\u00ean tr\u00e1i nh\u1ea5t c\u1ee7a b\u1ea3ng t\u00ednh. Xem h\u00ecnh b\u00ean d\u01b0\u1edbi, n\u1ebfu ch\u00fang ta mu\u1ed1n c\u1ed1 \u0111\u1ecbnh d\u1eef li\u1ec7u tr\u00ean hai c\u1ed9t A v\u00e0 B, th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/p>\n<ul>\n<li>Ch\u1ecdn to\u00e0n b\u1ed9 c\u1ed9t A v\u00e0 B.<\/li>\n<li>Ch\u1ecdn ch\u1ee9c n\u0103ng <strong>Freeze<\/strong> trong <strong>Window<\/strong>.<\/li>\n<\/ul>\n<p>(3) Gi\u1eef c\u1ed1 \u0111\u1ecbnh m\u1ed9t s\u1ed1 h\u00e0ng ti\u00eau \u0111\u1ec1 tr\u00ean c\u00f9ng \u0111\u1ed3ng th\u1eddi v\u1edbi m\u1ed9t s\u1ed1 c\u1ed9t b\u00ean tr\u00e1i nh\u1ea5t. Xem h\u00ecnh b\u00ean d\u01b0\u1edbi, n\u1ebfu ch\u00fang ta mu\u1ed1n c\u1ed1 \u0111\u1ecbnh d\u1eef li\u1ec7u tr\u00ean c\u00e1c h\u00e0ng s\u1ed1 1 \u0111\u1ebfn 9 v\u00e0 hai c\u1ed9t A v\u00e0 B c\u00f9ng l\u00fac, th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/p>\n<ul>\n<li>\u0110\u1eb7t (ch\u1ecdn) v\u00e0o \u00f4 <strong>C9<\/strong> (minh h\u1ecda nh\u01b0 h\u00ecnh th\u1ee9 hai: \u00f4 t\u00f4 m\u00e0u \u0111\u1ecf). V\u00f9ng t\u00f4 m\u00e0u v\u00e0ng v\u00e0 m\u00e0u xanh c\u1ea7n gi\u1eef c\u1ed1 \u0111\u1ecbnh, v\u1eady th\u00ec \u00f4 \u0111\u01b0\u1ee3c ch\u1ecdn n\u1eb1m \u1edf g\u00f3c ph\u1ea7n t\u01b0 ph\u00eda b\u00ean d\u01b0\u1edbi ngay t\u1ea1i \u0111i\u1ec3m giao hai v\u00f9ng.<\/li>\n<li>Ch\u1ecdn ch\u1ee9c n\u0103ng <strong>Freeze<\/strong> trong <strong>Window<\/strong>.<\/li>\n<\/ul>\n<figure id=\"attachment_1560\" aria-describedby=\"caption-attachment-1560\" style=\"width: 968px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/www.itersdesktop.com\/wp-content\/uploads\/2014\/07\/Freeze-Header-Rows-and-Columns.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-1560\" src=\"http:\/\/www.itersdesktop.com\/wp-content\/uploads\/2014\/07\/Freeze-Header-Rows-and-Columns.png\" alt=\"Freeze Header Rows and Columns\" width=\"968\" height=\"670\" srcset=\"https:\/\/www.itersdesktop.com\/wp-content\/uploads\/2014\/07\/Freeze-Header-Rows-and-Columns.png 968w, https:\/\/www.itersdesktop.com\/wp-content\/uploads\/2014\/07\/Freeze-Header-Rows-and-Columns-300x207.png 300w\" sizes=\"auto, (max-width: 968px) 100vw, 968px\" \/><\/a><figcaption id=\"caption-attachment-1560\" class=\"wp-caption-text\">Freeze Header Rows and Columns<\/figcaption><\/figure>\n<figure id=\"attachment_1561\" aria-describedby=\"caption-attachment-1561\" style=\"width: 964px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/www.itersdesktop.com\/wp-content\/uploads\/2014\/07\/Freeze-Rows-and-Columns-Choose-intersection-area.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-1561\" src=\"http:\/\/www.itersdesktop.com\/wp-content\/uploads\/2014\/07\/Freeze-Rows-and-Columns-Choose-intersection-area.png\" alt=\"Freeze Rows and Columns - Choose intersection area\" width=\"964\" height=\"477\" srcset=\"https:\/\/www.itersdesktop.com\/wp-content\/uploads\/2014\/07\/Freeze-Rows-and-Columns-Choose-intersection-area.png 964w, https:\/\/www.itersdesktop.com\/wp-content\/uploads\/2014\/07\/Freeze-Rows-and-Columns-Choose-intersection-area-300x148.png 300w\" sizes=\"auto, (max-width: 964px) 100vw, 964px\" \/><\/a><figcaption id=\"caption-attachment-1561\" class=\"wp-caption-text\">Freeze Rows and Columns &#8211; Choose intersection area<\/figcaption><\/figure>\n<p>Tr\u00ean Excel 2007, Excel 2010, t\u00ednh n\u0103ng n\u00e0y \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n t\u01b0\u01a1ng t\u1ef1. Google Spreadsheets c\u00f3 m\u1ed9t s\u1ef1 kh\u00e1c bi\u1ec7t \u0111\u00e1ng k\u1ec3. T\u00ednh n\u0103ng \u0111\u00f3ng b\u0103ng n\u1eb1m trong menu <strong>View<\/strong>, g\u1ed3m <strong>Freeze rows<\/strong> v\u00e0 <strong>Freeze columns<\/strong>. Ch\u1ecdn bao nhi\u00eau h\u00e0ng v\u00e0 bao nhi\u00eau c\u1ed9t c\u1ea7n c\u1ed1 \u0111\u1ecbnh. Spreadsheets t\u1ef1 \u0111\u1ed9ng ch\u1ecdn s\u1ed1 h\u00e0ng n\u1eb1m tr\u00ean c\u00f9ng v\u00e0 s\u1ed1 c\u1ed9t n\u1eb1m b\u00ean tr\u00e1i nh\u1ea5t \u0111\u1ec3 c\u1ed1 \u0111\u1ecbnh. Tham kh\u1ea3o <a href=\"http:\/\/goo.gl\/J1Ef2f\" target=\"_blank\">C\u00e1ch c\u1ed1 \u0111\u1ecbnh h\u00e0ng v\u00e0 c\u1ed9t ti\u00eau \u0111\u1ec1 trong Google Speadsheets<\/a>.<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>","protected":false},"excerpt":{"rendered":"<p>Khi l\u00e0m vi\u1ec7c v\u1edbi nh\u1eefng b\u1ea3ng t\u00ednh c\u00f3 \u0111\u1ebfn h\u00e0ng tr\u0103m h\u00e0ng d\u1eef li\u1ec7u v\u00e0 c\u00f3 nhi\u1ec1u c\u1ed9t, t\u00f4i ch\u1eafc b\u1ea1n s\u1ebd c\u1ea3m th\u1ea5y kh\u00f3 ch\u1ecbu khi ph\u1ea3i th\u1ef1c hi\u1ec7n&hellip; <\/p>\n","protected":false},"author":2,"featured_media":1561,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[390,425],"tags":[576,442,460,441,461,443,462],"class_list":["post-1419","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-office-applications","category-spreadsheet","tag-spreadsheet","tag-co-dinh-nhung-hang-va-cot-tieu-de","tag-excel","tag-figer-ou-defiger-les-lignes-et-colonnes","tag-freeze","tag-freeze-the-heading-rows-and-columns","tag-spreadsheets"],"_links":{"self":[{"href":"https:\/\/www.itersdesktop.com\/vi\/wp-json\/wp\/v2\/posts\/1419","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.itersdesktop.com\/vi\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.itersdesktop.com\/vi\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.itersdesktop.com\/vi\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.itersdesktop.com\/vi\/wp-json\/wp\/v2\/comments?post=1419"}],"version-history":[{"count":12,"href":"https:\/\/www.itersdesktop.com\/vi\/wp-json\/wp\/v2\/posts\/1419\/revisions"}],"predecessor-version":[{"id":1566,"href":"https:\/\/www.itersdesktop.com\/vi\/wp-json\/wp\/v2\/posts\/1419\/revisions\/1566"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.itersdesktop.com\/vi\/wp-json\/wp\/v2\/media\/1561"}],"wp:attachment":[{"href":"https:\/\/www.itersdesktop.com\/vi\/wp-json\/wp\/v2\/media?parent=1419"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.itersdesktop.com\/vi\/wp-json\/wp\/v2\/categories?post=1419"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.itersdesktop.com\/vi\/wp-json\/wp\/v2\/tags?post=1419"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}