VLOOKUP 函数 - Microsoft 支持
例如，=VLOOKUP("Fontan?",B2:E7,2,FALSE) 将使用最后一个字母搜索 Fontana 的所有实例，该实例可能有所不同。 请确保您的数据中不包含错误的字符。 在第一列中搜索文本值时，请确保第一列中的数据没有前导空格、尾部空格、直引号（' 或 "）与弯引号（‘或“）不一致 ...
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
Open Device Manager - Microsoft Support
Windows 10. In the search box on the taskbar, type device manager, then select Device Manager from the menu. Open Device Manager.
Secure messages by using a digital signature - Microsoft Support
In the message, on the Options tab, in the Permission group, click Sign Message. In the message, click Options. In the More Options group, click the dialog box launcher in the lower-right corner. Click Security Settings, and then select the Add digital signature to this message check box. Click OK, and then click Close.
Applies To:
Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016, Outlook 2013
Installing Microsoft Defender - Microsoft Support
Download Microsoft Defender on your devices either by: Scanning the following QR code. Searching for Microsoft Defender in your app store. Sharing with your devices, the following link: Copy link. We encourage you to install Microsoft Defender on at least five devices per person. Important: This article is about the Microsoft Defender app that ...
Applies To:
Microsoft Defender on Android, Microsoft Defender on iOS, Microsoft Defender on Mac, Microsoft Defender on Windows
Uninstall or remove apps and programs in Windows
Select Start > All apps and search for the app in the list shown. Press and hold (or right-click) on the app, then select Uninstall. Uninstall in Settings. Select Start > Settings > Apps > Apps & features . Find the app you want to remove, select More > Uninstall. Note: Some apps can't be uninstalled from the Settings app right now.
Upgrade Windows Home to Windows Pro - Microsoft Support
To upgrade from Windows 11 Home to Windows 11 Pro manually, first check which edition you’re running and your activation state: Select Start > Settings > System > Activation. At the top of the Activation page, you see your edition: either Home or Pro. You‘ll also see if you’re activated under Activation state . Open Activation settings ...
Manage your Microsoft 365 subscription or Office product
Follow the prompts to install or reinstall the desktop apps. For Microsoft 365 Family or Personal subscriptions: Select Install premium Microsoft 365 apps and follow the prompts to install or reinstall the desktop apps. On the Microsoft 365 subscription tab, select Manage. From here you can: Renew your subscription with a prepaid code or card.
Applies To:
Excel for Microsoft 365, Word for Microsoft 365, Outlook for Microsoft 365, PowerPoint for Microsoft 365, Access for Microsoft 365, OneNote for Microsoft 365, Publisher for Microsoft 365, Visio Plan 2, Excel for Microsoft 365 for Mac, Word for Microsoft 365 for Mac, Outlook for Microsoft 365 for Mac, PowerPoint for Microsoft 365 for Mac, OneNote for Microsoft 365 for Mac, Word for the web, OneNote for the web, PowerPoint for the web, Excel 2021, Word 2021, Outlook 2021, Access 2021, Project Professional 2021, Project Standard 2021, Publisher 2021, Visio Professional 2021, Visio Standard 2021, Office 2021, OneNote 2021, Excel 2021 for Mac, Word 2021 for Mac, Outlook 2021 for Mac, OneNote 2021 for Mac, Office 2021 for Mac, Excel 2019, Word 2019, Outlook 2019, PowerPoint 2019, Access 2019, Project Professional 2019, Project Standard 2019, Publisher 2019, Visio Professional 2019, Visio Standard 2019, Office 2019, Excel 2019 for Mac, Word 2019 for Mac, Outlook 2019 for Mac, PowerPoint 2019 for Mac, OneNote 2019 for Mac, Office 2019 for Mac, Excel 2016, Word 2016, Outlook 2016, PowerPoint 2016, Access 2016, OneNote 2016, Project Professional 2016, Project Standard 2016, Publisher 2016, Visio Professional 2016, Visio Standard 2016, Office 2016, Microsoft 365 admin, Outlook on the web, Word Web App, Microsoft account dashboard, New Outlook for Windows
使用“自动求和”对数字求和 - Microsoft 支持
如果需要对一列或一行数字求和，请让 Excel 为你计算。 选择要求和的数字旁边的单元格，在“开始”选项卡上选择“自动求和”，按 Enter，即可完成。 选择“自动求和”时，Excel 会自动输入一个公式 (，该公式使用 SUM 函数) 对数字求和。 下面是一个示例。
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
Open Control Panel in Windows - Microsoft Support
Open Control Panel in Windows. Windows 10. In the search box next to Start on the taskbar, type control panel. Select Control Panel from the list of results. Note: Many Control Panel features are simpler and faster in Settings . Open Settings. Open Control Panel in Windows.
How to troubleshoot problems that occur when you start or use Word
Click Options, and then click File > Export. Name the file "Wddata.reg", and then save the file to the desktop. Click Edit > Delete, then click Yes. Exit the Registry Editor and start Word. If Word starts and works correctly, you have resolved the problem (a damaged Word Options registry key).