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?
Re: How do you insert rows into multiple sheets in a workbook?
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.
Re: How do you insert rows into multiple sheets in a workbook?
"Marketing Queen" <Marketing Queen@discussions.microsoft.com> wrote in
message news:15269E91-C23E-4441-94C5-63FC0D21F5F3@microsoft.com...
>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
How do you insert rows into multiple sheets in a Google Drive workbook?
I have the same problem as above but I need to do it in an Excel file in Google Drive.
I have an excel workbook in Google Drive that has 40 sheets. All 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?
Bookmarks