Inserting rows in multiple sheets

[Guest]

Hey guys,
Im trying to find out if Excel has a feature were if I have say 5 sheets in
one workbook file and I inserted a row in one of the sheets that in the other
4 sheets a row would automatically be inserted in the same place?

 

[kkknie]

If you select all 5 worksheet tabs and insert a row in one, it wil
insert it into all of them. Be careful to unselece them again befor
continuing, since it will do the same thing if you enter data into on
(enters into all).

 

[Reg Besseling]

Try this

Hold down shift then click on the first sheet tab then click on the last
sheet tab

anything you now do on any of the sheets between the first and last will be
done to all selected sheets

HTH

Reg

 

[Don Guillett]

right click the sheet tab>select all sheets>insert row>select one
worksheet.>done

 

[Reg Besseling]

Try this

Hold down shift then click on the first sheet tab then click on the last
sheet tab

anything you now do on any of the sheets between the first and last will be
done to all selected sheets

HTH

Reg