Change formula across many sheets at the same time

Please purchase the course before starting the lesson.

If (and only if) you have used the concepts of best practice, you can access a tool which allows you to make mass changes to your spreadsheet, both with text and formulas.

In the example below we see two different sheets that are structurally the same (note that Product X and Y are in the same rows, the 31 Dec 2003’s are in the same column, the client name is in cell A1 on both sheets).

Change all sheets at once

If we want to make changes to both at the same time, all you need to do is….

To see the full course contents click here.

Back to: Advanced Excel Course > Formula Tips and Tricks