Select Settings > Mail > Junk email. Under Safe senders, enter the email address or domain you want to add, and select Add. Select Save. Tips: To edit or remove email addresses or domains from the blocked senders or safe senders list, select the item in the list and then select or . To empty your Junk Email folder, select Junk Email in the left ...

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. This argument can be a cell reference, or a fixed value such as "smith" or 21,000.

Use the XLOOKUP function when you need to find things in a table or a range by row. For example, look up the price of an automotive part by the part number, or find an employee name based on their employee ID. With XLOOKUP, you can look in one column for a search term, and return a result from the same row in another column, regardless of which side the return column is on.

Right click the network icon in the right side of the taskbar and select Diagnose network problems or open Get Help for Network & Internet. Make sure Wi‑Fi is turned on. Select the No internet icon on the right side of the taskbar, and make sure Wi-Fi is turned on. If it isn't, select it to turn it on. Also, make sure Airplane mode is turned off.

Get new themes and desktop backgrounds. Select Start , then select Settings > Personalization > Themes. Choose from a default theme or select Get more themes from Microsoft Store if you want to download new themes with desktop backgrounds that feature cute critters, breathtaking landscapes, and other smile-inducing options. Get new themes and ...

Download Microsoft Defender on your devices either by: Scanning the following QR code. Searching for Microsoft Defender in your app store. Sharing with your devices, the following link: Copy link. We encourage you to install Microsoft Defender on at least five devices per person. Important: This article is about the Microsoft Defender app that ...

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

Add flair to your email with emojis. Windows 10 and 11 contain a large set of emojis. To insert one: Put your cursor where you want the emoji. Hold Windows key + . (period) to open the Windows Emoji picker. Select a symbol to insert it in your email message. When you're done, select × to close the emoji picker.

Curate your notifications. Windows Security will send notifications about the health and safety of your device. You can turn these notifications on, or off, on the notifications page. In Virus & threat protection, under Virus & threat protection settings, select Manage settings, scroll down to Notifications and select Change notification settings.

Enter a formula that contains a built-in function. Select an empty cell. Type an equal sign = and then type a function. For example, =SUM for getting the total sales. Type an opening parenthesis (. Select the range of cells, and then type a closing parenthesis). Press Enter to get the result.