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

Note: If you use a Manual Table of Contents style, Word won't use your headings to create a table of contents and won't be able to update it automatically. Instead, Word will use placeholder text to create the look of a table of contents so you can manually type each entry into the table of contents.

Note: If a document has been shared with you for review, you may not be able to turn off Track Changes.If you want to edit the document without tracking changes, you’ll need to either save a copy or ask the person who sent it to you to share it again with review mode turned off.

Turn on caret browsing indefinitely by going to Settings and more > Settings > Accessibility and turn on Navigate pages with a text cursor. With caret browsing on, you can move the caret within a web page using the Up, Down, Left, and Right directional arrow keys and Home, Page Up, and Page Down buttons on your keyboard.. To select text, images, or other elements on the page, hold down Shift ...

For the website(s) you would like to allow scripting, enter the address within the Add this website to the zone text box and click Add. Note: If the address does not begin with "https:", you many need to uncheck "Require server verification (https:) for all sites in this zone".

This is a subscriber-only, Microsoft 365 feature. Find your version. Design ideas for one photo Applies to: PowerPoint for Microsoft 365 Current Channel: Version 1511 or later Semi-Annual Enterprise Channel: Version 1602 or later Multiple photos, color extraction, and facial recognition

Important Because changing your Microsoft account password is slightly different than resetting a forgotten password, this page does not cover the steps to reset your account password.

Click the Printing Options tab.. The printer driver tells Word which way the envelope should be loaded into the printer, and this information is displayed in the Printing Options tab of the Envelope Options dialog box.. 1. The feed method determines the position of the envelope (right, middle, left) and whether the long or short edge is being fed into the printer.

Solucionar problemas con accesorios Bluetooth. Si puedes activar Bluetooth pero tienes problemas para emparejar o usar un accesorio Bluetooth, prueba los siguientes pasos para solucionar problemas comunes de accesorios Bluetooth.

IMAP and POP are two methods to access email. IMAP is the recommended method when you need to check your emails from several different devices, such as a phone, laptop, and tablet.