Create conditional formulas - Microsoft Support
To switch between viewing the results and viewing the formulas that return the results, press CTRL+` (grave accent), or on the Formulas tab, in the Formula Auditing group, click the Show Formulas button.. After you copy the example to a blank worksheet, you can adapt it to suit your needs.
Applies To: Excel for Microsoft 365, Excel 2024, Excel 2021, Excel 2019, Excel 2016
Remove or turn off hyperlinks - Microsoft Support
You can remove a hyperlink from a single address, remove many links at once, turn automatic hyperlinks off, and turn off the requirement to press Ctrl to follow a hyperlink.
Applies To: Excel for Microsoft 365, Word for Microsoft 365, Outlook for Microsoft 365, PowerPoint for Microsoft 365, Excel 2024, Word 2024, Outlook 2024, PowerPoint 2024, Excel 2021, Word 2021, Outlook 2021, PowerPoint 2021, Excel 2019, Word 2019, Outlook 2019, PowerPoint 2019, Excel 2016, Word 2016, Outlook 2016, PowerPoint 2016
Filter by using advanced criteria - Microsoft Support
Click a cell in the list range. Using the example, click any cell in the range A6:C10. On the Data tab, in the Sort & Filter group, click Advanced.. Do one of the following: To filter the list range by hiding rows that don't match your criteria, click Filter the list, in-place.. To filter the list range by copying rows that match your criteria to another area of the worksheet, click Copy to ...
Applies To: Excel 2024, Excel 2021, Excel 2019, Excel 2016
Get help with Microsoft Photos app - Microsoft Support
Edit photos and videos. Whether you like to apply changes that affect your photo's quality, feel, and look—or you want to add information on top of your photos, the Photos app offers you comprehensive features to transform your photos and videos looking their best.
See who a file is shared with in OneDrive or SharePoint
There are also different levels of permission: Can view allows the recipient to only view the file or folder; they cannot make changes to it. This can be further restricted by selecting the Can't download option, which means they cannot save a local copy.. Can edit allows the recipient to view and make changes to the file or folder.. Can't download allows the recipient to only view the file or ...
Applies To: SharePoint in Microsoft 365, Office for business, OneDrive (work or school), OneDrive for Mac, OneDrive for Windows
Customize the Windows Start Menu - Microsoft Support
There are different ways to pin apps or shortcuts to the Start menu. For example: In the Search box on the taskbar or on the Start menu, type the name of the app you want to pin. Right-click on the app, then select Pin to Start . From Explorer, right-click on a folder and select Pin to Start For websites, open Edge and navigate to the website you want to pin.
Explorador de archivos en Windows - Soporte técnico de Microsoft
Acceso rápido. A partir de Windows 11, versión 22H2, las carpetas conocidas de Windows (Escritorio, Documentos, Descargas, Imágenes, Música y Vídeos) están disponibles de forma predeterminada como carpetas ancladas en Acceso rápido, tanto en Explorador de archivos Inicio como en el panel de navegación izquierdo.Estas carpetas predeterminadas ya no se muestran en Este equipo para ...
Microsoft Support
Microsoft Support is here to help you with Microsoft products. Find how-to articles, videos, and training for Microsoft Copilot, Microsoft 365, Windows, Surface, and more.
Organize your ideas with Collections in Microsoft Edge
Start a collection On a computer. Select Collections at the upper-right corner of Microsoft Edge and then Start new collection.. To change the title of the collection, select it at the top of the Collections pane. When you're ready to start adding content to your collection, you can do this in several ways:
Change a theme and make it the default in Word or Excel
Create my own color theme. On the Page Layout tab in Excel or the Design tab in Word, click Colors, and then click Customize Colors.. Click the button next to the theme color you want to change (for example, Accent 1 or Hyperlink), and then pick a color under Theme Colors. To create your own color, click More Colors, and then pick a color on the Standard tab, or enter numbers or select a color ...
Applies To: Excel for Microsoft 365, Word for Microsoft 365, Excel 2024, Excel 2021, Word 2021, Excel 2019, Word 2019, Excel 2016, Word 2016