computer on table

Sheet View makes collaborating easier

Feature deep dive
  • Share on Facebook
  • Share on Twitter
  • Share on LinkedIn

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.

screen shot of sheet view prompt

 

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 view 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.

Availability

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.

Feedback

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!