An array formula is a formula that can perform multiple calculations on one or more items in an array. You can think of an array as a row or column of values, or a combination of rows and columns of values. Array formulas can return either multiple results, or a single result. Beginning with the September 2018 update for Microsoft 365, any ...

FIND, FINDB functions. Finds one text value within another (case-sensitive) FIXED function. Formats a number as text with a fixed number of decimals. LEFT, LEFTB functions. Returns the leftmost characters from a text value. LEN, LENB functions. Returns the number of characters in a text string. LOWER function.

On the Design tab, select Watermark.. In the Insert Watermark dialog, select Text and either type your own watermark text or select one, like DRAFT, from the list. Then, customize the watermark by setting the font, layout, size, colors, and orientation. If you don’t see the watermark, click View > Print Layout.This also shows how the printed watermark will look.

To delete a theme: Click Start > Settings > Personalization > Themes. Right-click (or press and hold) the theme's tile, and select Delete. Note: You cannot delete the currently active theme. If you want to delete the currently active theme, first select another theme to use. The Settings app will also not allow you to delete default themes.

In an existing document, select the Share button. In the Share window, select the icon inside the " Add a message" compose box. Copilot will generate a summary of the document for easier sharing. Once Copilot generates the summary, you can edit it however you need. After you've shared the Word file, the email notification to your collaborators ...

Change permissions. Right-click on a shared folder or file, navigate to OneDrive and then select Manage access. Do one of the following: Select Grant access to share with more people. Select Links to change permissions. Select the Can edit or Can view dropdown to change permissions or Remove direct access. Select Remove to delete the link.

When versioning is enabled in a list or library, you can store, track, and restore items in a list and files in a library whenever they change. Versioning, combined with other settings, such as checkout, gives you control of the content posted on your site.

Select Important or Urgent. Mark a message as important or urgent at any time before sending it with the steps above. If you've already sent your message, edit your message and assign a priority to it. To edit your message in Teams, hover over the message, then select Edit . Then follow the steps above to assign a priority.

On the Insert tab, click SmartArt. In the Choose a SmartArt Graphic gallery, click Process, and then double-click a timeline layout. Tip: There are two timeline SmartArt graphics: Basic timeline and Circle Accent Timeline, but you can also use almost any process-related SmartArt graphic. Click [Text], and then type or paste your text in the ...

Solution 1: Find your email address on the Home screen. If you’re already signed in on an Xbox console, look in the upper-left corner of the Home screen. You should see your gamertag, name, and the email that’s used to sign in rotating there. If you don’t see your email address displayed, this setting may be disabled.