Tip: Also, refer to the Quick Reference Card: VLOOKUP troubleshooting tips which presents the common reasons for #NA issues in a convenient PDF file. You can share the PDF with others or print for your own reference.

Here are some tips to prepare your Excel spreadsheet for a mail merge. Make sure: Column names in your spreadsheet match the field names you want to insert in your mail merge.

iPhone 说明：如果 iPhone 导入时遇到问题，请确保设备已解锁，并且已接受权限。 适用于 Android 和其他设备的注意事项： 如果你使用的是 Android 手机或其他设备，并且导入不起作用，则可能需要将手机的 USB 设置从“通过 USB 充电”更改为“传输文件”或“传输照片”。

Check your computer's date settings. Excel uses your computer's date system. If a cell's date isn't entered using the same date system, Excel won't recognize it as a true date.

另请参阅. 我无法从 Microsoft Store 找到或安装应用. 需要更多帮助吗？ 请联系支持人员. 有关技术支持，请转到联系Microsoft 支持，输入问题并选择“获取帮助”。 如果仍然需要帮助，请选择“联系支持人员”以转至最佳支持选项。

Examples. Copy the example data in the following table, and paste it in cell A1 of a new Excel worksheet. For formulas to show results, select them, press F2, and then press Enter.

With Power Query (known as Get & Transform in Excel), you can import or connect to external data, and then shape that data, for example remove a column, change a data type, or merge tables, in ways that meet your needs. Then, you can load your query into Excel to create charts and reports.

Windows share window: Select the Outlook icon in the “Share using” section of the Windows share window to email your files using Outlook directly within the windows share window.It also has a search box. So, you can now search for contacts across Outlook to share a file. The Windows share window also displays 8-10 suggested contacts to quickly share to–including emailing yourself a file.

Automated safe mode is triggered if a Microsoft Office application could not start due to specific problems, such as an add-in or extension that won't start or a corrupted resource, file, registry, or template.

Explore subscription benefits, browse training courses, learn how to secure your device, and more.