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 ...

The View in File Explorer command uses a temporary folder that opens in File Explorer.That folder only lasts until you close it and the content is saved to SharePoint. So using View in File Explorer gives you one-time access to the SharePoint library by way of your desktop folders. By default, the View in File Explorer menu option will not be visible to you or users in the SharePoint modern ...

Missed activity emails. In the Missed activity emails section, you’re able to set the frequency of summary emails detailing your missed activity, or turn this feature off.. Chats and channels notifications. Notifications for chats and channels can be managed at a granular level, allowing you to customize your notifications to your personal work style.

A family group is a set of individuals connected through the Microsoft Family Safety app on their Windows, Xbox, or mobile devices. Establishing a family group is an easy, effective way to encourage healthy online habits and manage busy schedules.

Access, download, or run the Surface app and the Surface Diagnostic Toolkit to help find and solve Surface problems.

Whether it’s a new job title (congratulations!) or a phone number change, make sure you keep your email message signature up-to-date. If you're using new Outlook, for more information about email signatures, or if you haven’t created one yet, see Add a signature to messages.. Select File > Options > Mail > Signatures.

To edit a PDF, open it in Word. This works best with PDFs that are mostly text. PDFs of book chapters or something that looks like a manuscript from a copier won't be formatted well in Word.

Try it! Universal search. Select Search on the taskbar or press Windows logo key + S, then type what you want to find.You'll get personalized search results for people, email, and files in local and shared sites, or from the web. Desktop groups

Use the Block or Allow settings to help control unwanted and unsolicited email messages by creating and managing lists of email addresses and domains that you trust and those that you don’t.

Pin the apps you use most often to the Start menu. Here's how: Select Start from the taskbar, then find the app you want to pin in the list or search for it by typing the app name in the search box.