{"id":283510,"date":"2023-11-10T22:26:56","date_gmt":"2023-11-10T15:26:56","guid":{"rendered":"https:\/\/hoanghamobile.com\/tin-tuc\/?p=283510"},"modified":"2023-11-10T22:26:56","modified_gmt":"2023-11-10T15:26:56","slug":"sap-xep-trong-excel","status":"publish","type":"post","link":"https:\/\/hoanghamobile.com\/tin-tuc\/sap-xep-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn s\u1eafp x\u1ebfp trong Excel: C\u00e1ch s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng Sort"},"content":{"rendered":"<p><b>S\u1eafp x\u1ebfp trong Excel<\/b><span style=\"font-weight: 400;\"> l\u00e0 m\u1ed9t ph\u01b0\u01a1ng ph\u00e1p x\u1eed l\u00fd v\u00e0 qu\u1ea3n l\u00fd d\u1eef li\u1ec7u hi\u1ec7u qu\u1ea3 h\u01a1n trong c\u00f4ng vi\u1ec7c m\u00e0 ng\u01b0\u1eddi d\u00f9ng c\u1ea7n bi\u1ebft \u0111\u1ebfn. \u0110\u1ec3 gi\u00fap b\u1ea1n d\u1ec5 d\u00e0ng th\u1ef1c hi\u1ec7n thao t\u00e1c n\u00e0y, Microsoft Excel \u0111\u00e3 t\u00edch h\u1ee3p s\u1eb5n t\u00ednh n\u0103ng Sort. \u0110\u00e2y l\u00e0 c\u00f4ng c\u1ee5 gi\u00fap s\u1eafp x\u1ebfp d\u1eef li\u1ec7u trong ph\u1ea1m vi b\u1ea3ng t\u00ednh theo c\u00e1c ti\u00eau ch\u00ed, t\u00f9y thu\u1ed9c v\u00e0o l\u1ef1a ch\u1ecdn c\u1ee7a ng\u01b0\u1eddi s\u1eed d\u1ee5ng. <\/span><\/p>\n<p><span style=\"font-weight: 400;\">V\u1eady Sort l\u00e0 g\u00ec? L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 s\u1eafp x\u1ebfp d\u1eef li\u1ec7u trong b\u1ea3ng t\u00ednh m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3 m\u00e0 kh\u00f4ng x\u1ea3y ra sai s\u00f3t? Trong b\u00e0i vi\u1ebft h\u00f4m nay, <\/span><b>Ho\u00e0ng H\u00e0 Mobile <\/b><span style=\"font-weight: 400;\">s\u1ebd gi\u1edbi thi\u1ec7u cho b\u1ea1n ch\u1ee9c n\u0103ng s\u1eafp x\u1ebfp data trong b\u1ea3ng t\u00ednh v\u1edbi Sort v\u1edbi c\u00e1c h\u01b0\u1edbng d\u1eabn chi ti\u1ebft nh\u1ea5t v\u1ec1 c\u00e1ch th\u1ef1c hi\u1ec7n v\u00e0 kh\u1eafc ph\u1ee5c l\u1ed7i.<\/span><\/p>\n<h2><b>Gi\u1edbi thi\u1ec7u v\u1ec1 ch\u1ee9c n\u0103ng Sort gi\u00fap s\u1eafp x\u1ebfp trong Excel<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">Sort l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 \u0111\u01b0\u1ee3c t\u00edch h\u1ee3p trong b\u1ea3ng Sort &amp; Filter trong tab Data c\u1ee7a Microsoft Excel, c\u00f3 ch\u1ee9c n\u0103ng ch\u00ednh l\u00e0 s\u1eafp x\u1ebfp d\u1eef li\u1ec7u theo c\u00e1c ti\u00eau ch\u00ed nh\u1ea5t \u0111\u1ecbnh. Ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 s\u1eafp x\u1ebfp theo th\u1ee9 t\u1ef1 t\u0103ng gi\u1ea3m, theo b\u1ea3ng ch\u1eef c\u00e1i, theo m\u00e0u s\u1eafc ho\u1eb7c theo c\u00e1c bi\u1ebfn chuy\u00ean d\u1ee5ng \u0111\u01b0\u1ee3c li\u1ec7t k\u00ea trong b\u1ea3ng t\u00ednh. Nh\u1edd v\u1eady m\u00e0 vi\u1ec7c quan s\u00e1t v\u00e0 qu\u1ea3n l\u00fd c\u00e1c th\u00f4ng tin \u0111\u01b0\u1ee3c nh\u1eadp li\u1ec7u tr\u1edf n\u00ean d\u1ec5 d\u00e0ng h\u01a1n, tr\u1ef1c quan h\u01a1n v\u00e0 mang \u0111\u1ebfn t\u00ednh logic, khoa h\u1ecdc cho b\u1ea3ng t\u00ednh c\u1ee7a b\u1ea1n.<\/span><\/p>\n<p><img fetchpriority=\"high\" decoding=\"async\" class=\"aligncenter size-full wp-image-283512\" src=\"https:\\\/\\\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/sap-xep-trong-excel-1.jpg\" alt=\"sap-xep-trong-excel-1\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/sap-xep-trong-excel-1.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/sap-xep-trong-excel-1-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/sap-xep-trong-excel-1-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">Ch\u1ee9c n\u0103ng s\u1eafp x\u1ebfp trong Excel &#8211; Sort th\u01b0\u1eddng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng k\u00e8m v\u1edbi Filter \u0111\u1ec3 l\u1ecdc v\u00e0 x\u1ebfp c\u00e1c gi\u00e1 tr\u1ecb trong ph\u1ea1m vi m\u1ed9t ho\u1eb7c nhi\u1ec1u c\u1ed9t c\u1ee7a trang t\u00ednh. Thay v\u00ec ph\u1ea3i x\u1ebfp d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch th\u1ee7 c\u00f4ng, ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 ti\u1ebft ki\u1ec7m th\u1eddi gian v\u00e0 c\u00f4ng s\u1ee9c b\u1eb1ng c\u00e1ch s\u1eafp x\u1ebfp t\u1ef1 \u0111\u1ed9ng v\u1edbi thao t\u00e1c tr\u00ean Sort. Ph\u01b0\u01a1ng ph\u00e1p n\u00e0y \u0111\u01b0\u1ee3c \u1ee9ng d\u1ee5ng v\u1edbi c\u00e1c b\u1ea3ng t\u00ednh ch\u1ee9a l\u01b0\u1ee3ng d\u1eef li\u1ec7u l\u1edbn, kh\u00f3 th\u1ec3 l\u1ecdc b\u1eb1ng tay. B\u00ean c\u1ea1nh \u0111\u00f3, b\u1ea1n c\u00f3 th\u1ec3 ho\u00e0n to\u00e0n y\u00ean t\u00e2m khi s\u1eed d\u1ee5ng Sort. Ch\u1ec9 c\u1ea7n ng\u01b0\u1eddi d\u00f9ng thao t\u00e1c \u0111\u00fang theo tr\u00ecnh t\u1ef1 c\u00e1c b\u01b0\u1edbc \u0111\u01b0\u1ee3c h\u01b0\u1edbng d\u1eabn, c\u00f4ng c\u1ee5 n\u00e0y s\u1ebd tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 ch\u00ednh x\u00e1c v\u00e0 ph\u00f9 h\u1ee3p nh\u1ea5t.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">C\u00f3 th\u1ec3 th\u1ea5y, Sort l\u00e0 m\u1ed9t t\u00ednh n\u0103ng quan tr\u1ecdng m\u00e0 ai d\u00f9ng Excel c\u00f9ng c\u1ea7n bi\u1ebft \u0111\u1ebfn \u0111\u1ec3 s\u1eed d\u1ee5ng trong c\u00f4ng vi\u1ec7c. V\u1eady b\u1ea1n \u0111\u00e3 bi\u1ebft c\u00e1ch t\u1eadn d\u1ee5ng tri\u1ec7t \u0111\u1ec3 ch\u1ee9c n\u0103ng n\u00e0y? Ph\u1ea7n ti\u1ebfp theo sau \u0111\u00e2y s\u1ebd cung c\u1ea5p h\u01b0\u1edbng d\u1eabn c\u00e1ch sort t\u1eeb c\u01a1 b\u1ea3n \u0111\u1ebfn n\u00e2ng cao, ph\u00f9 h\u1ee3p v\u1edbi c\u1ea3 ng\u01b0\u1eddi m\u1edbi b\u1eaft \u0111\u1ea7u h\u1ecdc d\u00f9ng Excel.<\/span><\/p>\n<h2><b>H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eafp x\u1ebfp trong Excel v\u1edbi ch\u1ee9c n\u0103ng Sort<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">V\u1edbi m\u1ed9t b\u1ea3ng d\u1eef li\u1ec7u ch\u01b0a \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp, ng\u01b0\u1eddi d\u00f9ng s\u1ebd g\u1eb7p kh\u00f3 kh\u0103n khi theo d\u00f5i c\u00e1c th\u00f4ng tin b\u1edfi ch\u00fang kh\u00f4ng theo m\u1ed9t tr\u00ecnh t\u1ef1 nh\u1ea5t \u0111\u1ecbnh. V\u00ed d\u1ee5 \u0111i\u1ec3n h\u00ecnh nh\u01b0 danh s\u00e1ch h\u1ecd v\u00e0 t\u00ean, vi\u1ec7c s\u1eafp x\u1ebfp theo b\u1ea3ng ch\u1eef c\u00e1i t\u1eeb A \u0111\u1ebfn Z s\u1ebd gi\u00fap b\u1ea1n d\u1ec5 d\u00e0ng tra c\u1ee9u th\u00f4ng tin h\u01a1n l\u00e0 c\u00e1c d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c nh\u1eadp ng\u1eabu nhi\u00ean. V\u00ec v\u1eady, ng\u01b0\u1eddi d\u00f9ng c\u1ea7n bi\u1ebft c\u00e1ch s\u1eed d\u1ee5ng Sort \u0111\u1ec3 x\u1ebfp l\u1ea1i d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch nhanh ch\u00f3ng v\u00e0 ch\u00ednh x\u00e1c nh\u1ea5t. C\u00f4ng c\u1ee5 Sort \u0111em \u0111\u1ebfn nh\u1eefng ti\u00eau ch\u00ed v\u00f4 c\u00f9ng th\u00f4ng minh, \u0111\u00e1p \u1ee9ng m\u1ecdi nhu c\u1ea7u c\u1ee7a b\u1ea1n. B\u00ean c\u1ea1nh \u0111\u00f3, \u0111\u1ed1i v\u1edbi m\u1ed9t v\u00e0i ti\u00eau ch\u00ed x\u1ebfp c\u01a1 b\u1ea3n, ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 tr\u1ef1c ti\u1ebfp d\u00f9ng n\u00fat t\u1eaft tr\u00ean thanh c\u00f4ng c\u1ee5 thay v\u00ec ph\u1ea3i thao t\u00e1c tr\u00ean b\u1ea3ng Sort.<\/span><\/p>\n<h3><b>T\u00ecm hi\u1ec3u nhanh c\u00e1ch ch\u1ee9c n\u0103ng trong b\u1ea3ng Sort<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">Khi l\u1ef1a ch\u1ecdn t\u00ednh n\u0103ng Sort trong th\u1ebb Data, ng\u01b0\u1eddi d\u00f9ng s\u1ebd c\u1ea7n thao t\u00e1c v\u00e0 l\u1ef1a ch\u1ecdn ti\u00eau ch\u00ed s\u1eafp x\u1ebfp trong Excel t\u1ea1i m\u1ed9t b\u1ea3ng c\u00f4ng c\u1ee5 \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb tr\u00ean m\u00e0n h\u00ecnh. Ch\u1ee9c n\u0103ng Sort mang \u0111\u1ebfn nh\u1eefng ti\u00eau ch\u00ed v\u00f4 c\u00f9ng th\u00f4ng minh v\u00e0 ti\u1ec7n l\u1ee3i, d\u00f9 b\u1ea1n mu\u1ed1n x\u1ebfp theo d\u1ea1ng n\u00e0o c\u0169ng c\u00f3 th\u1ec3 \u0111\u00e1p \u1ee9ng. \u0110\u1ec3 c\u00f3 th\u1ec3 thao t\u00e1c \u0111\u00fang v\u00e0 cho ra k\u1ebft qu\u1ea3 ch\u00ednh x\u00e1c nh\u1ea5t, ng\u01b0\u1eddi d\u00f9ng c\u1ea7n n\u1eafm r\u00f5 c\u00e1c ch\u1ee9c n\u0103ng nh\u01b0 sau.<\/span><\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-283513\" src=\"https:\\\/\\\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/sap-xep-trong-excel-2.jpg\" alt=\"sap-xep-trong-excel-2\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/sap-xep-trong-excel-2.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/sap-xep-trong-excel-2-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/sap-xep-trong-excel-2-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">C\u00e1c ch\u1ee9c n\u0103ng ch\u00ednh trong b\u1ea3ng Sort:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Add Level:<\/b><span style=\"font-weight: 400;\"> Th\u00eam c\u1ea5p \u0111\u1ed9 s\u1eafp x\u1ebfp cho b\u1ea3ng t\u00ednh, c\u1ee5 th\u1ec3 l\u00e0 th\u00eam c\u00e1c m\u1ee5c Then by sau Sort by.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Delete Level:<\/b><span style=\"font-weight: 400;\"> X\u00f3a c\u00e1c c\u1ea5p \u0111\u1ed9 Then by \u0111\u00e3 \u0111\u01b0\u1ee3c th\u00eam n\u1ebfu kh\u00f4ng d\u00f9ng t\u1edbi.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Copy Level:<\/b><span style=\"font-weight: 400;\"> Sao ch\u00e9p c\u1ea5p \u0111\u1ed9 Sort gi\u1ed1ng v\u1edbi c\u00e1c v\u1eeba t\u1ea1o v\u00e0 th\u00eam v\u00e0o b\u00ean d\u01b0\u1edbi.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Options:<\/b><span style=\"font-weight: 400;\"> Bao g\u1ed3m c\u00e1c ch\u1ee9c n\u0103ng ph\u00e2n bi\u1ec7t ch\u1eef vi\u1ebft hoa v\u00e0 vi\u1ebft th\u01b0\u1eddng (Case Sensitive) v\u00e0 \u0111\u1ecbnh h\u01b0\u1edbng s\u1eafp x\u1ebfp (Orientation), trong \u0111\u00f3 c\u00f3 Sort top to bottom (theo c\u1ed9t) v\u00e0 Sort left to right (theo h\u00e0ng).<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">C\u00e1c thao t\u00e1c c\u1ea7n th\u1ef1c hi\u1ec7n trong b\u1ea3ng Sort:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Sort by &amp; Then by: <\/b><span style=\"font-weight: 400;\">C\u00e1c h\u00e0ng ho\u1eb7c c\u1ed9t \u0111\u01b0\u1ee3c l\u1ef1a ch\u1ecdn \u0111\u1ec3 s\u1eafp x\u1ebfp v\u1edbi th\u1ee9 t\u1ef1 \u01b0u ti\u00ean Sort t\u1eeb tr\u00ean xu\u1ed1ng d\u01b0\u1edbi.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Sort On:<\/b><span style=\"font-weight: 400;\"> L\u1ef1a ch\u1ecdn ki\u1ec3u s\u1eafp x\u1ebfp theo gi\u00e1 tr\u1ecb (Values), m\u00e0u \u00f4 (Cell Color), m\u00e0u ch\u1eef (Font Color) v\u00e0 bi\u1ec3u t\u01b0\u1ee3ng trong \u00f4 (Cell Icon).<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Order:<\/b><span style=\"font-weight: 400;\"> L\u1ef1a ch\u1ecdn th\u1ee9 t\u1ef1 Sort bao g\u1ed3m theo b\u1ea3ng ch\u1eef c\u00e1i, th\u1ee9 t\u1ef1 t\u0103ng gi\u1ea3m, v\u00e0 c\u00e1c ti\u00eau ch\u00ed c\u1ee5 th\u1ec3 kh\u00e1c trong Custom list.<\/span><\/li>\n<\/ul>\n<h3><b>S\u1eafp x\u1ebfp d\u1eef li\u1ec7u theo th\u1ee9 t\u1ef1 \u0111\u01a1n gi\u1ea3n trong Excel<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">\u0110\u1ed1i v\u1edbi c\u00e1c ti\u00eau ch\u00ed s\u1eafp x\u1ebfp trong Excel \u0111\u01a1n gi\u1ea3n nh\u01b0 t\u1eeb tr\u00ean xu\u1ed1ng d\u01b0\u1edbi, ng\u01b0\u1eddi d\u00f9ng kh\u00f4ng c\u1ea7n ph\u1ea3i thao t\u00e1c trong b\u1ea3ng Sort. Microsoft Excel \u0111\u00e3 t\u1ea1o nh\u1eefng n\u00fat t\u1eaft ti\u1ec7n l\u1ee3i ngay tr\u00ean thanh c\u00f4ng c\u1ee5, cho ph\u00e9p b\u1ea1n s\u1eafp x\u1ebfp d\u1eef li\u1ec7u ch\u1ec9 v\u1edbi m\u1ed9t c\u00fa click chu\u1ed9t. \u0110\u00e2y l\u00e0 ph\u01b0\u01a1ng ph\u00e1p th\u1ef1c hi\u1ec7n \u0111\u01a1n gi\u1ea3n v\u00e0 nhanh nh\u1ea5t, \u0111\u01b0\u1ee3c \u00e1p d\u1ee5ng trong c\u00e1c b\u1ea3ng t\u00ednh c\u1ea7n \u0111\u01b0\u1ee3c x\u1ebfp theo b\u1ea3ng ch\u1eef c\u00e1i ho\u1eb7c s\u1ed1 th\u1ee9 t\u1ef1 theo c\u1ed9t d\u1ecdc t\u1eeb tr\u00ean xu\u1ed1ng ho\u1eb7c ng\u01b0\u1ee3c l\u1ea1i.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">N\u00fat t\u1eaft Sort Oldest to Newest (Lowest to Highest) v\u00e0 ng\u01b0\u1ee3c l\u1ea1i c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c d\u00f9ng v\u1edbi c\u00e1c c\u1ed9t d\u1eef li\u1ec7u nh\u01b0 h\u1ecd v\u00e0 t\u00ean, ng\u00e0y th\u00e1ng, s\u1ed1 th\u1ee9 t\u1ef1 ho\u1eb7c gi\u00e1 tr\u1ecb t\u0103ng d\u1ea7n, gi\u1ea3m d\u1ea7n. B\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o h\u01b0\u1edbng d\u1eabn sau \u0111\u1ec3 th\u1ef1c hi\u1ec7n:<\/span><\/p>\n<p><b>B\u01b0\u1edbc 1:<\/b><span style=\"font-weight: 400;\"> L\u1ef1a ch\u1ecdn c\u1ed9t d\u1eef li\u1ec7u c\u1ea7n \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp.<\/span><\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-283514\" src=\"https:\\\/\\\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/sap-xep-trong-excel-3.jpg\" alt=\"sap-xep-trong-excel-3\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/sap-xep-trong-excel-3.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/sap-xep-trong-excel-3-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/sap-xep-trong-excel-3-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<p><b>B\u01b0\u1edbc 2: <\/b><span style=\"font-weight: 400;\">Tr\u00ean thanh c\u00f4ng c\u1ee5, ch\u1ecdn th\u1ebb<\/span><b> Data<\/b><span style=\"font-weight: 400;\">, sau \u0111\u00f3 l\u1ef1a ch\u1ecdn n\u00fat t\u1eaft<\/span><b> Sort Oldest to Newest (Lowest to Highest)<\/b><span style=\"font-weight: 400;\"> ho\u1eb7c <\/span><b>Sort Newest to Oldest (Highest to Lowest)<\/b><span style=\"font-weight: 400;\"> trong h\u1ed9p Sort &amp; Filter. L\u01b0u \u00fd, n\u00fat t\u1eaft n\u00e0y c\u00f3 bi\u1ec3u t\u01b0\u1ee3ng ch\u1eef A Z v\u00e0 m\u0169i t\u00ean ch\u1ec9 xu\u1ed1ng.<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Sort Oldest to Newest:<\/b><span style=\"font-weight: 400;\"> S\u1eafp x\u1ebfp theo th\u1ee9 t\u1ef1 t\u0103ng d\u1ea7n ho\u1eb7c t\u1eeb A \u0111\u1ebfn Z.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Sort Newest to Oldest:<\/b><span style=\"font-weight: 400;\"> S\u1eafp x\u1ebfp theo th\u1ee9 t\u1ef1 gi\u1ea3m d\u1ea7n ho\u1eb7c t\u1eeb Z \u0111\u1ebfn A.<\/span><\/li>\n<\/ul>\n<h3><b>S\u1eafp x\u1ebfp trong Excel theo h\u00e0ng ngang v\u1edbi Sort<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">Ph\u01b0\u01a1ng ph\u00e1p s\u1eed d\u1ee5ng n\u00fat t\u1eaft kh\u00e1 ti\u1ec7n l\u1ee3i, nh\u01b0ng ph\u1ea1m vi c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng l\u1ea1i b\u1ecb gi\u1edbi h\u1ea1n cho c\u1ed9t d\u1ecdc. Trong tr\u01b0\u1eddng h\u1ee3p ng\u01b0\u1eddi d\u00f9ng mu\u1ed1n s\u1eafp x\u1ebfp d\u1eef li\u1ec7u b\u1eb1ng c\u00e1c ti\u00eau ch\u00ed chuy\u00ean d\u1ee5ng h\u01a1n, b\u1ea1n c\u1ea7n ph\u1ea3i d\u00f9ng \u0111\u1ebfn b\u1ea3ng t\u00ednh n\u0103ng Sort v\u00e0 thao t\u00e1c tr\u00ean \u0111\u00f3. C\u00e1c ch\u1ee9c n\u0103ng ch\u00ednh c\u1ee7a b\u1ea3ng \u0111\u00e3 \u0111\u01b0\u1ee3c gi\u1edbi thi\u1ec7u c\u1ee5 th\u1ec3 \u1edf ph\u1ea7n tr\u00ean, sau \u0111\u00e2y l\u00e0 h\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eafp x\u1ebfp theo h\u00e0ng ngang trong b\u1ea3ng t\u00ednh.<\/span><\/p>\n<p><b>B\u01b0\u1edbc 1: <\/b><span style=\"font-weight: 400;\">L\u1ef1a ch\u1ecdn ph\u1ea1m vi c\u1ea7n s\u1eafp x\u1ebfp theo h\u00e0ng ngang. V\u00ed d\u1ee5 nh\u01b0 b\u1ea3ng t\u00ednh d\u01b0\u1edbi \u0111\u00e2y c\u00f3 th\u1ee9 t\u1ef1 c\u00e1c th\u00e1ng ch\u01b0a h\u1ee3p l\u00fd, c\u1ea7n s\u1eafp l\u1ea1i theo \u0111\u00fang tr\u00ecnh t\u1ef1 th\u1eddi gian.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-283515\" src=\"https:\\\/\\\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/sap-xep-trong-excel-4.jpg\" alt=\"sap-xep-trong-excel-4\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/sap-xep-trong-excel-4.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/sap-xep-trong-excel-4-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/sap-xep-trong-excel-4-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<p><b>B\u01b0\u1edbc 2: <\/b><span style=\"font-weight: 400;\">Ch\u1ecdn th\u1ebb <\/span><b>Data<\/b><span style=\"font-weight: 400;\"> v\u00e0 click chu\u1ed9t v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng <\/span><b>Sort<\/b><span style=\"font-weight: 400;\"> trong h\u1ed9p <\/span><b>Sort &amp; Filter<\/b><span style=\"font-weight: 400;\">.<\/span><\/p>\n<p><b>B\u01b0\u1edbc 3:<\/b><span style=\"font-weight: 400;\"> H\u1ed9p tho\u1ea1i Sort s\u1ebd \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb, ti\u1ebfn h\u00e0nh ch\u1ecdn <\/span><b>Options<\/b><span style=\"font-weight: 400;\"> \u0111\u1ec3 l\u1ef1a ch\u1ecdn ch\u1ee9c n\u0103ng s\u1eafp x\u1ebfp trong Excel theo h\u00e0ng ngang.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-283516\" src=\"https:\\\/\\\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/sap-xep-trong-excel-5.jpg\" alt=\"sap-xep-trong-excel-5\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/sap-xep-trong-excel-5.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/sap-xep-trong-excel-5-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/sap-xep-trong-excel-5-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<p><b>B\u01b0\u1edbc 4: <\/b><span style=\"font-weight: 400;\">Tick v\u00e0o \u00f4 Sort left to right v\u00e0 ch\u1ecdn <\/span><b>OK<\/b><span style=\"font-weight: 400;\"> \u0111\u1ec3 ho\u00e0n t\u1ea5t.<\/span><\/p>\n<h3><b>S\u1eafp x\u1ebfp d\u1eef li\u1ec7u theo c\u00e1c ti\u00eau ch\u00ed n\u00e2ng cao trong Sort<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">Hai h\u01b0\u1edbng d\u1eabn \u0111\u01b0\u1ee3c \u0111\u1ec1 c\u1eadp ph\u00e1i tr\u00ean m\u1edbi ch\u1ec9 \u00e1p d\u1ee5ng m\u1ed9t \u0111i\u1ec1u ki\u1ec7n khi sort d\u1eef li\u1ec7u. V\u1eady n\u1ebfu mu\u1ed1n x\u1ebfp theo nhi\u1ec1u ti\u00eau ch\u00ed c\u00f9ng l\u00fac, ng\u01b0\u1eddi d\u00f9ng ph\u1ea3i thao t\u00e1c nh\u01b0 th\u1ebf n\u00e0o? C\u00f4ng c\u1ee5 Sort ho\u00e0n to\u00e0n cho ph\u00e9p b\u1ea1n s\u1eafp x\u1ebfp d\u1eef li\u1ec7u v\u1edbi tr\u00ecnh t\u1ef1 \u01b0u ti\u00ean v\u00e0 \u00e1p d\u1ee5ng nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n. Thay v\u00ec ph\u1ea3i l\u00e0m th\u1ee7 c\u00f4ng hay th\u1ef1c hi\u1ec7n Sort nhi\u1ec1u l\u1ea7n (r\u1ea5t d\u1ec5 g\u00e2y ra sai s\u00f3t), b\u1ea1n ch\u1ec9 c\u1ea7n b\u1ed5 sung v\u00e0 l\u1ef1a ch\u1ecdn c\u00e1c c\u1ea5p \u0111\u1ed9 sort. Sau \u0111\u00f3, h\u1ec7 th\u1ed1ng s\u1ebd t\u1ef1 \u0111\u1ed9ng ghi nh\u1eadn l\u1ec7nh v\u00e0 th\u1ef1c hi\u1ec7n x\u1ebfp l\u1ea1i d\u1eef li\u1ec7u cho b\u1ea1n.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">\u0110\u1ec3 ng\u01b0\u1eddi d\u00f9ng d\u1ec5 h\u00ecnh dung h\u01a1n v\u1ec1 c\u00e1ch th\u1ef1c hi\u1ec7n s\u1eafp x\u1ebfp trong Excel, h\u01b0\u1edbng d\u1eabn sau \u0111\u00e2y s\u1ebd \u0111\u01b0\u1ee3c \u00e1p d\u1ee5ng cho m\u1ed9t b\u1ea3ng t\u00ednh c\u1ee5 th\u1ec3 v\u1edbi y\u00eau c\u1ea7u s\u1eafp x\u1ebfp l\u1ea1i d\u1eef li\u1ec7u trong c\u1ed9t Kh\u00e1ch h\u00e0ng v\u00e0 Ng\u00e0y thanh to\u00e1n sao cho:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">T\u00ean kh\u00e1ch h\u00e0ng theo th\u1ee9 t\u1ef1 b\u1ea3ng ch\u1eef c\u00e1i<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Ng\u00e0y thanh to\u00e1n x\u1ebfp theo tr\u00ecnh t\u1ef1 th\u1eddi gian t\u1eeb xa \u0111\u1ebfn g\u1ea7n nh\u1ea5t<\/span><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-283517\" src=\"https:\\\/\\\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/sap-xep-trong-excel-6.jpg\" alt=\"sap-xep-trong-excel-6\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/sap-xep-trong-excel-6.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/sap-xep-trong-excel-6-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/sap-xep-trong-excel-6-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<p><b>B\u01b0\u1edbc 1:<\/b><span style=\"font-weight: 400;\"> L\u1ef1a ch\u1ecdn ph\u1ea1m v\u1ecb b\u1ea3ng t\u00ednh c\u1ea7n s\u1eafp x\u1ebfp.<\/span><\/p>\n<p><b>B\u01b0\u1edbc 2: <\/b><span style=\"font-weight: 400;\">M\u1edf h\u1ed9p tho\u1ea1i <\/span><b>Sort <\/b><span style=\"font-weight: 400;\">b\u1eb1ng c\u00e1ch <\/span><b>Data \u2192 Sort<\/b><span style=\"font-weight: 400;\">.<\/span><\/p>\n<p><b>B\u01b0\u1edbc 3:<\/b><span style=\"font-weight: 400;\"> Trong <\/span><b>Sort by<\/b><span style=\"font-weight: 400;\">, l\u1ef1a ch\u1ecdn <\/span><b>Kh\u00e1ch h\u00e0ng<\/b><span style=\"font-weight: 400;\">. Ch\u1ecdn <\/span><b>Values<\/b><span style=\"font-weight: 400;\"> trong h\u1ed9p <\/span><b>Sort On<\/b><span style=\"font-weight: 400;\"> v\u00e0 <\/span><b>A to Z <\/b><span style=\"font-weight: 400;\">trong <\/span><b>Order<\/b><span style=\"font-weight: 400;\">.<\/span><\/p>\n<p><b>B\u01b0\u1edbc 4:<\/b><span style=\"font-weight: 400;\"> Click chu\u1ed9t ch\u1ecdn<\/span><b> Add Level<\/b><span style=\"font-weight: 400;\"> \u0111\u1ec3 b\u1ed5 sung th\u00eam c\u1ea5p \u0111\u1ed9 <\/span><b>Then by<\/b><span style=\"font-weight: 400;\">.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-283518\" src=\"https:\\\/\\\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/sap-xep-trong-excel-7.jpg\" alt=\"sap-xep-trong-excel-7\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/sap-xep-trong-excel-7.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/sap-xep-trong-excel-7-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/sap-xep-trong-excel-7-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<p><b>B\u01b0\u1edbc 5:<\/b><span style=\"font-weight: 400;\"> Ch\u1ecdn<\/span><b> Ng\u00e0y thanh to\u00e1n<\/b><span style=\"font-weight: 400;\"> trong<\/span><b> Then by<\/b><span style=\"font-weight: 400;\">, <\/span><b>Values<\/b><span style=\"font-weight: 400;\"> trong <\/span><b>Sort On <\/b><span style=\"font-weight: 400;\">v\u00e0 <\/span><b>Oldest to Newest<\/b><span style=\"font-weight: 400;\"> trong <\/span><b>Order.<\/b><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-283519\" src=\"https:\\\/\\\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/sap-xep-trong-excel-8.jpg\" alt=\"sap-xep-trong-excel-8\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/sap-xep-trong-excel-8.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/sap-xep-trong-excel-8-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/sap-xep-trong-excel-8-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<p><b>B\u01b0\u1edbc 6: <\/b><span style=\"font-weight: 400;\">Click chu\u1ed9t ch\u1ecdn <\/span><b>OK<\/b><span style=\"font-weight: 400;\"> \u0111\u1ec3 h\u1ec7 th\u1ed1ng ho\u00e0n to\u00e1n qu\u00e1 tr\u00ecnh s\u1eafp x\u1ebfp.<\/span><\/p>\n<h2><b>H\u01b0\u1edbng d\u1eabn c\u00e1ch h\u1ee7y Sort khi c\u00f3 l\u1ed7i s\u1eafp x\u1ebfp trong Excel<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">D\u00f9 qu\u00e1 tr\u00ecnh s\u1eafp x\u1ebfp \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n t\u1ef1 \u0111\u1ed9ng khi d\u00f9ng Sort nh\u01b0ng ng\u01b0\u1eddi d\u00f9ng v\u1eabn c\u1ea7n thao t\u00e1c th\u1ee7 c\u00f4ng \u0111\u1ec3 l\u1ef1a ch\u1ecdn c\u00e1c ti\u00eau ch\u00ed trong h\u1ed9p tho\u1ea1i ch\u1ee9c n\u0103ng. V\u00ec v\u1eady, nh\u1eefng sai s\u00f3t l\u00e0 kh\u00f4ng th\u1ec3 tr\u00e1nh kh\u1ecfi, khi\u1ebfn b\u1ea3ng t\u00ednh c\u1ee7a b\u1ea1n b\u1ecb \u0111\u1ea3o l\u1ed9n th\u1ee9 t\u1ef1 m\u00e0 kh\u00f4ng th\u1ec3 tr\u00ecnh t\u1ef1 \u0111\u01b0\u1ee3c y\u00eau c\u1ea7u. Khi n\u00e0y, c\u00e1ch t\u1ed1t nh\u1ea5t \u0111\u1ec3 kh\u1eafc ph\u1ee5c l\u00e0 h\u1ee7y b\u1ecf l\u1ec7nh Sort v\u1eeba th\u1ef1c hi\u1ec7n. Sau \u0111\u00f3, ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 thao t\u00e1c Sort l\u1ea1i t\u1eeb \u0111\u1ea7u v\u1edbi c\u00e1c b\u01b0\u1edbc \u0111\u00fang quy tr\u00ecnh v\u00e0 hi\u1ec7u qu\u1ea3 h\u01a1n.<\/span><\/p>\n<h3><b>H\u1ee7y l\u1ec7nh Sort b\u1eb1ng n\u00fat Undo ho\u1eb7c ph\u00edm t\u1eaft Ctrl Z<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">Th\u00f4ng th\u01b0\u1eddng, sau khi ch\u1ea1y m\u1ed9t l\u1ec7nh Sort, ng\u01b0\u1eddi d\u00f9ng s\u1ebd ngay l\u1eadp t\u1ee9c th\u1ea5y k\u1ebft qu\u1ea3 v\u1eeba \u0111\u01b0\u1ee3c Sort hi\u1ec3n th\u1ecb tr\u00ean b\u1ea3ng t\u00ednh. Khi n\u00e0y, b\u1ea1n s\u1ebd d\u1ec5 d\u00e0ng nh\u1eadn ra li\u1ec7u c\u00e1ch sort c\u1ee7a m\u00ecnh \u0111\u00e3 \u0111\u00fang ch\u01b0a, \u0111\u00e3 \u0111i theo tr\u00ecnh t\u1ef1 nh\u01b0 mong mu\u1ed1n ch\u01b0a hay v\u1eabn kh\u00f4ng c\u00f3 g\u00ec kh\u1ea3 quan. N\u1ebfu c\u00e1c d\u1eef li\u1ec7u v\u1eabn l\u1ed9n x\u1ed9n nh\u01b0 ban \u0111\u1ea7u, b\u1ea1n n\u00ean ho\u00e0n t\u00e1c l\u1ea1i l\u1ec7nh Sort v\u1eeba th\u1ef1c hi\u1ec7n ngay l\u1eadp t\u1ee9c \u0111\u1ec3 tr\u00e1nh c\u00e1c r\u1ee7i ro ph\u1ee9c t\u1ea1p h\u01a1n v\u1ec1 sau.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-283520\" src=\"https:\\\/\\\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/sap-xep-trong-excel-9.jpg\" alt=\"sap-xep-trong-excel-9\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/sap-xep-trong-excel-9.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/sap-xep-trong-excel-9-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/sap-xep-trong-excel-9-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">Ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng ngay n\u00fat <\/span><b>Undo <\/b><span style=\"font-weight: 400;\">tr\u00ean m\u00e0n h\u00ecnh Microsoft Excel, c\u00f3 bi\u1ec3u t\u01b0\u1ee3ng n\u00fat m\u0169i t\u00ean quay l\u1ea1i g\u00f3c tr\u00ean b\u00ean ph\u1ea3i. N\u00fat t\u1eaft n\u00e0y c\u00f3 ch\u1ee9c n\u0103ng tr\u1ea3 l\u1ea1i ph\u1ea7n d\u1eef li\u1ec7u ban \u0111\u1ea7u khi ch\u01b0a th\u1ef1c hi\u1ec7n s\u1eafp x\u1ebfp trong Excel \u0111\u1ec3 ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 thao t\u00e1c l\u1ea1i l\u1ea7n n\u1eefa. Tuy nhi\u00ean, n\u00fat Undo ch\u1ec9 cho ph\u00e9p b\u1ea1n quay tr\u1edf l\u1ea1i nh\u01b0 ban \u0111\u1ea7u n\u1ebfu thao t\u00e1c Sort v\u1eeba m\u1edbi \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n. Trong tr\u01b0\u1eddng h\u1ee3p b\u1ea1n s\u1eafp x\u1ebfp xong d\u1eef li\u1ec7u v\u00e0 th\u1ef1c hi\u1ec7n th\u00eam c\u00e1c h\u00e0nh \u0111\u1ed9ng kh\u00e1c r\u1ed3i m\u1edbi ph\u00e1t hi\u1ec7n l\u1ed7i, Undo s\u1ebd kh\u00f4ng th\u1ec3 \u0111\u01b0a b\u1ea1n tr\u1edf v\u1ec1 b\u1ea3ng d\u1eef li\u1ec7u g\u1ed1c.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">May m\u1eafn l\u00e0, trong c\u00e1c b\u1ea3n n\u00e2ng c\u1ea5p c\u1ee7a Microsoft 365, ph\u00edm t\u1eaft<\/span><b> Ctrl + Z <\/b><span style=\"font-weight: 400;\">(c\u00f3 ch\u1ee9c n\u0103ng ho\u00e0n t\u00e1c gi\u1ed1ng Undo) \u0111\u00e3 \u0111\u01b0\u1ee3c c\u1ea3i ti\u1ebfn. \u0110i\u1ec1u n\u00e0y c\u00f3 ngh\u0129a l\u00e0, b\u1ea1n s\u1ebd \u0111\u01b0\u1ee3c ph\u00e9p ho\u00e0n t\u00e1c l\u1ea1i c\u00e1c b\u01b0\u1edbc th\u1ef1c hi\u1ec7n tr\u01b0\u1edbc \u0111\u00f3 n\u1eefa n\u1ebfu v\u00f4 t\u00ecnh thao t\u00e1c v\u1edbi c\u00e1c ch\u1ee9c n\u0103ng sau khi Sort. Khi n\u00e0y, h\u00e3y Ctrl + Z cho \u0111\u1ebfn khi d\u1eef li\u1ec7u g\u1ed1c \u0111\u01b0\u1ee3c ph\u1ee5c h\u1ed3i v\u00e0 b\u1ea1n c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n s\u1eafp x\u1ebfp l\u1ea1i.<\/span><\/p>\n<h3><b>L\u1eadp th\u00eam c\u1ed9t d\u1eef li\u1ec7u g\u1ed1c khi s\u1eafp x\u1ebfp trong Excel<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">\u0110\u1ec3 ph\u00f2ng tr\u1eeb sai s\u00f3t, d\u1ec5 d\u00e0ng ph\u00e1t hi\u1ec7n ra s\u1ef1 c\u1ed1 v\u00e0 kh\u00f4ng ph\u1ea3i back l\u1ea1i b\u1ea3ng t\u00ednh qu\u00e1 nhi\u1ec1u l\u1ea7n, b\u1ea1n c\u00f3 th\u1ec3 l\u1eadp th\u00eam m\u1ed9t c\u1ed9t ph\u1ee5 ngay c\u1ea1nh ph\u1ea1m vi c\u1ea7n \u0111\u01b0\u1ee3c Sort \u0111\u1ec3 \u0111\u1ed1i chi\u1ebfu. C\u00e1ch \u00e1p d\u1ee5ng d\u1ec5 nh\u1ea5t trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y l\u00e0 l\u1eadp th\u00eam c\u1ed9t S\u1ed1 th\u1ee9 t\u1ef1 \u0111\u1ec3 \u0111\u00e1nh d\u1ea5u c\u00e1c d\u1eef li\u1ec7u tr\u01b0\u1edbc khi Sort.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-283521\" src=\"https:\\\/\\\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/sap-xep-trong-excel-10.jpg\" alt=\"sap-xep-trong-excel-10\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/sap-xep-trong-excel-10.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/sap-xep-trong-excel-10-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/sap-xep-trong-excel-10-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">Trong tr\u01b0\u1eddng h\u1ee3p c\u00e1ch s\u1eafp x\u1ebfp kh\u00f4ng \u0111\u00fang v\u1edbi y\u00eau c\u1ea7u, thay v\u00ec ph\u1ea3i Undo nhi\u1ec1u l\u1ea7n, b\u1ea1n ch\u1ec9 c\u1ea7n th\u1ef1c hi\u1ec7n duy nh\u1ea5t h\u00e0nh \u0111\u1ed9ng sau:<\/span><\/p>\n<p><b>B\u01b0\u1edbc 1: <\/b><span style=\"font-weight: 400;\">Ch\u1ecdn c\u1ed9t STT v\u1eeba \u0111\u01b0\u1ee3c t\u1ea1o.<\/span><\/p>\n<p><b>B\u01b0\u1edbc 2:<\/b><span style=\"font-weight: 400;\"> Ch\u1ecdn c\u00f4ng c\u1ee5 <\/span><b>Data<\/b><span style=\"font-weight: 400;\"> v\u00e0 click v\u00e0o <\/span><b>Sort<\/b><span style=\"font-weight: 400;\"> \u0111\u1ec3 m\u1edf h\u1ed9p tho\u1ea1i s\u1eafp x\u1ebfp trong Excel.<\/span><\/p>\n<p><b>B\u01b0\u1edbc 3: <\/b><span style=\"font-weight: 400;\">Tick ch\u1ecdn c\u1ed9t <\/span><b>STT<\/b><span style=\"font-weight: 400;\"> trong <\/span><b>Sort by<\/b><span style=\"font-weight: 400;\">, <\/span><b>Values<\/b><span style=\"font-weight: 400;\"> trong <\/span><b>Sort On<\/b><span style=\"font-weight: 400;\"> v\u00e0<\/span><b> Smallest to Largest<\/b><span style=\"font-weight: 400;\"> trong th\u1ebb <\/span><b>Order<\/b><span style=\"font-weight: 400;\">.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-283522\" src=\"https:\\\/\\\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/sap-xep-trong-excel-11.jpg\" alt=\"sap-xep-trong-excel-11\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/sap-xep-trong-excel-11.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/sap-xep-trong-excel-11-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/sap-xep-trong-excel-11-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<p><b>B\u01b0\u1edbc 4: <\/b><span style=\"font-weight: 400;\">Ch\u1ecdn <\/span><b>OK<\/b><span style=\"font-weight: 400;\"> \u0111\u1ec3 b\u1ea3ng t\u00ednh hi\u1ec3n th\u1ecb l\u1ea1i th\u1ee9 t\u1ef1 d\u1eef li\u1ec7u g\u1ed1c khi ch\u01b0a \u0111\u01b0\u1ee3c Sort.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">L\u01b0u \u00fd, c\u1ed9t d\u1eef li\u1ec7u v\u1ec1 s\u1ed1 th\u1ee9 t\u1ef1 ch\u1ec9 c\u00f3 ch\u1ee9c n\u0103ng h\u1ed7 tr\u1ee3 quan s\u00e1t v\u00e0 thao t\u00e1c Undo d\u1ec5 d\u00e0ng h\u01a1n \u0111\u1ed1i v\u1edbi b\u1ea3ng t\u00ednh. Trong tr\u01b0\u1eddng h\u1ee3p kh\u00f4ng d\u00f9ng \u0111\u1ebfn, ng\u01b0\u1eddi d\u00f9ng ho\u00e0n to\u00e0n c\u00f3 th\u1ec3 \u1ea9n c\u1ed9t n\u00e0y b\u1eb1ng c\u00e1ch click chu\u1ed9t ph\u1ea3i v\u00e0o c\u1ed9t STT v\u00e0 ch\u1ecdn <\/span><b>Hide<\/b><span style=\"font-weight: 400;\">.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">B\u00ean c\u1ea1nh \u0111\u00f3, ng\u01b0\u1eddi d\u00f9ng c\u0169ng c\u1ea7n l\u01b0u \u00fd n\u1ebfu th\u1ef1c hi\u1ec7n s\u1eafp x\u1ebfp n\u1ed9i dung H\u1ecd v\u00e0 t\u00ean trong b\u1ea3ng t\u00ednh. Microsoft Excel ch\u1ec9 ghi nh\u1eadn y\u00eau c\u1ea7u Sort A \u2192 Z v\u1edbi c\u00e1c ch\u1eef c\u00e1i \u0111\u1ea7u ti\u00ean c\u1ee7a ph\u1ea7n h\u1ecd v\u00e0 kh\u00f4ng th\u1ef1c hi\u1ec7n x\u1ebfp theo t\u00ean th\u01b0\u1eddng g\u1ecdi n\u1ebfu c\u1ea3 h\u1ecd v\u00e0 t\u00ean \u0111\u01b0\u1ee3c nh\u1eadp v\u00e0o c\u00f9ng \u00f4 t\u00ednh.<\/span><\/p>\n<h2><b>T\u1ea1m k\u1ebft<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">K\u1ebft lu\u1eadn l\u1ea1i, ch\u1ee9c n\u0103ng Sort \u0111\u00f3ng vai tr\u00f2 quan tr\u1ecdng trong b\u1ea3ng t\u00ednh, gi\u00fap c\u00e1c d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp l\u1ea1i theo m\u1ed9t tr\u00ecnh t\u1ef1 logic h\u01a1n. \u0110i\u1ec1u n\u00e0y gi\u00fap ng\u01b0\u1eddi xem d\u1ec5 d\u00e0ng theo d\u00f5i, qu\u1ea3n l\u00fd v\u00e0 t\u00ecm ki\u1ebfm c\u00e1c th\u00f4ng tin trong b\u1ea3ng t\u00ednh. B\u1eb1ng c\u00e1ch ch\u1ee9c n\u0103ng th\u00f4ng minh v\u00e0 ph\u1ea1m vi \u00e1p d\u1ee5ng kh\u00f4ng gi\u1edbi h\u1ea1n, ch\u1ee9c n\u0103ng s\u1eafp x\u1ebfp d\u1eef li\u1ec7u n\u00e0y mang \u0111\u1ebfn r\u1ea5t nhi\u1ec1u l\u1ee3i \u00edch cho ng\u01b0\u1eddi d\u00f9ng, \u0111\u1eb7c bi\u1ec7t l\u00e0 d\u00e2n v\u0103n ph\u00f2ng ph\u1ea3i th\u01b0\u1eddng xuy\u00ean l\u00e0m vi\u1ec7c v\u1edbi nh\u1eadp li\u1ec7u.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">B\u00e0i vi\u1ebft \u0111\u00e3 cung c\u1ea5p cho b\u1ea1n nh\u1eefng th\u00f4ng tin c\u1ea7n thi\u1ebft v\u1ec1 ch\u1ee9c n\u0103ng Sort c\u0169ng nh\u01b0 h\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng chi ti\u1ebft, c\u00e1ch kh\u1eafc ph\u1ee5c l\u1ed7i s\u1eafp x\u1ebfp v\u00e0 l\u1ea5y c\u00e1c v\u00ed d\u1ee5 minh h\u1ecda c\u1ee5 th\u1ec3. B\u00ean c\u1ea1nh th\u1ee7 thu\u1eadt v\u1ec1 <\/span><b>s\u1eafp x\u1ebfp trong Excel<\/b><span style=\"font-weight: 400;\">, <\/span><b>Ho\u00e0ng H\u00e0 Mobile<\/b><span style=\"font-weight: 400;\"> c\u00f2n \u0111em \u0111\u1ebfn nhi\u1ec1u th\u00f4ng tin h\u1eefu \u00edch kh\u00e1c m\u1ed7i ng\u00e0y. \u0110\u1eebng qu\u00ean theo d\u00f5i trang tin \u0111\u1ec3 c\u1eadp nh\u1eadt tin t\u1ee9c m\u1edbi nh\u1ea5t v\u00e0 h\u1ecdc th\u00eam nhi\u1ec1u k\u1ef9 n\u0103ng tin h\u1ecdc v\u0103n ph\u00f2ng b\u1ed5 \u00edch.<\/span><\/p>\n<p><b>Xem th\u00eam:<\/b><\/p>\n<ul>\n<li aria-level=\"1\"><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/dinh-dang-so-trong-excel\/\"><b>C\u00e1ch \u0111\u1ecbnh d\u1ea1ng s\u1ed1 trong Excel \u0111\u01a1n gi\u1ea3n, chi ti\u1ebft nh\u1ea5t<\/b><\/a><\/li>\n<li aria-level=\"1\"><a href=\"https:\\\/\\\/hoanghamobile.com\/tin-tuc\/cach-tach-ten-trong-excel\/\"><strong>C\u00e1ch t\u00e1ch c\u1ed9t h\u1ecd v\u00e0 t\u00ean trong Excel nhanh v\u00e0 \u0111\u01a1n gi\u1ea3n nh\u1ea5t<\/strong><\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>S\u1eafp x\u1ebfp trong Excel l\u00e0 m\u1ed9t ph\u01b0\u01a1ng ph\u00e1p x\u1eed l\u00fd v\u00e0 qu\u1ea3n l\u00fd d\u1eef li\u1ec7u hi\u1ec7u qu\u1ea3 h\u01a1n trong c\u00f4ng vi\u1ec7c m\u00e0 ng\u01b0\u1eddi d\u00f9ng c\u1ea7n bi\u1ebft \u0111\u1ebfn. \u0110\u1ec3 gi\u00fap b\u1ea1n d\u1ec5 d\u00e0ng th\u1ef1c hi\u1ec7n thao t\u00e1c n\u00e0y, Microsoft Excel \u0111\u00e3 t\u00edch h\u1ee3p s\u1eb5n t\u00ednh n\u0103ng Sort. \u0110\u00e2y l\u00e0 c\u00f4ng c\u1ee5 gi\u00fap s\u1eafp x\u1ebfp d\u1eef li\u1ec7u [&hellip;]<\/p>\n","protected":false},"author":79,"featured_media":283511,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28955,16],"tags":[],"class_list":["post-283510","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","category-thu-thuat"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.3 (Yoast SEO v27.4) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>H\u01b0\u1edbng d\u1eabn s\u1eafp x\u1ebfp trong Excel: C\u00e1ch s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng Sort<\/title>\n<meta name=\"description\" content=\"S\u1eed d\u1ee5ng Sort \u0111\u1ec3 s\u1eafp x\u1ebfp trong Excel \u0111em \u0111\u1ebfn nhi\u1ec1u l\u1ee3i \u00edch cho ng\u01b0\u1eddi d\u00f9ng. Sau \u0111\u00e2y l\u00e0 h\u01b0\u1edbng d\u1eabn c\u00e1ch d\u00f9ng Sort t\u1eeb \u0111\u01a1n gi\u1ea3n \u0111\u1ebfn n\u00e2ng cao.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/hoanghamobile.com\/tin-tuc\/sap-xep-trong-excel\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"H\u01b0\u1edbng d\u1eabn s\u1eafp x\u1ebfp trong Excel: C\u00e1ch s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng Sort\" \/>\n<meta property=\"og:description\" content=\"S\u1eed d\u1ee5ng Sort \u0111\u1ec3 s\u1eafp x\u1ebfp trong Excel \u0111em \u0111\u1ebfn nhi\u1ec1u l\u1ee3i \u00edch cho ng\u01b0\u1eddi d\u00f9ng. Sau \u0111\u00e2y l\u00e0 h\u01b0\u1edbng d\u1eabn c\u00e1ch d\u00f9ng Sort t\u1eeb \u0111\u01a1n gi\u1ea3n \u0111\u1ebfn n\u00e2ng cao.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/sap-xep-trong-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/hoanghamobilecom\" \/>\n<meta property=\"article:published_time\" content=\"2023-11-10T15:26:56+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/sap-xep-trong-excel.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Linh Kieu\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi\" \/>\n\t<meta name=\"twitter:data1\" content=\"Linh Kieu\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"16 ph\u00fat\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/sap-xep-trong-excel\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/sap-xep-trong-excel\\\/\"},\"author\":{\"name\":\"Linh Kieu\",\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/#\\\/schema\\\/person\\\/291b4b44e425ce775cae85435959ecb2\"},\"headline\":\"H\u01b0\u1edbng d\u1eabn s\u1eafp x\u1ebfp trong Excel: C\u00e1ch s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng Sort\",\"datePublished\":\"2023-11-10T15:26:56+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/sap-xep-trong-excel\\\/\"},\"wordCount\":3810,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/sap-xep-trong-excel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/wp-content\\\/uploads\\\/2023\\\/11\\\/sap-xep-trong-excel.jpg\",\"articleSection\":[\"Excel\",\"Th\u1ee7 thu\u1eadt\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/sap-xep-trong-excel\\\/#respond\"]}],\"copyrightYear\":\"2023\",\"copyrightHolder\":{\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/sap-xep-trong-excel\\\/\",\"url\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/sap-xep-trong-excel\\\/\",\"name\":\"H\u01b0\u1edbng d\u1eabn s\u1eafp x\u1ebfp trong Excel: C\u00e1ch s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng Sort\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/sap-xep-trong-excel\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/sap-xep-trong-excel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/wp-content\\\/uploads\\\/2023\\\/11\\\/sap-xep-trong-excel.jpg\",\"datePublished\":\"2023-11-10T15:26:56+00:00\",\"description\":\"S\u1eed d\u1ee5ng Sort \u0111\u1ec3 s\u1eafp x\u1ebfp trong Excel \u0111em \u0111\u1ebfn nhi\u1ec1u l\u1ee3i \u00edch cho ng\u01b0\u1eddi d\u00f9ng. Sau \u0111\u00e2y l\u00e0 h\u01b0\u1edbng d\u1eabn c\u00e1ch d\u00f9ng Sort t\u1eeb \u0111\u01a1n gi\u1ea3n \u0111\u1ebfn n\u00e2ng cao.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/sap-xep-trong-excel\\\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/sap-xep-trong-excel\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/sap-xep-trong-excel\\\/#primaryimage\",\"url\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/wp-content\\\/uploads\\\/2023\\\/11\\\/sap-xep-trong-excel.jpg\",\"contentUrl\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/wp-content\\\/uploads\\\/2023\\\/11\\\/sap-xep-trong-excel.jpg\",\"width\":1200,\"height\":628,\"caption\":\"sap-xep-trong-excel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/sap-xep-trong-excel\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Trang ch\u1ee7\",\"item\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Th\u1ee7 thu\u1eadt\",\"item\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/category\\\/thu-thuat\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"H\u01b0\u1edbng d\u1eabn s\u1eafp x\u1ebfp trong Excel: C\u00e1ch s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng Sort\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/#website\",\"url\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/\",\"name\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"vi\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/#organization\",\"name\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\",\"url\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/wp-content\\\/uploads\\\/2021\\\/12\\\/logo-text.png\",\"contentUrl\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/wp-content\\\/uploads\\\/2021\\\/12\\\/logo-text.png\",\"width\":256,\"height\":37,\"caption\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\"},\"image\":{\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/hoanghamobilecom\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/#\\\/schema\\\/person\\\/291b4b44e425ce775cae85435959ecb2\",\"name\":\"Linh Kieu\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ac6a455e70c2c8646d3d78aed483df3cfc092cad7749e643f76af5f4c2bd484d?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ac6a455e70c2c8646d3d78aed483df3cfc092cad7749e643f76af5f4c2bd484d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ac6a455e70c2c8646d3d78aed483df3cfc092cad7749e643f76af5f4c2bd484d?s=96&d=mm&r=g\",\"caption\":\"Linh Kieu\"},\"url\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/author\\\/linh-kieu\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"H\u01b0\u1edbng d\u1eabn s\u1eafp x\u1ebfp trong Excel: C\u00e1ch s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng Sort","description":"S\u1eed d\u1ee5ng Sort \u0111\u1ec3 s\u1eafp x\u1ebfp trong Excel \u0111em \u0111\u1ebfn nhi\u1ec1u l\u1ee3i \u00edch cho ng\u01b0\u1eddi d\u00f9ng. Sau \u0111\u00e2y l\u00e0 h\u01b0\u1edbng d\u1eabn c\u00e1ch d\u00f9ng Sort t\u1eeb \u0111\u01a1n gi\u1ea3n \u0111\u1ebfn n\u00e2ng cao.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/hoanghamobile.com\/tin-tuc\/sap-xep-trong-excel\/","og_locale":"vi_VN","og_type":"article","og_title":"H\u01b0\u1edbng d\u1eabn s\u1eafp x\u1ebfp trong Excel: C\u00e1ch s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng Sort","og_description":"S\u1eed d\u1ee5ng Sort \u0111\u1ec3 s\u1eafp x\u1ebfp trong Excel \u0111em \u0111\u1ebfn nhi\u1ec1u l\u1ee3i \u00edch cho ng\u01b0\u1eddi d\u00f9ng. Sau \u0111\u00e2y l\u00e0 h\u01b0\u1edbng d\u1eabn c\u00e1ch d\u00f9ng Sort t\u1eeb \u0111\u01a1n gi\u1ea3n \u0111\u1ebfn n\u00e2ng cao.","og_url":"https:\/\/hoanghamobile.com\/tin-tuc\/sap-xep-trong-excel\/","og_site_name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","article_publisher":"https:\/\/www.facebook.com\/hoanghamobilecom","article_published_time":"2023-11-10T15:26:56+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/sap-xep-trong-excel.jpg","type":"image\/jpeg"}],"author":"Linh Kieu","twitter_card":"summary_large_image","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"Linh Kieu","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"16 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/sap-xep-trong-excel\/#article","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/sap-xep-trong-excel\/"},"author":{"name":"Linh Kieu","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/291b4b44e425ce775cae85435959ecb2"},"headline":"H\u01b0\u1edbng d\u1eabn s\u1eafp x\u1ebfp trong Excel: C\u00e1ch s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng Sort","datePublished":"2023-11-10T15:26:56+00:00","mainEntityOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/sap-xep-trong-excel\/"},"wordCount":3810,"commentCount":0,"publisher":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/sap-xep-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/sap-xep-trong-excel.jpg","articleSection":["Excel","Th\u1ee7 thu\u1eadt"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/hoanghamobile.com\/tin-tuc\/sap-xep-trong-excel\/#respond"]}],"copyrightYear":"2023","copyrightHolder":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"}},{"@type":"WebPage","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/sap-xep-trong-excel\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/sap-xep-trong-excel\/","name":"H\u01b0\u1edbng d\u1eabn s\u1eafp x\u1ebfp trong Excel: C\u00e1ch s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng Sort","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#website"},"primaryImageOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/sap-xep-trong-excel\/#primaryimage"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/sap-xep-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/sap-xep-trong-excel.jpg","datePublished":"2023-11-10T15:26:56+00:00","description":"S\u1eed d\u1ee5ng Sort \u0111\u1ec3 s\u1eafp x\u1ebfp trong Excel \u0111em \u0111\u1ebfn nhi\u1ec1u l\u1ee3i \u00edch cho ng\u01b0\u1eddi d\u00f9ng. Sau \u0111\u00e2y l\u00e0 h\u01b0\u1edbng d\u1eabn c\u00e1ch d\u00f9ng Sort t\u1eeb \u0111\u01a1n gi\u1ea3n \u0111\u1ebfn n\u00e2ng cao.","breadcrumb":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/sap-xep-trong-excel\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/hoanghamobile.com\/tin-tuc\/sap-xep-trong-excel\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/sap-xep-trong-excel\/#primaryimage","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/sap-xep-trong-excel.jpg","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/sap-xep-trong-excel.jpg","width":1200,"height":628,"caption":"sap-xep-trong-excel"},{"@type":"BreadcrumbList","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/sap-xep-trong-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Trang ch\u1ee7","item":"https:\/\/hoanghamobile.com\/tin-tuc\/"},{"@type":"ListItem","position":2,"name":"Th\u1ee7 thu\u1eadt","item":"https:\/\/hoanghamobile.com\/tin-tuc\/category\/thu-thuat\/"},{"@type":"ListItem","position":3,"name":"H\u01b0\u1edbng d\u1eabn s\u1eafp x\u1ebfp trong Excel: C\u00e1ch s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng Sort"}]},{"@type":"WebSite","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#website","url":"https:\/\/hoanghamobile.com\/tin-tuc\/","name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","description":"","publisher":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/hoanghamobile.com\/tin-tuc\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"vi"},{"@type":"Organization","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization","name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","url":"https:\/\/hoanghamobile.com\/tin-tuc\/","logo":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png","width":256,"height":37,"caption":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/hoanghamobilecom"]},{"@type":"Person","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/291b4b44e425ce775cae85435959ecb2","name":"Linh Kieu","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/secure.gravatar.com\/avatar\/ac6a455e70c2c8646d3d78aed483df3cfc092cad7749e643f76af5f4c2bd484d?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/ac6a455e70c2c8646d3d78aed483df3cfc092cad7749e643f76af5f4c2bd484d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ac6a455e70c2c8646d3d78aed483df3cfc092cad7749e643f76af5f4c2bd484d?s=96&d=mm&r=g","caption":"Linh Kieu"},"url":"https:\/\/hoanghamobile.com\/tin-tuc\/author\/linh-kieu\/"}]}},"_links":{"self":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/283510","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/users\/79"}],"replies":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/comments?post=283510"}],"version-history":[{"count":0,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/283510\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media\/283511"}],"wp:attachment":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media?parent=283510"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/categories?post=283510"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/tags?post=283510"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}