Create a drop-down list - Microsoft Support
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.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016
Tips to improve PC performance in Windows - Microsoft Support
Other symptoms include unexpected pop-up messages, programs that unexpectedly start automatically, or the sound of your hard disk constantly working. The best way to handle viruses and malicious software is to try to prevent them by running antimalware and antivirus software and keeping it up to date. However, even if you take precautions, your ...
Repair an Office application - Microsoft Support
Right-click the Start button (lower-left corner) and select Apps and Features on the pop-up menu. Select the Microsoft Office product you want to repair and select Modify . Note: This will repair the entire Office suite even if it's just one application you want to repair such as Word or Excel.
Applies To: Excel for Microsoft 365, Word for Microsoft 365, Outlook for Microsoft 365, PowerPoint for Microsoft 365, Access for Microsoft 365, OneNote for Microsoft 365, Publisher for Microsoft 365, Visio Plan 2, Excel 2021, Word 2021, Outlook 2021, PowerPoint 2021, Access 2021, Project Professional 2021, Project Standard 2021, Publisher 2021, Visio Professional 2021, Visio Standard 2021, Office 2021, OneNote 2021, Excel 2019, Word 2019, Outlook 2019, PowerPoint 2019, Access 2019, Project Professional 2019, Project Standard 2019, Publisher 2019, Visio Professional 2019, Visio Standard 2019, Office 2019, Excel 2016, Word 2016, Outlook 2016, PowerPoint 2016, Access 2016, OneNote 2016, Project Professional 2016, Project Standard 2016, Publisher 2016, Visio Professional 2016, Visio Standard 2016, Office 2016, Microsoft 365 for home, Office for business, Office 365 Small Business, Microsoft 365 admin, Office 365 operated by 21Vianet, Office 365 operated by 21Vianet - Small Business Admin, Office 365 operated by 21Vianet - Admin, InfoPath 2013, Office 365 Germany - Enterprise, Office 365 Germany - Enterprise admin
Look up values with VLOOKUP, INDEX, or MATCH - Microsoft Support
Here's an example of how to use VLOOKUP. =VLOOKUP(B2,C2:E7,3,TRUE) In this example, B2 is the first argument—an element of data that the function needs to work.For VLOOKUP, this first argument is the value that you want to find.
Applies To: Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016
Introduction to Outlook Data Files (.pst and .ost)
Note: In earlier versions of Outlook, IMAP accounts also used an Outlook Data File (.pst).In Outlook 2016 and Outlook for Microsoft 365, IMAP accounts use Offline Outlook Data Files (.ost). You can also use an Outlook Data File (.pst) to backup or export items from any type of email account.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016
Xbox Status | Xbox Support
Check the Xbox services, games, and apps for any service outages.
Installing Microsoft Defender - Microsoft Support
When you first sign into Microsoft Defender on Android, we'll walk you through a few easy steps that start with setting up web protection.During this process, we'll ask you to give Defender permission to do two things: run in the background and use the Accessibility Service.
Applies To: Microsoft Defender on Android, Microsoft Defender on iOS, Microsoft Defender on Mac, Microsoft Defender on Windows
Server settings you'll need from your email provider
The POP3, IMAP4, and SMTP server name and other settings you may need to enter are listed on the POP and IMAP settings page. What server settings do I need from my email provider? To help you get the info you need, we've put together a handy chart of the email server settings you should ask for. You will most likely have to set up your email as ...
Applies To: Outlook for Microsoft 365, Outlook for Microsoft 365 for Mac, Microsoft 365 for home, Office for business, Office 365 Small Business, Microsoft 365 admin, Office 365 operated by 21Vianet, Office 365 operated by 21Vianet - Small Business Admin, Outlook.com, Office 365 operated by 21Vianet - Admin, New Outlook for Windows, Outlook for iOS, Outlook for Windows Phone 10, Outlook Mail for Windows 10, Outlook on the web for Exchange Server 2016
Add a Gmail account to Outlook for Windows - Microsoft Support
If you need instructions for adding an email account using advanced settings, go to Use advanced setup to add a POP or IMAP email account in Outlook for PC. Outlook won't accept my password. If Outlook won’t accept your password and you know you’re using the right password for your Gmail account, you might have an older version of Outlook that doesn't currently support this faster Gmail ...
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016, New Outlook for Windows
Change your browser home page - Microsoft Support
On the General tab, under Home page, enter the URL of the site you want to set as a homepage.You can add more than one URL. Or, to add the site you're currently viewing, select Use current.If you add more than one URL, put each URL on its own line.