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