{"id":26917,"date":"2026-10-26T09:22:46","date_gmt":"2026-10-26T02:22:46","guid":{"rendered":"https:\/\/gcloudvn.com\/?p=26917"},"modified":"2026-10-26T09:22:46","modified_gmt":"2026-10-26T02:22:46","slug":"manually-reorder-and-custom-sort-pivot-tables-in-google-sheets","status":"publish","type":"post","link":"https:\/\/gcloudvn.com\/en\/manually-reorder-and-custom-sort-pivot-tables-in-google-sheets\/","title":{"rendered":"Manually reorder and custom sort pivot tables in Google Sheets"},"content":{"rendered":"<p><span style=\"font-weight: 400;\">Google Sheets now supports custom sorting and manual reordering in pivot tables. Users can now drag and drop rows and columns on a pivot table to match specific presentation needs and custom business hierarchies, rather than being restricted to standard ascending or descending alphanumeric order. This launch includes the following capabilities:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">On-grid drag-and-drop: Directly grab and move individual row or column headers with clear drop-zone indicators<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Multi-item reordering: Select and reposition multiple rows or columns simultaneously<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Hierarchical preservation: Automatically move nested child items alongside parent fields, maintaining structure across expand and collapse actions<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Persistent sort states: Preserve custom arrangements across browser sessions, data refreshes, filtering, and layout adjustments<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">This update also delivers significant improvements for Microsoft Excel file interoperability. Previously, when importing Microsoft Excel workbooks containing pivot tables with manual or custom sort orders, Google Sheets defaulted back to ascending or descending order. Now, imported spreadsheets retain their pivot tables with the exact custom sort order preserved. Furthermore, exporting workbooks back to Microsoft Excel retains these sorted orders for seamless roundtrip compatibility.<\/span><\/p>\n<p><a href=\"https:\/\/gcloudvn.com\/en\/introducing-skills-in-the-gemini-app-and-workspace-plus-whats-next-for-gems\/attachment\/manually-reorder-and-custom-sort-pivot-tables-in-google-sheets-6842\/\" rel=\"attachment wp-att-26885\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-26885\" src=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2026\/10\/Manually-reorder-and-custom-sort-pivot-tables-in-Google-Sheets-6842.gif\" alt=\"\" width=\"1600\" height=\"1001\" srcset=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2026\/10\/Manually-reorder-and-custom-sort-pivot-tables-in-Google-Sheets-6842.gif 1600w, https:\/\/gcloudvn.com\/wp-content\/uploads\/2026\/10\/Manually-reorder-and-custom-sort-pivot-tables-in-Google-Sheets-6842-768x480.gif 768w, https:\/\/gcloudvn.com\/wp-content\/uploads\/2026\/10\/Manually-reorder-and-custom-sort-pivot-tables-in-Google-Sheets-6842-1536x961.gif 1536w, https:\/\/gcloudvn.com\/wp-content\/uploads\/2026\/10\/Manually-reorder-and-custom-sort-pivot-tables-in-Google-Sheets-6842-18x12.gif 18w\" sizes=\"auto, (max-width: 1600px) 100vw, 1600px\" \/><\/a><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_88 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\" style=\"cursor:inherit\">Table of contents<\/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\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" 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><\/span><\/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-3'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/gcloudvn.com\/en\/manually-reorder-and-custom-sort-pivot-tables-in-google-sheets\/#Bat_dau_su_dung\" >Getting started<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/gcloudvn.com\/en\/manually-reorder-and-custom-sort-pivot-tables-in-google-sheets\/#Toc_do_phat_hanh\" >Rollout pace<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/gcloudvn.com\/en\/manually-reorder-and-custom-sort-pivot-tables-in-google-sheets\/#Kha_dung_Availability\" >Availability<\/a><\/li><\/ul><\/nav><\/div>\n<h3><span class=\"ez-toc-section\" id=\"Bat_dau_su_dung\"><\/span><b>Getting started<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Admins: There is no admin control for this feature.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">End users: Visit the Help Center to learn more about customizing pivot tables in Google Sheets or creating and using pivot tables in Google Sheets.<\/span><\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"Toc_do_phat_hanh\"><\/span><b>Rollout pace<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\">Rapid Release domains: Gradual rollout (up to 15 days for feature visibility) starting on August 25, 2026<\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\">Scheduled Release domains: Full rollout (1\u20133 days for feature visibility) starting on October 19<\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"Kha_dung_Availability\"><\/span><b>Availability<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Available to all Google Workspace customers, as well as G Suite Basic and Business customers and users with personal Google Accounts.<\/span><\/li>\n<\/ul>","protected":false},"excerpt":{"rendered":"<p>Google Sheets hi\u1ec7n h\u1ed7 tr\u1ee3 s\u1eafp x\u1ebfp t\u00f9y ch\u1ec9nh v\u00e0 s\u1eafp x\u1ebfp l\u1ea1i th\u1ee7 c\u00f4ng trong b\u1ea3ng t\u1ed5ng h\u1ee3p (Pivot Table). Ng\u01b0\u1eddi d\u00f9ng hi\u1ec7n c\u00f3 th\u1ec3 k\u00e9o v\u00e0 th\u1ea3 c\u00e1c h\u00e0ng v\u00e0 c\u1ed9t trong b\u1ea3ng t\u1ed5ng h\u1ee3p \u0111\u1ec3 ph\u00f9 h\u1ee3p&hellip;<\/p>","protected":false},"author":2,"featured_media":26884,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[1,134],"tags":[],"class_list":["post-26917","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-kienthuc","category-google-workspace","entry","has-media"],"_links":{"self":[{"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/posts\/26917","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/comments?post=26917"}],"version-history":[{"count":2,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/posts\/26917\/revisions"}],"predecessor-version":[{"id":26919,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/posts\/26917\/revisions\/26919"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/media\/26884"}],"wp:attachment":[{"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/media?parent=26917"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/categories?post=26917"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/tags?post=26917"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}