How do I insert rows in more than one worksheet at a time?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ohio accountant - 13 Oct 2006 21:50 GMT

I have a "master" spreadsheet which consolidates information from multiple
sheets in the workbook. I need to insert a line in all the sheets, including
the master, and have all the other rows retain their formulas in all the
sheets. How can I do that?

Reply to this Message

lk - 13 Oct 2006 22:14 GMT

If the row is at the same location for all sheets, for example row 20, select
all the worksheets by holding down the Ctrl key and clicking on the worksheet
tab (there are other ways to select - this is one of them).

Then insert a row. This will insert on all the tabs selected. Be careful -
anything you do will be done on all the sheets! To unselect, right click on
a tab and select Ungroup.

> I have a "master" spreadsheet which consolidates information from multiple
> sheets in the workbook. I need to insert a line in all the sheets, including
> the master, and have all the other rows retain their formulas in all the
> sheets. How can I do that?

Reply to this Message