Inserting rows in multiple sheets

[ca.nkv]

Hi everyone,

I need to insert multiple rows in all the sheets of an excel file. I've tried using the Grouping sheets option, but that's working only for formatting and not for insertion of rows / columns.

It would be great if you could help me.

Nalinikanth

 

[bobhc]

Good day Nalinikanth
and welcome to the forum if you have not already done so, please read this link posted by Chandoo as it will help you in the use of the forum.

http://chandoo.org/forum/threads/new-users-please-read.294/


Inserting rows into multiple sheets does work....select all sheets (right click tab) then go to first sheet right click on the row above where you want the insertion and click insert/row.


.

 

[ca.nkv]

Thanks bobhc. I've tried but its not working. I've tables in all the sheets. May be that's why. Thanks anyway.

 

[bobhc]

Upload a sheet with want you want and lets look at it.....But I think it is the tables that are stopping you.


.

 

[ca.nkv]

Yes I've removed the table and tried. Now i got it. Thanks a lot