Change the column width or row height in Excel
Note: The boundary is the line between cells, columns, and rows.If a column is too narrow to display the data, you will see ### in the cell.
Applies To: Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016
Aktivieren von Office - Microsoft-Support
Wenn Sie Office Professional Plus, Visio Professional oder Project Professional über das Microsoft Workplace Discount Program-Angebot (ehemals als Microsoft Home Use Program bekannt) Ihres Arbeitgebers erworben haben, wählen Sie Ich möchte mich nicht anmelden oder ein Konto erstellen (unten auf dem Bildschirm) aus, und geben Sie Ihren Product Key ein.
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, Publisher for Microsoft 365, Visio Plan 2, Excel 2021, Word 2021, Outlook 2021, PowerPoint 2021, Access 2021, Project Standard 2021, Publisher 2021, Visio Professional 2021, Visio Standard 2021, Office 2021, OneNote 2021, Excel 2019, Word 2019, Outlook 2019, PowerPoint 2019, Access 2019, Project Standard 2019, Publisher 2019, Visio Professional 2019, Visio Standard 2019, Office 2019, Excel 2016, Word 2016, Outlook 2016, PowerPoint 2016, Access 2016, OneNote 2016, Publisher 2016, Office 2016, Microsoft 365 for home, Office for business, Office.com, Project for Office 365
Control the formatting when you paste text - Microsoft Support
Merge Formatting (M) This option discards most formatting that was applied directly to the copied text, but it retains formatting that is considered emphasis, such as bold and italic, when it is applied to only a portion of the selection.The text takes on the style characteristics of the paragraph where it is pasted. The text also takes on any direct formatting or character style properties of ...
Applies To: Word for Microsoft 365, Word 2021, Word 2019, Word 2016, Word 2013
LOOKUP function - Microsoft Support
Vector form. The vector form of LOOKUP looks in a one-row or one-column range (known as a vector) for a value and returns a value from the same position in a second one-row or one-column range.. Syntax. LOOKUP(lookup_value, lookup_vector, [result_vector]) The LOOKUP function vector form syntax has the following arguments:. lookup_value Required.A value that LOOKUP searches for in the first vector.
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
How to close your Microsoft account - Microsoft Support
Closing a Microsoft account means you won’t be able to use it to sign in to any Microsoft products or services, including Outlook.com or Hotmail, OneDrive, Xbox, Skype, Office or Microsoft 365, Rewards and Microsoft Certification.
检查你的 DirectX 版本 - Microsoft 支持
检查你的版本. DirectX 是许多 Windows 游戏都需要的一种多媒体技术套件。 如果你的电脑未安装正确版本的 DirectX(产品包装盒上应标有所需的版本),游戏可能无法正常运行。
Filter by using advanced criteria - Microsoft Support
Using the equal sign to type text or a value. Because the equal sign (=) is used to indicate a formula when you type text or a value in a cell, Excel evaluates what you type; however, this may cause unexpected filter results.To indicate an equality comparison operator for either text or a value, type the criteria as a string expression in the appropriate cell in the criteria range:
Applies To: Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016
Create, load, or edit a query in Excel (Power Query) - Microsoft Support
A Data Model typically contains several tables arranged in a relationship. You load a query to a Data Model by using the Load To command to display the Import Data dialog box, and then selecting the Add this data to the Data Model check box.For more information about Data Models, see Find out which data sources are used in a workbook data model, Create a Data Model in Excel, and Use multiple ...
Applies To: Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016
Create an organization chart in Office by using SmartArt
Create an organization chart using SmartArt graphics. Although you cannot automatically connect two top-level boxes with a line in the organization chart layouts, such as Organization Chart, you can imitate this look by adding a box to the top level to your SmartArt graphic and then drawing a line to connect the boxes.(On the Insert tab, in the Illustrations group, select Shape, select a line ...
Applies To: Excel for Microsoft 365, Word for Microsoft 365, Outlook for Microsoft 365, PowerPoint for Microsoft 365, Excel 2021, Word 2021, Outlook 2021, PowerPoint 2021, Excel 2019, Word 2019, Outlook 2019, PowerPoint 2019, Excel 2016, Word 2016, Outlook 2016, PowerPoint 2016
How to use two-step verification with your Microsoft account
Important: If you turn on two-step verification, you will always need two forms of identification.This means that if you forget your password, you need two contact methods. Or if you lose your contact method, your password alone won't get you back into your account—and it can take you 30 days to regain access.