updating all sheets at once?

[Louis]

I have a spreadsheet w/ several sheets. They are all
identical in setup as far as columns/rows. My problem is
when I need to add a couple of rows i have to do it for
each sheet. Is there a way to only have to edit 1 sheet
but it effects all the sheets. For instance, I want to
add 2 rows on sheets A-Z. Is there a quick and easy way
to do this or am I stuck w/ bringing up 26 sheets and
adding additional rows to each of them?


Thank you


Louis

 

[JE McGimpsey]

Group the sheets:

Select the leftmost sheet, then right-click the tab of the right-most
sheet. Now any changes you make will be done to all sheets.

Be sure to ungroup the sheets after your changes. It's very easy to
trash a workbook by making changes to inadvertently grouped sheets.

 

[Frank Kabel]

Hi Louis
you may use a macro for this. the following will insert two rows at the
top of your sheet

sub insert_many()
dim wks as worksheet
for each wks in activeworkbook.worksheets
wks.range("A1").EntireRow.insert (shift:=xlshiftup)
wks.range("A1").EntireRow.insert (shift:=xlshiftup)
next
end sub

 

[Louis]

-----Original Message-----
Group the sheets:

Select the leftmost sheet, then right-click the tab of the right-most
sheet. Now any changes you make will be done to all sheets.

Be sure to ungroup the sheets after your changes. It's very easy to
trash a workbook by making changes to inadvertently grouped sheets.


.
Thanks....worked great....you did fail to mention that

you need to hold down the Shift key to group the sheets
but I kinda figured that one out. Thanks again.

Louis

 

[Louis]

-----Original Message-----
Group the sheets:

Select the leftmost sheet, then right-click the tab of the right-most
sheet. Now any changes you make will be done to all sheets.

Be sure to ungroup the sheets after your changes. It's very easy to
trash a workbook by making changes to inadvertently grouped sheets.


.
It doesn't seem to work on the Headings. How do I change

all the headings at once?

Louis