iOS, iPad and Android mobiles now support sheet view. For collaboration to work, you must save the workbook to OneDrive or SharePoint. I’m using Microsoft 365 Excel for the web on a Windows 10 64-bit system and OneDrive for Business. This feature would be more helpful if they did so, but perhaps this capability will be added in a future upgrade. Unfortunately, the process doesn’t save with the custom sheet view.
The process is simple, but it’s something users might not realize is available. In this tutorial, I’ll show you how to create a sheet view in a shared Excel workbook and then add groups as well as hidden rows and columns. Microsoft 365: A side-by-side analysis w/checklist (TechRepublic Premium) After applying a sheet view, a collaborator can hide data and other collaborators won’t see this change. Now, sheet views support hidden rows and columns and groups while collaborating. To read about this feature, read How to use sheet view for more flexible collaboration in Excel.
For more info, visit our Terms of Use page.Ī few years ago, Microsoft Excel improved collaboration by adding sheet view to shared workbooks. This may influence how and where their products appear on our site, but vendors cannot pay to influence the content of our reviews. We may be compensated by vendors who appear on this page through methods such as affiliate links or sponsored partnerships. Microsoft Excel’s sheet view collaboration feature has been around for a while, but now it supports hiding rows and columns and applying groups. How to hide rows and columns and use groups in a shared Microsoft Excel workbook
0 kommentar(er)
