SUMIF function - Microsoft Support
sum_range Optional.The actual cells to add, if you want to add cells other than those specified in the range argument. If the sum_range argument is omitted, Excel adds the cells that are specified in the range argument (the same cells to which the criteria is applied).. Sum_range should be the same size and shape as range.If it isn't, performance may suffer, and the formula will sum a range of ...
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
Combine text from two or more cells into one cell
Select the cell you want to combine first. Use commas to separate the cells you are combining and use quotation marks to add spaces, commas, or other text.
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 Mobile
Recover your Word files and documents - Microsoft Support
Closing recovered files. If you click Close without reviewing all recovered files, you'll see an option to view them again later. The next time you open the application you'll have the option to save or remove those autorecover files. Yes, I want to view these files later (safest option)- Select this option if you are not sure whether you need the data in the recovered versions of the files.
Applies To: Word for Microsoft 365, Word for Microsoft 365 for Mac, Word 2021, Word 2021 for Mac, Word 2019, Word 2019 for Mac, Word 2016
Create and add an email signature in Outlook - Microsoft Support
Under Edit signature, compose your signature.You can change fonts, font colors, and sizes, as well as text alignment. If you want to create a more robust signature with bullets, tables, or borders, use Word to create and format your signature text, then copy and paste it into the Edit signature box.You can also use a pre-designed template to create your signature.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016, Office for business, Office 365 Small Business, Microsoft 365 admin, Outlook on the web, Outlook.com, New Outlook for Windows, Outlook on the web for Exchange Server 2016, Outlook on the web for Exchange Server 2019
Change your background in Microsoft Teams meetings
If you want to change what appears behind you in your video meeting or call, you can either blur your background, replace it entirely with any image you want, or use Teams virtual background template.And with a Teams Premium license, you can change your Teams meeting background to a branded logo or image specific to your company.
Applies To: Microsoft Teams
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
Change your default search engine in Microsoft Edge
Keeping Bing as your default search engine provides an enhanced search experience in the new Microsoft Edge , including direct links to Windows apps, relevant suggestions from your organization if you’re signed in with a work or school account, and instant answers to questions about Windows.However, you can change the default search engine to any site that uses OpenSearch technology.
How to sign in to Hotmail - Microsoft Support
Tips: While signing in, select Yes at the "Stay signed in?" prompt if you want to go straight to your mailbox next time (not recommended for shared computers). Alternatively, check the "Don't show this again" box and select No to be prompted for your password each time.. If you can't sign in, or have forgotten your username or password, use our sign-in troubleshooter.
Applies To: Outlook.com
Save an Outlook message as a .eml file, a PDF file, or as a draft
Better together tip: Manage drafts from Outlook for iOS and Outlook for Android. If you use Outlook for iOS or Outlook for Android, your drafts will automatically synchronize to your mobile device.From there, you can finish messages you've started at your computer, easily add attachments from your photos or camera, or use Office Lens to capture notes from a whiteboard in a meeting.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016, Outlook on the web, Outlook.com, New Outlook for Windows
Aan- of afmelden bij Outlook.com - Microsoft Ondersteuning
Als je ondersteuning wilt krijgen in Outlook.com, klik je hier of selecteer je Help op de menubalk en voer je je query in. Als de zelfhulp uw probleem niet oplost, schuift u omlaag naar Hebt u nog steeds hulp nodig? en selecteer Ja.. Als je contact met ons wilt opnemen in Outlook.com, moet je je aanmelden. Als u zich niet kunt aanmelden, klikt u hier.
Applies To: Outlook.com