• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Inserting rows in multiple sheets

C

ca.nkv

New Member
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
 
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.


.
 
Thanks bobhc. I've tried but its not working. I've tables in all the sheets. May be that's why. Thanks anyway.
 
Upload a sheet with want you want and lets look at it.....But I think it is the tables that are stopping you.


.
 
You must log in or register to reply here.
Back
Top