Why no insert multiple rows in spreadsheet

Desktop editors
,
1

Greetings. Am I missing something or is there no ability to insert multiple lines in a spreadsheet? Thanks!

2

Hello

Actually to insert multiple rows, you just select several rows before clicking “insert rows” :
Cinnamon-mars-22-2025_07:41:14.mkv (671.1 KB)

Did I understood your question right ?

In French, the label “insérer une ligne” in the menu is singular and so misleading (I asked the same question here some time ago).
I suggested it to be change to a plural “insérer des lignes”. The best would be the label to depend on how much lines are selected before choosing the option.

1 Like
3

Thank you for your reply! This is somewhat useful but does not handle the logic of inserting X number of rows between two existing rows (of data.)

4

Hello @paulf123

Please elaborate on described functionality. Do you mean inserting N amount of lines in between to rows?

5

Thank you, yes that is exactly it. I’ve also posted similarly hoping for something like CTRL-Y functionality where the function could be repeated.

6

Frankly, I think that the easiest way to insert N amount of rows between existing rows is:

  1. Select a row, above which you want insert empty rows;
  2. Use combination CTRL+Shift++ to insert new rows;
  3. Repeat action above N amount of times.

To repeat this action you can simply hold CTRL and Shift keys and keep pressing + necessary amount of times.

NB: Make sure to select a row first. You can do this by clicking on a row number to the left of the sheet or using Shift+Space to select a row, when a cell from necessary row is selected.

As for the CTRL+Y functionality: I’ve replied to you in respective topic.

7

Perfect thank you!!!

1 Like
8

I am gad to know it helped. Should I mark this topic as solved?

9

I learned something useful today, thanks !

1 Like
10

I am glad to know that the information was useful. Since there is no reply from original poster, I’m considering this topic as solved.