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.

This article applies to Office Home & Business, Office Professional, and individually purchased Office apps. To switch an Office install to or from Microsoft 365, see Switch your Office license.. Change the product key for your version

In the Step 1: Select condition(s) list, select the check boxes for any options that you want, and then click Next.. If you do not select any check boxes, a confirmation dialog box appears. If you click Yes, the rule that you are creating is applied to all messages that you send.

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.

Microsoft 365 for business If your business subscription plan includes the desktop version of the Microsoft 365 apps you won't see an option to install it unless someone in your organization assigned a license to you.. Learn how to check this in What Microsoft 365 business product or license do I have? or if you're a Microsoft 365 admin responsible for assigning licenses to people in your ...

Learn how to remove malware from your PC. Use Microsoft Defender Antivirus in Windows 10 or Windows 11 to scan your PC for malware, viruses, or other threats.

In the following example we used the formula =FILTER(A5:D20,C5:C20=H2,"") to return all records for Apple, as selected in cell H2, and if there are no apples, return an empty string ("").

Cloud files can exist locally on the disk or be available online only. To choose the conditions for when inactive files are made online only, under Content will become online-only if not opened for more than: choose your preferred amount of time. Note that starting in Windows 11, version 22H2, the default for OneDrive cloud files is to make files online-only if not opened for more than 30 days.

This article is for Outlook.com. If you're using Outlook for Windows, see Fixes or workarounds for recent issues in Outlook for Windows.. If you're having problems accessing Outlook.com, you can see the status of Microsoft Office Online Services at the Service Health portal.. If you're having problems sending or receiving email, read how to Fix Outlook.com email sync issues.

To keep an area of a worksheet visible while you scroll to another area of the worksheet, go to the View tab, where you can Freeze Panes to lock specific rows and columns in place, or you can Split panes to create separate windows of the same worksheet.