Insert Rows

Click the Data | Edit | Insert command, right-click in a table and choose Insert Rows, or press CTRL+R on the keyboard to add an additional row above the current row in a table.

 

The number of inserted rows is determined by the number of highlighted rows in the data table. For example, if you highlight five rows and click the Data | Edit | Insert command, five blank rows will be inserted above the highlighted rows.

 

There is no need to insert or append rows at the end of the table. These rows are already available. Scroll down to the final row in your data table and continue to scroll. Only those rows with data are considered part of the active data table.

 

See Also

Copy

Paste

Paste Special

Append Column

Data Tab Commands