使用 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
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
App permissions - Microsoft Support
Here's more info on what permissions allow an app to do: Access all your files, peripheral devices, apps, programs, and registry: The app has the ability to read or write to all your files (including documents, pictures, and music) and registry settings, which allows the app to make changes to your computer and settings. It can use any peripheral devices that are either attached or part of ...
What's new in Office 2021 - Microsoft Support
Immersive Reader advanced color support. In Immersive Reader, we've added many additional ways you can choose a page color.Selecting a page color can make text easy to scan with less eye strain. On the Immersive Reader tab click Page Color to see a 4x5 color picker.. Click More Colors to see additional color selection options such as Wheel, Sliders, Color Palettes, Image Palettes, and Pencils.
Applies To: Office 2021, Office 2021 for Mac
About the Microsoft Support and Recovery Assistant
Scenario. Description. Recommended Solution. Add Teams meeting add-in for Outlook. Helps fix the issue where teams meeting add-in is missing or is not loaded, preventing you from creating teams meeting from Outlook.
Applies To: Outlook for Microsoft 365, Office 2021, Office 2019, Office 2016, Microsoft 365 for home, Microsoft 365 admin
Set apps to run automatically when you start your device
Note: If you see the icon next to the On/Off toggle for an app, you can select it to see the registry location that contains the path for the app. Apps installed through Microsoft Store (.MSIX apps) don’t have these icons. If you select the icon for these apps, File Explorer opens and highlights the executable file.
How do I sign in to Skype? - Microsoft Support
Note : Once you've signed in, Skype will remember your sign in information when you close Skype or sign out and choose to remember your account settings. If you don't have a Skype or Microsoft account: Visit Skype.com from your browser and download Skype.
XLOOKUP function - Microsoft Support
Use the XLOOKUP function when you need to find things in a table or a 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
Télécharger et installer ou réinstaller Office 2019, Office 2016 ou ...
Remarque : Les étapes d’installation des versions 2019, 2016 ou 2013 de Office Professionnel Plus, Office Standardou une application autonome telle que Word ou Project peuvent être différentes si vous avez obtenu Microsoft 365 via l’une des options suivantes : Programme de remise pour le lieu de travail de Microsoft (anciennement Programme d’utilisation à domicile): si vous avez ...
Applies To: Office 2019, Office 2016, Office 2016 for Mac, Office 2013
Check the recent sign-in activity for your Microsoft account
If you get an email about unusual activity on your Microsoft account, or if you’re worried that someone else might have used your account, go to the Recent activity page.You’ll see when your Microsoft account was signed in during the last 30 days, along with any device or app-specific info.
Applies To: Microsoft account dashboard