Select the cell in the worksheet where you want the drop-down list. Go to the Data tab on the Ribbon, and then Data Validation. Note: If you can’t select Data Validation, the worksheet might be protected or shared. Unlock specific areas of a protected workbook or stop sharing the worksheet, and then try step 3 again.

sum_range Optional.The actual cells to add, if you want to add cells other than those specified in the range argument. If the sum_range argument is omitted, Excel adds the cells that are specified in the range argument (the same cells to which the criteria is applied).. Sum_range should be the same size and shape as range.If it isn't, performance may suffer, and the formula will sum a range of ...

Edit an inbox rule in new Outlook for Windows. At the top of the page, select Settings . Select Mail > Rules. In the rule you want to edit, select . Press Save to save your edited rule. Note: Some rules created in other versions of Outlook can't be processed by Outlook on the web. You won't be able to run or edit the rule in Outlook on the web.

Customize your lock screen status. Select Start > Settings . Select Personalization > Lock screen. Select the list for Lock screen status and select an app that can show detailed status on the lock screen. You can also select None if you don't want to see detailed status on the lock screen. Note: Lock screen status will be available when you ...

Check the Xbox services, games, and apps for any service outages.

Turn on Dark Mode. To use Dark Mode in Word, you must first set your Office theme to Black. This will enable the Black theme for all Office apps. Go to File > Account > Office Theme. Open the drop-down menu and select Black. Alternatively, you can select Use system setting, which will automatically switch your Office theme based on your Windows ...

Resolution. This update for the Microsoft Visual C++ 2013 Update 5 Redistributable Package is released as a download-only update and isn’t distributed through Windows Update. Redistribution of this update is allowed, subject to the same license terms as granted by the Microsoft Visual Studio 2013 Update 5 release.

This Excel template can help you track your monthly budget by income and expenses. Input your costs and income, and any difference is calculated automatically so you can avoid shortfalls or make plans for any projected surpluses. Compare projected costs with actual costs to hone your budgeting skills over time. > Get this personal budget template.

In Settings: Select Start > Settings > Bluetooth & devices , and then turn on Bluetooth . In quick settings: To find the quick setting for Bluetooth, select the Network, Sound, or Battery icons ( ) next to the time and date on the right side of your taskbar. Select Bluetooth to turn it on.

Mouse and Keyboard Center download. The Microsoft Mouse and Keyboard Center is an app that helps you make the most out of your Microsoft keyboard and mouse. Mouse and Keyboard Center helps you personalize and customize how you work on your PC. This app is not available for Windows S mode . Download the latest release of Mouse and Keyboard ...