Tom’s Tutorials For Excel: Filling Across Worksheets

Tom’s Tutorials For Excel: Filling Across Worksheets

I previously posted this example for making changes on all sheets at once.

Here’s a quick and easy solution when the changes you want to put on all worksheets have already been made to one worksheet. If your workbook only holds one or two other worksheets, you could copy and paste, but if your workbook holds dozens of worksheets, you’ll want a better way.



Right-click any worksheet tab, and click Select All Sheets from the popup menu.



Select the cell(s) that have been changed on the one worksheet.
In this example, that would be A1:D1.

Then…

…If you are using Excel version 2003:
• Click the Edit button on the menu bar.
• Click the Fill flyout menu item.
• Select the Across Worksheets item.
• Select the All option in the Fill Across Worksheets dialog box, and click OK.

…Or if you are using Excel version 2007 or after:
• Get onto the Home tab and find the Editing panel on your Ribbon.
• On the Editing panel, click the Fill icon and select the Across Worksheets menu item.
• Select the All option in the Fill Across Worksheets dialog box, and click OK.

Remember to ungroup (deselect) all worksheets!
To do that, simply click onto any worksheet tab that is not the active worksheet.

Share Button
Posted in Tom's Tutorials for Excel
Tags: , , , , , , , , , , , ,
3 comments on “Tom’s Tutorials For Excel: Filling Across Worksheets
  1. fatima says:

    Please provide me a definition of across worksheet

    • Tom Urtis says:

      My core title of “Filling across worksheets” could also be titled as:
      “Make it be such that what you are doing or have done on one worksheet shall be replicated (done the same way) on other worksheets you specify, which could be only some other worksheets, or all other worksheets, in that same workbook.”

Leave a Reply to Tom Urtis Cancel reply

Your email address will not be published. Required fields are marked *

*