Multiply and divide numbers in Excel - Microsoft Support
Multiply numbers in different cells by using a formula. You can use the PRODUCT function to multiply numbers, cells, and ranges.. You can use any combination of up to 255 numbers or cell references in the PRODUCT function. For example, the formula =PRODUCT(A2,A4:A15,12,E3:E5,150,G4,H4:J6) multiplies two single cells (A2 and G4), two numbers (12 and 150), and three ranges (A4:A15, E3:E5, and H4 ...
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016
Use conditional formatting to highlight information in Excel
Notes: The formatting options that appear in the Formatting tab depend on the data you have selected. If your selection contains only text, then the available options are Text, Duplicate, Unique, Equal To, and Clear.When the selection contains only numbers, or both text and numbers, then the options are Data Bars, Colors, Icon Sets, Greater, Top 10%, and Clear.
Applies To: Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016
Collaborate on Excel workbooks at the same time with co-authoring ...
If you selected the Share button, people will receive an email message inviting them to open the file. They can select the link to open the workbook. A web browser will open, and the workbook will open in Excel for the web. If they want to use the Excel desktop app to co-author, they can select Edit in Desktop App.However, they'll need a version of the Excel app that supports co-authoring.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2016, Excel for iPad, Excel for iPhone, Excel for Android tablets, Excel for Android phones, Excel for Windows Phone 10, Excel Mobile
Translate text into a different language - Microsoft Support
To change your translation preferences, go to Home > Translate > Translation Preferences.. Here you can set your preferred language. Translate part of an email. To translate just a bit of text from a message, select that text and right-click.
Applies To: Excel for Microsoft 365, Word for Microsoft 365, PowerPoint for Microsoft 365, OneNote for Microsoft 365, Publisher for Microsoft 365, Visio Plan 2, Excel for Microsoft 365 for Mac, Word for Microsoft 365 for Mac, PowerPoint for Microsoft 365 for Mac, Word for the web, Excel 2021, Word 2021, PowerPoint 2021, Publisher 2021, Visio Professional 2021, Visio Standard 2021, OneNote 2021, Excel 2021 for Mac, Word 2021 for Mac, PowerPoint 2021 for Mac, Excel 2019, Word 2019, PowerPoint 2019, Publisher 2019, Visio Professional 2019, Visio Standard 2019, Excel 2019 for Mac, Word 2019 for Mac, PowerPoint 2019 for Mac, Excel 2016, Word 2016, PowerPoint 2016, OneNote 2016, Publisher 2016, Visio Professional 2016, Visio Standard 2016
Save a Word document as a template - Microsoft Support
Whether you’re starting from a Microsoft template or updating one of your own, Word's built-in tools help you update templates to suit your needs. To update your template, open the file, make the changes you want, and then save the template. In Microsoft Word, you can create a template by saving a document as a .dotx file, .dot file, or a .dotm fie (a .dotm file type allows you to enable ...
Applies To: Word for Microsoft 365, Word 2021, Word 2019, Word 2016
Download free, pre-built templates - Microsoft Support
Find and download free templates to create documents like calendars, business cards, letters, greeting cards, brochures, newsletters, or resumes.
Applies To: Excel for Microsoft 365, Word for Microsoft 365, PowerPoint for Microsoft 365, Access for Microsoft 365, Project Online Desktop Client, Publisher for Microsoft 365, Excel 2021, Word 2021, PowerPoint 2021, Access 2021, Project Professional 2021, Project Standard 2021, Publisher 2021, Excel 2019, Word 2019, PowerPoint 2019, Access 2019, Project Professional 2019, Project Standard 2019, Publisher 2019, Excel 2016, Word 2016, PowerPoint 2016, Access 2016, Project Professional 2016, Project Standard 2016, Publisher 2016, Visio Professional 2016, Visio 2010, InfoPath 2013
Send large files with Outlook - Microsoft Support
Compress the file. When you compress, or zip, your file, it decreases its size, and it might decrease it enough to fit within the Outlook size limits for attachments.The following articles describe how to compress and extract files for different Windows operating systems.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016
Insert a table of contents - Microsoft Support
Note: If you use a Manual Table of Contents style, Word won't use your headings to create a table of contents and won't be able to update it automatically. Instead, Word will use placeholder text to create the look of a table of contents so you can manually type each entry into the table of contents.
Applies To: Word for Microsoft 365, Word for Microsoft 365 for Mac, Word for the web, Word 2021, Word 2021 for Mac, Word 2019, Word 2019 for Mac, Word 2016
Use inbox rules in Outlook - Microsoft Support
Use rules to automatically perform specific actions on email that arrives in your inbox. For example, you can create rules that will change the importance level of messages as they come in, automatically move them to other folders, or delete them based on certain criteria.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016, Microsoft 365 admin, Outlook on the web, Outlook.com, New Outlook for Windows
Filter data in a range or table - Microsoft Support
Use AutoFilter or built-in comparison operators like "greater than" and “top 10” in Excel to show the data you want and hide the rest. Once you filter data in a range of cells or table, you can either reapply a filter to get up-to-date results, or clear a filter to redisplay all of the data.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2019, Excel 2016