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

In Microsoft Teams (free), you can use keyboard shortcuts to send a wide range of emojs. You can either find the emojis in the reaction picker or type the shortcuts below into a message to make the emoji appear when you send your message.

在应用中，按 Ctrl + V 以使用默认粘贴，这将添加一个链接，其中页面标题作为链接文本。 如果要粘贴到 Microsoft Edge 的应用或网站中，也可以右键单击，选择上下文菜单上的"粘贴"，然后从子菜单中选择"链接 (默认) "。

Windows 10 puts notifications and quick actions in Action Center—right on the taskbar—where you can get to them instantly. Select Action Center on the taskbar to open it. (You can also swipe in from the right edge of your screen, or press Windows logo key + A.). Notifications at a glance

If you don't want to sync all of your folders in OneDrive to your computer, you can use the OneDrive app for Windows and macOS to select which folders you'd like to have visible in File Explorer or Finder.. When viewing Windows or Mac via a web browser or mobile app, you will always see all your folders.

How Microsoft Edge interacts with operating system permissions when sharing your location with a website. Windows can use information such as your IP address, nearby Wi-Fi access points, and GPS data, if available, to estimate your precise or imprecise location coordinates and pass this info to Microsoft Edge.

Microsoft has added OAuth support for Yahoo! accounts in the Windows 10 Creators update. To install the Creators Update now, go to the software download site, and select Update now.For more information about the update, see Windows 10 Creators Update is here.. If you have a Japanese Yahoo! email account you will need to do the following:

The COUNTIFS function is similar to the COUNTIF function with one important exception: COUNTIFS lets you apply criteria to cells across multiple ranges and counts the number of times all criteria are met. You can use up to 127 range/criteria pairs with COUNTIFS. The syntax for COUNTIFS is: COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2],…)

Contacts have been moved to the People app.If you don't have it pinned to your app list on the left side of Teams, you can find it from the Calls app. In the People app, you can add new contacts, designate contacts as favorites, and add categories to contacts.

获取有关您的 Xbox Live 好友、聊天、群等的帮助。