Instead of inserting rows one by one, you can select multiple rows simultaneously to speed up your workflow. This method is perfect for adding space for new data entries.
Le faire avec l'IASelect the rows
Click and drag your mouse over the row numbers on the far left to select the number of rows you wish to insert.
Right-click the selection
Right-click anywhere within the highlighted row numbers to open the context menu.
Insert the rows
Select 'Insert' from the menu. Excel will automatically add the exact number of rows you selected above your current selection.
Yes, hold the Ctrl key (Cmd on Mac) while clicking different row numbers to select multiple non-adjacent rows, then right-click and select Insert.