Insert Row Using Right-Click Options

Inserting rows using the right-click option is one way where users will be able to insert the rows. Select one or more entire rows by moving the cursor to the row numbers. Right-click the selection and select Insert rows from the selection. Select either the row that needs to be inserted above or below the selection.

In the below image we inserted a row below E9 and when we click Save it will display the data in E10.

Formulas and default values won't be dragged to the newly inserted rows with a right-click insert, unlike Insert rows in the toolbox.