How To Use Goal Seek In Excel For Multiple Cells. Here's how to use goal seek, step by step: Sometimes you need to start with a different input value to find a solution.

E.g., i want to set cells (j339:j379) to value=2 by changing cells (j44:j84). How to use goal seek in excel for multiple cells.in the goal seek dialog box, define the cells/values to test and click ok: Pros of excel vba goal seek.