Problem: You have twelve monthly worksheets in a workbook. You’ve made changes to January and now need to copy the changes to the other eleven worksheets.
Strategy: After you’ve successfully made changes to January, follow these steps:
- Select the January worksheet. While holding down the Shift key, select the December worksheet. This will select all twelve worksheets and the January worksheet will be the active sheet.
Note: If your changes are in a middle sheet, such as April, then the process is different. First, click the April worksheet. Next, Shift+Click the December sheet, and then Ctrl+Click the January, February, March sheets.
-
Select the cells that you want to copy. If the cells are not adjacent, select the first range and then Ctrl+ select the remaining ranges.
Advertisement -
From the menu, select Edit – Fill – Fill Across Worksheets, as shown in Fig. 154.
-
From the dialog, as shown in Fig. 155, select if you want to copy values, formats, or both.
Advertisement
Gotcha: After this, right-click any sheet tab and select Ungroup. If you fail to ungroup, any changes you make to the active worksheet will be made to all worksheets.
Additional Details: This command is fairly difficult to use. You have to be able to group sheets and then make the sheet with the changes to copy the active (top) sheet. The above steps are designed to help select all sheets. If you need to copy from March to only June, September, December, then you might do this:
-
Select March to make it the active sheet.
-
Ctrl+ select June to add to the group.
Advertisement -
Ctrl+ select September to add to the group.
-
Ctrl+ select December to add to the group.
Advertisement -
Do the Edit – Fill – Fill Across Worksheets.
Summary: To copy cells from one worksheet to several other worksheets, select the worksheets to copy to, including the worksheet that has the data to copy. With that worksheet as the active sheet, select the data to copy, and then select Edit – Fill – Fill Across Worksheets.
Commands Discussed: Edit – Fill – Fill Across Worksheets
Images
