Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.
VLOOKUP、INDEX、または MATCH を使って値を検索する - Microsoft サポート
vlookup、hlookup、その他の index や match などの関数を使い、ユーザーが入力した値に基づいてデータを検索して見つけます。 この記事では、vlookup について簡単に復習してから、その他の情報へのリンクを示します。
Applies To: Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016
从“文件”菜单打开文件 - Microsoft 支持
提示: 如果要绕过“文件”>“打开”并始终使用“打开”对话框,请执行此操作:选择“文件 > 选项 > 保存”,然后选择“打开或保存文件时不显示 Backstage”框检查。然后,关闭所有打开的 Office 应用程序再重新打开。 请注意,此更改仅影响按 Ctrl+O 访问“打开文件”对话框时看到的内容。
Applies To: Excel for Microsoft 365, Word for Microsoft 365, PowerPoint for Microsoft 365, Access for Microsoft 365, Project Online Desktop Client, Publisher for Microsoft 365, Visio Plan 2, Excel for Microsoft 365 for Mac, Word for Microsoft 365 for Mac, PowerPoint for Microsoft 365 for Mac, Excel 2021, Word 2021, PowerPoint 2021, Access 2021, Project Professional 2021, Project Standard 2021, Publisher 2021, Visio Professional 2021, Visio Standard 2021, Excel 2021 for Mac, Word 2021 for Mac, PowerPoint 2021 for Mac, Excel 2019, Word 2019, PowerPoint 2019, Access 2019, Project Professional 2019, Project Standard 2019, Publisher 2019, Visio Professional 2019, Visio Standard 2019, Excel 2019 for Mac, Word 2019 for Mac, PowerPoint 2019 for Mac, Excel 2016, Word 2016, PowerPoint 2016, Access 2016, Project Professional 2016, Project Standard 2016, Publisher 2016, Visio Professional 2016, Visio Standard 2016
Restore deleted files or folders in OneDrive - Microsoft Support
If you accidentally delete a file or folder in OneDrive, you may be able to recover it later from the OneDrive recycle bin.. For info about restoring a SharePoint file or folder, see how to restore items from the SharePoint recycle bin.For info about restoring SharePoint files stored in OneDrive, see Restore a previous version of a file in OneDrive.
Applies To: OneDrive for Business, SharePoint Server Subscription Edition, SharePoint Server 2019, OneDrive (work or school), OneDrive (home or personal), OneDrive (work or school) operated by 21Vianet, OneDrive for Mac, OneDrive for Windows
How to investigate a billing charge from Microsoft
Tip: If you believe someone has acquired your payment info, contact your bank or your payment provider to prevent more charges. Tell them your credit card has been stolen or compromised - If you only dispute the charges, there's nothing to prevent the fraudulent charges from happening again.
Applies To: Microsoft account dashboard
在 Excel 中将 IF 与 AND、OR 和 NOT 函数配合使用 - Microsoft 支持
但如果需要测试多个条件,例如我们假设所有条件都需要为 True 或 False (AND),或只有一个条件需要为 True 或 False (OR),或者如果想要检查某个条件是否不 (NOT) 符合你的条件,这时该怎么做呢?这三个函数均可以单独使用,但它们更常见于与 IF 函数成对使用。
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 Web App, Excel for Windows Phone 10
Windows location service and privacy - Microsoft Support
To control location for just your user account, switch the Let apps access your location setting On or Off.If "Location services is off" appears on the settings page, you won't be able to turn on the Let apps access your location setting for an individual user account.
What to try if your touchscreen doesn't work - Microsoft Support
In Settings, select Update & Security , then Windows Update , and then select the Check for updates button. Install any available updates and restart your PC if required.
Device encryption in Windows - Microsoft Support
Is it available on my device? BitLocker encryption is available on supported devices running Windows 10 or 11 Pro, Enterprise, or Education. On supported devices running Windows 10 or newer BitLocker will automatically be turned on the first time you sign into a personal Microsoft account (such as @outlook.com or @hotmail.com) or your work or school account.
A driver can't load on this device - Microsoft Support
Warning: Turning off Memory Integrity on a Secured-core PC takes the device out of a Secured-core state.If you choose to continue using your device without addressing the driver problem, you might discover that the functionality the driver supports does not work any longer, which could have consequences ranging from negligible to severe.
Repair an Office application - Microsoft Support
The steps to access the repair tool vary depending on your operating system. Right-click the Start button (lower-left corner) and select Apps and Features on the pop-up menu.
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 2021, Word 2021, Outlook 2021, PowerPoint 2021, Access 2021, Project Professional 2021, Project Standard 2021, Publisher 2021, Visio Professional 2021, Visio Standard 2021, Office 2021, OneNote 2021, 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 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 for home, Office for business, Office 365 Small Business, Microsoft 365 admin, Office 365 operated by 21Vianet, Office 365 operated by 21Vianet - Small Business Admin, Office 365 operated by 21Vianet - Admin, InfoPath 2013, Office 365 Germany - Enterprise, Office 365 Germany - Enterprise admin