Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.
Format a date the way you want - Microsoft Support
When you enter some text into a cell such as "2/2", Excel assumes that this is a date and formats it according to the default date setting in Control Panel.Excel might format it as "2-Feb".If you change your date setting in Control Panel, the default date format in Excel will change accordingly.
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
Create or edit a hyperlink - Microsoft Support
Optional: To customize the ScreenTip that appears when you rest the pointer over the hyperlink, click ScreenTip in the top-right corner of the Insert Hyperlink dialog box and enter the text you want. You can also create a hyperlink to a blank email message by simply typing the address in the document. For example, type someone@example.com, and Microsoft 365 creates the hyperlink for you ...
Applies To: Word for Microsoft 365, Outlook for Microsoft 365, Project Online Desktop Client, Word 2021, Outlook 2021, Project Professional 2021, Project Standard 2021, Word 2019, Outlook 2019, Project Professional 2019, Project Standard 2019, Word 2016, Outlook 2016, Project Professional 2016, Project Standard 2016, Office 2016, InfoPath 2013, InfoPath Filler 2013
See your Google Calendar in Outlook - Microsoft Support
By importing a snapshot of your Google calendar into Outlook, you can see it alongside other calendars in the Outlook Calendar View. To keep the imported calendar up-to-date, subscribe to the Google Calendar in Outlook.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016, New Outlook for Windows
Create a new folder - Microsoft Support
For Windows 8 or Windows 8.1, swipe in from the right edge of the screen, and tap Search. If you're using a mouse, point to the upper-right corner of the screen, move the mouse pointer down, and click Search.Type File Explorer in the search box, and then tap or click File Explorer.
Create an email message template - Microsoft Support
In the Save As dialog box, in the Save as type list, select Outlook Template.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016
Create, load, or edit a query in Excel (Power Query) - Microsoft Support
Tip Sometimes the Load To command is dimmed or disabled. This can occur the first time you create a query in a workbook. If this occurs, select Close & Load, in the new worksheet, select Data > Queries & Connections > Queries tab, right click the query, and then select Load To.Alternatively, on the Power Query Editor ribbon select Query > Load To. ...
Applies To: Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016
Nachschlagen von Werten mit SVERWEIS, INDEX oder VERGLEICH
Tipp: Versuchen Sie, die neuen Funktionen XLOOKUP und XMATCH zu verwenden, verbesserte Versionen der in diesem Artikel beschriebenen Funktionen. Diese neuen Funktionen funktionieren in beliebige Richtungen und geben standardmäßig genaue Übereinstimmungen zurück, sodass sie einfacher und bequemer zu verwenden sind als ihre Vorgänger.
Applies To: Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016
Block or allow (junk email settings) - Microsoft Support
This article is for Outlook Web App, which is used by organizations that manage email servers running Exchange Server 2013 or 2010. If you're using Microsoft 365, or Exchange Server 2016 or 2019, your email program is Outlook on the web.
Applies To: Outlook on the web for Exchange Server 2016, Outlook on the web for Exchange Server 2019, Outlook Web App
Set up auto-reply (out of office) - Microsoft Support
Notes: To set an automatic reply for contacts outside your company, select Outside My Organization > Auto-reply to people outside my organization, type in a message, and select OK.. The OK button may be missing because of certain screen solution and scaling settings. To resolve this issue, you can adjust the screen resolution and scaling settings, or use a large monitor.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016
Microsoft Teams (free) - Microsoft Support
Connect with friends, family, and coworkers in Teams. Stay organized and connected with friends, family, and coworkers all from one app. Get started
Applies To: Microsoft Teams, Microsoft Teams personal, Microsoft Teams small business