Hi, Office Insiders, I’m Avani Reddy, a PM on the Excel team. I’m happy to announce Sheet View is available for you to try. Have you ever collaborated with someone in a worksheet and suddenly the table shrinks and you’re unable to finish your work? Often, this happens when someone adds filters to or sorts a column in a table of a shared worksheet.
Introducing Sheet View
You spoke – we listened. Introducing Sheet View on Excel Desktop. It’s a new way to create customized views in an Excel worksheet to sort and filter your data. You can filter to display only the records important to you without being affected by others in the document. All your cell level edits propagate through the file regardless of your view, so you can make all your in-cell edits in your view, too.
How it works
If you’re in the worksheet or workbook with others, you’ll receive a prompt to use a Sheet view if you want to sort and filter in a separate view. You can also create a Sheet View by clicking the View tab and clicking the New button.
Sheet views are temporary initially. Once you’re done with your work, you can choose to save the view to reuse later or discard it. To discard it, simply exit the Sheet view. Views can be accessed again in the worksheet or workbook later, once saved. All you need to do is click the View tab and find the Sheet view you saved in the drop-down list on the left side of the ribbon.
This feature is available to Beta Channel users running Version 2005 Build 12816.20006.
This feature is available to Mac Slow users running Version 16.38 (20061401).
We typically release features over some time to ensure that things are working smoothly. This is true for Insiders as well. We highlight features that you may not have because they’re slowly releasing to larger numbers of Insiders. Sometimes we remove elements to further improve them based on your feedback. Though this is rare, we also reserve the option to pull a feature entirely out of the product, even if you, as Insiders, have had the opportunity to try them.
If you have any feedback or suggestions, you can submit them by clicking Help > Feedback. To stay connected to Excel and its community, send us ideas and suggestions via UserVoice.
Learn what other information you should include in your feedback to ensure it’s actionable and reaches the right people. We’re excited to hear from you!
Sign up for the Office Insider newsletter and get the latest information about Insider features in your inbox once a month!