INDEX function - Microsoft Support
Note: If you have a current version of Microsoft 365, then you can input the formula in the top-left-cell of the output range, then press ENTER to confirm the formula as a dynamic array formula. Otherwise, the formula must be entered as a legacy array formula by first selecting two blank cells, input the formula in the top-left-cell of the output range, then press CTRL+SHIFT+ENTER to confirm it.
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
Learn about encrypted messages in Outlook.com
If you choose the Do Not Forward option, there are two possibilities:. Microsoft Office attachments such as Word, Excel or PowerPoint files remain encrypted even after they’re downloaded. This means that if the recipient downloads the attachment and sends it to someone else, the person they forwarded it to won’t be able to open the attachment because they don’t have permission to open it.
Applies To: Outlook.com
About Windows backup and sync settings - Microsoft Support
To find Sync settings, select Start , then select Settings > Accounts > Sync your settings . Choose from settings such as language preferences, passwords, and color themes. If you turn on Other Windows settings, Windows also syncs some device settings (for things like printers and mouse options), File Explorer settings, and notification preferences.
Applies To: Microsoft account dashboard
Install the Windows Fax driver or service to use Internet Fax in Office
Microsoft Office has a feature that lets you send Outlook, Word, Excel, and PowerPoint files as Internet faxes. This feature relies on having the Windows Fax Printer Driver or Fax Services installed on the computer to send the faxes.
Applies To: Excel for Microsoft 365, Word for Microsoft 365, Outlook for Microsoft 365, PowerPoint for Microsoft 365, Word 2021, Word 2019, Excel 2016, Word 2016, Outlook 2016, PowerPoint 2016, Office 2016, Excel 2013, Word 2013, Outlook 2013, PowerPoint 2013, Office 2013
Print in Microsoft Edge - Microsoft Support
Choose number of pages to print per sheet: Printing multiple pages on a single sheet of paper is a useful technique to save paper, reduce printing costs, and create compact versions of your documents. The number of pages that can be printed on a single sheet depends on the capabilities of your printer and the printing options you choose (Example: 1, 2, 4, 6, 9 or 16 pages per sheet).
Surface Pro (5th Gen) specs and features - Microsoft Support
Surface Pro (5th Gen) and Windows 10. Surface Pro (5th Gen) comes with Windows 10 Pro edition. If you're not sure which Surface model you're using, see Which Surface model do I have?. Diagrams of Surface Pro (5th Gen)
October 5, 2021, update for Outlook 2016 (KB5001998)
This article describes update 5001998 for Microsoft Outlook 2016 that was released on October 5, 2021. Be aware that the update in the Microsoft Download Center applies to the Microsoft Installer (.msi)-based edition of Office 2016.
Manage audio settings in Microsoft Teams meetings
Audio source. When you choose this... Computer audio Your computer's default speaker and mic will be used during the meeting. To adjust your PC mic and speaker settings, select Open device settings .. In Audio settings, select the audio devices you want to use from the Speaker and Microphone dropdown menus.You can alsoturn on spatial audio and adjust noise suppression.
Applies To: Microsoft Teams
Examples of common formulas in lists - Microsoft Support
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.
Applies To: SharePoint Server Subscription Edition, SharePoint Server 2019, SharePoint Server 2016, SharePoint Server 2013 Enterprise, SharePoint Server Central Admin 2013, SharePoint in Microsoft 365, SharePoint Server 2010, Microsoft Lists, SharePoint in Microsoft 365 Small Business
Excel specifications and limits - Microsoft Support
32-bit environment is subject to 2 gigabytes (GB) of virtual address space, shared by Excel, the workbook, and add-ins that run in the same process. A data model’s share of the address space might run up to 500 – 700 megabytes (MB), but could be less if other data models and add-ins are loaded.
Applies To: Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016