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.
Thanks for nice tip!
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.
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.
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!
In fact, I did express a caution for that, highlighted in bright yellow in the last screen shot.
Thanks for following my Excel blog page!
nice tip