Erstellen von Dropdownlisten - Microsoft-Support
Wählen Sie die Registerkarte Fehlerwarnung aus .. Wenn eine Nachricht angezeigt werden soll, wenn jemand etwas eingibt, das nicht in Ihrer Liste enthalten ist, aktivieren Sie das Kontrollkästchen Fehlerwarnung anzeigen, nachdem ungültige Daten eingegeben wurden , wählen Sie eine Option aus dem Feld Format aus, und geben Sie einen Titel und eine Nachricht ein.
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
TEXTSPLIT function - Microsoft Support
Splits text strings by using column and row delimiters. The TEXTSPLIT function works the same as the Text-to-Columns wizard, but in formula form.It allows you to split across columns or down by rows.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web
Solicitar un reembolso de juegos digitales | Xbox Support
Descubre cómo enviar una solicitud para obtener el reembolso de una compra de contenido digital de Xbox.
Save or convert to PDF or XPS in Office Desktop apps
Portable Document Format (PDF) preserves document formatting and enables file sharing. When the PDF format file is viewed online or printed, it retains the format that you intended. The PDF format is also useful for documents that will be reproduced using commercial printing methods.
Applies To: Excel for Microsoft 365, Word for Microsoft 365, Access for Microsoft 365, Project Online Desktop Client, Publisher for Microsoft 365, Word for the web, OneNote for the web, PowerPoint for the web, Excel 2021, Word 2021, Access 2021, Project Professional 2021, Project Standard 2021, Publisher 2021, OneNote 2021, Excel 2019, Word 2019, Access 2019, Project Professional 2019, Project Standard 2019, Publisher 2019, Excel 2016, Word 2016, Access 2016, OneNote 2016, Project Professional 2016, Project Standard 2016, Publisher 2016, Project Online
将数据从行转置到列,或将数据从列转置到行 - Microsoft 支持
注意: 如果数据位于 Excel 表中,则“转置”功能不可用。您可以 将 表格 转换为区域 中首先,或可以使用 TRANSPOSE 函数 旋转的行和列。
Applies To: Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016
Microsoft Japanese IME - Microsoft Support
At this state. Press this key. To do this. Before focus enters the candidate window. Space. 1 st press: Convert what you type.. 2 nd press: Open the conversion candidate window.. Shift + Space. 1 st press: Convert what you type.. 2 nd press: Open the conversion candidate window.. With focus inside the candidate window. Space
Find and lock a lost Windows device - Microsoft Support
Turn on Find my device. When you set up a new device, you can decide whether to turn on or turn off the Find my device setting. If you turned it off during setup and now want to turn it on, make sure your Windows device is connected to the internet, has enough battery power so it can send its location, and that you're signed in to the device using your Microsoft account.
Applies To: Microsoft account dashboard
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
Using Checkboxes in Excel - Microsoft Support
If you reference a Checkbox cell with a formula, TRUE or FALSE will be passed along to that formula. For example, if you have a Checkbox in cell A1, you can use a formula like =IF(A1, "Checked", "Unchecked") to display a custom message based on the Checkbox's state.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web
在Microsoft Edge浏览器中使用Microsoft 翻译工具 - Microsoft 支持
如果在设置中打开用与首选语言不同的语言编写的页面,Microsoft Edge会自动提示你翻译它。 转到用外语编写的网页时,“翻译”图标 显示在地址栏中。 如果语言未包含在设置中的首选语言列表中,则该语言被视为外在语言。
Applies To: Microsoft Edge