Excel Made Easy

Edit multiple worksheets together in Excel

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?

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.

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).

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.

You can find similar Excel Questions and Answer hereunder

1) How can I find the least common multiple using Excel?

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

3) How can I sort data using multiple criteria?

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

5) Split string into multiple columns in Excel

6) How can I edit names of all the Shapes in the WorkSheet easily instead of navigating to each Shape and renaming them?

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

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

9) How to rename multiple sheets easily with VBA

10) How can i filter multiple columns simultaneously in Excel