How to correct a #SPILL! error - Microsoft Support
Approach. Formula. 1. Reference just the lookup values you are interested in. This style of formula will return a dynamic array, but does not work with Excel tables. =VLOOKUP(A2:A7,A:C,2,FALSE)2. Reference just the value on the same row, and then copy the formula down.
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 Web App, Excel for iPhone, Excel for Android tablets, Excel for Android phones
Create a system repair disc - Microsoft Support
In the left pane, click Create a system repair disc, and then follow the steps. If you're prompted for an administrator password or confirmation, type the password or provide confirmation.
Troubleshooting Wi-Fi connection on your Surface
Network adapter. Surface device used in. Intel® Wi-Fi 6 AX200, AX201, AX210, AX211. Surface Pro 7 and later generations, Surface Laptop 3 and later generations, Surface Laptop Go (all generations), Surface Laptop Studio (all generations), Surface Go 2 and later generations, Surface Book 3, Surface Studio 2+
Error 0xC0000142 when you start an Office application
Note: If you have a suite such as Microsoft 365 Family, Office Home & Student 2016, or Office Home and Student 2013, search for the suite name, even if it's just a particular application you want to repair such as Word or Excel.If you have a standalone application such as Word or Excel, search for the application name.
View only unread messages in Outlook - Microsoft Support
Near the upper right corner of the message list, select Filter > Unread. Tip: The name of the filter button changes to Unread to indicate which filter is applied. When you want to remove the filter so that you can see all the messages in the current folder, simply click the Unread filter button.
Applies To:
Outlook for Microsoft 365, Outlook for Microsoft 365 for Mac, Outlook 2021, Outlook 2021 for Mac, Outlook 2019, Outlook 2016, Outlook 2013
为升级 Windows 11 准备就绪 - Microsoft 支持
安装 Windows 11. 在针对你的特定电脑测试和验证 Windows 11 升级后，Windows 更新将指示它已准备好安装。 若要检查 Windows 11 是否已为你的设备准备就绪，请转到“开始” “设置” >“更新和安全性” >“Windows 更新” ，然后选择“检查更新”。 如果升级适用于你的设备，并且想要继续，请下载并安装它。
Optimizations for windowed games in Windows 11
Optimizations for windowed games improves gaming on your PC by using a new presentation model for DirectX 10 and DirectX 11 games that appear in a window or in a borderless window.
管理与你的 Microsoft 帐户一起使用的设备 - Microsoft 支持
选择“立即重新启动”或“稍后重新启动”。 重命名 Xbox 按控制器上的 Xbox 按钮以显示指南，然后导航到“ 档案和系统 ”（帐户图标），然后选择“ 设置 ” >“ 系统 ”>“ 主机信息 ”>“ 名称 ”。
Applies To:
Microsoft account dashboard
在 Windows 11 電腦上啟用虛擬化 - Microsoft 支援服務
瞭解如何透過電腦的 UEFI (或 BIOS) 啟用虛擬化，以執行 Windows 子系統 Android 版 或 Windows 子系統 Linux 版。
更改浏览器主页 - Microsoft 支持
Microsoft Edge. 下面介绍如何在新版 Microsoft Edge 中更改主页：. 打开 Microsoft Edge，依次选择“设置及更多” >“设置” 。