SUMIFS function - Microsoft Support
Argument name. Description. Sum_range (required). The range of cells to sum. Criteria_range1 (required). The range that is tested using Criteria1.. Criteria_range1 and Criteria1 set up a search pair whereby a range is searched for specific criteria. Once items in the range are found, their corresponding values in Sum_range are added.. Criteria1 (required)
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 Web App
Change the column width or row height in Excel
Note: The boundary is the line between cells, columns, and rows.If a column is too narrow to display the data, you will see ### in the cell.
Applies To:
Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016
Remove a page break - Microsoft Support
Remove a manual page break. Go to Home and select Show/Hide .. This displays page breaks while you’re working on your document.
Applies To:
Word for Microsoft 365, Word for Microsoft 365 for Mac, Word for the web, Word 2021, Word 2021 for Mac, Word 2019, Word 2019 for Mac, Word 2016
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
Dark Mode in Outlook - Microsoft Support
Why does my reading pane have a dark background? When dark mode is turned on, the reading pane has a dark background to reduce eye strain. You can make the reading pane brighter by selecting at the top of the reading pane. If you don't see the button, select .
Applies To:
Outlook for Microsoft 365, Outlook on the web, Outlook.com
Solucionar problemas de Bluetooth en Windows
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.
What's new in Word 2021 for Windows - Microsoft Support
Word 2021 for Windows enables you to create compelling content and includes co-authoring, new stock media from the Office Premium Creative Content collection, and new Draw tab additions such as Point Eraser, Ruler, and Lasso.
Applies To:
Word 2021
Switch to the new Microsoft Teams - Microsoft Support
When in the new Teams, turn on (or off) notifications by selecting Settings and more at the top of the new Teams, then selecting Settings > Notifications > Open Windows notifications settings.Find Microsoft Teams (work preview) in the apps list and set your preference.
Applies To:
Microsoft Teams
Windows Media Player 12 - Microsoft Support
Designed by media lovers for media lovers. Windows Media Player 12—available as part of Windows 7, Windows 8.1, and Windows 10*—plays more music and video than ever, including Flip Video and unprotected songs from your iTunes library!
Install the Language Accessory Packs for Office 2016
Install language accessory packs after installing Microsoft Office, to add additional display, help, or proofing tools. Install the language accessory pack for your desired language.