Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

How to Insert a blank row to separate data rows in the entire excel sheet?

user-image
Question added by Rajesh K , ISP Manager , CENPAC NET INC
Date Posted: 2013/12/26
Trainer Dalia Abd El-Latif
by Trainer Dalia Abd El-Latif , موظفة شئون إدارية , إدارة سوهاج الاجتماعية جمعية تنمية المجتمع ببرخيل - البلينا المشهرة برقم 155لسنة 1670

(Home-cells   ------  insert    ------     (insert sheet rows

Joby Raj
by Joby Raj , Manager - Projects and Testing , QBurst

you can see the row numbers in the left hand side of the XL. if you need to insert a row between row #10 and11, then select  the entire row11 (you have to click on the row number on the left ) and right click your mouse button and click insert.

This will add a blank row. Let me know if this helps!

More Questions Like This

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.