Get from External Data Source. Get from Data Model. Use this option if your workbook contains a Data Model, and you want to create a PivotTable from multiple tables, enhance the PivotTable with custom measures, or are working with very large datasets.. Get from Power BI. Use this option if your organization uses Power BI and you want to discover and connect to endorsed cloud datasets you have ...

Windows Media Player is available for Windows-based devices. Use this table to find the right version of the Player for your system. (If you've got a Mac, you can download Windows Media Components for QuickTime to play Windows Media files.)

Free. A Free badge means an active Microsoft 365 Family or Personal subscription isn't associated with the account you signed in with. Only the free web versions of Word, Excel, and PowerPoint are available to you. To access these apps in your browser, all you need to do is to sign in to Microsoft365.com with your Microsoft account and select the app you need from the app launcher .

After you update a drop-down list, make sure it works the way you want. For example, check to see how to Change the column width and row height to show your updated entries. If the list of entries for your drop-down list is on another worksheet and you want to prevent users from seeing it or making changes, consider hiding and protecting that worksheet.

Note: The TEXT function converts numbers to text, which may make it difficult to reference in later calculations.It’s best to keep your original value in one cell, and then use the TEXT function in another cell. Then, if you need to build other formulas, always reference the original value and not the TEXT function result.

Select the cell you want to combine first. Use commas to separate the cells you are combining and use quotation marks to add spaces, commas, or other text.

Learn how to open and run DxDiag.exe on Windows to collect device information and troubleshoot DirectX sound and video issues.

Note: The scan creates a backup file during the repair process.To change the default name or location of this backup file, in the Enter name of backup file box, enter a new name, or choose Browse to select the file you want to use. You may need to run the tool several times in order to repair your Outlook Data File.

Download our Formulas tutorial workbook. We've put together a Get started with Formulas workbook that you can download. If you’re new to Excel, or even if you have some experience with it, you can walk through Excel’s most common formulas in this tour.

On a Mac? See Check for Office for Mac updates automatically.. Click here for the Latest updates for versions of Office that use Windows Installer (MSI).. Choose your version of Office. If you're not sure what version of Office you have, see What version of Office am I using?. Not sure which type of install you have?