# Deleting & inserting rows/cols

In addition to attaching labels, the **Edit** menu allows a range of other edit functions on the data entries. For example, to delete whole columns (or rows), highlight them by clicking on their labels and then take a menu sequence such as **Edit>Delete>Columns**. A prompt is given for all such deletion operations to ask whether they were really intended. Note that the current cursor position – the cell in the sheet outlined in black – is ignored; deletion works only on highlighted rows or columns. In contrast, insertion ignores highlights and uses only the current cursor position, e.g. **Edit>Insert>Row** will add a new row immediately <u>above</u> the current position of the cursor and **Edit>Insert>Column** adds a new column to the <u>left</u> of the cursor. Logically therefore, if a new row or column is needed at the bottom or right of the whole data sheet, respectively, a different operation is required: this is **Edit>Add>Row** (or **Column**) and it will ignore the position of the cursor or any highlighting of rows or columns.