{"id":11335,"date":"2025-01-15T02:37:32","date_gmt":"2025-01-15T02:37:32","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/sap-xep-thu-tu-trong-danh-sach-slicer\/"},"modified":"2025-01-15T02:37:32","modified_gmt":"2025-01-15T02:37:32","slug":"sap-xep-thu-tu-trong-danh-sach-slicer","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/sap-xep-thu-tu-trong-danh-sach-slicer\/","title":{"rendered":"S\u1eafp x\u1ebfp th\u1ee9 t\u1ef1 trong danh s\u00e1ch Slicer"},"content":{"rendered":"
\n

T\u00ednh n\u0103ng Slicers trong Excel mang l\u1ea1i r\u1ea5t nhi\u1ec1u c\u00f4ng d\u1ee5ng nh\u01b0ng c\u0169ng c\u00f3 nhi\u1ec1u m\u1eb7t h\u1ea1n ch\u1ebf.<\/strong><\/h1>\n

S\u1eed d\u1ee5ng Slicer l\u00e0 m\u1ed9t c\u00e1ch tuy\u1ec7t v\u1eddi \u0111\u1ec3 t\u0103ng t\u00ednh t\u01b0\u01a1ng t\u00e1c trong b\u1ea3ng t\u00ednh Excel. Slicer cho ph\u00e9p ta l\u1ecdc nh\u1eefng d\u1eef li\u1ec7u c\u1ea7n thi\u1ebft trong danh s\u00e1ch v\u00e0 thay v\u00e0o \u0111\u00f3 ng\u01b0\u1eddi d\u00f9ng ch\u1ec9 \u0111\u01a1n gi\u1ea3n \u1ea5n ch\u1ecdn m\u1ed9t m\u1ee5c \u0111\u1ec3 l\u1ecdc ho\u1eb7c ch\u1ec9nh s\u1eeda d\u1eef li\u1ec7u c\u00f3 tr\u01b0\u1edbc.<\/p>\n

Tuy nhi\u00ean. Microsoft m\u1edbi ch\u1ec9 \u0111\u1ec3 c\u00e1c m\u1ee5c n\u00e0y \u1edf d\u1ea1ng ch\u1ee9c n\u0103ng \u0111\u01a1n gi\u1ea3n, \u0111i\u1ec1u n\u00e0y ng\u0103n c\u1ea3n ch\u00fang v\u01b0\u1ee3t ra kh\u1ecfi gi\u1edbi h\u1ea1n. M\u1ed9t trong nh\u1eefng h\u1ea1n ch\u1ebf l\u00e0 c\u00e1ch s\u1eafp x\u1ebfp th\u1ee9 t\u1ef1 c\u00e1c m\u1ee5c trong Slicer \u0111\u00e3 \u0111\u01b0\u1ee3c \u00a0\u0111\u1ecbnh s\u1eb5n.<\/p>\n

Khi t\u1ea1o Slicer, b\u1ea1n th\u01b0\u1eddng s\u1ebd \u0111\u1ec3 c\u00e1c m\u1ee5c hay s\u1eed d\u1ee5ng nh\u1ea5t l\u00ean d\u00f2ng \u0111\u1ea7u. \u0110i\u1ec1u n\u00e0y l\u00e0 do h\u1ea7u h\u1ebft m\u1ecdi ng\u01b0\u1eddi \u0111\u1ec1u c\u00f3 xu h\u01b0\u1edbng ch\u1ec9 nh\u00ecn l\u01b0\u1edbt qua c\u00e1c m\u1ee5c t\u01b0\u01a1ng t\u1ef1 nh\u01b0 c\u00e1ch h\u1ecd \u0111\u1ecdc s\u00e1ch n\u00ean s\u1ebd kh\u00f4ng mu\u1ed1n m\u1ea5t th\u1eddi gian b\u1eb1ng c\u00e1ch \u0111\u1eb7t nh\u1eefng m\u1ee5c ph\u1ed5 bi\u1ebfn \u1edf gi\u1eefa.<\/p>\n

Slicers ch\u1ec9 cho ph\u00e9p ch\u00fang ta s\u1eafp x\u1ebfp c\u00e1c m\u1ee5c theo th\u1ee9 t\u1ef1 b\u1ea3ng ch\u1eef c\u00e1i ( t\u0103ng d\u1ea7n ho\u1eb7c gi\u1ea3m d\u1ea7n). Nh\u01b0ng kh\u00f4ng ph\u1ea3i l\u00fac n\u00e0o m\u1ee5c ph\u1ed5 bi\u1ebfn nh\u1ea5t c\u1ee7a b\u1ea1n c\u0169ng b\u1eaft \u0111\u1ea7u b\u1eb1ng ch\u1eef A cho n\u00ean \u0111i\u1ec1u n\u00e0y \u0111\u00e3 \u0111\u1eb7t ra m\u1ed9t v\u1ea5n \u0111\u1ec1 cho ng\u01b0\u1eddi d\u00f9ng.<\/p>\n

V\u00ed d\u1ee5 minh h\u1ecda:<\/strong><\/p>\n

H\u00e3y xem x\u00e9t v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y, ch\u00fang ta mu\u1ed1n t\u1ea1o c\u00e1c m\u1ee5c trong Slicer \u0111\u1ec3 ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 l\u1ecdc m\u1ed9t th\u00e1ng ho\u1eb7c qu\u00fd nh\u1ea5t \u0111inh. \u00a0Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, c\u00e1c qu\u00fd d\u01b0\u1eddng nh\u01b0 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng ph\u1ed5 bi\u1ebfn h\u01a1n v\u00ec ng\u01b0\u1eddi s\u1eed d\u1ee5ng d\u1eef li\u1ec7u n\u00e0y ch\u1ec9 b\u00e1o c\u00e1o k\u1ebft qu\u1ea3 ba th\u00e1ng m\u1ed9t l\u1ea7n.<\/p>\n

B\u1edfi v\u00ec c\u00e1c qu\u00fd l\u00e0 nh\u1eefng m\u1ee5c ph\u1ed5 bi\u1ebfn n\u00ean ch\u00fang n\u00ean \u0111\u01b0\u1ee3c \u00a0x\u1ebfp\u00a0 l\u00ean h\u00e0ng \u0111\u1ea7u. \u0110i\u1ec1u n\u00e0y c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n \u0111\u01b0\u1ee3c b\u1eb1ng c\u00e1c s\u1eafp x\u1ebfp d\u1eef li\u1ec7u theo th\u1ee9 t\u1ef1 t\u1eeb Z \u0111\u1ebfn A. Tuy nhi\u00ean \u0111i\u1ec1u s\u1ebd k\u00e9o theo t\u1ea5t c\u1ea3 c\u00e1c m\u1ee5c kh\u00e1c b\u1ecb x\u1ebfp ng\u01b0\u1ee3c l\u1ea1i.<\/p>\n

<\/p>\n

\n
\n
\n
\n<\/a>\n<\/div>\n<\/div>\n

M\u1ed9t c\u00e1ch gi\u1ea3i quy\u1ebft m\u00e0 b\u1ea1n c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n l\u00e0 \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 cho c\u00e1c m\u1ee5c, tuy nhi\u00ean \u0111i\u1ec1u n\u00e0y c\u00f3 th\u1ec3 l\u00e0m x\u00e1o tr\u1ed9n c\u00e1c ph\u1ea7n kh\u00e1c trong trang t\u00ednh ho\u1eb7c g\u00e2y ra s\u1ef1 nh\u1ea7m l\u1eabn (v\u00ed d\u1ee5 \u201c05.Jan\u201d -> Th\u00e1ng m\u1ed9t kh\u00f4ng ph\u1ea3i th\u00e1ng \u0111\u1ea7u ti\u00ean? ). V\u00ec v\u1eadu \u0111\u00e2y c\u00f3 l\u1ebd kh\u00f4ng ph\u1ea3i c\u00e1ch gi\u1ea3i quy\u1ebft kh\u1ea3 thi cho tr\u01b0\u1eddng n\u00e0y.<\/p>\n

<\/p>\n

Gi\u1ea3i ph\u00e1p: S\u1eed d\u1ee5ng \u00a0Custom List<\/strong><\/p>\n

S\u1eed d\u1ee5ng Custom Lists \u0111\u1ec3 s\u1eafp x\u1ebfp th\u1ee9 t\u1ef1 c\u1ee5 th\u1ec3 cho c\u00e1c m\u1ee5c trong Slicers theo \u00fd mu\u1ed1n.<\/p>\n

Th\u1ef1c t\u1ebf, t\u00ednh n\u0103ng Custom List \u0111\u01b0\u1ee3c ng\u01b0\u1eddi d\u00f9ng s\u1eed d\u1ee5ng m\u1ecdi l\u00fac. B\u1ea1n \u0111\u00e3 bao gi\u1edd nh\u1eadp m\u1ed9t \u00f4 v\u1edbi n\u1ed9i dung l\u00e0 \u201cJanuary\u201d v\u00e0 sau \u0111\u00f3 xu\u1ea5t\u00a0 hi\u1ec7n m\u1ed9t danh s\u00e1ch t\u1ea5t c\u1ea3 c\u00e1c th\u00e1ng c\u00f2n l\u1ea1i. S\u1edf d\u0129 \u0111i\u1ec1u n\u00e0y x\u1ea3y ra l\u00e0 do Excel \u0111\u00e3 t\u1ea1o tr\u01b0\u1edbc nh\u1eefng danh s\u00e1ch n\u00e0y n\u00ean c\u1ea3 danh s\u00e1ch s\u1ebd xu\u1ea5t hi\u1ec7n khi m\u1ed9t gi\u00e1 tr\u1ecb nh\u1ea5t \u0111\u1ecbnh \u0111\u01b0\u1ee3c nh\u1eadp.<\/p>\n

<\/p>\n

D\u01b0\u1edbi \u0111\u00e2y l\u00e0 b\u1ed1n danh s\u00e1ch \u0111\u01b0\u1ee3c m\u1eb7c \u0111\u1ecbnh trong Excel:<\/p>\n

<\/p>\n

\u00a0<\/p>\n

V\u00ec v\u1eady, h\u00e3y th\u1eed t\u1ea1o m\u1ed9t Custom List d\u1ef1a tr\u00ean th\u1ee9 t\u1ef1 c\u00e1c m\u1ee5c trong Slicer mong mu\u1ed1n. B\u1ea3ng d\u01b0\u1edbi \u0111\u00e2y l\u00e0 danh s\u00e1ch mu\u1ed1n t\u1ea1o \u0111\u01b0\u1ee3c x\u1ebfp \u00a0theo th\u1ee9 t\u1ef1 t\u1eeb tr\u00e1i sang ph\u1ea3i, tr\u00ean xu\u1ed1ng d\u01b0\u1edbi, \u0111\u1ed3ng th\u1eddi c\u00e1c qu\u00fd \u0111\u01b0\u1ee3c x\u1ebfp l\u00ean h\u00e0ng \u0111\u1ea7u v\u00e0 c\u00e1c d\u00f2ng d\u01b0\u1edbi m\u1ed7i qu\u00fd l\u00e0 ba th\u00e1ng trong qu\u00fd.<\/p>\n

<\/p>\n

B\u00e2y gi\u1edd ch\u00fang ta \u0111\u00e3 c\u00f3 m\u1ed9t danh s\u00e1ch theo th\u1ee9 t\u1ef1 mong mu\u1ed1n, vi\u1ec7c ti\u1ebfp theo l\u00e0 th\u1ef1c hi\u1ec7n c\u00e1c b\u01b0\u1edbc sau \u0111\u1ec3 t\u1ea1o m\u1ed9t Custom List:<\/p>\n

    \n
  1. Ch\u1ecdn tab File<\/li>\n
  2. \u1ea4n Options<\/li>\n
  3. Ch\u1ecdn Advanced \u1edf ph\u00eda b\u00ean tr\u00e1i<\/li>\n
  4. K\u00e9o thanh d\u1ecdc xu\u1ed1ng d\u01b0\u1edbi c\u00f9ng<\/li>\n
  5. \u1ea4n v\u00e0o Edit Custom Lists<\/li>\n<\/ol>\n

    <\/p>\n

    Xu\u1ea5t hi\u1ec7n h\u1ed9p tho\u1ea1i, s\u1ebd c\u00f3 nhi\u1ec1u s\u1ef1 l\u1ef1a ch\u1ecdn \u0111\u1ec3 t\u1ea1o m\u1ed9t danh s\u00e1ch: g\u00f5 tr\u1ef1c ti\u1ebfp danh s\u00e1ch v\u00e0o mi\u1ec1n v\u0103n b\u1ea3n ho\u1eb7c s\u1eed d\u1ee5ng n\u00fat M\u0169i t\u00ean \u0111\u1ec3 l\u1ef1a ch\u1ecdn danh s\u00e1ch c\u00f3 s\u1eb5n. Trong v\u00ed d\u1ee5 n\u00e0y, danh s\u00e1ch \u0111\u00e3 \u0111\u01b0\u1ee3c t\u1ea1o trong trang t\u00ednh, kh\u00f4ng c\u1ea7n g\u00f5 l\u1ea1i. V\u00ec v\u1eady ti\u1ebfp t\u1ee5c theo c\u00e1c b\u01b0\u1edbc sau:<\/p>\n

      \n
    1. Ch\u1ecdn Arrow v\u00e0 b\u00f4i \u0111en danh s\u00e1ch m\u00e0 b\u1ea1n mu\u1ed1n th\u00eam v\u00e0o trong Custom List<\/li>\n
    2. \u1ea4n Import v\u00e0 \u0111\u1ee3i c\u00e1c gi\u00e1 tr\u1ecb xu\u1ea5t hi\u1ec7n trong h\u1ed9p List Entries<\/li>\n
    3. \u1ea4n OK \u0111\u1ec3 x\u00e1c nh\u1eadn danh s\u00e1ch m\u1edbi.<\/li>\n<\/ol>\n

      <\/p>\n

      Sau khi t\u1ea1o Custom List, click chu\u1ed9t ph\u1ea3i v\u00e0o Slicers v\u00e0 ch\u1ecdn Sort A to Z \u0111\u1ec3 xem k\u1ebft qu\u1ea3.<\/p>\n

      <\/p>\n

      M\u1ed9t v\u00e0i l\u01b0u \u00fd:<\/strong><\/p>\n

      T\u00ednh n\u0103ng Custom Lists thu\u1ed9c ph\u1ea7n c\u00e0i \u0111\u1eb7t c\u1ea5p \u1ee9ng d\u1ee5ng. \u0110i\u1ec1u n\u00e0y c\u00f3 ngh\u0129a l\u00e0 n\u1ebfu b\u1ea1n m\u1edf m\u1ed9t file kh\u00e1c v\u00e0 nh\u1eadp g\u00eda tr\u1ecb thu\u1ed9c Custom List, Excel s\u1ebd s\u1eed d\u1ee5ng danh s\u00e1ch gi\u00e1 tr\u1ecb m\u1edbi m\u00e0 kh\u00f4ng d\u00f9ng l\u1ea1i gi\u00e1 tr\u1ecb c\u0169. V\u00ec v\u1eady \u0111\u1eebng b\u1ed1i r\u1ed1i khi \u0111i\u1ec1u \u0111\u00f3 x\u1ea3y ra. L\u1eddi khuy\u00ean l\u00e0 n\u00ean x\u00f3a Custom List tr\u1eeb khi b\u1ea1n th\u01b0\u1eddng xuy\u00ean s\u1eed d\u1ee5ng ch\u00fang.<\/p>\n

      Sau khi x\u00f3a Custom List, n\u1ebfu \u00a0mu\u1ed1n s\u1eafp x\u1ebfp l\u1ea1i th\u1ee9 t\u1ef1 c\u00e1c m\u1ee5c trong t\u01b0\u01a1ng lai th\u00ec ch\u00fang s\u1ebd \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp theo th\u1ee9 t\u1ef1 b\u1ea3ng ch\u1eef c\u00e1i.<\/p>\n<\/div>\n

      \n

      Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n

      T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0\ud83d\udcd6<\/span><\/a><\/p>\n

      H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n

      HKD H\u1ecdc Excel Online
      S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n

      \n

      \u00a9 document.currentScript.insertAdjacentHTML(‘afterend’, ” + new Intl.DateTimeFormat(document.documentElement.lang, {year: ‘numeric’}).format() + ”); H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

      \n
      \n
      \n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":11336,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-11335","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/11335","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=11335"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/11335\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/11336"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=11335"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=11335"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=11335"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}