FILTER 函数将返回一个数组，如果该数组是公式的最终结果，则将溢出。 这意味着，当按“Enter”时，Excel 将动态创建相应大小的数组范围。如果支持数据位于 Excel 表格中，若使用结构化引用，则从数组范围中添加或删除数据时，数组将自动重设大小。有关详细信息，请参阅关于溢出数组行为的此 ...

If your keyboard does not have a Scroll Lock key, on your computer, click Start and then press CTRL+C to display the Charms bar. Click Change PC Settings. Select Ease of Access > Keyboard. Click the On Screen Keyboard slider button to turn it on. When the on-screen keyboard appears on your screen, click the ScrLk button.

To create a passkey for your Microsoft account, follow these steps on the device for which you’d like to create a passkey: Sign in to your Microsoft account Advanced Security Options. Choose Add a new way to sign in or verify. Select Face, fingerprint, PIN, or security key. Follow the instructions on your device. Provide a name for your passkey.

Sending a message. If you haven't already set up messages, do the following: On your PC, in the Phone Link, select Messages. To start a new conversation, select New message. Enter the name or phone number of a contact. Select the person you want to send a message to. A new message thread opens for you to begin with.

To see self-help answers, or to get support via email, Select Help from the top menu then Help. Open the Help pane. Enter your question or issue in the Search Help box on the right, and then press Return. If the self-help answers don't resolve your issue, try a different search, or scroll to the bottom of the Help pane and, under Still need ...

If you can't find a contact in the Deleted folder, the next place to look is the Recoverable folder. From the navigation pane, select People. In People, select the Deleted folder. At the top of the list, select Recover deleted. Select the contact you want to recover, and select Restore. Where do recovered contacts go?

找到想在 Office 应用程序中使用的字体后，可下载该字体，然后通过计算机上当前使用的操作系统安装该字体。. 由于字体由操作系统处理，因此不会直接下载到 Office。. 需在 Windows 控制面板中浏览系统的“ 字体 ”文件夹，字体将自动应用于 Office。. 在 Mac 中 ...

Der Windows 10 Update-Assistent lädt und installiert Funktionsaktualisierungen auf Ihrem Gerät. Featureupdates wie Windows 10 Version 1909 (auch als das Windows 10 November 2019 Update) bieten neue Funktionen und helfen, Ihre Systeme zu schützen. Sie erhalten diese Updates automatisch, nachdem Sie den Updateassistenten heruntergeladen haben.

Windows Web. 如果有一个工作表，其中列包含数据，需要旋转才能按行重新排列它，请使用 “转置” 功能。. 使用它，可以快速将数据从列切换到行，反之亦然。. 例如，如果数据如下所示，则列标题为“销售区域”，左侧为“季度”：. “转置”功能重新排列表 ...

Get from External Data Source. Get from Data Model. Use this option if your workbook contains a Data Model, and you want to create a PivotTable from multiple tables, enhance the PivotTable with custom measures, or are working with very large datasets.. Get from Power BI. Use this option if your organization uses Power BI and you want to discover and connect to endorsed cloud datasets you have ...