How do you insert rows into multiple sheets in a workbook?

I have an excel workbook that is 145 sheets large. Most of the sheets have
cells with reference points to the first sheet. I need to add a row to EACH
sheet in the same location. Is it possible to add a row to each sheet with
one basic command or do I have to do it on EACH individual sheet?

You can group all your sheets together, so that whatever you do to one
sheet is done to them all - you must remember to ungroup them at the
end.

Assuming all your sheets are contiguous, then click on the first sheet,
hold down SHIFT and click on the last sheet. (If they are not
contiguous you will have to hold down CTRL instead of SHIFT and click
on each one). Then you can highlight the row in the visible sheet and
Insert | Row - this will be inserted at that position in every sheet
which is part of the group.

To ungroup the sheets right-click on one of the sheet tabs.

Hope this helps.

Pete

"Marketing Queen" <Marketing [email protected]> wrote in
message news:[email protected]...
>I have an excel workbook that is 145 sheets large. Most of the sheets have
> cells with reference points to the first sheet. I need to add a row to
> EACH
> sheet in the same location. Is it possible to add a row to each sheet
> with
> one basic command or do I have to do it on EACH individual sheet?

Select all the tabs, then if you do an insert on one it will apply to the
others.
--
David Biddulph