使用 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
Troubleshoot Game Bar on Windows | Xbox Support
Make sure you have the latest updates on your Windows device. Press the Start button , then choose Settings.Go to Update & security (Windows Update on Windows 11), then select Check for updates.; Check your Game Bar settings. Press the Start button , then choose Settings.Go to Gaming > Game bar, then turn on Record game clips, screenshots, and broadcast using Game bar.
在 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
Fix problems that block programs from being installed or removed ...
The troubleshooter provides steps for you to follow. If a program isn't listed in the uninstall options, you'll be asked for that program's product code. To access the code, you'll need a tool for reading MSI files—which is typically available to IT professionals. You'll find the product code in the property table of the MSI file. What it fixes
What's new in recent Windows updates - Microsoft Support
Windows share window: Select the Outlook icon in the “Share using” section of the Windows share window to email your files using Outlook directly within the windows share window.It also has a search box. So, you can now search for contacts across Outlook to share a file. The Windows share window also displays 8-10 suggested contacts to quickly share to–including emailing yourself a file.
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 .
ドロップダウン リストの項目を追加または削除する - Microsoft サポート
Excel の表に基づいたドロップダウン リストを編集する. ソースの一覧を Excel の表として設定する場合、一覧からアイテムを追加または削除するだけで、自動的に関連するドロップダウンが更新されます。. 項目を追加する場合は、一覧の最後に移動して、新しい項目を入力します。
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
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
Troubleshoot Outlook email setup - Microsoft Support
My Outlook doesn't look like any of these pictures. There are multiple ways for you to send and receive email, and multiple versions of Outlook available. If the images in these topics don't match what you see on your screen, you might be using a different version of Outlook. See What version of Outlook do I have? for more information.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016, Microsoft 365 admin
Repair apps and programs in Windows - Microsoft Support
Repair programs in Control Panel. Select the Advanced options link under the name of the app (some apps don't have this option). On the page that opens, select Repair if it's available.If it isn't available or doesn't fix the problem, select Reset.