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.

Download our Formulas tutorial workbook. We've put together a Get started with Formulas workbook that you can download. If you’re new to Excel, or even if you have some experience with it, you can walk through Excel’s most common formulas in this tour.

Note: If you have a current version of Microsoft 365, then you can input the formula in the top-left-cell of the output range, then press ENTER to confirm the formula as a dynamic array formula. Otherwise, the formula must be entered as a legacy array formula by first selecting the output range, input the formula in the top-left-cell of the output range, then press CTRL+SHIFT+ENTER to confirm it.

Billing & payments. Your dashboard is also where you can: Buy, renew, or cancel a subscription.

Cookies are small pieces of data stored on your device by websites you visit. They serve various purposes, such as remembering login credentials, site preferences, and tracking user behavior.

Whether you’re creating a new document or working on an existing one, Copilot can help you move forward. In a new, blank document or upon creating new line in an existing document, the Draft with Copilot experience appears.. The description you provide can be a simple sentence or a more complex request with outlines, notes, or referenced files that you want Copilot to use.

Use Version History to view previous versions of files stored in OneDrive or SharePoint libraries.

Your Outlook mailbox is only so big, and it’s a good bet that you won’t stop getting email anytime soon. To keep it from filling up, you can move old items you want to keep to an archive, a separate Outlook Data File (.pst) that you can open from Outlook any time you need it.

Learn how to run Windows Update Troubleshooter to resolve errors downloading or installing Windows updates.

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.