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.

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.

Tip: If you installed the Microsoft 365 apps as part of a suite, such as Office Home and Student or Microsoft 365, search for the suite name.For stand-alone apps search by the app name, such as Project or Visio. In most cases you can't uninstall an individual app if it's included in your Microsoft 365 suite.

Press the Start button , and then enter store into the search bar.; Choose Microsoft Store from the results to open the app.; Select your account in the top-right corner of the screen, and then select Redeem code or gift cards.; Enter the 25-character code, select Next, and then follow the prompts.

Windows 11 in S mode is designed for security and performance, exclusively running apps from the Microsoft Store. If you want to install an app that isn't available in the Microsoft Store, you'll need to switch out of S mode.

Learn how to run a disk cleanup in Windows including deleting temporary and system files to free up disk space.

Los dispositivos Windows pueden obtener nuevas funciones en diferentes momentos, ya que Microsoft ofrece actualizaciones no relacionadas con la seguridad, correcciones, mejoras y mejoras a través de varias tecnologías de mantenimiento, incluida la implementación controlada de funciones (CFR). Windows te avisará si necesitas reiniciar el dispositivo para completar una actualización y ...

Whether you're at home, work, or out and about, chances are you'll find a Wi-Fi network that you can connect to for internet access. Select the Network, Sound, or Battery icons ( ) on the far right side of the taskbar to open quick settings. The Disconnected icon appears when you’re not connected.

Select Settings, and under the About section, select About Photos. Photos: Says Updated in the About section of Settings—you are running the new version of the Photos app.This version includes features like iCloud integration in left navigation bar. This version of Microsoft Photos app offers a convenient and user-friendly way to view, import, organize, edit, and share photos and videos on ...