How do I insert a row in multiple tables on different sheets in the same workbook? I have 12 sheets, one for every month, and the sheets are exactly the same. Is there a way to insert a row and value on one sheet and have this apply to all sheets?© BrainMass Inc. brainmass.com December 20, 2018, 5:29 am ad1c9bdddf
To place an additional row, right click on the leftmost side of the worksheet, where the row numbers are displayed. Then click insert to insert an additional row. If you only click on one cell inside the table, you can not add an additional row.
Please see attached file for the detailed solution to the given problem.
To add a row in a table inside a worksheet, do the following steps:
1. Right ...
The expert determines how I insert a row in multiple tables on different sheets in the same workbooks.