Mostly, the differences are found in the formatting options. Multiple options from the Find & Select feature, such as constants, formulae, and more.Easy rows and columns filling from multiple directions.Customizable new table and cell format styles.Some styling options from the Number group, such as Percent Style and Comma Style.In reality, these options are still there, but they’re hidden in the dropdown menus.ĭespite that, the online version lacks the following feature as compared to the desktop app: The Home MenuĪt first, you’ll think that the menu in Microsoft Excel Online doesn’t have many options like the desktop version. Let’s begin our one-on-one with the features offered by both Excel versions. In this article, we will get deeper insights into how they differ from each other, along with a side-by-side comparison of their features. So, it’s easy to use all the new features of the online version that the Excel Desktop app version doesn’t offer.īoth versions have their pros and cons. Typically, you can access almost all the features of the cloud-based Microsoft Office applications with an Office 365 subscription.

It resembles the traditional Excel in various domains but has some exceptions.

Microsoft Support has more information within their article about Sheet Views in Excel.Excel Online is an easy-to-use, slimmed version of the desktop app.

If you saved your view, you can select it from the View > Sheet View drop-down menu.

Upon closing the file, it will be reset to its Default view.

There can be up to 256 sheet views per Excel workbook file.

Sheet views that you create are visible for all who have access to the file by going to the View > Sheet View drop-down menu.

You can rename the view you just created, you can duplicate an existing view, delete views you no longer need or switch to another view. Select the Options button to manage your views. If you select Exit, a dialog box will allow you to rename the view in order to keep it or to discard the view. You can rename it by selecting the Options button. This will rename your temporary view, View1. If you decide that you like your view, select the Keep button. You can add filters, sort the data, and freeze panes (among other options) however you wish. Select the New button adjacent to the Sheet View drop-down menu. Go into an Excel workbook file and select the View tab from the ribbon menu. Note: Sheet views work for Excel files that are stored in OneDrive or SharePoint.

View excel online