updating all sheets at once?

  • Thread starter Thread starter Louis
  • Start date Start date
L

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
 
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.
 
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
 
-----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
Click to expand...
you need to hold down the Shift key to group the sheets
but I kinda figured that one out. Thanks again.

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
Click to expand...
all the headings at once?

Louis
 
Back
Top