How to Use Tab Names as Variables in Excel. When you type data into an Excel workbook, the sheet's name appears in a tab at the bottom of the application window. When you edit the page code, the ...

If you want to use Excel's Goal Seek on multiple cells simultaneously, you'll need a much more powerful tool. Fortunately, one such tool comes with Excel. Let's have a look at the Solver add-in.