This article explains how to use Microsoft Excel's Solver tool, which allows you to alter variables in a spreadsheet to achieve the desired solution. You can use it in the Windows and Mac versions of the program, but you need to enable it first.
Steps
Part 1 of 2: Enable the Solver
![Use Solver in Microsoft Excel Step 1 Use Solver in Microsoft Excel Step 1](https://i.sundulerparents.com/images/007/image-18362-1-j.webp)
Step 1. Open Excel
Click once or twice on the app icon, which looks like a green square with a white "X" inside.
Solver is pre-installed in the Windows and Mac versions of Excel, but you must manually enable it
![Use Solver in Microsoft Excel Step 2 Use Solver in Microsoft Excel Step 2](https://i.sundulerparents.com/images/007/image-18362-2-j.webp)
Step 2. Click on Blank Workbook
This will open the Excel window and you can proceed with activation.
![Use Solver in Microsoft Excel Step 3 Use Solver in Microsoft Excel Step 3](https://i.sundulerparents.com/images/007/image-18362-3-j.webp)
Step 3. Click on File
It is a tab in the upper left part of the Excel window.
On Mac, click instead Tools, then skip the next step.
![Use Solver in Microsoft Excel Step 4 Use Solver in Microsoft Excel Step 4](https://i.sundulerparents.com/images/007/image-18362-4-j.webp)
Step 4. Click Options
This item is one of the last in the menu File. Press it and the Options window will open.
![Use Solver in Microsoft Excel Step 5 Use Solver in Microsoft Excel Step 5](https://i.sundulerparents.com/images/007/image-18362-5-j.webp)
Step 5. Click Add-ons
It is a tab at the bottom left of the Options window.
On Mac, click on Excel add-ins in the menu Tools.
![Use Solver in Microsoft Excel Step 6 Use Solver in Microsoft Excel Step 6](https://i.sundulerparents.com/images/007/image-18362-6-j.webp)
Step 6. Open the "Available Add-ons" window
Make sure "Excel Add-ins" is in the "Manage" text field, then click Go At the bottom of the page.
On Mac, you can open this window by clicking on Excel add-ins in the menu Tools.
![Use Solver in Microsoft Excel Step 7 Use Solver in Microsoft Excel Step 7](https://i.sundulerparents.com/images/007/image-18362-7-j.webp)
Step 7. Install the Solver component
Check the "Solver" box in the center of the page, then click OK. The Solver should appear as a tool on the tab Data at the top of Excel.
Part 2 of 2: Using the Solver
![Use Solver in Microsoft Excel Step 8 Use Solver in Microsoft Excel Step 8](https://i.sundulerparents.com/images/007/image-18362-8-j.webp)
Step 1. Learn how to use Solver
This tool can analyze your spreadsheet data and any constraints you have added to show you possible solutions. It is very useful if you are doing calculations with multiple variables.
![Use Solver in Microsoft Excel Step 9 Use Solver in Microsoft Excel Step 9](https://i.sundulerparents.com/images/007/image-18362-9-j.webp)
Step 2. Add the data to the spreadsheet
To use the Solver, your sheet must contain data with some variables and a solution.
- For example, you can create a sheet that documents all your expenses over the course of a month, where the result is the remaining money.
- You cannot use Solver on a sheet that does not contain solvable data (for example, it will not work if the data does not contain equations).
![Use Solver in Microsoft Excel Step 10 Use Solver in Microsoft Excel Step 10](https://i.sundulerparents.com/images/007/image-18362-10-j.webp)
Step 3. Click on the Data tab at the top of the Excel window
The toolbar will open Data.
![Use Solver in Microsoft Excel Step 11 Use Solver in Microsoft Excel Step 11](https://i.sundulerparents.com/images/007/image-18362-11-j.webp)
Step 4. Click on Solver
You will find this entry on the far right of the toolbar Data. Press it and the Solver window will open.
![Use Solver in Microsoft Excel Step 12 Use Solver in Microsoft Excel Step 12](https://i.sundulerparents.com/images/007/image-18362-12-j.webp)
Step 5. Select the target cell
Click on the cell where the Solver solution should appear. You'll see it appear in the "Set Goal" box.
For example, if you are creating a budget where the ultimate goal is your monthly income, click on the final cell "Income"
![Use Solver in Microsoft Excel Step 13 Use Solver in Microsoft Excel Step 13](https://i.sundulerparents.com/images/007/image-18362-13-j.webp)
Step 6. Set a goal
Check the "Value of" box, then enter your target value in the text field next to it.
- For example, if your goal is to save € 200 at the end of the month, type 200 in the text field.
- You can also check the "Max" or "Min" boxes to instruct the Solver to determine the absolute maximum or minimum value.
- Once a goal has been decided, the Solver will try to achieve it by modifying the variables in the spreadsheet.
![Use Solver in Microsoft Excel Step 14 Use Solver in Microsoft Excel Step 14](https://i.sundulerparents.com/images/007/image-18362-14-j.webp)
Step 7. Add constraints
Constraints impose restrictions on the values that the Solver can use, so that one or more values on the sheet are not accidentally canceled. You can add a constraint as follows:
- Click on add;
- Click on the cell (or select the cells) for which the constraint is to be applied;
- Select a type of constraint from the drop-down menu in the center;
- Enter the value of the constraint (for example a maximum or a minimum);
- Click on OK.
![Use Solver in Microsoft Excel Step 15 Use Solver in Microsoft Excel Step 15](https://i.sundulerparents.com/images/007/image-18362-15-j.webp)
Step 8. Run the Solver
Once you have added all the constraints, click Solve at the bottom of the Solver window. This way the tool will find the optimal solution to the problem.
![Use Solver in Microsoft Excel Step 16 Use Solver in Microsoft Excel Step 16](https://i.sundulerparents.com/images/007/image-18362-16-j.webp)
Step 9. Check the results
When the Solver warns you that it has found a result, you can analyze the spreadsheet to see which values have been changed.
![Use Solver in Microsoft Excel Step 17 Use Solver in Microsoft Excel Step 17](https://i.sundulerparents.com/images/007/image-18362-17-j.webp)
Step 10. Change the Solver criteria
If the result you have obtained is not ideal, click on Cancel in the window that appears, then modify the objective and constraints.