{"id":117693,"date":"2025-02-23T12:05:51","date_gmt":"2025-02-23T05:05:51","guid":{"rendered":"https:\/\/phongvu.vn\/cong-nghe\/?p=117693"},"modified":"2025-03-14T09:22:59","modified_gmt":"2025-03-14T02:22:59","slug":"cach-co-dinh-dong-trong-excel","status":"publish","type":"post","link":"https:\/\/phongvu.vn\/cong-nghe\/cach-co-dinh-dong-trong-excel\/","title":{"rendered":"Chi ti\u1ebft c\u00e1ch c\u1ed1 \u0111\u1ecbnh d\u00f2ng trong Excel m\u1edbi nh\u1ea5t 2025"},"content":{"rendered":"\n<p>B\u1ea1n \u0111\u00e3 bao gi\u1edd cu\u1ed9n xu\u1ed1ng m\u1ed9t danh s\u00e1ch d\u00e0i trong Excel v\u00e0 b\u1ed7ng d\u01b0ng qu\u00ean m\u1ea5t ti\u00eau \u0111\u1ec1 c\u1ed9t \u1edf tr\u00ean c\u00f9ng ch\u01b0a? Ho\u1eb7c khi l\u00e0m b\u00e1o c\u00e1o, b\u1ea1n c\u1ee9 ph\u1ea3i k\u00e9o qua k\u00e9o l\u1ea1i v\u00ec m\u1ea5t d\u1ea5u d\u00f2ng d\u1eef li\u1ec7u quan tr\u1ecdng? N\u1ebfu c\u00f3 th\u00ec \u0111\u00e2y ch\u00ednh l\u00e0 m\u1eb9o &#8220;c\u1ee9u nguy&#8221; cho b\u1ea1n! Trong b\u00e0i vi\u1ebft n\u00e0y, <a href=\"https:\/\/phongvu.vn\/cong-nghe\" target=\"_blank\" rel=\"noreferrer noopener\">Phong V\u0169 Tech News<\/a> s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch c\u1ed1 \u0111\u1ecbnh c\u1ed9t c\u0169ng nh\u01b0 c\u1ed1 \u0111\u1ecbnh d\u00f2ng trong Excel m\u1edbi nh\u1ea5t 2025 \u2013 nhanh g\u1ecdn, d\u1ec5 hi\u1ec3u, gi\u00fap b\u1ea1n l\u00e0m vi\u1ec7c hi\u1ec7u qu\u1ea3 h\u01a1n m\u00e0 kh\u00f4ng b\u1ecb r\u1ed1i m\u1eaft.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\" \/>\n\n\n\n<ul>\n<li><a href=\"https:\/\/phongvu.vn\/cong-nghe\/strongham-index-trong-excel-cach-su-dung-don-gian-2025\/\" target=\"_blank\" rel=\"noreferrer noopener\">H\u00e0m INDEX trong Excel: C\u00e1ch s\u1eed d\u1ee5ng \u0111\u01a1n gi\u1ea3n v\u00e0 d\u1ec5 hi\u1ec3u nh\u1ea5t 2025<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/phongvu.vn\/cong-nghe\/tong-hop-cac-ham-trong-excel-thuong-dung\/\" target=\"_blank\" rel=\"noreferrer noopener\">T\u1ed5ng h\u1ee3p c\u00e1c h\u00e0m trong Excel th\u01b0\u1eddng d\u00f9ng v\u00e0 v\u00ed d\u1ee5 d\u1ec5 hi\u1ec3u<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/phongvu.vn\/cong-nghe\/ham-if\/\" target=\"_blank\" rel=\"noreferrer noopener\">H\u00e0m IF l\u00e0 g\u00ec? C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IF trong Excel nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/a><\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\" \/>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_55 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >M\u1ee5c l\u1ee5c<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\" role=\"button\"><label for=\"item-6a209cb45f88a\" ><span class=\"\"><span style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input aria-label=\"Toggle\" aria-label=\"item-6a209cb45f88a\"  type=\"checkbox\" id=\"item-6a209cb45f88a\"><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/phongvu.vn\/cong-nghe\/cach-co-dinh-dong-trong-excel\/#Loi_ich_khi_co_dinh_dong_va_cot_trong_Excel\" title=\"L\u1ee3i \u00edch khi c\u1ed1 \u0111\u1ecbnh d\u00f2ng v\u00e0 c\u1ed9t trong Excel?\">L\u1ee3i \u00edch khi c\u1ed1 \u0111\u1ecbnh d\u00f2ng v\u00e0 c\u1ed9t trong Excel?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/phongvu.vn\/cong-nghe\/cach-co-dinh-dong-trong-excel\/#Huong_dan_co_dinh_dong_trong_Excel\" title=\"H\u01b0\u1edbng d\u1eabn c\u1ed1 \u0111\u1ecbnh d\u00f2ng trong Excel\">H\u01b0\u1edbng d\u1eabn c\u1ed1 \u0111\u1ecbnh d\u00f2ng trong Excel<\/a><ul class='ez-toc-list-level-3'><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/phongvu.vn\/cong-nghe\/cach-co-dinh-dong-trong-excel\/#11_Co_dinh_dong_dau_tien\" title=\"1.1. C\u1ed1 \u0111\u1ecbnh d\u00f2ng \u0111\u1ea7u ti\u00ean\">1.1. C\u1ed1 \u0111\u1ecbnh d\u00f2ng \u0111\u1ea7u ti\u00ean<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/phongvu.vn\/cong-nghe\/cach-co-dinh-dong-trong-excel\/#12_Co_dinh_nhieu_dong\" title=\"1.2. C\u1ed1 \u0111\u1ecbnh nhi\u1ec1u d\u00f2ng\">1.2. C\u1ed1 \u0111\u1ecbnh nhi\u1ec1u d\u00f2ng<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/phongvu.vn\/cong-nghe\/cach-co-dinh-dong-trong-excel\/#Huong_dan_co_dinh_cot_trong_Excel\" title=\"H\u01b0\u1edbng d\u1eabn c\u1ed1 \u0111\u1ecbnh c\u1ed9t trong Excel\">H\u01b0\u1edbng d\u1eabn c\u1ed1 \u0111\u1ecbnh c\u1ed9t trong Excel<\/a><ul class='ez-toc-list-level-3'><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/phongvu.vn\/cong-nghe\/cach-co-dinh-dong-trong-excel\/#21_Co_dinh_cot_dau_tien_trong_Excel\" title=\"2.1 C\u1ed1 \u0111\u1ecbnh c\u1ed9t \u0111\u1ea7u ti\u00ean trong Excel\">2.1 C\u1ed1 \u0111\u1ecbnh c\u1ed9t \u0111\u1ea7u ti\u00ean trong Excel<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/phongvu.vn\/cong-nghe\/cach-co-dinh-dong-trong-excel\/#22_Co_dinh_nhieu_cot_trong_Excel\" title=\"2.2 C\u1ed1 \u0111\u1ecbnh nhi\u1ec1u c\u1ed9t trong Excel\">2.2 C\u1ed1 \u0111\u1ecbnh nhi\u1ec1u c\u1ed9t trong Excel<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/phongvu.vn\/cong-nghe\/cach-co-dinh-dong-trong-excel\/#Cach_co_dinh_dong_thoi_nhieu_hang_va_cot\" title=\"C\u00e1ch c\u1ed1 \u0111\u1ecbnh \u0111\u1ed3ng th\u1eddi nhi\u1ec1u h\u00e0ng v\u00e0 c\u1ed9t\">C\u00e1ch c\u1ed1 \u0111\u1ecbnh \u0111\u1ed3ng th\u1eddi nhi\u1ec1u h\u00e0ng v\u00e0 c\u1ed9t<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/phongvu.vn\/cong-nghe\/cach-co-dinh-dong-trong-excel\/#Lam_the_nao_de_co_dinh_nhieu_vung_trong_Excel\" title=\"L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 c\u1ed1 \u0111\u1ecbnh nhi\u1ec1u v\u00f9ng trong Excel?\">L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 c\u1ed1 \u0111\u1ecbnh nhi\u1ec1u v\u00f9ng trong Excel?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/phongvu.vn\/cong-nghe\/cach-co-dinh-dong-trong-excel\/#Xoa_go_bo_co_dinh_hang_cot_trong_Excel\" title=\"X\u00f3a, g\u1ee1 b\u1ecf c\u1ed1 \u0111\u1ecbnh h\u00e0ng, c\u1ed9t trong Excel\">X\u00f3a, g\u1ee1 b\u1ecf c\u1ed1 \u0111\u1ecbnh h\u00e0ng, c\u1ed9t trong Excel<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/phongvu.vn\/cong-nghe\/cach-co-dinh-dong-trong-excel\/#Tong_ket\" title=\"T\u1ed5ng k\u1ebft\">T\u1ed5ng k\u1ebft<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Loi_ich_khi_co_dinh_dong_va_cot_trong_Excel\"><\/span><strong>L\u1ee3i \u00edch khi c\u1ed1 \u0111\u1ecbnh d\u00f2ng v\u00e0 c\u1ed9t trong Excel?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Trong qu\u00e1 tr\u00ecnh l\u00e0m vi\u1ec7c v\u1edbi Excel, \u0111\u1eb7c bi\u1ec7t l\u00e0 khi x\u1eed l\u00fd c\u00e1c b\u1ea3ng d\u1eef li\u1ec7u l\u1edbn, ch\u1eafc h\u1eb3n b\u1ea1n \u0111\u00e3 t\u1eebng g\u1eb7p ph\u1ea3i t\u00ecnh hu\u1ed1ng: cu\u1ed9n xu\u1ed1ng \u0111\u1ec3 xem th\u00f4ng tin chi ti\u1ebft nh\u01b0ng l\u1ea1i kh\u00f4ng c\u00f2n th\u1ea5y ti\u00eau \u0111\u1ec1 c\u1ed9t, ho\u1eb7c cu\u1ed9n ngang \u0111\u1ec3 ki\u1ec3m tra s\u1ed1 li\u1ec7u m\u00e0 m\u1ea5t d\u1ea5u c\u00e1c c\u1ed9t quan tr\u1ecdng nh\u01b0 m\u00e3 kh\u00e1ch h\u00e0ng hay t\u00ean s\u1ea3n ph\u1ea9m. \u0110i\u1ec1u n\u00e0y kh\u00f4ng ch\u1ec9 g\u00e2y b\u1ea5t ti\u1ec7n m\u00e0 c\u00f2n l\u00e0m t\u0103ng nguy c\u01a1 nh\u1ea7m l\u1eabn khi ph\u00e2n t\u00edch d\u1eef li\u1ec7u. Vi\u1ec7c c\u1ed1 \u0111\u1ecbnh d\u00f2ng trong Excel s\u1ebd gi\u00fap kh\u1eafc ph\u1ee5c ho\u00e0n to\u00e0n v\u1ea5n \u0111\u1ec1 n\u00e0y, mang l\u1ea1i nhi\u1ec1u l\u1ee3i \u00edch thi\u1ebft th\u1ef1c.<\/p>\n\n\n\n<p>Tr\u01b0\u1edbc h\u1ebft, c\u1ed1 \u0111\u1ecbnh c\u00e1c c\u1ed9t v\u00e0 c\u1ed1 \u0111\u1ecbnh d\u00f2ng quan tr\u1ecdng trong Excel s\u1ebd gi\u00fap b\u1ea1n theo d\u00f5i th\u00f4ng tin d\u1ec5 d\u00e0ng h\u01a1n. Ch\u1eb3ng h\u1ea1n, khi b\u1ea1n l\u00e0m vi\u1ec7c v\u1edbi danh s\u00e1ch h\u00e0ng tr\u0103m s\u1ea3n ph\u1ea9m trong kho, n\u1ebfu c\u1ed9t t\u00ean s\u1ea3n ph\u1ea9m b\u1ecb \u201ctr\u00f4i\u201d m\u1ea5t khi cu\u1ed9n ngang, vi\u1ec7c \u0111\u1ed1i chi\u1ebfu s\u1ed1 l\u01b0\u1ee3ng t\u1ed3n kho hay gi\u00e1 b\u00e1n s\u1ebd tr\u1edf n\u00ean kh\u00f3 kh\u0103n. Nh\u01b0ng khi c\u1ed9t n\u00e0y \u0111\u01b0\u1ee3c c\u1ed1 \u0111\u1ecbnh, b\u1ea1n c\u00f3 th\u1ec3 cu\u1ed9n tho\u1ea3i m\u00e1i m\u00e0 v\u1eabn n\u1eafm b\u1eaft \u0111\u01b0\u1ee3c th\u00f4ng tin c\u1ea7n thi\u1ebft, gi\u00fap qu\u00e1 tr\u00ecnh qu\u1ea3n l\u00fd tr\u1edf n\u00ean tr\u1ef1c quan v\u00e0 ch\u00ednh x\u00e1c h\u01a1n.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-1-1024x640.jpg\" alt=\"L\u1ee3i \u00edch khi c\u1ed1 \u0111\u1ecbnh d\u00f2ng trong Excel, c\u1ed9t trong Excel.\" class=\"wp-image-118010\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-1-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-1-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-1-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-1-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-1-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-1-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-1-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-1-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-1-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-1-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-1.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">L\u1ee3i \u00edch khi c\u1ed1 \u0111\u1ecbnh d\u00f2ng trong Excel, c\u1ed9t trong Excel.<\/figcaption><\/figure>\n\n\n\n<p>B\u00ean c\u1ea1nh \u0111\u00f3, vi\u1ec7c n\u00e0y c\u00f2n gi\u00fap t\u0103ng hi\u1ec7u su\u1ea5t l\u00e0m vi\u1ec7c. Khi th\u1ef1c hi\u1ec7n b\u00e1o c\u00e1o t\u00e0i ch\u00ednh ho\u1eb7c ph\u00e2n t\u00edch d\u1eef li\u1ec7u, b\u1ea1n kh\u00f4ng c\u1ea7n m\u1ea5t th\u1eddi gian li\u00ean t\u1ee5c k\u00e9o l\u00ean k\u00e9o xu\u1ed1ng \u0111\u1ec3 ki\u1ec3m tra l\u1ea1i ti\u00eau \u0111\u1ec1 c\u1ed9t hay t\u00ecm ki\u1ebfm th\u00f4ng tin. Thay v\u00e0o \u0111\u00f3, b\u1ea1n c\u00f3 th\u1ec3 t\u1eadp trung v\u00e0o n\u1ed9i dung v\u00e0 \u0111\u01b0a ra quy\u1ebft \u0111\u1ecbnh nhanh h\u01a1n. \u0110i\u1ec1u n\u00e0y \u0111\u1eb7c bi\u1ec7t h\u1eefu \u00edch v\u1edbi nh\u1eefng b\u1ea3ng t\u00ednh c\u00f3 nhi\u1ec1u d\u1eef li\u1ec7u ph\u1ee9c t\u1ea1p nh\u01b0 b\u1ea3ng l\u01b0\u01a1ng, b\u00e1o c\u00e1o doanh s\u1ed1 ho\u1eb7c k\u1ebf ho\u1ea1ch kinh doanh.<\/p>\n\n\n\n<p>M\u1ed9t l\u1ee3i \u00edch quan tr\u1ecdng kh\u00e1c c\u1ee7a c\u1ed1 \u0111\u1ecbnh d\u00f2ng trong Excel l\u00e0 gi\u00fap gi\u1ea3m thi\u1ec3u sai s\u00f3t. Khi l\u00e0m vi\u1ec7c v\u1edbi m\u1ed9t b\u1ea3ng t\u00ednh d\u00e0i, vi\u1ec7c nh\u1ea7m l\u1eabn d\u00f2ng ho\u1eb7c c\u1ed9t l\u00e0 \u0111i\u1ec1u d\u1ec5 x\u1ea3y ra, \u0111\u1eb7c bi\u1ec7t khi x\u1eed l\u00fd s\u1ed1 li\u1ec7u quan tr\u1ecdng. Ch\u1ec9 c\u1ea7n nh\u1eadp d\u1eef li\u1ec7u v\u00e0o sai d\u00f2ng ho\u1eb7c t\u00ednh to\u00e1n d\u1ef1a tr\u00ean m\u1ed9t c\u1ed9t kh\u00f4ng ch\u00ednh x\u00e1c, b\u1ea1n c\u00f3 th\u1ec3 v\u00f4 t\u00ecnh \u0111\u01b0a ra nh\u1eefng k\u1ebft lu\u1eadn sai l\u1ec7ch. Nh\u1edd c\u1ed1 \u0111\u1ecbnh c\u00e1c h\u00e0ng v\u00e0 c\u1ed9t c\u1ea7n thi\u1ebft, b\u1ea1n c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng \u0111\u1ed1i chi\u1ebfu, so s\u00e1nh d\u1eef li\u1ec7u v\u00e0 \u0111\u1ea3m b\u1ea3o \u0111\u1ed9 ch\u00ednh x\u00e1c cao h\u01a1n trong c\u00f4ng vi\u1ec7c.<\/p>\n\n\n\n<h2><span class=\"ez-toc-section\" id=\"Huong_dan_co_dinh_dong_trong_Excel\"><\/span><strong>H\u01b0\u1edbng d\u1eabn c\u1ed1 \u0111\u1ecbnh d\u00f2ng trong Excel<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3><span class=\"ez-toc-section\" id=\"11_Co_dinh_dong_dau_tien\"><\/span><strong>1.1. C\u1ed1 \u0111\u1ecbnh d\u00f2ng \u0111\u1ea7u ti\u00ean<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\u0110\u1ec3 c\u1ed1 \u0111\u1ecbnh d\u00f2ng \u0111\u1ea7u ti\u00ean trong Excel, h\u00e3y th\u1ef1c hi\u1ec7n theo c\u00e1c b\u01b0\u1edbc sau:<\/p>\n\n\n\n<ul>\n<li><strong>B\u01b0\u1edbc 1:<\/strong> Tr\u00ean thanh c\u00f4ng c\u1ee5, ch\u1ecdn th\u1ebb <strong>View<\/strong>, nh\u1ea5p v\u00e0o <strong>Freeze Panes<\/strong>, sau \u0111\u00f3 ch\u1ecdn <strong>Freeze Top Row<\/strong>.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-2-1024x640.jpg\" alt=\"Ch\u1ecdn th\u1ebb View, nh\u1ea5p v\u00e0o Freeze Panes v\u00e0 ch\u1ecdn Freeze Top Row.\" class=\"wp-image-118011\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-2-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-2-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-2-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-2-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-2-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-2-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-2-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-2-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-2-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-2-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-2.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">Ch\u1ecdn th\u1ebb View, nh\u1ea5p v\u00e0o Freeze Panes v\u00e0 ch\u1ecdn Freeze Top Row.<\/figcaption><\/figure>\n\n\n\n<ul>\n<li><strong>B\u01b0\u1edbc 2:<\/strong> N\u1ebfu thao t\u00e1c c\u1ed1 \u0111\u1ecbnh d\u00f2ng trong Excel th\u00e0nh c\u00f4ng. D\u00f2ng \u0111\u1ea7u ti\u00ean \u0111\u01b0\u1ee3c c\u1ed1 \u0111\u1ecbnh s\u1ebd \u0111\u01b0\u1ee3c \u0111\u00e1nh d\u1ea5u b\u1eb1ng m\u1ed9t \u0111\u01b0\u1eddng k\u1ebb \u0111\u1eadm h\u01a1n so v\u1edbi c\u00e1c \u0111\u01b0\u1eddng k\u1ebb kh\u00e1c trong b\u1ea3ng t\u00ednh.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-3-1024x640.jpg\" alt=\"D\u00f2ng \u0111\u1ea7u ti\u00ean \u0111\u01b0\u1ee3c c\u1ed1 \u0111\u1ecbnh s\u1ebd \u0111\u01b0\u1ee3c \u0111\u00e1nh d\u1ea5u b\u1eb1ng m\u1ed9t \u0111\u01b0\u1eddng k\u1ebb \u0111\u1eadm h\u01a1n.\" class=\"wp-image-118012\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-3-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-3-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-3-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-3-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-3-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-3-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-3-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-3-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-3-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-3-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-3.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">D\u00f2ng \u0111\u1ea7u ti\u00ean \u0111\u01b0\u1ee3c c\u1ed1 \u0111\u1ecbnh s\u1ebd \u0111\u01b0\u1ee3c \u0111\u00e1nh d\u1ea5u b\u1eb1ng m\u1ed9t \u0111\u01b0\u1eddng k\u1ebb \u0111\u1eadm h\u01a1n.<\/figcaption><\/figure>\n\n\n\n<h3><span class=\"ez-toc-section\" id=\"12_Co_dinh_nhieu_dong\"><\/span><strong>1.2. C\u1ed1 \u0111\u1ecbnh nhi\u1ec1u d\u00f2ng<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Ngo\u00e0i vi\u1ec7c c\u1ed1 \u0111\u1ecbnh d\u00f2ng \u0111\u1ea7u ti\u00ean trong Excel nh\u01b0 tr\u00ean, b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 c\u1ed1 \u0111\u1ecbnh nhi\u1ec1u d\u00f2ng li\u00ean ti\u1ebfp t\u1eeb tr\u00ean xu\u1ed1ng.<\/p>\n\n\n\n<ul>\n<li><strong>B\u01b0\u1edbc 1:<\/strong> X\u00e1c \u0111\u1ecbnh s\u1ed1 d\u00f2ng c\u1ea7n c\u1ed1 \u0111\u1ecbnh v\u00e0 \u0111\u1eb7t con tr\u1ecf chu\u1ed9t v\u00e0o \u00f4 \u0111\u1ea7u ti\u00ean c\u1ee7a d\u00f2ng ngay b\u00ean d\u01b0\u1edbi nh\u00f3m d\u00f2ng \u0111\u00f3. V\u00ed d\u1ee5, n\u1ebfu mu\u1ed1n c\u1ed1 \u0111\u1ecbnh hai d\u00f2ng \u0111\u1ea7u, h\u00e3y \u0111\u1eb7t con tr\u1ecf t\u1ea1i d\u00f2ng th\u1ee9 ba.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-4-1024x640.jpg\" alt=\" X\u00e1c \u0111\u1ecbnh s\u1ed1 d\u00f2ng c\u1ea7n c\u1ed1 \u0111\u1ecbnh.\" class=\"wp-image-118013\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-4-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-4-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-4-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-4-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-4-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-4-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-4-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-4-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-4-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-4-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-4.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\"> X\u00e1c \u0111\u1ecbnh s\u1ed1 d\u00f2ng c\u1ea7n c\u1ed1 \u0111\u1ecbnh.<\/figcaption><\/figure>\n\n\n\n<ul>\n<li><strong>B\u01b0\u1edbc 2:<\/strong> Ch\u1ecdn th\u1ebb <strong>View<\/strong>, nh\u1ea5p v\u00e0o <strong>Freeze Panes<\/strong>, sau \u0111\u00f3 ch\u1ecdn <strong>Freeze Panes<\/strong>.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-5-1024x640.jpg\" alt=\"Ch\u1ecdn th\u1ebb View, nh\u1ea5p v\u00e0o Freeze Panes, sau \u0111\u00f3 ch\u1ecdn Freeze Panes.\" class=\"wp-image-118014\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-5-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-5-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-5-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-5-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-5-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-5-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-5-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-5-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-5-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-5-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-5.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">Ch\u1ecdn th\u1ebb View, nh\u1ea5p v\u00e0o Freeze Panes, sau \u0111\u00f3 ch\u1ecdn Freeze Panes.<\/figcaption><\/figure>\n\n\n\n<ul>\n<li><strong>B\u01b0\u1edbc 3:<\/strong> N\u1ebfu c\u1ed1 \u0111\u1ecbnh d\u00f2ng trong Excel th\u00e0nh c\u00f4ng, k\u1ebft qu\u1ea3 c\u00e1c d\u00f2ng \u0111\u01b0\u1ee3c c\u1ed1 \u0111\u1ecbnh s\u1ebd \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb v\u1edbi \u0111\u01b0\u1eddng k\u1ebb \u0111\u1eadm h\u01a1n, gi\u00fap b\u1ea1n d\u1ec5 d\u00e0ng theo d\u00f5i n\u1ed9i dung khi cu\u1ed9n trang.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-6-1024x640.jpg\" alt=\"D\u00f2ng \u0111\u01b0\u1ee3c c\u1ed1 \u0111\u1ecbnh s\u1ebd hi\u1ec3n th\u1ecb v\u1edbi \u0111\u01b0\u1eddng k\u1ebb \u0111\u1eadm.\" class=\"wp-image-118015\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-6-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-6-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-6-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-6-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-6-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-6-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-6-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-6-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-6-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-6-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-6.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">D\u00f2ng \u0111\u01b0\u1ee3c c\u1ed1 \u0111\u1ecbnh s\u1ebd hi\u1ec3n th\u1ecb v\u1edbi \u0111\u01b0\u1eddng k\u1ebb \u0111\u1eadm.<\/figcaption><\/figure>\n\n\n\n<h2><span class=\"ez-toc-section\" id=\"Huong_dan_co_dinh_cot_trong_Excel\"><\/span><strong>H\u01b0\u1edbng d\u1eabn c\u1ed1 \u0111\u1ecbnh c\u1ed9t trong Excel<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3><span class=\"ez-toc-section\" id=\"21_Co_dinh_cot_dau_tien_trong_Excel\"><\/span><strong>2.1 C\u1ed1 \u0111\u1ecbnh c\u1ed9t \u0111\u1ea7u ti\u00ean trong Excel<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>T\u01b0\u01a1ng t\u1ef1 nh\u01b0 c\u00e1c c\u1ed1 \u0111\u1ecbnh d\u00f2ng trong Excel, \u0111\u1ec3 c\u1ed1 \u0111\u1ecbnh c\u1ed9t \u0111\u1ea7u ti\u00ean trong Excel b\u1ea1n c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n theo c\u00e1c b\u01b0\u1edbc \u0111\u01a1n gi\u1ea3n sau:<\/p>\n\n\n\n<ul>\n<li><strong>B\u01b0\u1edbc 1: <\/strong>Ch\u1ecdn th\u1ebb <strong>View<\/strong>. Ti\u1ebfp theo ch\u1ecdn v\u00e0o <strong>Freeze Panes<\/strong>. Cu\u1ed1i c\u00f9ng, ch\u1ecdn <strong>Freeze First Column<\/strong> \u0111\u1ec3 c\u1ed1 \u0111\u1ecbnh c\u1ed9t \u0111\u1ea7u ti\u00ean trong b\u1ea3ng t\u00ednh.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-7-1024x640.jpg\" alt=\"Ch\u1ecdn Freeze First Column \u0111\u1ec3 c\u1ed1 \u0111\u1ecbnh c\u1ed9t \u0111\u1ea7u ti\u00ean. \" class=\"wp-image-118016\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-7-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-7-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-7-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-7-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-7-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-7-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-7-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-7-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-7-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-7-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-7.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">Ch\u1ecdn Freeze First Column \u0111\u1ec3 c\u1ed1 \u0111\u1ecbnh c\u1ed9t \u0111\u1ea7u ti\u00ean. <\/figcaption><\/figure>\n\n\n\n<ul>\n<li><strong>B\u01b0\u1edbc 2:<\/strong> K\u1ebft qu\u1ea3 c\u1ed9t \u0111\u1ea7u ti\u00ean trong b\u1ea3ng \u0111\u01b0\u1ee3c c\u1ed1 \u0111\u1ecbnh nh\u01b0 h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y. C\u1ed9t \u0111\u01b0\u1ee3c c\u1ed1 \u0111\u1ecbnh s\u1ebd \u0111\u01b0\u1ee3c \u0111\u00e1nh d\u1ea5u b\u1eb1ng \u0111\u01b0\u1eddng k\u1ebb \u0111\u1eadm h\u01a1n so v\u1edbi c\u00e1c c\u1ed9t kh\u00e1c.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-8-1024x640.jpg\" alt=\"\" class=\"wp-image-118017\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-8-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-8-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-8-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-8-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-8-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-8-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-8-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-8-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-8-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-8-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-8.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\"> C\u1ed9t \u0111\u01b0\u1ee3c c\u1ed1 \u0111\u1ecbnh s\u1ebd \u0111\u01b0\u1ee3c \u0111\u00e1nh d\u1ea5u b\u1eb1ng \u0111\u01b0\u1eddng k\u1ebb \u0111\u1eadm h\u01a1n.<\/figcaption><\/figure>\n\n\n\n<h3><span class=\"ez-toc-section\" id=\"22_Co_dinh_nhieu_cot_trong_Excel\"><\/span><strong>2.2 C\u1ed1 \u0111\u1ecbnh nhi\u1ec1u c\u1ed9t trong Excel<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Gi\u1ed1ng v\u1edbi thao t\u00e1c c\u1ed1 \u0111\u1ecbnh d\u00f2ng tr\u00ean Excel, c\u00e1c b\u01b0\u1edbc c\u1ed1 \u0111\u1ecbnh nhi\u1ec1u c\u1ed9t trong Excel c\u0169ng v\u00f4 c\u00f9ng \u0111\u01a1n gi\u1ea3n.<\/p>\n\n\n\n<ul>\n<li><strong>B\u01b0\u1edbc 1: <\/strong>T\u01b0\u01a1ng t\u1ef1 v\u1edbi vi\u1ec7c c\u1ed1 \u0111\u1ecbnh d\u00f2ng trong Excel, b\u1ea1n c\u0169ng c\u1ea7n x\u00e1c \u0111\u1ecbnh nh\u00f3m c\u1ed9t c\u1ea7n c\u1ed1 \u0111\u1ecbnh. \u0110\u1eb7t tr\u1ecf chu\u1ed9t t\u1ea1i \u00f4 thu\u1ed9c d\u00f2ng \u0111\u1ea7u ti\u00ean c\u1ee7a c\u1ed9t n\u1eb1m b\u00ean ph\u1ea3i nh\u00f3m c\u1ed9t c\u1ea7n c\u1ed1 \u0111\u1ecbnh. Ngh\u0129a l\u00e0 n\u1ebfu b\u1ea1n c\u1ed1 \u0111\u1ecbnh 2 c\u1ed9t \u0111\u1ea7u th\u00ec \u0111\u1eb7t tr\u1ecf chu\u1ed9t \u1edf c\u1ed9t th\u1ee9 3.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-9-1024x640.jpg\" alt=\"\" class=\"wp-image-118018\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-9-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-9-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-9-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-9-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-9-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-9-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-9-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-9-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-9-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-9-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-9.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\"> X\u00e1c \u0111\u1ecbnh nh\u00f3m c\u1ed9t c\u1ea7n c\u1ed1 \u0111\u1ecbnh.<\/figcaption><\/figure>\n\n\n\n<ul>\n<li><strong>B\u01b0\u1edbc 2:<\/strong> Ch\u1ecdn th\u1ebb <strong>View<\/strong>. Nh\u1ea5n <strong>Freeze Panes<\/strong>. V\u00e0 ch\u1ecdn <strong>Freeze Panes<\/strong>.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-10-1024x640.jpg\" alt=\"Ch\u1ecdn th\u1ebb View. Nh\u1ea5n Freeze Panes. V\u00e0 ch\u1ecdn Freeze Panes.\" class=\"wp-image-118019\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-10-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-10-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-10-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-10-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-10-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-10-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-10-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-10-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-10-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-10-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-10.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">Ch\u1ecdn th\u1ebb View. Nh\u1ea5n Freeze Panes. V\u00e0 ch\u1ecdn Freeze Panes.<\/figcaption><\/figure>\n\n\n\n<ul>\n<li><strong>B\u01b0\u1edbc 3:<\/strong> K\u1ebft qu\u1ea3 l\u00e0 2 c\u1ed9t \u0111\u1ea7u trong b\u1ea3ng \u0111\u00e3 \u0111\u01b0\u1ee3c c\u1ed1 \u0111\u1ecbnh.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-11-1024x640.jpg\" alt=\"2 c\u1ed9t \u0111\u1ea7u trong b\u1ea3ng \u0111\u00e3 \u0111\u01b0\u1ee3c c\u1ed1 \u0111\u1ecbnh.\" class=\"wp-image-118020\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-11-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-11-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-11-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-11-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-11-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-11-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-11-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-11-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-11-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-11-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-11.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">Nh\u01b0 v\u1eady, 2 c\u1ed9t \u0111\u1ea7u trong b\u1ea3ng \u0111\u00e3 \u0111\u01b0\u1ee3c c\u1ed1 \u0111\u1ecbnh.<\/figcaption><\/figure>\n\n\n\n<h2><span class=\"ez-toc-section\" id=\"Cach_co_dinh_dong_thoi_nhieu_hang_va_cot\"><\/span><strong>C\u00e1ch c\u1ed1 \u0111\u1ecbnh \u0111\u1ed3ng th\u1eddi nhi\u1ec1u h\u00e0ng v\u00e0 c\u1ed9t<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>V\u1edbi b\u1ea3ng t\u00ednh, ngo\u00e0i c\u1ed1 \u0111\u1ecbnh d\u00f2ng trong Excel, c\u1ed9t trong Excel, b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 c\u1ed1 \u0111\u1ecbnh \u0111\u1ed3ng th\u1eddi nhi\u1ec1u d\u00f2ng v\u00e0 c\u1ed9t \u0111\u1ec3 thu\u1eadn ti\u1ec7n khi xem d\u1eef li\u1ec7u. Thao t\u00e1c n\u00e0y gi\u00fap gi\u1eef nguy\u00ean c\u00e1c d\u00f2ng v\u00e0 c\u1ed9t quan tr\u1ecdng khi cu\u1ed9n trang. Tham kh\u1ea3o ngay c\u00e1c thao t\u00e1c \u0111\u01a1n gi\u1ea3n d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n\n\n\n<ul>\n<li><strong>B\u01b0\u1edbc 1:<\/strong> Ch\u1ecdn m\u1ed9t \u00f4 n\u1eb1m <strong>b\u00ean d\u01b0\u1edbi d\u00f2ng cu\u1ed1i c\u00f9ng<\/strong> v\u00e0 <strong>b\u00ean ph\u1ea3i c\u1ed9t cu\u1ed1i c\u00f9ng<\/strong> trong nh\u00f3m b\u1ea1n mu\u1ed1n c\u1ed1 \u0111\u1ecbnh. V\u00ed d\u1ee5: N\u1ebfu c\u1ea7n c\u1ed1 \u0111\u1ecbnh hai d\u00f2ng v\u00e0 hai c\u1ed9t \u0111\u1ea7u ti\u00ean, h\u00e3y \u0111\u1eb7t con tr\u1ecf chu\u1ed9t t\u1ea1i \u00f4 <strong>D3<\/strong>.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-12-1024x640.jpg\" alt=\"Ch\u1ecdn m\u1ed9t \u00f4 n\u1eb1m b\u00ean d\u01b0\u1edbi d\u00f2ng cu\u1ed1i c\u00f9ng v\u00e0 b\u00ean ph\u1ea3i c\u1ed9t cu\u1ed1i c\u00f9ng trong nh\u00f3m b\u1ea1n mu\u1ed1n c\u1ed1 \u0111\u1ecbnh.\" class=\"wp-image-118021\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-12-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-12-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-12-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-12-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-12-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-12-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-12-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-12-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-12-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-12-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-12.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">Ch\u1ecdn m\u1ed9t \u00f4 n\u1eb1m b\u00ean d\u01b0\u1edbi d\u00f2ng cu\u1ed1i c\u00f9ng v\u00e0 b\u00ean ph\u1ea3i c\u1ed9t cu\u1ed1i c\u00f9ng trong nh\u00f3m b\u1ea1n mu\u1ed1n c\u1ed1 \u0111\u1ecbnh.<\/figcaption><\/figure>\n\n\n\n<ul>\n<li><strong>B\u01b0\u1edbc 2:<\/strong> Tr\u00ean thanh c\u00f4ng c\u1ee5, ch\u1ecdn th\u1ebb <strong>View<\/strong>, nh\u1ea5p v\u00e0o <strong>Freeze Panes<\/strong>, sau \u0111\u00f3 ch\u1ecdn <strong>Freeze Panes<\/strong>.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-13-1024x640.jpg\" alt=\"Ch\u1ecdn th\u1ebb View, nh\u1ea5p v\u00e0o Freeze Panes, sau \u0111\u00f3 ch\u1ecdn Freeze Panes.\" class=\"wp-image-118022\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-13-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-13-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-13-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-13-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-13-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-13-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-13-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-13-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-13-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-13-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-13.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">Ch\u1ecdn th\u1ebb View, nh\u1ea5p v\u00e0o Freeze Panes, sau \u0111\u00f3 ch\u1ecdn Freeze Panes.<\/figcaption><\/figure>\n\n\n\n<ul>\n<li><strong>B\u01b0\u1edbc 3:<\/strong> N\u1ebfu thao t\u00e1c th\u00e0nh c\u00f4ng, c\u00e1c \u0111\u01b0\u1eddng k\u1ebb \u0111\u1eadm s\u1ebd xu\u1ea5t hi\u1ec7n t\u1ea1i v\u1ecb tr\u00ed c\u1ed1 \u0111\u1ecbnh, gi\u00fap b\u1ea1n d\u1ec5 d\u00e0ng theo d\u00f5i n\u1ed9i dung khi cu\u1ed9n trang.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-14-1024x640.jpg\" alt=\"C\u00e1c \u0111\u01b0\u1eddng k\u1ebb \u0111\u1eadm s\u1ebd xu\u1ea5t hi\u1ec7n t\u1ea1i v\u1ecb tr\u00ed c\u1ed1 \u0111\u1ecbnh.\" class=\"wp-image-118023\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-14-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-14-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-14-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-14-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-14-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-14-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-14-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-14-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-14-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-14-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-14.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">C\u00e1c \u0111\u01b0\u1eddng k\u1ebb \u0111\u1eadm s\u1ebd xu\u1ea5t hi\u1ec7n t\u1ea1i v\u1ecb tr\u00ed c\u1ed1 \u0111\u1ecbnh.<\/figcaption><\/figure>\n\n\n\n<h2><span class=\"ez-toc-section\" id=\"Lam_the_nao_de_co_dinh_nhieu_vung_trong_Excel\"><\/span><strong>L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 c\u1ed1 \u0111\u1ecbnh nhi\u1ec1u v\u00f9ng trong Excel?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Ngo\u00e0i c\u00e1ch c\u1ed1 \u0111\u1ecbnh d\u00f2ng trong Excel, c\u1ed9t trong Excel n\u00eau tr\u00ean, b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 c\u1ed1 \u0111\u1ecbnh \u0111\u1ed3ng th\u1eddi nhi\u1ec1u h\u00e0ng v\u00e0 c\u1ed9t trong Excel, mi\u1ec5n l\u00e0 \u0111i\u1ec3m b\u1eaft \u0111\u1ea7u lu\u00f4n t\u1eeb h\u00e0ng v\u00e0 c\u1ed9t \u0111\u1ea7u ti\u00ean.<\/p>\n\n\n\n<p>\u0110\u1ec3 th\u1ef1c hi\u1ec7n, h\u00e3y ch\u1ecdn m\u1ed9t \u00f4 n\u1eb1m <strong>b\u00ean d\u01b0\u1edbi h\u00e0ng cu\u1ed1i c\u00f9ng<\/strong> v\u00e0 <strong>b\u00ean ph\u1ea3i c\u1ed9t cu\u1ed1i c\u00f9ng<\/strong> c\u1ee7a v\u00f9ng c\u1ea7n c\u1ed1 \u0111\u1ecbnh. V\u00ed d\u1ee5:<\/p>\n\n\n\n<ul>\n<li>\u0110\u1ec3 c\u1ed1 \u0111\u1ecbnh <strong>h\u00e0ng v\u00e0 c\u1ed9t \u0111\u1ea7u ti\u00ean<\/strong>, ch\u1ecdn \u00f4 <strong>C2<\/strong>, sau \u0111\u00f3 v\u00e0o th\u1ebb <strong>View<\/strong> v\u00e0 nh\u1ea5p v\u00e0o <strong>Freeze Panes<\/strong>.<\/li>\n\n\n\n<li>\u0110\u1ec3 c\u1ed1 \u0111\u1ecbnh <strong>2 h\u00e0ng v\u00e0 2 c\u1ed9t<\/strong>, ch\u1ecdn \u00f4 <strong>D3<\/strong>.<\/li>\n\n\n\n<li>\u0110\u1ec3 c\u1ed1 \u0111\u1ecbnh <strong>3 h\u00e0ng v\u00e0 3 c\u1ed9t<\/strong>, ch\u1ecdn \u00f4 <strong>F4<\/strong>&#8230;<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-15-1024x640.jpg\" alt=\" C\u00e1ch c\u1ed1 \u0111\u1ecbnh nhi\u1ec1u v\u00f9ng trong Excel.\" class=\"wp-image-118025\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-15-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-15-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-15-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-15-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-15-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-15-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-15-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-15-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-15-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-15-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-15.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\"> C\u00e1ch c\u1ed1 \u0111\u1ecbnh nhi\u1ec1u v\u00f9ng trong Excel.<\/figcaption><\/figure>\n\n\n\n<p>B\u1ea1n c\u0169ng c\u00f3 th\u1ec3 c\u1ed1 \u0111\u1ecbnh s\u1ed1 h\u00e0ng v\u00e0 c\u1ed9t kh\u00e1c nhau. V\u00ed d\u1ee5, \u0111\u1ec3 kh\u00f3a <strong>2 h\u00e0ng v\u00e0 3 c\u1ed9t<\/strong>, h\u00e3y ch\u1ecdn \u00f4 <strong>F3<\/strong>.<\/p>\n\n\n\n<h2><span class=\"ez-toc-section\" id=\"Xoa_go_bo_co_dinh_hang_cot_trong_Excel\"><\/span><strong>X\u00f3a, g\u1ee1 b\u1ecf c\u1ed1 \u0111\u1ecbnh h\u00e0ng, c\u1ed9t trong Excel<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Khi mu\u1ed1n h\u1ee7y c\u1ed1 \u0111\u1ecbnh d\u00f2ng trong Excel ho\u1eb7c c\u1ed9t trong Excel. H\u00e3y v\u00e0o th\u1ebb <strong>View<\/strong>, ch\u1ecdn <strong>Freeze Panes<\/strong>, sau \u0111\u00f3 nh\u1ea5p v\u00e0o <strong>Unfreeze Panes<\/strong>. Ngay l\u1eadp t\u1ee9c, c\u00e1c d\u00f2ng v\u00e0 c\u1ed9t \u0111\u00e3 c\u1ed1 \u0111\u1ecbnh tr\u01b0\u1edbc \u0111\u00f3 s\u1ebd \u0111\u01b0\u1ee3c b\u1ecf kh\u00f3a.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-16-1024x640.jpg\" alt=\"X\u00f3a, g\u1ee1 b\u1ecf c\u1ed1 \u0111\u1ecbnh h\u00e0ng, c\u1ed9t trong Excel.\" class=\"wp-image-118026\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-16-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-16-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-16-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-16-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-16-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-16-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-16-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-16-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-16-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-16-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/co-dinh-dong-trong-excel-16.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">X\u00f3a, g\u1ee1 b\u1ecf c\u1ed1 \u0111\u1ecbnh h\u00e0ng, c\u1ed9t trong Excel.<\/figcaption><\/figure>\n\n\n\n<h2><span class=\"ez-toc-section\" id=\"Tong_ket\"><\/span><strong>T\u1ed5ng k\u1ebft<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Nh\u00ecn chung, d\u00f9 b\u1ea1n \u0111ang qu\u1ea3n l\u00fd danh s\u00e1ch kh\u00e1ch h\u00e0ng, l\u1eadp b\u00e1o c\u00e1o t\u00e0i ch\u00ednh hay theo d\u00f5i ti\u1ebfn \u0111\u1ed9 d\u1ef1 \u00e1n, vi\u1ec7c c\u1ed1 \u0111\u1ecbnh d\u00f2ng trong Excel l\u00e0 m\u1ed9t thao t\u00e1c nh\u1ecf nh\u01b0ng l\u1ea1i mang \u0111\u1ebfn s\u1ef1 ti\u1ec7n l\u1ee3i l\u1edbn. N\u1eafm v\u1eefng k\u1ef9 n\u0103ng c\u1ed1 \u0111\u1ecbnh d\u00f2ng trong Excel, c\u1ed9t trong Excel n\u00e0y s\u1ebd gi\u00fap b\u1ea1n l\u00e0m vi\u1ec7c chuy\u00ean nghi\u1ec7p h\u01a1n, ti\u1ebft ki\u1ec7m th\u1eddi gian v\u00e0 n\u00e2ng cao \u0111\u1ed9 ch\u00ednh x\u00e1c khi x\u1eed l\u00fd d\u1eef li\u1ec7u.<\/p>\n\n\n\n<p>V\u00e0 ch\u1ec9 v\u1edbi v\u00e0i thao t\u00e1c c\u1ed1 \u0111\u1ecbnh d\u00f2ng trong Excel ho\u1eb7c nhi\u1ec1u d\u00f2ng, nhi\u1ec1u c\u1ed9t trong Excel tr\u00ean, b\u1ea1n c\u00f3 th\u1ec3 l\u00e0m vi\u1ec7c v\u1edbi b\u1ea3ng t\u00ednh d\u1ec5 d\u00e0ng h\u01a1n, kh\u00f4ng c\u00f2n lo m\u1ea5t d\u1ea5u d\u1eef li\u1ec7u quan tr\u1ecdng n\u1eefa. Phong v\u0169 ch\u00fac b\u1ea1n l\u00e0m vi\u1ec7c v\u1edbi Excel ng\u00e0y c\u00e0ng chuy\u00ean nghi\u1ec7p v\u00e0 qu\u1ea3n l\u00fd d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3 h\u01a1n nh\u00e9!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>B\u1ea1n \u0111\u00e3 bao gi\u1edd cu\u1ed9n xu\u1ed1ng m\u1ed9t danh s\u00e1ch d\u00e0i trong Excel v\u00e0 b\u1ed7ng d\u01b0ng qu\u00ean m\u1ea5t ti\u00eau \u0111\u1ec1 c\u1ed9t \u1edf tr\u00ean c\u00f9ng ch\u01b0a? Ho\u1eb7c khi l\u00e0m b\u00e1o c\u00e1o, b\u1ea1n c\u1ee9 ph\u1ea3i k\u00e9o qua k\u00e9o l\u1ea1i v\u00ec m\u1ea5t d\u1ea5u d\u00f2ng d\u1eef li\u1ec7u quan tr\u1ecdng? N\u1ebfu c\u00f3 th\u00ec \u0111\u00e2y ch\u00ednh l\u00e0 m\u1eb9o &#8220;c\u1ee9u nguy&#8221; cho b\u1ea1n! [&hellip;]<\/p>\n","protected":false},"author":13,"featured_media":118027,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false},"categories":[1029,24],"tags":[],"_links":{"self":[{"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/posts\/117693"}],"collection":[{"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/users\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/comments?post=117693"}],"version-history":[{"count":4,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/posts\/117693\/revisions"}],"predecessor-version":[{"id":120591,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/posts\/117693\/revisions\/120591"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/media\/118027"}],"wp:attachment":[{"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/media?parent=117693"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/categories?post=117693"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/tags?post=117693"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}