To turn AutoSave on, save your file to your OneDrive or SharePoint folder from within your Microsoft 365 app. Go to File then Save As. Select your OneDrive personal, work or school account. Choose your sub-folder from the list that appears. Enter a file name and select Save. Tips:

About Microsoft Authenticator. Microsoft Authenticator is a free app that helps you sign in to all your accounts without using a password - just use a fingerprint, face recognition, or a PIN. You can use Authenticator to sign in to your Microsoft personal, work, school or other accounts. Authenticator can be used three ways:

Windows 10. On a PC running Windows 10, select Start > File Explorer, or select File Explorer from the taskbar. Press and hold (or right-click) the MP4 file you want to play, select Open with , and then choose your preferred file player from the list of applications. Play MP4 files in Windows 10 by right-clicking the file and choosing what ...

Consolidate multiple worksheets into one PivotTable. Consolidating data is a useful way to combine data from different sources into one report. For example, if you have a PivotTable of expense figures for each of your regional offices, you can use a data consolidation to roll up these figures into a corporate expense report. This report can ...

Zip and unzip files. Zipped (compressed) files take up less storage space and can be transferred to other computers more quickly than uncompressed files. In Windows, you work with zipped files and folders in the same way that you work with uncompressed files and folders. Combine several files into a single zipped folder to more easily share a ...

If you're working in Page Layout view ( View > Workbook Views > Page Layout ), you can specify a column width or row height in inches, centimeters and millimeters. The measurement unit is in inches by default. Go to File > Options > Advanced > Display > select an option from the Ruler Units list. If you switch to Normal view, then column widths ...

Turn your data into insights. List of all Excel functions available. VLOOKUP function. IF function. Create a drop-down list. Combine text from two or more cells. Freeze panes to lock rows & columns. Create a PivotTable to analyze worksheet data. Design the layout and format of a PivotTable.

Add or remove an automation add-in. Add-ins provide optional commands and features for Microsoft Excel. By default, add-ins are not immediately available in Excel, so you must first install and (in some cases) activate these add-ins so that you can use them. Some add-ins are built in to Excel, such as Solver and the Analysis ToolPak. Some other ...

When you're asked for a verification code, open the app and use whatever number is currently displayed. Sign in to an application or service such as Microsoft 365 using your username and password. Microsoft prompts you for a verification code. Open the Microsoft Authenticator app on your phone and enter the code in the box where you are signing in.

Cortana voice assistance in Windows as a standalone app was retired in the spring of 2023. Additionally, Cortana in Teams mobile, Microsoft Teams display, Microsoft Teams Rooms, Outlook mobile, and Microsoft 365 mobile was retired in the fall of 2023. In June of 2024, we will be retiring the voice search and the Play My Emails feature in ...