If you are using an Excel spreadsheet as your data source, format the ZIP/postal codes as text to avoid auto-deletion of any leading zeroes. For more information, see Format mail merge numbers, dates, and other values in Excel.

使用 格式刷快速将相同的格式（如颜色、字体样式和大小或边框样式）应用于多个文本或图形。使用格式刷，可以从一个对象复制所有格式，并将其应用于另一个对象， 将其视为复制和粘贴以设置格式。

switch 函数根据值列表计算一个值（称为表达式），并返回与第一个匹配值对应的结果。 如果不匹配，则可能返回可选默认值。 如果没有匹配值，且未提供默认参数，则 switch 函数返回 #n/a! 错误。

Here's an example of how to use VLOOKUP. =VLOOKUP(B2,C2:E7,3,TRUE) In this example, B2 is the first argument—an element of data that the function needs to work.For VLOOKUP, this first argument is the value that you want to find.

To create a new, blank file and link to it, click Create New Document under Link to, type a name for the new file, and either use the location shown under Full path or browse to a different save location by clicking Change.You can also choose whether to Edit the new document later or open and Edit the new document now.

See also. If you can't find Microsoft Store, see Trouble finding Microsoft Store in Windows 10. If you're having trouble launching Microsoft Store, see Microsoft Store doesn't launch. If you can launch the Microsoft Store but you are just having trouble finding or installing an app, see I can't find or install an app from Microsoft Store. Need more help?

How does multifactor authentication work? Let's say you're going to sign into your Microsoft account or work or school account, and you enter your username and password.If that's all you need then anybody who knows your username and password can sign in as you from anywhere in the world!

To help protect your privacy, the new Microsoft Edge sets tracking prevention to balanced by default. For increased protection, you can switch your tracking prevention to strict or block all third-party cookies.

Note: Notice the checkbox at the bottom of the window that allows you to Add this data to the Data Model, shown in the following screen.A Data Model is created automatically when you import or work with two or more tables simultaneously. A Data Model integrates the tables, enabling extensive analysis using PivotTables, Power Pivot, and Power View.

If you've received any reactions in the previous day or so, you'll get a digest email that summarizes the reactions you've received. You can unsubscribe from the digest email if you'd prefer not to receive it.