Explore BrainMass
Share

Explore BrainMass

    MS Excel

    This content was COPIED 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 April 3, 2020, 8:35 pm 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

    ADVERTISEMENT