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
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.
Sign in using Microsoft Authenticator - Microsoft Support
Sign in to a work/school account using a remote computer. Many apps allow you to authenticate by entering a code on another device such as a PC.
Change the refresh rate on your monitor in Windows
Battery Life: Lowering your refresh rate can save battery power by reducing the amount of energy your display consumes.This can be useful when you are using a laptop or tablet and want to extend your battery life.
Microsoft account security info & verification codes
Important: You don't need to remove old security information unless there is an account security risk (e.g. someone else has access to your old mailbox).
Applies To: Microsoft account dashboard
Turn on automatic forwarding in Outlook - Microsoft Support
In the Rule Address dialog, under Address Book, select the contact list that contains the address you want to forward to.. In the To box at the bottom, enter the email address that you want to forward all your mail to.Select OK.You should see the email address you want all of your email forwarded to inserted into the rule under Step 2.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016, Outlook on the web, Outlook.com, New Outlook for Windows
Manage app permissions for your camera in Windows
To use your camera with apps on Windows 11, you'll need to turn on some permissions in Camera settings. Then, you'll need to check your app permissions if you want to use your camera with apps.
XLOOKUP function - Microsoft Support
Use the XLOOKUP function to find things in a table or range by row. For example, look up the price of an automotive part by the part number, or find an employee name based on their employee ID. With XLOOKUP, you can look in one column for a search term and return a result from the same row in another column, regardless of which side the return column is on.
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 2016, Excel for iPad, Excel for iPhone, Excel for Android tablets, Excel for Android phones
Get help with Windows upgrade and installation errors
To upgrade to Windows 11, you need enough space on your hard drive for the installation to take place. To view how much hard drive space is available on your computer, select File Explorer on the taskbar (known as Windows Explorer in Windows 7) or press Windows logo key + E. Then select Computer or This PC and look under Hard Disk Drives or under Devices and drives.
Command Prompt and Windows Powershell for Windows 11
Solution 2: Windows Terminal settings. Open Windows Terminal, then select the Startup tab > Default terminal application > Windows Console Host.. Solution 3: Windows Console settings. If you already have a command line app open in a Windows Console Host and want to change the default setting: