You are here

Edit Menu

Adding and deleting rows

To insert blank rows below the selected row, follow these steps:

  • Move the cursor above the row where additional rows need to be inserted
  • From the Edit menu, select the Add rows command
  • In the window that appears, key in the number of rows to insert
  • Confirm by clicking on OK


There is still another procedure to add blank rows:

  • Move the cursor above the row where additional rows need to be inserted
  • Click on the following icon  on the Tool bar, one time for each row that you want to add. This procedure is advised when the amount of rows to be added is rather limited. The sequence for the shortcut key is: Ctrl+Enter.


To insert blank rows above the selected row, follow these steps:

  • Move the cursor below the row where additional rows need to be inserted
  • From the Edit menu, select the Insert rows command
  • In the window that appears, key in the number of rows to insert
  • Confirm by clicking on OK.

In order to delete one or more rows, select the row or rows that need to be deleted and from the Edit menu, click on the Delete rows command.


Protecting the rows

Using the Protect rows command, from the Edit menu, the user activates row protection to avoid making any changes by mistake.
The protected rows cannot be edited until, by using the Unprotect rows command, the protection is being removed.


To put protection into effect:

  • Select the desired row(s) to protect
  • From the Edit menu, select the Protect rows command
  • Confirm the number of rows to be protected by clicking on OK.

Protected rows have light grey row numbers. In order to edit them again, first remove the protection by the Unprotect rows command in the Edit menu.

 

Share this article: Twitter | Facebook | Email


Help us improve the documentation

We welcome feedback on how to improve this page.
Tell us what theme needs a better explanation or how to clarify a topic.