Classic file types are no longer available for use as of January 2021. You can transition your classic files or download a PDF. Learn More

Insert multiple rows on a spreadsheet

Answered
Request Demo
  • Edited

It would be very helpful to have the ability to insert multiple rows in a spreadsheet once we already have information on the spreadsheet. I'm currently working on a project where I need to add a full section of information into the middle of a current document, although most of the work is copying and pasting information, I'm spending way too much time on the inserting of rows. I had to insert 42 rows, which I could only do one by one, doesn't seem like a productive use of our time.

1

Comments

2 comments

Date Votes
  • Isabel Messore

    Welcome to the Community Luisa Jiron de Martinez!

    I have some good news for you - this functionality is currently possible. You'll need to do the following:

    1. Select the amount of rows or columns that you want to add
    2. Right click
    3. Insert
    4. X Rows/Columns

     

    If you would like to add multiple rows at once in different locations. You'll follow the same process except, when selecting the cells you'll need to hold down the Ctrl. button on your keypad. This allows you to select multiple rows in multiple locations. Then simply right click > insert > before / after selected rows.

     

    0
  • Luisa Jiron de Martinez

    Very late making a follow up comment, but THANK YOU so much for this Isabel Messore. I knew there had to be a way to do it, but not even chat support was able to help me, so I appreciate your input to my inquiry. 

    0

Please sign in to leave a comment.