How to Solve Linear Programming in Spreadsheet. ... Click the "Solve" button. Excel computes the optimal values for your objective formula's variables (e.g., 19 widgets and 1 gadget).