Defragment your Windows 10 PC - Microsoft Support
Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.
Filter data in a range or table - Microsoft Support
Use AutoFilter or built-in comparison operators like "greater than" and “top 10” in Excel to show the data you want and hide the rest. Once you filter data in a range of cells or table, you can either reapply a filter to get up-to-date results, or clear a filter to redisplay all of the data.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2019, Excel 2016
Windows help and learning
Find help and how-to articles for Windows operating systems. Get support for Windows and learn about installation, updates, privacy, security and more.
下载Microsoft Authenticator - Microsoft 支持
中国的身份验证方法. 中国仅提供有限的身份验证方法。 用户可以将 Authenticator 设置为在其设备上接收可用于验证其身份的验证码,而不是使用推送通知进行双重验证。
Where is Save As? - Microsoft Support
The Save As feature in Word, Excel, and PowerPoint has been replaced by Save a Copy.To save a copy of a file, do the following: Tap File > Save a Copy.
Applies To: Excel for iPad, Word for iPad, PowerPoint for iPad, Excel for iPhone, Word for iPhone, PowerPoint for iPhone
COUNTIF function - Microsoft Support
Argument name. Description. range (required). The group of cells you want to count. Range can contain numbers, arrays, a named range, or references that contain numbers. Blank and text values are ignored. Learn how to select ranges in a worksheet.. criteria (required). A number, expression, cell reference, or text string that determines which cells will be counted.
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
Recover lost or deleted files - Microsoft Support
If you can't find a file on your computer or you accidently modified or deleted a file, you can restore it from a backup (if you're using Windows backup) or you can try to restore it from a previous version.Previous versions are copies of files and folders that Windows automatically saves as part of a restore point.
Install Office updates - Microsoft Support
On a Mac? See Check for Office for Mac updates automatically.. Click here for the Latest updates for versions of Office that use Windows Installer (MSI).. Choose your version of Office. If you're not sure what version of Office you have, see What version of Office am I using?. Not sure which type of install you have?
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
Introduction to lists - Microsoft Support
The following are some ways you can work with lists to help you to manage information for your group. Track versions and detailed history Track versions of list items, so that you can see which items have changed from version to version, as well as who changed the list items.If mistakes are made in a newer version, you can restore a previous version of an item.
Applies To: SharePoint Server Subscription Edition, SharePoint Server 2019, SharePoint Server 2016, SharePoint Server 2013, SharePoint in Microsoft 365, Microsoft Lists
Verwendung von Remotedesktop - Microsoft-Support
Hinweis: Während auf einem Remotedesktopserver (dem PC, zu dem Sie eine Verbindung herstellen) eine Pro Edition von Windows ausgeführt werden muss, kann auf einem Clientcomputer (dem Gerät, von dem aus Sie eine Verbindung herstellen) eine beliebige Edition von Windows (Pro oder Home) oder sogar ein anderes Betriebssystem ausgeführt werden.