{"id":5092,"date":"2025-11-21T14:19:21","date_gmt":"2025-11-21T07:19:21","guid":{"rendered":"https:\/\/autofillform.com\/blog\/cach-tim-kiem-du-lieu-trong-excel-nhanh-chong-don-gian\/"},"modified":"2025-11-21T14:19:21","modified_gmt":"2025-11-21T07:19:21","slug":"cach-tim-kiem-du-lieu-trong-excel-nhanh-chong-don-gian","status":"publish","type":"post","link":"https:\/\/autofillform.com\/blog\/cach-tim-kiem-du-lieu-trong-excel-nhanh-chong-don-gian\/","title":{"rendered":"C\u00e1ch t\u00ecm ki\u1ebfm d\u1eef li\u1ec7u trong Excel nhanh ch\u00f3ng, \u0111\u01a1n gi\u1ea3n"},"content":{"rendered":"<div class=\"content_article\" id=\"clicklinka\">\n<div id=\"bxindexknh\">\u00a0<\/div>\n<p>C\u00e1c c\u00f4ng c\u1ee5 nh\u01b0 Find, Replace, t\u00ecm theo \u0111\u1ecbnh d\u1ea1ng hay ph\u00edm t\u1eaft, h\u1ed7 tr\u1ee3 b\u1ea1n tra c\u1ee9u th\u00f4ng tin nhanh h\u01a1n trong Excel, \u0111\u1eb7c bi\u1ec7t khi l\u00e0m vi\u1ec7c v\u1edbi b\u1ea3ng t\u00ednh l\u1edbn. Nh\u1eefng t\u00f9y ch\u1ecdn n\u00e0y gi\u00fap x\u00e1c \u0111\u1ecbnh d\u1eef li\u1ec7u ch\u00ednh x\u00e1c m\u00e0 kh\u00f4ng c\u1ea7n ki\u1ec3m tra th\u1ee7 c\u00f4ng. B\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y s\u1ebd h\u01b0\u1edbng d\u1eabn chi ti\u1ebft c\u00e1ch t\u00ecm ki\u1ebfm d\u1eef li\u1ec7u trong Excel v\u1edbi nhi\u1ec1u c\u00e1ch kh\u00e1c nhau \u0111\u1ec3 b\u1ea1n d\u1ec5 d\u00e0ng \u00e1p d\u1ee5ng.<\/p>\n<p><em><img decoding=\"async\" alt=\"C\u00e1ch t\u00ecm ki\u1ebfm d\u1eef li\u1ec7u trong Excel\" src=\"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/cach-tim-kiem-du-lieu-trong-excel.jpg\" title=\"cach-tim-kiem-du-lieu-trong-excel\">C\u00e1c c\u00e1ch t\u00ecm ki\u1ebfm d\u1eef li\u1ec7u trong Excel<\/em><\/p>\n<div class=\"titletab\" id=\"titletab1\">\n<h2>1. S\u1eed d\u1ee5ng Filter<\/h2>\n<\/div>\n<p><strong>B\u01b0\u1edbc 1:<\/strong> Ch\u1ecdn to\u00e0n b\u1ed9 v\u00f9ng d\u1eef li\u1ec7u c\u1ea7n thao t\u00e1c, sau \u0111\u00f3 v\u00e0o tab Home \u2192 Sort &amp; Filter \u2192 Filter \u0111\u1ec3 k\u00edch ho\u1ea1t t\u00ednh n\u0103ng l\u1ecdc.<\/p>\n<p><em><img decoding=\"async\" alt=\"B\u1eadt Filter trong tab Home\" src=\"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/cach-tim-kiem-du-lieu-trong-excel-1.jpg\" title=\"cach-tim-kiem-du-lieu-trong-excel-1\">B\u1eadt Filter trong tab Home \u0111\u1ec3 hi\u1ec3n th\u1ecb m\u0169i t\u00ean l\u1ecdc d\u1eef li\u1ec7u<\/em><\/p>\n<p><strong>B\u01b0\u1edbc 2: <\/strong>Sau khi b\u1eadt Filter, m\u0169i t\u00ean l\u1ecdc s\u1ebd xu\u1ea5t hi\u1ec7n t\u1ea1i t\u1eebng ti\u00eau \u0111\u1ec1 c\u1ed9t. B\u1ea1n nh\u1ea5p v\u00e0o m\u0169i t\u00ean c\u1ee7a c\u1ed9t mu\u1ed1n t\u00ecm ki\u1ebfm d\u1eef li\u1ec7u.<\/p>\n<p><em><img decoding=\"async\" alt=\"Nh\u1eadp n\u1ed9i dung c\u1ea7n t\u00ecm ki\u1ebfm v\u00e0o \u00f4\" src=\"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/cach-tim-kiem-du-lieu-trong-excel-2.jpg\" title=\"cach-tim-kiem-du-lieu-trong-excel-2\">Ch\u1ecdn bi\u1ec3u t\u01b0\u1ee3ng m\u0169i t\u00ean Filter v\u00e0 nh\u1eadp n\u1ed9i dung c\u1ea7n t\u00ecm ki\u1ebfm<\/em><\/p>\n<p><strong>B\u01b0\u1edbc 3:<\/strong> M\u1ed9t danh s\u00e1ch t\u00f9y ch\u1ecdn s\u1ebd hi\u1ec7n ra. T\u1ea1i \u00f4 Search, nh\u1eadp n\u1ed9i dung b\u1ea1n mu\u1ed1n l\u1ecdc. V\u00ed d\u1ee5 t\u00ecm ki\u1ebfm t\u00ean \u201cLinh\u201d, Excel s\u1ebd t\u1ef1 \u0111\u1ed9ng hi\u1ec3n th\u1ecb c\u00e1c gi\u00e1 tr\u1ecb kh\u1edbp trong danh s\u00e1ch b\u00ean d\u01b0\u1edbi. Ch\u1ecdn gi\u00e1 tr\u1ecb mong mu\u1ed1n v\u00e0 nh\u1ea5n OK \u0111\u1ec3 \u00e1p d\u1ee5ng.<\/p>\n<p><em><img decoding=\"async\" alt=\"K\u1ebft qu\u1ea3 sau khi l\u1ecdc\" src=\"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/cach-tim-kiem-du-lieu-trong-excel-3.jpg\" title=\"cach-tim-kiem-du-lieu-trong-excel-3\">K\u1ebft qu\u1ea3 d\u1eef li\u1ec7u \u0111\u00e3 l\u1ecdc theo t\u00ean qu\u1ea3n l\u00fd hi\u1ec3n th\u1ecb r\u00f5 r\u00e0ng<\/em><\/p>\n<div class=\"infobox\"><strong>Xem th\u00eam: <\/strong>C\u00e1ch d\u00f9ng h\u00e0m ROUNDDOWN trong Excel \u0111\u1ec3 l\u00e0m tr\u00f2n gi\u00e1 tr\u1ecb<\/div>\n<div class=\"titletab\" id=\"titletab2\">\n<h2>2. C\u00e1ch t\u00ecm ki\u1ebfm d\u1eef li\u1ec7u trong Excel b\u1eb1ng c\u00f4ng c\u1ee5 Find<\/h2>\n<\/div>\n<div class=\"titletab\" id=\"titletab2_1\">\n<h3>2.1 T\u00ecm ki\u1ebfm h\u00e0ng lo\u1ea1t<\/h3>\n<\/div>\n<p><strong>B\u01b0\u1edbc 1: <\/strong>Tr\u00ean tab Home, trong nh\u00f3m Editing, b\u1ea1n ch\u1ecdn Find &amp; Select \u2192 Find \u0111\u1ec3 m\u1edf c\u00f4ng c\u1ee5 t\u00ecm ki\u1ebfm. Ngo\u00e0i ra, b\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng ph\u00edm t\u1eaft Ctrl + F \u0111\u1ec3 truy c\u1eadp nhanh.<\/p>\n<p><em><img decoding=\"async\" alt=\"Ch\u1ecdn Find &amp; Select trong nh\u00f3m Editing\" src=\"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/cach-tim-kiem-du-lieu-trong-excel-4.jpg\" title=\"cach-tim-kiem-du-lieu-trong-excel-4\">Ch\u1ecdn Find &amp; Select trong nh\u00f3m Editing \u0111\u1ec3 m\u1edf c\u00f4ng c\u1ee5 t\u00ecm ki\u1ebfm<\/em><\/p>\n<p><strong>B\u01b0\u1edbc 2:<\/strong> Trong h\u1ed9p tho\u1ea1i Find and Replace, ch\u1ecdn tab Find, nh\u1eadp n\u1ed9i dung c\u1ea7n t\u00ecm ki\u1ebfm v\u00e0o \u00f4 Find what v\u00e0 nh\u1ea5n Find All. Danh s\u00e1ch k\u1ebft qu\u1ea3 s\u1ebd hi\u1ec7n ra, nh\u1ea5p v\u00e0o m\u1ed9t d\u00f2ng \u0111\u1ec3 chuy\u1ec3n ngay \u0111\u1ebfn \u00f4 ch\u1ee9a d\u1eef li\u1ec7u \u0111\u00f3.<\/p>\n<p><em><img decoding=\"async\" alt=\"Nh\u1eadp n\u1ed9i dung t\u00ecm ki\u1ebfm v\u00e0o \u00f4 Find\" src=\"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/cach-tim-kiem-du-lieu-trong-excel-5.jpg\" title=\"cach-tim-kiem-du-lieu-trong-excel-5\">Nh\u1eadp n\u1ed9i dung v\u00e0o \u00f4 Find what v\u00e0 xem k\u1ebft qu\u1ea3 b\u1eb1ng Find All<\/em><\/p>\n<div class=\"titletab\" id=\"titletab2_2\">\n<h3>2.2 T\u00ecm ki\u1ebfm \u1edf nhi\u1ec1u Sheets Excel c\u00f9ng l\u00fac<\/h3>\n<\/div>\n<p><strong>B\u01b0\u1edbc 1:<\/strong> Nh\u1ea5n Ctrl + F \u0111\u1ec3 m\u1edf h\u1ed9p tho\u1ea1i t\u00ecm ki\u1ebfm. Khi c\u1eeda s\u1ed5 xu\u1ea5t hi\u1ec7n, ch\u1ecdn Options &gt;&gt; \u0111\u1ec3 m\u1edf r\u1ed9ng c\u00e1c t\u00f9y ch\u1ecdn n\u00e2ng cao.<\/p>\n<p><strong>B\u01b0\u1edbc 2:<\/strong> \u1ede m\u1ee5c Within, chuy\u1ec3n sang Workbook \u0111\u1ec3 t\u00ecm tr\u00ean to\u00e0n b\u1ed9 c\u00e1c sheet. Nh\u1eadp n\u1ed9i dung c\u1ea7n tra c\u1ee9u v\u00e0o \u00f4 Find what, sau \u0111\u00f3 b\u1ea5m Find All. Excel s\u1ebd li\u1ec7t k\u00ea t\u1ea5t c\u1ea3 v\u1ecb tr\u00ed ch\u1ee9a d\u1eef li\u1ec7u kh\u1edbp trong to\u00e0n file. Nh\u1ea5p v\u00e0o m\u1ed9t d\u00f2ng b\u1ea5t k\u1ef3 \u0111\u1ec3 di chuy\u1ec3n ngay \u0111\u1ebfn \u00f4 t\u01b0\u01a1ng \u1ee9ng.<\/p>\n<p><em><img decoding=\"async\" alt=\"Thi\u1ebft l\u1eadp \u0111i\u1ec1u ki\u1ec7n t\u00ecm ki\u1ebfm trong h\u1ed9p tho\u1ea1i\" src=\"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/cach-tim-kiem-du-lieu-trong-excel-6.jpg\" title=\"cach-tim-kiem-du-lieu-trong-excel-6\">M\u1edf t\u00f9y ch\u1ecdn n\u00e2ng cao \u0111\u1ec3 thi\u1ebft l\u1eadp \u0111i\u1ec1u ki\u1ec7n t\u00ecm ki\u1ebfm chi ti\u1ebft h\u01a1n<\/em><\/p>\n<div class=\"titletab\" id=\"titletab2_3\">\n<h3>2.3 T\u00ecm ki\u1ebfm theo Format<\/h3>\n<\/div>\n<p><strong>B\u01b0\u1edbc 1: <\/strong>Nh\u1ea5n Ctrl + F \u0111\u1ec3 m\u1edf h\u1ed9p tho\u1ea1i Find &amp; Replace. T\u1ea1i c\u1eeda s\u1ed5 n\u00e0y, ch\u1ecdn Options &gt;&gt;, sau \u0111\u00f3 b\u1ea5m v\u00e0o m\u1ee5c Format Find \u2192Format \u0111\u1ec3 thi\u1ebft l\u1eadp ki\u1ec3u \u0111\u1ecbnh d\u1ea1ng b\u1ea1n mu\u1ed1n t\u00ecm.<\/p>\n<p><em><img decoding=\"async\" alt=\"Ch\u1ecdn \u0111\u1ecbnh d\u1ea1ng c\u1ea7n t\u00ecm qua b\u1ea3ng Format\" src=\"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/cach-tim-kiem-du-lieu-trong-excel-7.jpg\" title=\"cach-tim-kiem-du-lieu-trong-excel-7\">Ch\u1ecdn \u0111\u1ecbnh d\u1ea1ng c\u1ea7n t\u00ecm th\u00f4ng qua b\u1ea3ng Format trong Find &amp; Replace<\/em><\/p>\n<p><strong>B\u01b0\u1edbc 2: <\/strong>N\u1ebfu b\u1ea1n mu\u1ed1n truy t\u00ecm c\u00e1c \u00f4 c\u00f3 \u0111\u1ecbnh d\u1ea1ng gi\u1ed1ng m\u1ed9t \u00f4 b\u1ea5t k\u1ef3 trong b\u1ea3ng t\u00ednh, h\u00e3y \u0111\u1ec3 tr\u1ed1ng \u00f4 Find what, nh\u1ea5p v\u00e0o m\u0169i t\u00ean b\u00ean c\u1ea1nh Format, ch\u1ecdn Choose Format From Cell, r\u1ed3i b\u1ea5m v\u00e0o \u00f4 c\u00f3 ki\u1ec3u \u0111\u1ecbnh d\u1ea1ng c\u1ea7n s\u1eed d\u1ee5ng l\u00e0m m\u1eabu.<\/p>\n<p><em><img decoding=\"async\" alt=\"Ch\u1ecdn \u0111\u1ecbnh d\u1ea1ng m\u1eabu t\u1eeb Choose Format From Cell\" src=\"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/cach-tim-kiem-du-lieu-trong-excel-8.jpg\" title=\"cach-tim-kiem-du-lieu-trong-excel-8\">L\u1ea5y \u0111\u1ecbnh d\u1ea1ng m\u1eabu t\u1eeb \u00f4 b\u1ea5t k\u1ef3 b\u1eb1ng Choose Format From Cell<\/em><\/p>\n<div class=\"titletab\" id=\"titletab2_4\">\n<h3>2.4 T\u00ecm ki\u1ebfm \u00f4 c\u00f3 c\u00f4ng th\u1ee9c<\/h3>\n<\/div>\n<p><strong>B\u01b0\u1edbc 1:<\/strong> Ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u c\u1ea7n ki\u1ec3m tra ho\u1eb7c \u0111\u1eb7t con tr\u1ecf t\u1ea1i b\u1ea5t k\u1ef3 \u00f4 n\u00e0o n\u1ebfu b\u1ea1n mu\u1ed1n t\u00ecm tr\u00ean to\u00e0n trang t\u00ednh. Ti\u1ebfp theo, v\u00e0o Find &amp; Select v\u00e0 ch\u1ecdn Go to Special.<\/p>\n<p><strong>B\u01b0\u1edbc 2: <\/strong>Khi h\u1ed9p tho\u1ea1i Go to Special xu\u1ea5t hi\u1ec7n, ch\u1ecdn Formulas v\u00e0 tick v\u00e0o lo\u1ea1i gi\u00e1 tr\u1ecb mu\u1ed1n tra c\u1ee9u. Sau \u0111\u00f3 nh\u1ea5n OK \u0111\u1ec3 Excel t\u00f4 s\u00e1ng c\u00e1c \u00f4 t\u01b0\u01a1ng \u1ee9ng.<\/p>\n<p><strong>\u00dd ngh\u0129a t\u1eebng l\u1ef1a ch\u1ecdn:<\/strong><\/p>\n<ul>\n<li><strong>Numbers:<\/strong> X\u00e1c \u0111\u1ecbnh c\u00e1c \u00f4 c\u00f3 c\u00f4ng th\u1ee9c tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb d\u1ea1ng s\u1ed1 (bao g\u1ed3m c\u1ea3 ng\u00e0y th\u00e1ng).<\/li>\n<li><strong>Text:<\/strong> T\u00ecm nh\u1eefng c\u00f4ng th\u1ee9c cho k\u1ebft qu\u1ea3 l\u00e0 chu\u1ed7i v\u0103n b\u1ea3n.<\/li>\n<li><strong>Logicals: <\/strong>Hi\u1ec3n th\u1ecb c\u00e1c \u00f4 tr\u1ea3 v\u1ec1 TRUE ho\u1eb7c FALSE.<\/li>\n<li><strong>Errors:<\/strong> X\u00e1c \u0111\u1ecbnh c\u00e1c c\u00f4ng th\u1ee9c sinh l\u1ed7i nh\u01b0 #N\/A, #NAME?, #REF!, #VALUE!, #DIV\/0!, #NULL!, #NUM!.<\/li>\n<\/ul>\n<p><em><img decoding=\"async\" alt=\"D\u00f9ng Go To Special \u0111\u1ec3 l\u1ecdc c\u00e1c \u00f4\" src=\"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/cach-tim-kiem-du-lieu-trong-excel-9.jpg\" title=\"cach-tim-kiem-du-lieu-trong-excel-9\">D\u00f9ng Go To Special \u0111\u1ec3 l\u1ecdc c\u00e1c \u00f4 ch\u1ee9a c\u00f4ng th\u1ee9c theo lo\u1ea1i<\/em><\/p>\n<div class=\"titletab\" id=\"titletab3\">\n<h2>3. T\u00ecm ki\u1ebfm v\u00e0 thay th\u1ebf d\u1eef li\u1ec7u trong Excel<\/h2>\n<\/div>\n<div class=\"titletab\" id=\"titletab3_1\">\n<h3>3.1 T\u00ecm ki\u1ebfm v\u00e0 thay th\u1ebf m\u1ed9t gi\u00e1 tr\u1ecb b\u1eb1ng m\u1ed9t gi\u00e1 tr\u1ecb kh\u00e1c<\/h3>\n<\/div>\n<p><strong>B\u01b0\u1edbc 1:<\/strong> Nh\u1ea5n Ctrl + H \u0111\u1ec3 m\u1edf h\u1ed9p tho\u1ea1i Find and Replace.<\/p>\n<p><strong>B\u01b0\u1edbc 2: <\/strong>Chuy\u1ec3n sang tab Replace, Trong \u00f4 Find what, nh\u1eadp n\u1ed9i dung c\u1ea7n t\u00ecm v\u00e0o \u00f4 Find What, sau \u0111\u00f3 t\u1ea1i \u00f4 Replace with, nh\u1eadp gi\u00e1 tr\u1ecb mu\u1ed1n thay th\u1ebf.<\/p>\n<p>Cu\u1ed1i c\u00f9ng ch\u1ecdn Replace All \u0111\u1ec3 \u00e1p d\u1ee5ng cho to\u00e0n b\u1ed9 d\u1eef li\u1ec7u kh\u1edbp trong b\u1ea3ng t\u00ednh.<\/p>\n<p><em><img decoding=\"async\" alt=\"Thi\u1ebft l\u1eadp n\u1ed9i dung Find v\u00e0 Replace\" src=\"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/cach-tim-kiem-du-lieu-trong-excel-10.jpg\" title=\"cach-tim-kiem-du-lieu-trong-excel-10\">Thi\u1ebft l\u1eadp n\u1ed9i dung Find v\u00e0 Replace tr\u01b0\u1edbc khi thay th\u1ebf h\u00e0ng lo\u1ea1t<\/em><\/p>\n<div class=\"titletab\" id=\"titletab3_2\">\n<h3>3.2 Thay th\u1ebf v\u0103n b\u1ea3n ho\u1eb7c s\u1ed1 v\u1edbi kho\u1ea3ng tr\u1eafng<\/h3>\n<\/div>\n<p>\u0110\u1ec3 thay n\u1ed9i dung t\u00ecm \u0111\u01b0\u1ee3c b\u1eb1ng kho\u1ea3ng tr\u1eafng, tr\u01b0\u1edbc ti\u00ean nh\u1ea5n Ctrl + H \u0111\u1ec3 m\u1edf h\u1ed9p tho\u1ea1i Replace. Nh\u1eadp gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm v\u00e0o \u00f4 Find what, \u0111\u1ec3 tr\u1ed1ng \u00f4 Replace with, r\u1ed3i ch\u1ecdn Replace All \u0111\u1ec3 x\u00f3a to\u00e0n b\u1ed9 n\u1ed9i dung kh\u1edbp.<\/p>\n<p><em><img decoding=\"async\" alt=\"Nh\u1eadp gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm v\u00e0 ch\u1ecdn Replace All\" src=\"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/cach-tim-kiem-du-lieu-trong-excel-11.jpg\" title=\"cach-tim-kiem-du-lieu-trong-excel-11\">Nh\u1eadp gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm v\u00e0 ch\u1ecdn Replace All \u0111\u1ec3 thay \u0111\u1ed3ng lo\u1ea1t<\/em><\/p>\n<div class=\"titletab\" id=\"titletab3_3\">\n<h3>3.3 T\u00ecm ki\u1ebfm v\u00e0 thay th\u1ebf d\u1eef li\u1ec7u v\u1edbi k\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n<\/h3>\n<\/div>\n<p>Khi c\u1ea7n t\u00ecm ch\u00ednh x\u00e1c d\u1ea5u * ho\u1eb7c ? trong b\u1ea3ng t\u00ednh, b\u1ea1n ph\u1ea3i th\u00eam k\u00fd t\u1ef1 ~ ph\u00eda tr\u01b0\u1edbc \u0111\u1ec3 Excel hi\u1ec3u \u0111\u00e2y l\u00e0 k\u00fd t\u1ef1 th\u1eadt, kh\u00f4ng ph\u1ea3i k\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n.<\/p>\n<p><strong>V\u00ed d\u1ee5:<\/strong> N\u1ebfu mu\u1ed1n t\u00ecm c\u00e1c \u00f4 c\u00f3 ch\u1ee9a d\u1ea5u h\u1ecfi, h\u00e3y nh\u1eadp ~? v\u00e0o \u00f4 Find what. N\u1ebfu mu\u1ed1n thay t\u1ea5t c\u1ea3 d\u1ea5u ? \u0111\u00f3 b\u1eb1ng d\u1ea5u *, ch\u1ec9 c\u1ea7n nh\u1eadp * v\u00e0o Replace with v\u00e0 th\u1ef1c hi\u1ec7n l\u1ec7nh thay th\u1ebf.<\/p>\n<p><em><img decoding=\"async\" alt=\"Thao t\u00e1c t\u00ecm ki\u1ebfm v\u00e0 thay th\u1ebf k\u00fd t\u1ef1\" src=\"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/cach-tim-kiem-du-lieu-trong-excel-12.jpg\" title=\"cach-tim-kiem-du-lieu-trong-excel-12\">Thao t\u00e1c t\u00ecm ki\u1ebfm v\u00e0 thay th\u1ebf k\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n<\/em><\/p>\n<div class=\"titletab\" id=\"titletab4\">\n<h2>4. S\u1eed d\u1ee5ng ph\u00edm t\u1eaft \u0111\u1ec3 t\u00ecm ki\u1ebfm<\/h2>\n<\/div>\n<p>B\u1ea1n c\u00f3 th\u1ec3 thao t\u00e1c nhanh h\u01a1n khi t\u00ecm ho\u1eb7c thay th\u1ebf d\u1eef li\u1ec7u b\u1eb1ng c\u00e1c ph\u00edm t\u1eaft sau:<\/p>\n<ul>\n<li><strong>Ctrl + F:<\/strong> M\u1edf nhanh c\u00f4ng c\u1ee5 Find.<\/li>\n<li><strong>Ctrl + H: <\/strong>Truy c\u1eadp h\u1ed9p tho\u1ea1i Replace.<\/li>\n<li><strong>Ctrl + Shift + F4:<\/strong> Quay l\u1ea1i k\u1ebft qu\u1ea3 t\u00ecm ki\u1ebfm tr\u01b0\u1edbc \u0111\u00f3.<\/li>\n<li><strong>Shift + F4:<\/strong> Chuy\u1ec3n \u0111\u1ebfn k\u1ebft qu\u1ea3 kh\u1edbp ti\u1ebfp theo.<\/li>\n<li><strong>Ctrl + J:<\/strong> T\u00ecm ho\u1eb7c thay th\u1ebf k\u00fd t\u1ef1 xu\u1ed1ng d\u00f2ng trong \u00f4.<\/li>\n<\/ul>\n<p>Nh\u1eefng ph\u01b0\u01a1ng ph\u00e1p t\u00ecm ki\u1ebfm trong Excel v\u1eeba gi\u00fap r\u00fat ng\u1eafn th\u1eddi gian thao t\u00e1c, v\u1eeba h\u1ed7 tr\u1ee3 b\u1ea1n ki\u1ec3m so\u00e1t d\u1eef li\u1ec7u ch\u00ednh x\u00e1c h\u01a1n. \u00c1p d\u1ee5ng linh ho\u1ea1t c\u00e1c c\u00f4ng c\u1ee5 n\u00e0y s\u1ebd khi\u1ebfn vi\u1ec7c x\u1eed l\u00fd b\u1ea3ng t\u00ednh tr\u1edf n\u00ean nh\u1eb9 nh\u00e0ng h\u01a1n r\u1ea5t nhi\u1ec1u. \u0110\u1eebng qu\u00ean theo d\u00f5i chuy\u00ean m\u1ee5c Kinh nghi\u1ec7m c\u1ee7a Si\u00eau Th\u1ecb \u0110i\u1ec7n M\u00e1y &#8211; N\u1ed9i Th\u1ea5t Ch\u1ee3 L\u1edbn \u0111\u1ec3 c\u1eadp nh\u1eadt th\u00eam nhi\u1ec1u m\u1eb9o hay kh\u00e1c.<\/p>\n<p>N\u1ebfu b\u1ea1n \u0111ang c\u1ea7n n\u00e2ng c\u1ea5p thi\u1ebft b\u1ecb \u0111\u1ec3 l\u00e0m vi\u1ec7c tr\u00ean Excel m\u01b0\u1ee3t m\u00e0 h\u01a1n, h\u00e3y tham kh\u1ea3o c\u00e1c m\u1eabu \u0111i\u1ec7n tho\u1ea1i, m\u00e1y t\u00ednh b\u1ea3ng t\u1ea1i Si\u00eau Th\u1ecb \u0110i\u1ec7n M\u00e1y &#8211; N\u1ed9i Th\u1ea5t Ch\u1ee3 L\u1edbn, v\u1edbi nhi\u1ec1u \u01b0u \u0111\u00e3i h\u1ea5p d\u1eabn.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u00a0 C\u00e1c c\u00f4ng c\u1ee5 nh\u01b0 Find, Replace, t\u00ecm theo \u0111\u1ecbnh d\u1ea1ng hay ph\u00edm t\u1eaft, h\u1ed7 tr\u1ee3 b\u1ea1n tra c\u1ee9u th\u00f4ng tin nhanh h\u01a1n trong Excel, \u0111\u1eb7c bi\u1ec7t khi l\u00e0m vi\u1ec7c v\u1edbi b\u1ea3ng t\u00ednh l\u1edbn. Nh\u1eefng t\u00f9y ch\u1ecdn n\u00e0y gi\u00fap x\u00e1c \u0111\u1ecbnh d\u1eef li\u1ec7u ch\u00ednh x\u00e1c m\u00e0 kh\u00f4ng c\u1ea7n ki\u1ec3m tra th\u1ee7 c\u00f4ng. B\u00e0i vi\u1ebft d\u01b0\u1edbi [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":5093,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-5092","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-thu-thuat"],"jetpack_featured_media_url":"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/19409.jpg","_links":{"self":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts\/5092","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/comments?post=5092"}],"version-history":[{"count":0,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts\/5092\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/media\/5093"}],"wp:attachment":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/media?parent=5092"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/categories?post=5092"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/tags?post=5092"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}