如果您有Office 365订阅,则可以访问基于云的Office应用程序版本提供的所有功能。但这是否意味着Microsoft Excel在线版拥有您在桌面版Excel中可以找到的所有功能?(Excel)
在本文中,我们将对两者进行并排比较,并展示您在使用 Microsoft Excel Online时会发现缺少哪些功能。
主菜单
从主菜单(Home Menu)开始,乍一看,Microsoft Excel Online 中的菜单似乎缺少桌面版 Excel中的很多按钮。(Excel)
这在技术上是不正确的,只是在线版本更多地使用了下拉菜单。
那么在线Microsoft Excel中缺少什么?在主(Home)菜单上,您会发现Excel for desktop 的以下所有功能都在在线版本中丢失。
- (Percent Style)数字(Number)组中的百分比样式和逗号样式。(Comma Style)
- 自定义新的表格格式样式。
- 自定义新的单元格格式样式。
- 保护工作表。
- 锁定一个单元格。
- 在任何方向填充行或列。
- 缺少整个清除菜单(用于清除格式、评论等)。
- 缺少大部分“查找(Find)和选择(Select)”菜单(公式、注释、常量等)。
在大多数情况下,当涉及到主菜单时,您确实不会丢失在(Home)Excel for desktop中找到的任何主要功能。几乎所有可以在桌面版本上执行的格式(包括条件格式),您都可以在Excel在线版中执行。
插入菜单
插入(Insert)菜单在Excel在线版本中看起来也很基本,但这也是因为大多数高级功能都隐藏在子菜单中。
在“插入”菜单上,如果您使用(Insert)Excel的在线版本,您将错过桌面版Excel的以下功能。
- 创建数据透视(Creating a PivotTable)表缺少使用外部数据源的能力,并且您无法一次分析多个表。
- 没有插入图标、3D 模型或SmartArt的选项。
- 图表和图形选项(Charts and graph options)严重缺乏。
- (Text)缺少文本框、艺术字、签名行和对象。(WordArt)
- 没有符号菜单。
在线版和桌面版Excel之间的(Excel)插入(Insert)菜单最显着的区别肯定是图表菜单。
Microsoft Excel online 确实有一些图表可供选择,但它们非常基础。您会发现 2D 柱形图、折线图、饼图、条形图和面积图。
但是,在Excel for Desktop中,您会获得这些图表类型的大量集合。这些包括大多数图表和图形类型的 2D 和 3D 版本、树形图和旭日形图、直方图、散点图和气泡图,甚至 2D 和 3D 地图。
如果您在Excel(Excel)中进行大量高级制图,您可能会对Microsoft Excel在线选项的缺乏感到非常失望。
公式菜单
如果您选择在线Microsoft Excel中的“(Microsoft Excel)公式(Formulas)”菜单并期望在桌面版Excel中看到各种选项,那么您会大吃一惊。
事实上,菜单几乎是空的。当您将此与Excel桌面版进行比较时,会发现缺少多少功能,这非常令人震惊。
您可以看到Excel for desktop 中的“(Excel)公式(Formulas)”菜单充满了整个下拉菜单,所有这些公式都组织到子菜单中。功能区中还有具有公式审核功能的组和监视窗口(a watch window)。
Excel Online在该区域中匹配的唯一功能是能够触发工作表中的公式计算。这是否意味着在线Microsoft Excel中缺少公式?一点也不。你只需要以不同的方式对待它们。
如果您选择公式字段附近的函数图标,您将看到一个弹出窗口,您可以在其中搜索Excel提供的众多函数之一。
如果您将Pick a category下拉菜单更改为All,您会看到您希望Excel中出现的几乎所有公式函数都在那里。你只需要去寻找它们与你在桌面版Excel中所做的有所不同。(Excel)
数据菜单
乍一看,很明显,Microsoft Excel在线版仅具有(Microsoft Excel)Excel桌面版中大约一半的功能。在任何隐藏菜单中也找不到这些缺失的功能。
Microsoft Excel联机版中缺少以下数据菜单功能:(Data)
- 无法从文本、Web 或数据库文件等外部来源“获取数据”。(Get Data)
- 没有高级过滤选项(filtering options)。
- 数据(Data)工具组缺少列(Columns)、快速填充、合并和关系的文本。
- 在Excel(Excel)桌面版功能区上根本找不到任何预测或大纲组。
即使缺少所有这些数据(Data)菜单功能,至少在线Microsoft Excel确实提供了从 Internet 引入股票和地理数据源的能力,这是一件好事。
如果您对使用Excel(Excel)检索外部数据源不感兴趣,那么“数据(Data)”菜单中缺少的大多数功能都不会打扰您。
审查菜单
在 Excel 桌面版中,审阅(Review)菜单通常是您进行编辑和拼写检查的地方。如果您在Excel的桌面版本中使用过它,那么您已经习惯了能够添加评论、注释,甚至使用嵌入式词库。
那么在线版Excel中缺少哪些功能呢?
- 没有嵌入式词库。
- 缺少智能查找见解。
- 缺少语言翻译工具。
- 没有“备注(Notes)”功能,但您可以将备注(Notes)转换为评论(Comments)。
- 无法保护工作簿或工作表。
- 没有“着墨”编辑功能。
如果您进行大量编辑(尤其是其他人的工作),并且您确实需要桌面版Excel中的墨迹书写或注释功能,那么您将对Microsoft Excel在线版感到非常失望。如果您使用桌面版本中的同义词库,则尤其如此。
查看菜单
Excel for desktop 中的“查看”(View)菜单包含许多功能。在这一点上,您可能不会惊讶地发现Microsoft Excel在线缺少很多这些内容。
事实上,您所能做的就是创建一个私人工作表视图、打开一个新的电子表格窗口、冻结窗格或隐藏和显示标题和网格线。
缺少所有其他功能,例如:
- 分页符、页面布局(page layout)和自定义视图。
- 隐藏公式栏。
- 缩放功能。
- 排列(Arranging)、分割、隐藏或切换窗口。
- 宏。
无论如何,这些功能中的大多数都与在线应用程序无关。例如,无法在基于浏览器的应用程序中创建或运行VBA宏。(VBA)大多数这些缺失的功能不应该影响您对Microsoft Excel的整体使用。
完全缺失的菜单
虽然Microsoft Excel在线提供了您在桌面版(Microsoft Excel)Excel中找到的核心菜单,但实际上完全缺失了整个菜单。
这些菜单包括:
- 绘制(Draw):使用鼠标绘制线条或突出显示区域
- 页面布局(Page Layout):应用主题、边距、方向、打印区域以及对齐或组织对象
- 时间线(Timeline):在时间范围内按时间顺序直观地显示事件 - 对项目时间表等有用
- 开发人员(Developer):将宏或VBA代码添加到电子表格
除此之外,无法在线向Microsoft Excel添加任何其他加载项或菜单,因为文件(File)菜单缺少选项(Options)选项,您通常会在桌面版Excel中添加这些选项。
同样,这对于在线应用程序来说并不奇怪。但是,如果您喜欢通过使用加载项或启用一些桌面版Excel中可用的非默认菜单来向Excel添加许多附加功能,则需要考虑这一点。(Excel)
最终判决
鉴于Microsoft Excel在线提供的所有核心功能与(Microsoft Excel)Excel桌面版相比缺少的所有功能,在线版本可能会有所不足。但这并不意味着它没有用。
如果您通常只将Excel用于最常见的用途,例如创建用于计算或组织的电子表格,您会在Microsoft Excel在线中找到所需的一切。如果您需要引入外部资源或进行大量VBA编码或宏,您将要坚持使用Excel桌面版。
Differences Between Microsoft Excel Online And Excel For Desktop
If yоu have an Office 365 subscrіption, then you haνe access to all of the features that the cloud-bаsed versions of Office applications offer. But does that mean that Microsoft Excel online has all of the features you’d find in Excel for desktop?
In this article we’ll do a side-by-side comparison of the two and show what features you’ll find lacking when you use Microsoft Excel Online.
The Home Menu
Starting with the Home Menu, at first glance it looks like the menu in Microsoft Excel online lacks a lot of the buttons in the Excel for desktop version.
This technically isn’t true, it’s just that the online version makes more use of dropdown menus.
So what’s missing in Microsoft Excel online? On the Home menu, you’ll discover that all of the following features from Excel for desktop are missing from the online version.
- Percent Style and Comma Style from the Number group.
- Customizing new table format styles.
- Customizing new cell format styles.
- Protecting a sheet.
- Locking a cell.
- Filling rows or columns in any direction.
- Entire clear menu is missing (to clear formats, comments, and more).
- Most of the Find & Select menu is missing (formulas, notes, constants, and more).
For the most part, when it comes to the Home menu, you really aren’t losing any of the major functionality that you find in Excel for desktop. Just about all of the formatting (including conditional formatting) that you can do on the desktop version, you can do just as well in Excel online.
The Insert Menu
The Insert menu also looks pretty basic in the Excel online version, but again this is because most of the advanced features are buried in submenus.
On the Insert menu, you’ll miss out on the following features from Excel for desktop if you use the online version of Excel.
- Creating a PivotTable is missing the ability to use an external data source, and you can’t analyze multiple tables at once.
- No option to insert icons, 3D models, or SmartArt.
- Charts and graph options are dramatically lacking.
- Text box, WordArt, a signature line, and objects are missing.
- No symbols menu.
The most significant difference in the Insert menu between the online and desktop versions of Excel is definitely the charts menu.
Microsoft Excel online does have a selection of charts, but they are very basic. You’ll find 2D column, line, pie, bar, and area charts.
However, in Excel for Desktop, you get a massive collection of each of these chart types. These include 2D and 3D versions of most chart and graph types, treemap and sunburst, histogram, scatter and bubble charts, and even 2D and 3D maps.
If you do a lot of advanced charting in Excel, you’re probably going to be very disappointed by the lack of options in Microsoft Excel online.
The Formulas Menu
If you select the Formulas menu in Microsoft Excel online expecting to see the variety of options in Excel for desktop, you’re in for quite a surprise.
In fact, the menu is pretty much completely empty. When you compare this to Excel for desktop, it’s quite shocking how much functionality is missing.
You can see that the Formulas menu in Excel for desktop is just filled with entire dropdown menus with all of those formulas organized into submenus. There are also groups in the ribbon with formula auditing features, and a watch window.
The only features Excel Online matches in this area is the ability to trigger the calculation of formulas in the sheet. Does that mean formulas are missing from Microsoft Excel online? Not at all. You just have to get at them differently.
If you select the function icon near the formula field, you’ll see a pop-up window where you can search for one of the many functions Excel offers.
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 just have to go about finding them somewhat differently than you do in Excel for desktop.
The Data Menu
At first glance, it’s pretty clear that Microsoft Excel online only has about half of the features present in the Excel for desktop version. None of those missing features are found in any hidden menus either.
The following Data menu features are missing from Microsoft Excel online:
- No ability to “Get Data” from external sources like text, web, or database files.
- No advanced filtering options.
- Data tools group lacks text to Columns, flash fill, consolidate, and relationships.
- There are no forecast or outline groups that you find on the Excel for desktop ribbon at all.
Even with all of those Data menu features missing, it is good at least that Microsoft Excel online does provide the ability to bring in stock and geography data sources from the internet.
If you aren’t interested in using Excel to retrieve external data sources, then most of the features missing from the Data menu won’t bother you.
The Review Menu
In Excel for desktop, the Review menu is where you’ll typically go to edit and spell check. If you’ve used this in the desktop version of Excel, then you’re accustomed to being able to add comments, notes, and even use an embedded thesaurus.
So which of these features are missing from the online version of Excel?
- No embedded thesaurus.
- Missing Smart Lookup insights.
- Missing language translation tool.
- No “Notes” feature, but you can convert Notes to Comments.
- Can’t protect the workbook or sheet.
- No “inking” editing feature.
If you do a lot of editing (especially of other peoples’ work), and you really need the inking or notes feature that you have in Excel for desktop, you’re going to be very disappointed by Microsoft Excel online. This is especially true if you use the thesaurus found in the desktop version.
The View Menu
The View menu in Excel for desktop is filled with a lot of features. By this point you may not be surprised to learn that Microsoft Excel online lacks a lot of those.
In fact, all you can do is create a private sheet view, open a new spreadsheet window, freeze panes, or hide and show headings and gridlines.
All of the other features are missing, such as:
- Page break, page layout, and custom views.
- Hiding the formula bar.
- Zoom features.
- Arranging, splitting, hiding, or switching windows.
- Macros.
Most of these features aren’t really relevant for an online app anyway. For example, there is no way to create or run VBA macros in a browser based application. Most of these missing features shouldn’t impact your use of Microsoft Excel online overall.
Menus That Are Completely Missing
While Microsoft Excel online offers the core menus you find in Excel for desktop, there are actually entire menus that are completely missing.
These menus include:
- Draw: Use your mouse to draw lines or highlight areas
- Page Layout: Apply themes, margins, orientation, print areas, and align or organize objects
- Timeline: Visually showing events chronologically over a timescale – useful for things like project schedules
- Developer: Adding macros or VBA code to a spreadsheet
In addition to this, there is no way to add any additional add-ins or menus to Microsoft Excel online, since the File menu lacks the Options choice where you would normally go to in Excel for desktop to add those.
Again, this isn’t surprising for an online app. But it is something to consider if you enjoy adding a lot of additional features to Excel by using add-ins or enabling some of the non-default menus that are available in Excel for desktop.
The Final Verdict
Given all of the core features available in Microsoft Excel online versus everything that’s missing compared to the Excel for desktop version, the online version might fall short. But that doesn’t mean it’s useless.
If you typically only use Excel for its most common uses, like creating spreadsheets for calculations or organization, you’ll find everything you need in Microsoft Excel online. If you need to bring in external sources or you do a lot of VBA coding or macros, you’re going to want to stick to using Excel for desktop.