The default templates folder is opened. The folder location (in Windows 7 and later operating systems) is c:\users\username\appdata\roaming\microsoft\templates.If your template is saved in a different folder, click Browse, and then select the template.

Learn more about simple formulas. All formula entries begin with an equal sign (=).For simple formulas, simply type the equal sign followed by the numeric values that you want to calculate and the math operators that you want to use — the plus sign (+) to add, the minus sign (-) to subtract, the asterisk (*) to multiply, and the forward slash (/) to divide.

To stay updated when a SharePoint document or an item on your site changes, create an alert. You can set up an alert for a list, library, folder, file, or list item.

There are two types of rules in Outlook—server-based and client-only. Server-based rules When you're using a Microsoft Exchange Server account, some rules are server-based.These rules run on your mailbox on the Exchange mail server even when Outlook isn’t running.

Capture screen shots to use in your documents. For more details and instructions, see Use Snipping Tool to capture screenshots.. Use the PRINT SCREEN key. Pressing PRINT SCREEN captures an image of your entire screen and copies it to the Clipboard in your computer's memory.

Data sources. Your first step in setting up a mail merge is to pick the source of data you'll use for the personalized information. Excel spreadsheets and Outlook contact lists are the most common data sources, but if you don't yet have a data source, you can type it up in Word, as part of the mail merge process.

If you're having trouble using the Outlook for Android mobile app, Open an in-app Outlook support ticket. If you have a work or school account that uses Microsoft 365 for business or Exchange-based accounts, there may be additional requirements set by your IT admin.

Note: Calculated fields can only operate on their own row, so you can't reference a value in another row, or columns contained in another list or library.Lookup fields are not supported in a formula, and the ID of newly inserted row can't be used as the ID doesn't exist when the formula is processed.

Automatically fill a series of data in your worksheet, like dates, numbers, text, and formulas. Use the AutoComplete feature, Auto Fill Options button and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.