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.
在 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
Install Office updates - Microsoft Support
Note: If you can't open an app to check your installation type, try the more common Click-to-Run or MSI uninstall steps first. Create or open an existing file and select File > Account (or it might say Office Account). Under Product information, find the About button and check for the following:
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, Excel 2021, Word 2021, Outlook 2021, PowerPoint 2021, Access 2021, Office 2021, OneNote 2021, Excel 2019, Word 2019, Outlook 2019, PowerPoint 2019, Access 2019, Office 2019, Excel 2016, Word 2016, Outlook 2016, PowerPoint 2016, Access 2016, OneNote 2016, Project Professional 2016, Project Standard 2016, Office 2016, Microsoft 365 for home, Office for business, Office 365 Small Business, Microsoft 365 admin, Office 365 operated by 21Vianet, InfoPath 2013, InfoPath Filler 2013
Share OneDrive files and folders - Microsoft Support
The files on your OneDrive are private until you share them. Keep in mind that when you share folders with Edit permissions, people you share with can add the shared folders to their own OneDrive.. This lets them keep the folder alongside their own folders and items, easily move items between folders, and more easily work on it offline.
Applies To: OneDrive for Business, SharePoint Server Subscription Edition, SharePoint Server 2019, SharePoint Server 2016, SharePoint Server 2013 Enterprise, SharePoint in Microsoft 365, Office for business, Microsoft 365 admin, OneDrive (work or school), OneDrive (home or personal), SharePoint in Microsoft 365 Small Business
Give your PC a Fresh Start - Microsoft Support
Note: If you don't see the option to Restore preinstalled apps, it means your PC doesn't have preinstalled apps configured. In versions of Windows 10 prior to version 2004 this feature was called Fresh Start and to use it you'd select Start > Settings > Update & security > Windows Defender > Device performance & health .
Import photos and videos - Microsoft Support
Note for iPhone: If you are having trouble with your iPhone import, make sure your device is unlocked and you’ve accepted the permissions. Note for Android and other devices: If you’re using an Android phone or other device and import isn’t working, you might need to change your phone’s USB settings from Charging over USB to Transfer Files or Transfer Photos.
Keyboard shortcuts in Windows - Microsoft Support
Do you want to learn how to navigate Windows using keyboard shortcuts? Whether you need to switch between apps, open the command prompt, or perform any other tasks, you can find a full list of keyboard shortcuts in Windows on this webpage. Discover how to save time and improve your productivity with these handy tips.
PC またはワイヤレス ディスプレイへのスクリーン ミラーリングと投影 - Microsoft サポート
注: ワイヤレス ディスプレイ アプリは、Windows 11 バージョン 22H2 以降を実行しているデバイスで使用できます。以前のバージョンの Windows を実行している場合は、タスク バーの検索ボックスに 「connect」と入力し、結果の一覧で [接続 ] を選択して、Connect アプリを起動します。
Use conditional formatting to highlight information in Excel
Notes: The formatting options that appear in the Formatting tab depend on the data you have selected. If your selection contains only text, then the available options are Text, Duplicate, Unique, Equal To, and Clear.When the selection contains only numbers, or both text and numbers, then the options are Data Bars, Colors, Icon Sets, Greater, Top 10%, and Clear.
Applies To: Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016
Mouse and Keyboard Center download - Microsoft Support
The Microsoft Mouse and Keyboard Center is an app that helps you make the most out of your Microsoft keyboard and mouse. Mouse and Keyboard Center helps you personalize and customize how you work on your PC.
Share and access a view-only calendar in Outlook
Notes: If your email account uses Exchange, you will see Publish This Calendar, instead of the option to publish to a WebDAV server.This lets you publish your calendar directly to an Exchange Server. In the window that opens, select the publishing options you want, and click Start Publishing.. If you're using Microsoft 365, you can still publish your calendar to a WebDAV server, but you must ...
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016, Microsoft 365 admin, Outlook on the web, New Outlook for Windows