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

M

Marketing Queen

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?
 
P

Pete_UK

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
 
D

David Biddulph

Marketing Queen said:
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?
Click to expand...

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