Syntax. INDEX (array, row_num, [column_num]) The array form of the INDEX function has the following arguments: array Required. A range of cells or an array constant. If array contains only one row or column, the corresponding row_num or column_num argument is optional. If array has more than one row and more than one column, and only row_num or ...

Add or remove an automation add-in. Add-ins provide optional commands and features for Microsoft Excel. By default, add-ins are not immediately available in Excel, so you must first install and (in some cases) activate these add-ins so that you can use them. Some add-ins are built in to Excel, such as Solver and the Analysis ToolPak. Some other ...

Archive messages by using the Archive button. You can use the Archive button in the Delete group on the ribbon to move one or more messages to your Archive folder without deleting them. There are several benefits to using Archive. Archived items remain easy to find from the search box or by navigating to your Archive folder.

In Control Panel, search for and open the Mail icon. On the Mail Setup - Outlook window, click Email Accounts. On the Account Settings window, select the account you're trying to troubleshoot and select Change. On the Change Account window, check the Incoming mail server and Outgoing mail server settings against those from your email provider ...

Windows 11 Windows 10. Most of the advanced display settings from previous versions of Windows are now available on the Display settings page. Select Start > Settings > System > Display. If you want to change the size of your text and apps, choose an option from the drop-down menu next to Scale. Learn how to change just your text size in Make ...

Simply select a cell in a data range > select the Analyze Data button on the Home tab. Analyze Data in Excel will analyze your data, and return interesting visuals about it in a task pane. If you're interested in more specific information, you can enter a question in the query box at the top of the pane, and press Enter.

To reset your PC, go to Start > Settings > System > Recovery . Next to Reset this PC , select Reset PC. Then, select Keep my files, choose cloud or local, change your settings, and set Restore preinstalled apps? to No . Open Recovery settings. Note: If you don't see the option to Restore preinstalled apps, it means your PC doesn't have ...

Try guided support. If you're having problems setting up your email in Outlook, we want to help. Choose an option below for more information. Tip: If you're a small business owner looking for more information on how to get Microsoft 365 set up, visit Small business help & learning. Select any heading below, and it will open to show more info:

Open the Devices and Printers dialog box. In Windows 10, in the Search box, type Devices and Printers, and then click Devices and Printers. In Windows 8, go to the start screen, type Devices and Printers, then click Devices and Printers. In Windows 7, click Start > Devices and Printers. Note: You can also access this through Control Panel.

In the search box on the taskbar, type Manage BitLocker and then select it from the list of results. Or, select the Start button, and then under Windows System, select Control Panel.In Control Panel, select System and Security, and then under BitLocker Drive Encryption, select Manage BitLocker. Note: You'll only see this option if BitLocker is available for your device.