edit multiple worksheets together in Excel

Q119. In Excel, how can I edit data in multiple WorkSheets together?

For example, I have set up identical Sales Tracking WorkSheets for each of my SalesPerson. Since a new product "Laptop" has been introduced, I would like to update each of the Tracking Sheet with a row for the new product.

Is there a simpler way of adding the new row as opposed to adding row individually in each of the SalesPerson's Tracking Sheet?

excel edit multiple worksheets together

To do it in Excel, here is the answer:

a) Select all the Sheets that are to be updated together by pressing on "Ctrl" and clicking each Sheet name as shown below.

excel excel edit multiple worksheets together

b) When multiple Sheets are selected together, the File name in Title Bar has a suffix [Group] as shown below. Update one Sheet as needed (add and format a row for the new product "Laptop" in "Barbara" Sheet).

excel excel excel edit multiple worksheets together

c) Once update is complete click on any one Sheet Name to stop [Group] selection. The other Sheets are also updated with the new row of data entered in "Barbara" Sheet as shown below.

excel excel excel excel edit multiple worksheets together

excel excel excel excel excel edit multiple worksheets together

 

You can find similar Excel Questions and Answer hereunder

1) How can I copy and rename a WorkSheet using VBA?

2) Split one long column into multiple smaller columns in Excel

3) How can I get row count of filtered data?

4) How can I sort data using multiple criteria?

5) how do you enter multiple line in a cell in Excel

6) How can I find time interval between 2 times?

7) Is there a way to get a log value of a number using Excel?

8) How can i filter multiple columns simultaneously in Excel

9) How can I hide a specific Shape in my WorkSheet?

10) Vlookup to return multiple values in same cell in Excel

11) How can I loop through all WorkSheets and get their names using VBA?

12) Vlookup to return max value from multiple hits in Excel

13) How can I enter multiple lines of data in a cell?

14) How do I restrict user entry in ActiveX Text Box to just numeric values?

15) Is there a way to easily shade alternate rows in a data range for improving readability?