Edit Multiple Excel Worksheets at One Time

Let’s say you have a workbook with three worksheets with only minor differences and you would like to change the Header info and other template info at the same time.

Changing three worksheets from Fall to Spring at once

In Excel you can use the Ctrl or Shift keys to select multiple worksheet tabs and make changes to multiple worksheets at one time.

Currently only one of these three worksheets has been selected.

After selecting all three tabs any changes made to one workbook will apply to all three workbooks.

Now all three worksheets have been selected