输入允许的最小值、最大值或特定值。 您还可以输入返回数值的公式。 例如，若要在单元格 e1 中将佣金和奖金的最大限制设置为销售人员工资的 6%，请在“数据”框中选择小于或等于，然后在“最大”框中输入公式 =e1*6%。

Text recognition in images is enhanced, including handwriting recognition, and overall image descriptions are better. To experience the improved experience, navigate to any image and, while the image is in focus, execute the keyboard combination "Narrator key+CTRL+d “. . An active internet connection is necessary for this feature, and Narrator settings must have the option to obtain Image ...

Important: Subtotals are not supported in Excel tables.The Subtotal command will appear grayed out if you are working with an Excel table. To add subtotals in a table, you must first convert the table to a normal range of data, and then add the subtotal. Note that this will remove all table functionality from the data except table formatting.

Microsoft has added OAuth support for Yahoo! accounts in the Windows 10 Creators update. To install the Creators Update now, go to the software download site, and select Update now.For more information about the update, see Windows 10 Creators Update is here.. If you have a Japanese Yahoo! email account you will need to do the following:

You can use the Office language options to add a language, to choose the UI display language, and to set the authoring and proofing language. The language options are in the Set the Office Language Preferences section of the Office Options dialog box, which you can access by going to File > Options > Language.The display and authoring languages can be set independently.

A key icon in the message list or reading pane indicates an encrypted message.. If you normally use Conversation view, you'll have to open the message in a new window to read it. There will be a link on the message to make this easier.

If you open an Office file from your recent files list via the Taskbar or the Office app, you will need to open the file as described above to enable AutoSave.. To check, hover your mouse over the recent list: Files that begin C:\Users\ in their path will not open with AutoSave, but files with https:// will.. Close and re-open the file from within the Microsoft 365 app, not the recent file list.

Create a new object from inside Excel. You can create an entirely new object based on another program without leaving your workbook. For example, if you want to add a more detailed explanation to your chart or table, you can create an embedded document, such as a Word or PowerPoint file, in Excel.

备注 Excel for Mac不支持数据模型。. 关系数据库并不是唯一允许您在一个数据透视表字段列表中使用多个表的数据源。 可以在整个工作簿中使用表格，或者导入随后可与工作簿中的其他表格数据进行集成的数据源。

如果在“Office 加载项”框中找不到要激活 的加载项，则可能需要安装它。. 安装 Excel 加载项 . 若要安装通常随 Excel 一起安装的加载项（如规划求解或分析工具库），请运行 Excel 或 Microsoft Office 安装程序，然后选择 “更改” 选项以安装加载项。 重启 Excel 后，加载项应显示在 “可用加载项 ”框中。