使 Excel 在检测到模式时可自动填充数据。 例如，年中的月份，月中的日期或数字序列。 此外，还可以分析数据（如拆分列中的名字和姓氏），或连接数据（如连接两列中的名字和姓氏）。

2. Record Validation Rule You can use a record validation rule to specify a condition that all valid records must satisfy.You can compare values across different fields using a record validation rule. For example, a record with two date fields might require that values of one field always precede values of the other field (e.g., StartDate is before EndDate).

Learn more about simple formulas. All formula entries begin with an equal sign (=).For simple formulas, simply type the equal sign followed by the numeric values that you want to calculate and the math operators that you want to use — the plus sign (+) to add, the minus sign (-) to subtract, the asterisk (*) to multiply, and the forward slash (/) to divide.

Add guests to a group. When you add guests, also known as external users, to a group, you're granting them access to all information within the group.

At Microsoft, we're guided by our AI principles, our Responsible AI Standard, and decades of research on AI, grounding, and privacy-preserving machine learning.Data privacy and security is a key principle of responsible AI. We aim to help our customers use our AI products responsibly, sharing our learnings, and building trust-based partnerships.

注意: 如果无法选择 “Windows 聚焦 ”选项，则表示管理员可能已禁用该功能，或者你可能尚未获取更新。 此功能在一段时间内推出。 有关详细信息，请参阅 何时获取 Microsoft 365 的最新功能？

Get answers to all of your Microsoft Word questions. Find Word help, how-to articles, training videos, tutorials, and more.

Use Tips to discover things you didn't know you could do in Windows—for example, how to customize your PC, keep things more secure, work more quickly with keyboard shortcuts, and more.

Note To use many of the Xbox features within Game Bar, including Xbox Social features, you must have the Xbox app for Windows installed. To use Xbox Social features, sign in to Game Bar with your Microsoft account. Press the Windows logo key + G to open Game Bar, choose Settings > Accounts, select Sign in, and then follow the steps.

Note: Offers vary by country.Be sure to redeem your rewards points in the same region you signed up in. Do not use a VPN while trying to redeem points. When redeeming points, use a mobile or landline phone number for authentication and not a VoIP phone number.