After you create your drop-down list, make sure it works the way you want. For example, you might want to check to see if Change the column width and row height to show all your entries.. If the list of entries for your drop-down list is on another worksheet and you want to prevent users from seeing it or making changes, consider hiding and protecting that worksheet.

Sometimes add-ins can conflict with Outlook. Starting Outlook in safe mode, which starts Outlook without add-ins loaded, can tell you if an add-in is the source of the problem.

Under Customize toolbar, for Show favorites bar, do one of the following:. To turn on the favorites bar, select Always.

The COUNTIFS function is similar to the COUNTIF function with one important exception: COUNTIFS lets you apply criteria to cells across multiple ranges and counts the number of times all criteria are met. You can use up to 127 range/criteria pairs with COUNTIFS. The syntax for COUNTIFS is: COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2],…)

Clean up Mailbox. From the Settings > Storage page you should see a breakdown of how much space each folder in your mailbox is taking. Below, you should see a list of the folders represented in the breakdown with the option to permanently delete all items (or those older than 3, 6, or 12 months) in these folders to free up space.

Note: To let a user enter percentages, for example 20%, select Decimal in the Allow box, select the type of restriction that you want in the Data box, enter the minimum, maximum, or specific value as a decimal, for example .2 , and then display the data validation cell as a percentage by selecting the cell and clicking Percent Style in the Number group on the Home tab.

Turn on Find my device. When you set up a new device, you can decide whether to turn on or turn off the Find my device setting. If you turned it off during setup and now want to turn it on, make sure your Windows device is connected to the internet, has enough battery power so it can send its location, and that you're signed in to the device using your Microsoft account.

Learn how to check your PC's storage capacity and manage it effectively with Microsoft Support's guidance.

If instructions to install the update don’t automatically appear, you can start the process manually. To do this, press the Xbox button to open the guide, choose Profile & system > Settings > Devices & connections > Controllers & headsets, and then select the controller you want to update.On the Xbox Wireless Controller screen, select “…” to check the firmware version for your controller.

Add, change, or remove transitions between slides Article; Animate text or objects Article; Use the Morph transition in PowerPoint Article; Insert a video from YouTube or another site