FILTER function - Microsoft Support
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 ("").
Applies To:
Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel for iPad, Excel for iPhone, Excel for Android tablets, Excel for Android phones
Instalar Windows 7 Service Pack 1 (SP1) - Soporte técnico de Microsoft
La forma recomendada (y más sencilla) de obtener SP1 es activar la actualización automática en Windows Update en Panel de control y esperar a que Windows 7 te avise de que SP1 está listo para instalarse.
Join a meeting without an account in Microsoft Teams
Learn how to join a Microsoft Teams meeting if you don't have an account. Join a Teams meeting as a guest in the Windows app or on the web.
Applies To:
Microsoft Teams
Activa Bluetooth activa o desactiva en Windows
Esta es la manera de activar o desactivar Bluetooth en Windows 11: Sigue uno de estos procedimientos: En la barra de tareas, seleccione el icono Red. Seleccione la Bluetooth configuración rápida para activarla o desactivarla.
Contact us | Xbox Support
Need help with an Xbox console, an Xbox game, or Xbox network? Find out how to get in touch with us.
View hidden files and folders in Windows - Microsoft Support
Select the View tab and, in Advanced settings, select Show hidden files, folders, and drives and OK.
Keyboard shortcuts in Excel - Microsoft Support
To do this. Press. Move to the Tell me or Search field on the ribbon and type a search term for assistance or Help content.. Alt+Q, then enter the search term. Open the File menu.. Alt+F. Open the Home tab and format text and numbers and use the Find tool.. Alt+H. Open the Insert tab and insert PivotTables, charts, add-ins, Sparklines, pictures, shapes, headers, or text boxes.
Applies To:
Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016, Excel for iPad, Excel for iPhone, Excel for Android tablets, Excel for Android phones, Excel Mobile
Fix network connection issues in Windows - Microsoft Support
Try these things to troubleshoot network connection issues in Windows 11. Make sure Wi-Fi is on. Select Start > Settings > Network & internet, then turn on Wi-Fi.Next, select More options (>) next to Wi-Fi, then select Show available networks.If a network you expect to see appears in the list, select it, then select Connect. Open Wi-Fi settings
How to use two-step verification with your Microsoft account
Important: If you turn on two-step verification, you will always need two forms of identification.This means that if you forget your password, you need two contact methods. Or if you lose your contact method, your password alone won't get you back into your account—and it can take you 30 days to regain access.
Restart (reboot) your PC - Microsoft Support
Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.