Alternate command key. What it does. Help. Opens the Help system (if any) for the active window. Undo. Cancels the previous action. Redo. Cancels the previous Undo action.

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 ("").

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Advanced settings - This will open the classic Windows Defender Firewall tool which lets you create inbound or outbound rules, connection security rules, and see monitoring logs for the firewall. Most people won't want to dig into it that deeply; adding, changing, or deleting rules incorrectly can cause your system to be more vulnerable or can cause some apps not to work.

The notification area is located at the right end of the taskbar. It contains icons you might find yourself selecting or pressing pretty often: battery, Wi-Fi, volume, Clock and Calendar, and action center.

In the Rule Address dialog, under Address Book, select the contact list that contains the address you want to forward to.. In the To box at the bottom, enter the email address that you want to forward all your mail to.Select OK.You should see the email address you want all of your email forwarded to inserted into the rule under Step 2.

Better together tip: Manage drafts from Outlook for iOS and Outlook for Android. If you use Outlook for iOS or Outlook for Android, your drafts will automatically synchronize to your mobile device.From there, you can finish messages you've started at your computer, easily add attachments from your photos or camera, or use Office Lens to capture notes from a whiteboard in a meeting.

A delivery receipt confirms delivery of your email message to the recipient's mailbox, but not that the recipient has seen it or read it. A read receipt confirms that your message was opened.

Step 2: Back up your folders. Windows Backup is an easy, single stop for all of your backup needs. Your free Microsoft account comes with 5 GB of OneDrive cloud storage (and more storage is available if you need it), and backing up your folders syncs the folders you specify to your OneDrive account, making them instantly accessible on all computers that you use with this Microsoft account.

If you try to add an IMAP account to Outlook, for example a Gmail account, Apple account, Yahoo account, or an account from your local ISP, and you're not prompted to enter your password, use the following steps to work around the problem.