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

Instead of using explicit cell references. Excel uses table and column names. =Sum (C2:C7) =SUM (DeptSales [Sales Amount]) That combination of table and column names is called a structured reference. The names in structured references adjust whenever you add or remove data from the table. Structured references also appear when you create a ...

Note: This support article is only applicable if you sign in with a work or school account. Outlook accounts can have up to 100GB of storage per mailbox ( Exchange Online mailbox storage limits ). Administrators can reduce maximum mailbox sizes per user or globally, see: How to set Exchange Online mailbox sizes and limits in the Microsoft 365 ...

When Smart charging is on, you’ll see a heart on the Battery icon in the following places—on the right side of the taskbar and in Power & battery settings. When your hover over the Battery icon with your mouse, it says “Fully Smart charged” and means the battery isn’t charging even though your device is still plugged in.

Add or change headers or footers in Page Layout view. Select the worksheet where you want to add or change headers or footers. Go to Insert > Header & Footer. Excel displays the worksheet in Page Layout view. To add or edit a header or footer, select the left, center, or right header or footer text box at the top or the bottom of the worksheet ...

Sometimes add-ins can conflict with Outlook. Starting Outlook in safe mode, which starts Outlook without add-ins loaded, can tell you if an add-in is the source of the problem.

Add a font. Download the font files. These often come compressed in .zip folders. In one .zip folder, you might find several variations on the same font, such as “light” and “heavy.”. If the font files are zipped, unzip them by right-clicking the .zip folder and then clicking Extract. Now you'll see the available TrueType and OpenType ...

The files on your OneDrive are private until you share them. Keep in mind that when you share folders with Edit permissions, people you share with can add the shared folders to their own OneDrive.. This lets them keep the folder alongside their own folders and items, easily move items between folders, and more easily work on it offline.

Sign in to Microsoft 365 with your work or school account with your password like you normally do. After you choose Sign in, you'll be prompted for more information. Choose Next. The default authentication method is to use the free Microsoft Authenticator app. If you have it installed on your mobile device, select Next and follow the prompts to ...

Flagging an email in Outlook is a lot like starring an email in Gmail. Use Folders to organize your email. Select a message. Select Move. Choose a folder. Or, drag and drop an email into a folder. Create Rules to sort your email automatically. You can make your Rules as complicated or as simple as you want.