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.

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.

Function. Description. ARRAYTOTEXT function. Returns an array of text values from any specified range. ASC function. Changes full-width (double-byte) English letters or katakana within a character string to half-width (single-byte) characters

Going passwordless refers to removing your password and using a passwordless method to sign in instead. Passwordless solutions such as Windows Hello, the Microsoft Authenticator app, SMS or Email codes, and physical security keys provide a more secure and convenient sign-in method. While passwords can be guessed, stolen, or phished, only you can provide fingerprint authentication, or provide ...

Reinstall OneDrive for Windows. The OneDrive app comes with some versions of Windows 10 and 11. Select the Start button, type Programs in the search box, and then select Add or remove programs.

When Outlook switches between working online and offline in classic Outlook, all email accounts are changed. You know you’re working offline when Work Offline is highlighted on the ribbon or Working Offline appears on the status bar at the bottom of the classic Outlook window.. When you’re ready to work online again, click Send / Receive > Work Offline.

Use AutoFilter or built-in comparison operators like "greater than" and “top 10” in Excel to show the data you want and hide the rest. Once you filter data in a range of cells or table, you can either reapply a filter to get up-to-date results, or clear a filter to redisplay all of the data.

This topic gives you step-by-step instructions and best practices for making your Excel spreadsheets accessible and unlock your content to everyone, including people with disabilities.

Tip: If you want to keep a banded table style without the table functionality, you can convert the table to a data range.Color banding won't automatically continue as you add more rows or columns but you can copy alternate color formats to new rows by using Format Painter.

You'll see the list of files you saved to OneDrive or OneDrive for work or school. The type files you see are specific to the app you opened them in.