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

In Windows 10, you can share your printer with many PCs on your network. To share a printer from the PC that the printer is connected to (the primary PC) with secondary PCs that the printer is not connected to, you must set up sharing settings for the printer, connect the printer to the primary PC (either wirelessly or by using a USB cable), and then turn on the printer.

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.

Enter your Email, phone, or Skype name in the first box if you know it.; In the Contact email address text box, type an email address where we can contact you or send your password reset link. Note that this email address should be different from the one you’re trying to recover. In the third text box, type the characters displayed on the screen.

On the Home tab, in the Number group, click the arrow next to the General box, and then click More Number Formats.

To keep an area of a worksheet visible while you scroll to another area of the worksheet, go to the View tab, where you can Freeze Panes to lock specific rows and columns in place, or you can Split panes to create separate windows of the same worksheet.

To find downloads on your PC: Select File Explorer from the taskbar, or press the Windows logo key + E.

The tool may make one or more changes to the installed version of .NET Framework. For example, it may correct the state of Windows Installer on the computer, reset the discretionary access control lists (DACLs) on certain folders, or resolve issues that are related to an invalid or corrupted update registration.

The Program Install and Uninstall troubleshooter helps you automatically repair issues when you're blocked from installing or removing programs.

How to find and remove duplicates in Excel. Filter for unique values in large or small datasets to clean up your worksheets and workbooks.