An array formula (one that spans multiple cells) can do calculations on rows and columns of cells where you might otherwise need to use several formulas. For example, you can count the number of characters that are contained in a range of cells, sum only numbers that meet certain conditions (such as the lowest values in a range or numbers that fall between an upper and lower boundary), and sum ...

Near the upper right corner of the message list, select Filter > Unread. Tip: The name of the filter button changes to Unread to indicate which filter is applied. When you want to remove the filter so that you can see all the messages in the current folder, simply click the Unread filter button.

如何在 Microsoft Edge 中管理隐私设置. 要更改跟踪防护级别、清除浏览数据、帮助改进 Microsoft Edge 等，请选择“设置及更多 ” > “设置 ” > “隐私、搜索和服务 ”。 要选择网站是否可以向你请求位置、相机、麦克风等权限，请选择“设置及更多 ” > “设置 ” > “站点权限”。

@mention a tag in a channel. In a channel conversation, simply @mention a tag (type @ and the tag name) in your message and select the tag from the list.The tag will appear just like any @mention, and the people associated with the tag will be notified.

To do this. Say this. Select an item by its name. File; Start; View . Select an item or icon. Click Recycle Bin; click Computer; click file name . Double-click an item. Double-click Computer; double-click Recycle Bin; double-click folder name . Right-click an item. Right-click Computer; right-click Recycle Bin; right-click folder name . Minimize all windows to show your desktop

Repair or reset Windows Media Player: If Windows Media Player is not working properly, you can try to repair or reset it to its default settings.To do this, Select Start > Settings > Apps > Installed Apps.. Scroll down and click the three horizontal dots next to Windows Media Player and choose Advanced options, and click the Repair or Reset button. Note that resetting Windows Media Player will ...

Add a blank page anywhere in your document. To put a blank page into your Word document, place the cursor where you want the new page to begin and then select Insert > Blank Page.The blank page opens, ready for whatever you want to add.

To save time on tasks you do often, bundle the steps into a macro. First, you record the macro. Then you can run the macro by clicking a button on the Quick Access Toolbar or pressing a combination of keys.

Use OneDrive on your desktop. If you use Windows 10, OneDrive may have already asked you to sign in to sync your files. In File Explorer, select:

Have Excel automatically fill your data when it detects a pattern. For example, the months of the year, the days in a month, or a sequence of numbers. You can also parse data, like splitting first and last names out of a column, or concatenate data, like joining first and last names from two columns.