G Gord Dibben Oct 22, 2004 #2 Right-click on first sheet and "select all sheets". Insert your row(s) on first sheet and will be inserted in all sheets. DO NOT FORGET to right-click and "ungroup sheets" when complete. Gord Dibben Excel MVP
Right-click on first sheet and "select all sheets". Insert your row(s) on first sheet and will be inserted in all sheets. DO NOT FORGET to right-click and "ungroup sheets" when complete. Gord Dibben Excel MVP