If you don't see Table Tools or PivotTable Tools on your worksheet, do this: Click any cell in the table or PivotTable. If you've selected an Excel table, you'll see the Table Tools with a Design …

Select the ellipsis (...) at the top right of the screen. This temporarily restores the ribbon. When you return to the document, the ribbon is hidden again. To keep the ribbon displayed, select a …

Expand the ribbon in Excel to find the commands you need. Click any tab to show the Ribbon, or use the Ribbon Display Options at the top of your document.

To get new add-ins, select Get Add-ins. To use add-ins you already have, select My Add-ins. The add-ins you'll see will depend on the kind of Microsoft 365 subscription you have. Get a VBA …

Include this many sheets: By default new workbooks in Excel start with just 1 sheet. If you know that you'd like your workbooks to start with more sheets than that, adjust this setting.

Right-click the Quick Access Toolbar then select Customize Quick Access Toolbar on the shortcut menu. Under Customize Quick Access Toolbar, select the command you want to move.

Learn how to change the settings that enable or disable macros in Excel, and more. Change the macro security settings to control which macros run when you open a workbook.

They're all now in the ribbon, which is a kind of menu that organizes them in a visual way. Let's first look at how the ribbon works, and then how to find where the features you want might be.

The Solver Add-in is a Microsoft Office Excel add-in program that is available when you install Microsoft Office or Excel. To use the Solver Add-in, however, you first need to load it in Excel.

You provide the data and parameters for each analysis, and the tool uses the appropriate statistical or engineering macro functions to calculate and display the results in an output table.