Tom’s Tutorials For Excel: Making Changes on All Sheets at Once

Tom’s Tutorials For Excel: Making Changes on All Sheets at Once

Here’s a time-saving tip for newcomers or casual users of Excel. When you need to make the same changes on all your worksheets, you only need to make the changes one time and still have every worksheet show those changes.

All it takes is the act of selecting all the sheets, making your changes once, and deselecting the sheets. Here’s how, with a pictorial example.





Share Button
Posted in Tom's Tutorials for Excel
Tags: , , , , , , , , , , , ,
6 comments on “Tom’s Tutorials For Excel: Making Changes on All Sheets at Once
  1. sebastian_k says:

    Thanks for nice tip!

  2. Tony says:

    Tom, to select all the sheets in a workbook, I always find it easier to hold down the Shift Key and click the tab of the last sheet. I have never seen the ‘Select All Sheets’ on the tab right click, so a very useful tip.

    • Tom Urtis says:

      Thanks, Tony, and yes, I agree. When there are a lot of worksheets and the last tab is out of view, this right-click method is easier by saving the trouble of an extra click and keystroke. Thanks again for visiting my blog.

  3. Vaslo says:

    Really enjoy the quick tips coming up almost daily! One note I’d caution people is to make sure that when they are done with changes to make sure they turn it off. Can’t forget how many times I’ve kept multiple sheets selected and inadvertently typed over good data!

  4. chakravarthy svgk says:

    nice tip

Leave a Reply to Tony Cancel reply

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

*