Repair programs in Control Panel. Select the Advanced options link under the name of the app (some apps don't have this option). On the page that opens, select Repair if it's available.If it isn't available or doesn't fix the problem, select Reset.

Learn Excel skills from beginner to advanced with video tutorials, templates, and tips from Microsoft Support.

Important: The Assistant will, in most cases, modify the registry and move files from startup folders used by Excel. Before you run the Assistant, make sure that you back up the registry and all files in startup folders used by Excel so that you can restore the registry and backed-up files if a problem occurs.

Examples. Example 1. This example uses SORT and UNIQUE together to return a unique list of names in ascending order. Example 2. This example has the exactly_once argument set to TRUE, and the function returns only those customers who have had service one time.

Automatically fill a series of data in your worksheet, like dates, numbers, text, and formulas. Use the AutoComplete feature, Auto Fill Options button and more.

Both options allow essentially the same thing—you can access files on your local computer in File Explorer or Finder. However, adding OneDrive shortcuts allows content to be accessed on all devices, whereas sync is related to a specific device.

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.

Get Microsoft 365 support, help, and learning resources. Organize your life, expand your creativity, and protect what’s important with Microsoft 365

Xbox Support offers help for Xbox, Game Pass, and billing questions. Get advice and customer service in the Xbox Support community.

Elevate your device by showcasing beautiful images from around the globe with Windows spotlight, or your favorite memories with a custom photo or a dynamic slide show as your lock screen background.. Stay informed and efficient with dynamic updates that bring weather, finance, sports, traffic, and app notifications right to your lock screen.