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
OneDrive help & learning
Protect your most important files, like your passport, driver’s license, or insurance information with OneDrive Personal Vault. Get started with Personal Vault. Explore OneDrive. Protect & restore. Manage security, backup, and restore options for your files and photos.
Join a meeting without an account in Microsoft Teams
Learn how to join a Microsoft Teams meeting if you don't have an account. Join a Teams meeting as a guest in the Windows app or on the web.
Applies To: Microsoft Teams
Insert and update Excel data in PowerPoint - Microsoft Support
Use Destination Styles to copy the data as a PowerPoint table, using the format of the presentation. Keep Source Formatting to copy the Excel data as a PowerPoint table, using the format of the worksheet. Embed to copy the data as information that can be edited in Excel later. Picture to copy the data as a picture that can't be edited in Excel. Keep Text Only to copy all the data as a single ...
Applies To: PowerPoint for Microsoft 365, PowerPoint 2021, PowerPoint 2019, PowerPoint 2016
Sign out or remove an account from Microsoft Teams
Sign out of Teams. While it's a good idea to remain signed in to continue receiving chats, notifications, incoming calls, and other activities, sometimes you might want to sign out of Teams to use another account or for other reasons.
Applies To: Microsoft Teams
Switch between Microsoft 365 subscriptions - Microsoft Support
With this subscription you won't have access to the desktop apps and you only get 100 GB of storage. Important: If you're moving from Microsoft 365 Family or Personal and you used over 100 GB of storage, you'll need to remove some of your files to remain within the 100 GB limit.. Switch to Microsoft 365 Family. Before you move to Microsoft 365 Family, you can check prices.
Applies To: Microsoft 365 for home, Office for business
How to perform a clean boot in Windows - Microsoft Support
How to determine what is causing the problem after you do a clean boot. If your problem does not occur while the computer is in a clean boot environment, then you can determine which startup application or service is causing the problem by systematically turning them on or off and restarting the computer.
Encrypt messages by using S/MIME in Outlook on the web
A key icon in the message list or reading pane indicates an encrypted message.. If you normally use Conversation view, you'll have to open the message in a new window to read it. There will be a link on the message to make this easier.
Applies To: Outlook.com, Outlook on the web for Exchange Server 2016, Outlook on the web for Exchange Server 2019
Create and print a single envelope - Microsoft Support
Click the Printing Options tab.. The printer driver tells Word which way the envelope should be loaded into the printer, and this information is displayed in the Printing Options tab of the Envelope Options dialog box.. 1. The feed method determines the position of the envelope (right, middle, left) and whether the long or short edge is being fed into the printer.
Applies To: Word for Microsoft 365, Word 2021, Word 2019, Word 2016, Word 2013
Insert ASCII or Unicode Latin-based symbols and characters
Inserting ASCII characters. To insert an ASCII character, press and hold down ALT while typing the character code. For example, to insert the degree (º) symbol, press and hold down ALT while typing 0176 on the numeric keypad.
Applies To: Excel for Microsoft 365, Outlook for Microsoft 365, PowerPoint for Microsoft 365, Publisher for Microsoft 365, Excel 2021, Outlook 2021, PowerPoint 2021, Publisher 2021, Visio Professional 2021, Visio Standard 2021, OneNote 2021, Excel 2019, Outlook 2019, PowerPoint 2019, Publisher 2019, Visio Professional 2019, Visio Standard 2019, Excel 2016, Outlook 2016, PowerPoint 2016, OneNote 2016, Publisher 2016, Visio Professional 2016, Visio Standard 2016