The following Data menu features are missing from Microsoft Excel online: None of those missing features are found in any hidden menus either. The Data MenuĪt first glance, it’s pretty clear that Microsoft Excel online only has about half of the features present in the Excel for desktop version. You just have to go about finding them somewhat differently than you do in Excel for desktop. If you change the Pick a category dropdown to All, you see that just about all of the formula functions you’d expect to be present in Excel are there. You can also follow Excel on Facebook and Twitter. To stay connected to Excel and its community, read the Excel blog posts and send us ideas and suggestions via UserVoice. We’ve started the rollout to users on Excel for the web and will be available to all Excel for the web users within the coming weeks.

All you need to do is click on the View tab and find the Sheet View you saved in the drop down list on the left side of the ribbon.

Views can be accessed again in the document at a later time once saved. Sheet Views are temporary initially, so once you’re done with your work, you can choose to save the view to reuse later or discard it. You can also create a new Sheet View by going to the View tab and clicking the eye icon labelled ‘New’. If you’re in the document with others, you’ll receive a prompt to enter a Sheet View if you want to sort and filter in a separate view. All your cell level edits propagate through the file regardless of your view, so you can make all of your in-cell edits in your Sheet View, too. You can filter to display only the records that are important to you without being affected by others collaborating in the document. Introducing Sheet View on Excel for the web, a new way of letting you create customized views in an Excel worksheet to sort and filter your data. We realize that our users want to collaborate in a document, but also accomplish their own tasks while sorting or filtering data in a table. We love all the benefits of collaboration, but it does mean that when collaborating, everyone's changes are immediately seen in the document by you. Have you ever collaborated with someone else in a worksheet, looking at a large data set, 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 your worksheet.

View excel online