Work with your files in your file system. Once you're synced, you’ll see your files in File Explorer. On a Mac, your files will appear under OneDrive in the Mac Finder.. If you use more than one account, your personal files appear under OneDrive – Personal and your work or school files appear under OneDrive - CompanyName.. You can copy or move files from your computer to OneDrive right ...

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

Most of the time, Excel will recognize this, and you'll see an alert next to the cell where numbers are being stored as text. If you see the alert:

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

The FILTER function allows you to filter a range of data based on criteria you define.

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 ...

Outlook won't accept my password. If you've forgotten the password for a Microsoft account, user our sign-in helper to get back into your account.. If you know you’re using the correct password for your email account but Outlook won’t accept it, you might have an email account that requires additional security.

Note: When Excel opens a .csv file, it uses the current default data format settings to interpret how to import each column of data.If you want more flexibility in converting columns to different data formats, you can use the Import Text Wizard. For example, the format of a data column in the .csv file may be MDY, but Excel's default data format is YMD, or you want to convert a column of ...

Country/region. Microsoft Store sales support. Technical or download support. Egypt +20 2 353 3333. Technical support. South Africa. 0800 167 344. Technical support

If you try to add an IMAP account to Outlook, for example a Gmail account, Apple account, Yahoo account, or an account from your local ISP, and you're not prompted to enter your password, use the following steps to work around the problem.