微信内可能无法直接打开本站。请点右上角 ··· → 在浏览器打开，或复制链接。
Google Sheets now plays more nicely with your imported Excel spreadsheets
RSS 官方收录 · 可信分层展示
关键摘要
TL;DR Google Sheets now lets users drag and drop rows or columns in pivot tables.It also maintains data hierarchy when moving rows or columns with nested child items.…
- It now also preserves custom-sorted pivot tables when importing Excel …
- The last few months have been really great for Google Sheets users.
- Google has steadily rolled out new updates and features, introduced us…
规则摘要 · 来源可核验
正文提要
- Google Sheets now lets users drag and drop rows or columns in pivot tables.
- It also maintains data hierarchy when moving rows or columns with nested child items.
- It now also preserves custom-sorted pivot tables when importing Excel spreadsheets.
The last few months have been really great for Google Sheets users. Google has steadily rolled out new updates and features, introduced useful add-ons, and improved support for pivot tables. Now, it’s making it easier for users to manipulate pivot tables directly in Sheets.
Google announced today that Sheets can now preserve custom sorting in pivot tables imported from Excel spreadsheets. Previously, Sheets reverted pivot tables to a standard alphanumeric sort order. However, it will now maintain any custom sort you’ve applied within Excel so you can easily move between the two apps. Exporting a Sheets file to an Excel spreadsheet also maintains the exact sorting order of your pivot tables.