How to correct a #REF! error - Microsoft Support
Macro Issues. If a macro enters a function on the worksheet that refers to a cell above the function, and the cell that contains the function is in row 1, the function will return #REF! because there are no cells above row 1.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016, Excel for iPad, Excel for iPhone, Excel for Android tablets, Excel for Android phones, Excel for Windows Phone 10, Excel Mobile
Manually add an account to the Microsoft Authenticator app
Add your work or school account. On your computer, note the Code and Url information on the Configure mobile app page.Keep this page open so you can see the code and URL.
修复 Windows 中的打印机连接和打印问题 - Microsoft 支持
检查电缆(对于有线打印机)。确保打印机的 USB 电缆已从打印机正确连接到你的电脑。 如果未识别 USB,请参阅自动诊断和修复 Windows USB问题。. 检查无线连接(对于无线打印机)。
如何使用电脑健康状况检查应用 - Microsoft 支持
注意: 如果设备上发现兼容性问题会中断使用 Windows 11 的体验,我们会暂时延迟升级,直到问题得到解决。兼容性保障措施有助于确保在升级时获得最佳体验,并且当关键应用或驱动程序尚不兼容时,工作效率不会中断。
在 Microsoft Teams 中录制会议 - Microsoft 支持
了解如何录制 Teams 会议。 捕获音频、视频、屏幕共享活动,并对Microsoft Teams 中的录制内容进行故障排除。
Applies To: Microsoft Teams
自定义键盘快捷键 - Microsoft 支持
重要: 重新指定组合键意味着你将不能再使用该组合达到原来的目的。例如,按 Ctrl+B 可将选择的文本更改为加粗。 如果将 CTRL+B 重新分配给新命令或其他项目,则无法通过按 Ctrl+B 使文本加粗,除非通过选择“自定义键盘”对话框底部的“全部重置”将键盘快捷方式分配还原到原始设置。
Applies To: Word for Microsoft 365, Word 2021, Word 2019, Word 2016
Sum data by using a query - Microsoft Support
This article explains how to use a type of function in Access called an aggregate function to sum the data in a query result set. This article also briefly explains how to use other aggregate functions, such as COUNT and AVG to count or average the values in a result set. In addition, this article explains how to use the Total Row, a feature in Access that you use to sum data without having to ...
Applies To: Access for Microsoft 365, Access 2021, Access 2019, Access 2016
How to verify an email address in your Microsoft account
View more Microsoft account help topics. Need more help? Contact Support. For technical support, go to Contact Microsoft Support, enter your problem and select Get Help.If you still need help, select Contact Support to be routed to the best support option.
Applies To: Microsoft account dashboard
Fix problems uploading files on the OneDrive website
The full path (including the file name) is too long. The path must contain fewer than 442 characters. Shorten the name of your file or the name of subfolders in OneDrive, or select a subfolder that's closer to the top-level folder, and then try to upload the file again.
Applies To: Office for business, OneDrive (home or personal)
在工作表单元格中自动填充数据 - Microsoft 支持
在Mike Girvin 的 YouTube 频道 上查找更多视频。 选择一个或多个单元格,将其用作填充更多单元格的基础。 对于 1、2、3、4、5... 之类的系列,在前两个单元格中键入 1 和 2。 对于 2、4、6、8... 之类的系列,请键入 2 和 4。 对于 2、2、2、2...
Applies To: Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016