Simultaneouly insert of rows or col. - Ajit

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want excel to automatically insert row below or column
beside in Sheet2 when I insert row or column in Sheet1.
e.g. If I insert row below a1 in Sheet1 excel should automatically
insert a row below a1 in Sheet2.How can I do this?
Ajit
 
Hi Ajit

If you want to insert only rows and columns, then a simpler solution, is
before inserting the rows and columns, select the sheets where you want
automatic inserting of rows and columns and then continue with inserting.
Once the inserting of rows and columns is complete then deselect the sheet
you don't want to work on.

Regards
Raj
 
Back
Top