Enable Solver Add-in

1. Go to Excel Option ==> Add-Ins ==> Manage box ==> Excel Add-ins, then click go
2. In the Add-Ins available box, select Solver Add-in (If Solver Add-in is not listed, click Browser to locate the add-in)
3. Solver command is now in Analysis group on the Data tab