FILTER function. Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web More... The FILTER function allows you to filter a range of data based on criteria you define. 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 ...

Windows 11 automatically downloads and installs updates to make sure your device is secure and up to date. This means you receive the latest fixes and security updates, helping your device run efficiently and stay protected. To check for updates manually, select Start > Settings > Windows Update . Check for updates.

To unblock your account, you'll need to reset your password. Unblock your account. Enter the email address of the blocked account, then enter the characters you see on your screen and select Next. Enter the code generated by your authenticator app or select Use a different verification option to get a text message. Notes:

Customize your lock screen status. Select Start > Settings . Select Personalization > Lock screen. Select the list for Lock screen status and select an app that can show detailed status on the lock screen. You can also select None if you don't want to see detailed status on the lock screen. Note: Lock screen status will be available when you ...

For technical support, go to Contact Microsoft Support, enter your problem and select Get Help. If you still need help, select Contact Support to be routed to the best support option. Learn how to change Microsoft account email address or phone number using aliases to sign into your Microsoft account.

Select Start > Settings > Windows Update . Select Schedule the restart and choose a time that's convenient for you. Note: You can set active hours to make sure your device only restarts for updates when you're not using your PC. Get updates when you're away from your PC with active hours in Windows. Open Windows Update.

Open Device Manager. In the search box on the taskbar, type device manager, then select Device Manager from the menu.

There's no charge to switch out of S mode. To switch out of S mode, click here to open the Microsoft Store to the Switch out of S mode (or similar) page. On the Switch out of S mode (or similar) page, select the Get button. After you see a confirmation message on the page, you'll be able to install apps from outside of the Microsoft Store.

Add a new Yahoo email account. On the View tab, select View settings. Select Accounts, then Email accounts. Tip: If your Settings window doesn't look like this, you might be using classic Outlook. Select + Add Account. Enter the Yahoo! account you want to add and select Continue. On Sync your Yahoo account, select Continue.

Top of Page. Layout tips. Use the following tips to help you refine the appearance, size, and other aspects of a multiple-selection list box: To change the width of several multiple-selection list boxes at once, select the multiple-selection list boxes whose size you want to change, press ALT+ENTER, click the Size tab, and then in the Width box, type a new number.