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.
SVERWEIS (Funktion) - Microsoft-Support
Argumentname. Beschreibung. Suchkriterium (erforderlich). Der Wert, nach dem Sie suchen möchten. Der gesuchte Wert muss sich in der ersten Spalte des Zellbereichs befinden, den Sie im Matrix-Argument angeben.. Wenn die Matrix z. B. die Zellen B2:D7 umfasst, muss sich das Suchkriterium in Spalte B befinden.. Das Suchkriterium kann ein Wert oder ein Bezug auf eine Zelle sein.
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
Find where your browser is saving downloads - Microsoft Support
To see where your browser is saving downloads, look in your browser's settings. For example, in the new Microsoft Edge , select Settings and more > Settings > Downloads .The file path for your downloaded files (for example, C:\Users\[your name]\Downloads) is listed under Location.. In Microsoft Edge Legacy , select Settings and more > Settings .
Repair a corrupted workbook - Microsoft Support
Use a macro to extract data from a corrupted workbook If a chart is linked to the corrupted workbook, try using a macro to extract the source data of the chart.. Copy the following macro code and paste it in a module sheet: Sub GetChartValues() Dim NumberOfRows As Integer
Applies To: Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016
Add or delete notifications or reminders in Outlook
In Outlook, you have the option to: Snooze or dismiss events or tasks | Turn the notifications on or off | Add reminders to events | Add reminders to tasks | Troubleshoot notifications. Snooze or dismiss an event or task. With the reminders window, you can select to snooze calendar events and tasks, join a Teams meeting, or dismiss events and tasks.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016, Outlook on the web, New Outlook for Windows
How do I reassign hot keys for my keyboard? - Microsoft Support
Note: The options listed in this wizard vary depending on the key selected.For example, since you cannot reassign the Windows key, the only option available is to disable it.
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
Listen to your Word documents - Microsoft Support
Supported languages. Read Aloud uses the proofing language set for the document. To change the language, see the help article Fix text-to-speech reading in wrong language.. Voices. Depending on your platform, text-to-speech (TTS) uses software that comes built into your device or by a Microsoft service.
Use mail merge for bulk email, letters, labels, and envelopes
Data sources. Your first step in setting up a mail merge is to pick the source of data you'll use for the personalized information. Excel spreadsheets and Outlook contact lists are the most common data sources, but if you don't yet have a data source, you can type it up in Word, as part of the mail merge process.
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, Word 2016 for Mac
Create an organization chart in Office by using SmartArt
Create an organization chart using SmartArt graphics. Although you cannot automatically connect two top-level boxes with a line in the organization chart layouts, such as Organization Chart, you can imitate this look by adding a box to the top level to your SmartArt graphic and then drawing a line to connect the boxes.(On the Insert tab, in the Illustrations group, select Shape, select a line ...
Applies To: Excel for Microsoft 365, Word for Microsoft 365, Outlook for Microsoft 365, PowerPoint for Microsoft 365, Excel 2021, Word 2021, Outlook 2021, PowerPoint 2021, Excel 2019, Word 2019, Outlook 2019, PowerPoint 2019, Excel 2016, Word 2016, Outlook 2016, PowerPoint 2016
Stay up to date with widgets - Microsoft Support
Each widget is powered by a different app or service. To see what is powering a widget, select More Options (…) in the upper-right corner of the widget, and look for the “Powered by” message at the bottom of the menu. Each individual widget is an extension of its corresponding app or service and is controlled by the settings for that app or service.