Explore BrainMass
Share

MS Excel

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

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
https://brainmass.com/computer-science/files/rows-multiple-tables-different-sheets-same-workbook-329846

Solution Preview

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

Solution Summary

The expert determines how I insert a row in multiple tables on different sheets in the same workbooks.

$2.19