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 ...

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

Recover lost or deleted files. Windows 7. Note: If you've recently updated Windows 10 and are having problems finding files, see Find lost files after the upgrade to Windows 10. 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 ...

Use the XLOOKUP function to find things in a table or range by row. For example, look up the price of an automotive part by the part number, or find an employee name based on their employee ID. With XLOOKUP, you can look in one column for a search term and return a result from the same row in another column, regardless of which side the return column is on.

若要访问 OneDrive 设置，请单击或点击任务栏或通知区域中的 OneDrive 图标。. 如果未看到 OneDrive 图标，则 OneDrive 可能没有运行。. 在电脑上，转至“ 开始 ”，在搜索框中键入“ OneDrive ”，然后在搜索结果中单击“ OneDrive ”。. 可能需要单击通知区域旁的“ 显示 ...

最近的安装、激活、更新问题. 如果最近遭遇安装、激活或更新问题，请参阅 最新 Office 安装问题或激活问题的修补程序或解决方法 一文。. 有关 Office 应用程序的具体问题，请单击下面的链接，查找解决方法或修补程序。.

在 Microsoft Edge 中，选择 “设置和更多 > 设置 > 隐私、搜索和服务 ”。. 确认 “增强 Web 安全性” 为 “打开 ”。. 在 “增强 Web 安全性”下 ，选择“ 管理站点增强的安全性 ”。. 根据要管理的列表，执行以下操作之一：. 若要从特定站点中删除额外的保护层 ...

You can work offline to: Create a file: You can create a blank document, workbook, or presentation when offline. However, to create a document, workbook, or presentation from a template, you'll need to be connected to the Internet. You can then continue working on your file when offline. Note: When you're offline, the title bar of the file will ...

Preview your document. Select File > Print. To preview each page, select the forward and backward arrows at the bottom of the page. If the text is too small to read, use the zoom slider at the bottom of the page to enlarge it. Choose the number of copies, and any other options you want, and select the Print button.

If you have a good antivirus program installed, make sure it's up to date and then do a full scan of your system. If you don't have an antivirus app installed on your PC, Microsoft offers some solutions if you're running Windows 8.1 or Windows 10/11. If you're running Windows 8.1 or Windows 10/11, you already have Windows Defender.