How to Use Solver in Excel Click Data > Solver. You'll see the Solver Parameters window below. ... Set your cell objective and tell Excel your goal. ... Choose the variable cells that Excel can change. ... Set constraints on multiple or individual variables. ... Once all of this information is in place, hit Solve to get your answer.