INDIRECT function - Microsoft Support
Example. Copy the example data in the following table, and paste it in cell A1 of a new Excel worksheet. For formulas to show results, select them, press F2, and then press Enter.
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
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
Beheben von Sound- oder Audioproblemen in Windows
Hardwareprobleme können durch veraltete oder fehlerhafte Treiber verursacht werden. Stellen Sie sicher, dass der Audiotreiber auf dem neuesten Stand ist, und aktualisieren Sie ihn bei Bedarf.
Use the Navigation pane in Word - Microsoft Support
To go to a page or a heading in a Word document without scrolling, use the Navigation pane. To open the Navigation pane, press Ctrl+F, or select the View tab and choose Navigation Pane.. Browse by headings
Applies To:
Word for Microsoft 365, Word 2021, Word 2019, Word 2016
Contact - Microsoft Support
Contact Microsoft Support. What's new. Surface Pro; Surface Laptop; Surface Laptop Studio 2
Create, change, or delete a view of a list or library
Note: Once a view is created, you cannot change the view type (for example, you cannot switch from Standard View to Datasheet View, or Gantt view to Calendar view, or vice-versa).You will have to create a new view with the view type you want. If you are just looking to edit columns and rows in lists or libraries quickly, however, you can temporarily change Standard View to Datasheet View by ...
Applies To:
SharePoint Server Subscription Edition, SharePoint Server 2019, SharePoint Server 2016, SharePoint in Microsoft 365, SharePoint Server 2010, Microsoft Lists
Work together on PowerPoint presentations - Microsoft Support
Share your file with others. To invite other people to access your PowerPoint file and collaborate, take these steps: With the presentation open, select the Share button in the top right corner of the ribbon. If you have not yet stored your presentation to OneDrive or SharePoint in Microsoft 365, a message will direct you to do so.
Applies To:
PowerPoint for Microsoft 365, PowerPoint for Microsoft 365 for Mac, PowerPoint 2021, PowerPoint 2021 for Mac, PowerPoint 2019, PowerPoint 2019 for Mac, PowerPoint 2016, PowerPoint for iPad, PowerPoint for iPhone, PowerPoint for Android tablets, PowerPoint for Android phones, PowerPoint Mobile
Windows Update Troubleshooter - Microsoft Support
Learn how to run Windows Update Troubleshooter to resolve errors downloading or installing Windows updates.
Create a workbook in Excel - Microsoft Support
Excel makes it easy to crunch numbers. With Excel, you can streamline data entry with AutoFill. Then, get chart recommendations based on your data, and create them with one click.
Applies To:
Excel for Microsoft 365, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2016
OneDrive release notes - Microsoft Support
Updated Files On-Demand settings on Windows.We are updating the OneDrive sync app advanced settings for Files On-Demand for users who have the feature enabled.
Applies To:
OneDrive for Business, SharePoint Server Subscription Edition, SharePoint Server 2019, SharePoint in Microsoft 365, Microsoft 365 admin, OneDrive (work or school), OneDrive (work or school) operated by 21Vianet, OneDrive for Mac, OneDrive for Windows, SharePoint admin center, SharePoint in Microsoft 365 Small Business, SharePoint operated by 21Vianet