Insert multiple rows on a spreadsheet
已回答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.
-
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:
- Select the amount of rows or columns that you want to add
- Right click
- Insert
- 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
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请先登录再写评论。
评论
2 条评论