How to Change Multiple Tabs in Microsoft Excel

Microsoft Excel offers a feature in which you can modify information on multiple worksheet tabs at the same time. Each worksheet will reflect the same information that is entered into the active sheet. You may change all or just selected sheets. This feature can save a lot of time and can help when setting up the initial spreadsheet. Use this feature to create multiple pages with the same formatting or labels.

Instructions

1. Locate the worksheet tabs that you want to change at the bottom of the workbook. Check on each one to ensure that there is no extraneous data that should not be removed or replaced.

2. Click on the first worksheet tab. Hold the "Ctrl" button and select all the other worksheets that should be changed. The selected worksheet tabs will appear lighter in color than the rest of them. Scroll to the left or right to display all the tabs.

3. Click on the cells that you want to change on the active worksheet. Make the changes to the selected cells. Repeat the process with any additional cells that need to be edited.

4. Click on any unselected worksheet tab to end the editing process. You may have selected to change every worksheet and will need to right-click on a worksheet tab and select to "Ungroup Sheets."

5. View the other worksheets and verify that the changes were made as needed.

References

• Microsoft Office Online: Edit Data on Multiple Worksheets