Edit Multiple Excel Worksheets at One Time

| January 3, 2013 | 0 Comments

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.

Screenshot from Excel

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.

Screenshot of Excel tabs

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.

Screenshot of Excel tabs

Now all three worksheets have been selected

Filed Under: Excel, Windows

Comments are closed.