Inserting rows in multiple sheets

R

RogM

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

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).
 
R

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
 
D

Don Guillett

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

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
 
Top