Ever had a time when you needed to modify data across multiple worksheets?  It is very easy to do this using the Group Worksheets feature in Excel!

Let us say we have this same mistake on multiple worksheets –  see the Dvv typo in the screenshot below.  We want to change this to Dec

Group Worksheets

The same spelling mistake is also done for the other 2 worksheets (2017 & 2018):

Group Worksheets

Group Worksheets

 

I explain how you can do this and please go to the bottom of the page to see the animated gif tutorial:

DOWNLOAD EXCEL WORKBOOK

STEP 1: Hold the CTRL button and select the worksheets with the left mouse button that need editing.

For our example, we need to select the 2016, 2017, and 2018 worksheets while holding the CTRL button (this will turn each selected sheet to a white color).

Group Worksheets

 

STEP 2: Edit the cell in any one of the worksheets.  Let us change the Dvv to Dec and press ENTER.

This will change all of the worksheet values to reflect the same change.

 

How to Group Worksheets in Excel

How to Group Worksheets in Excel

How to Group Worksheets in Excel

 

STEP 3: To ungroup the worksheets, right click on the worksheet tabs and select Ungroup Sheets (super important to do this when you finish making your changes).

How to Group Worksheets in Excel

 

How to Group Worksheets in Excel

How to Group Worksheets in Excel

Helpful Resource:

728x90

 

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Share on Google+

Google+

Related Posts

How to View Multiple Worksheets in Excel I usually have a workbook that has a lot of worksheets, and I have to view multiple sheets at the same time. Switching tabs back and forth just to compare the contents drives me nuts!! Did you know that you can view multiple worksheets in Excel? Let me show you how! I expla...
Group Dates with a Pivot Table Grouping Dates is very easy with a Pivot Table.  All you have to do is Right Click on your Date values (which are either in the Row or Column Labels of your Pivot Table), then choose the Group option.  From the dialogue box you can choose to Group by Days, Months, Quarters or Yea...
How to Lock Cells in Excel Have you encountered a scenario where you do not want to lock the whole sheet, but just a couple of cells in your Excel worksheet? Locking an entire sheet is straightforward, but locking separate cells is a different story. Let us say, we have this single cell that we want ...
Group Sales with a Pivot Table A Pivot Table allows you to Group your transactional sales values by any range that you want.  You can then summarize each sales group and see the total sales and the number of transactions that they have produced.  This is useful for pricing analysis. DOWNLOAD WORKBOOK ...