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.
View display settings in Windows - Microsoft Support
To change your screen resolution, use the drop-down menu next to Display resolution.. Note: You should use the Recommended resolution. If you change the resolution, content might appear blurry or pixelated.
Open Control Panel in Windows - Microsoft Support
Learn how to access the Control Panel in Windows for managing your system settings and programs.
Move your files to a new Windows PC - Microsoft Support
We recommend using OneDrive to quickly save your files in the cloud. You can then get to your files on your new PC and across all your devices, including your phone, tablet, and more. Your files will also be backed up and protected in the cloud, so they're accessible even if something happens to your PC.
下载并安装或重新安装 Office 2019、Office 2016 或 Office 2013
如果这是你第一次安装 Microsoft 365,则可能需要先执行一些设置步骤。展开下面的 “了解详细信息”部分。 但是如果是重新安装 Microsoft 365,且已兑换了产品密钥并拥有与 Microsoft 365 相关联的帐户,请转到“登录并安装 Office”的部分。
Applies To: Office 2019, Office 2016, Office 2016 for Mac, Office 2013
Set up the Microsoft Authenticator app as your verification method
Mobile device text: Enter your mobile device number and get a text a code you'll use for two-step verification or password reset. For step-by-step instructions about how to verify your identity with a text message (SMS), see Set up security info to use text messaging (SMS).
Download free, pre-built templates - Microsoft Support
Find and download free templates to create documents like calendars, business cards, letters, greeting cards, brochures, newsletters, or resumes.
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, Excel 2021, Word 2021, PowerPoint 2021, Access 2021, Project Professional 2021, Project Standard 2021, Publisher 2021, Excel 2019, Word 2019, PowerPoint 2019, Access 2019, Project Professional 2019, Project Standard 2019, Publisher 2019, Excel 2016, Word 2016, PowerPoint 2016, Access 2016, Project Professional 2016, Project Standard 2016, Publisher 2016, Visio Professional 2016, Visio 2010, InfoPath 2013
Keyboard shortcuts in Excel - Microsoft Support
To do this. Press. Move to the Tell me or Search field on the ribbon and type a search term for assistance or Help content.. Alt+Q, then enter the search term. Open the File menu.. Alt+F. Open the Home tab and format text and numbers and use the Find tool.. Alt+H. Open the Insert tab and insert PivotTables, charts, add-ins, Sparklines, pictures, shapes, headers, or text boxes.
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 Mobile
Download and install custom fonts to use with Office
Learn how to locate, install, and share files with custom fonts compatible with Microsoft Office applications.
Applies To: Office 2021, Office 2021 for Mac, Office 2019, Office 2019 for Mac, Office 2016
Use Microsoft Teams for work or school in Windows 11
If you are planning to use Teams free or if you were a guest in an org, you can connect and collaborate by downloading and installing another version of Microsoft Teams (work or school) and signing in with your Microsoft account or the guest account where the invite was sent to.
Applies To: Microsoft Teams, Microsoft Teams personal, Microsoft Teams small business
Using IF with AND, OR, and NOT functions in Excel
Following are examples of some common nested IF(AND()), IF(OR()) and IF(NOT()) statements in Excel. The AND and OR functions can support up to 255 individual conditions, but it’s not good practice to use more than a few because complex, nested formulas can get very difficult to build, test and maintain. The NOT function only takes one condition.
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