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.
Get apps from Microsoft Store on your Windows PC
If you're moving from a Windows 7 or Windows 8.1 PC to a new Windows device, you'll find that the best way to get apps and games is through Microsoft Store.
Transpose (rotate) data from rows to columns or vice versa
Note: If your data is in an Excel table, the Transpose feature isn't available.You can convert the table to a range first, or you can use the TRANSPOSE function to rotate the rows and columns.
Applies To: Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016
How do I upgrade Office? - Microsoft Support
Microsoft 365 Family or Personal. If you have a Microsoft 365 Family or Microsoft 365 Personal subscription, you already have the most current version of Office at no additional cost and should already receive the latest features to your Office apps.See What’s new in Microsoft 365 to learn more about the newest features.. If you don’t see these features, you may not have received the ...
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, Project Online Desktop Client, Publisher for Microsoft 365, Visio Plan 2, Excel for Microsoft 365 for Mac, Word for Microsoft 365 for Mac, Outlook for Microsoft 365 for Mac, PowerPoint for Microsoft 365 for Mac, Excel 2016, Word 2016, Outlook 2016, PowerPoint 2016, Access 2016, OneNote 2016, Project Professional 2016, Project Standard 2016, Publisher 2016, Visio Professional 2016, Visio Standard 2016, Office 2016, Excel 2016 for Mac, Word 2016 for Mac, Outlook 2016 for Mac, PowerPoint 2016 for Mac, OneNote 2016 for Mac, Office 2016 for Mac, Excel 2013, Word 2013, Outlook 2013, PowerPoint 2013, Access 2013, OneNote 2013, Visio Professional 2013, Visio 2013, Office 2013, Microsoft 365 for home, Office for business, Office 365 Small Business, Microsoft 365 admin, Office 365 operated by 21Vianet, Office 365 operated by 21Vianet - Small Business Admin, Office 365 operated by 21Vianet - Admin, Project Online, Microsoft 365 for Mac, Office 365 Germany - Enterprise, Office 365 Germany - Enterprise admin
Protect a worksheet - Microsoft Support
Option. Allows users to. Select locked cells. Move the pointer to cells for which the Locked box is checked on the Protection tab of the Format Cells dialog box. By default, users are allowed to select locked cells. Select unlocked cells
Applies To: Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016
使用 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
Date and time functions (reference) - Microsoft Support
Use date and time functions to create formulas that return serial numbers, display a specific date or time, or that calculate the difference between dates or times.
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
Find and remove duplicates - Microsoft Support
How to find and remove duplicates in Excel. Filter for unique values in large or small datasets to clean up your worksheets and workbooks.
Applies To: Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016
CONCATENATE function - Microsoft Support
Important: In Excel 2016, Excel Mobile, and Excel for the web, this function has been replaced with the CONCAT function.Although the CONCATENATE function is still available for backward compatibility, you should consider using CONCAT from now on. This is because CONCATENATE may not be available in future versions of 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
FILTER function - Microsoft Support
In the following example we used the formula =FILTER(A5:D20,C5:C20=H2,"") to return all records for Apple, as selected in cell H2, and if there are no apples, return an empty string ("").
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel for iPad, Excel for iPhone, Excel for Android tablets, Excel for Android phones
Anmelden bei oder Abmelden von Outlook.com - Microsoft-Support
Um Unterstützung in Outlook.com zu erhalten, klicken Sie hier, oder wählen Sie in der Menüleiste Hilfe- aus, und geben Sie Ihre Abfrage ein. Wenn ihr Problem durch die Selbsthilfe nicht behoben werden kann, scrollen Sie nach unten zu Benötigen Sie weitere Hilfe? und wählen Sie Ja aus.. Um uns in Outlook.com zu kontaktieren, müssen Sie sich anmelden.
Applies To: Outlook.com