Editing

When entering data in the spreadsheet, you can either type information directly into each cell or paste information from another cell or data file. This section describes how to perform these common operations.

Entering Data Manually

To type information into cell, the cell must first be made active - usually by clicking in the cell with the mouse.

To enter data into the active cell, simply type the new value. The cell's previous contents are overwritten.

To edit the contents of the active cell, click in the Input Area or press the F2 key and then make the desired changes to the current value in the Input Area.

Pasting Data Between Documents

Data can be easily copied from a ETBX spreadsheet or another spreadsheet program such as Microsoft Excel and then pasted into an ETBX spreadsheet.

To copy data from an ETBX spreadsheet to the system clipboard, select the cells containing the data that you want to copy and choose the Edit -> Copy menu item or press CTRL + C. A colored border will be drawn around the selected cells to indicate that the data is available on the clipboard.

In the target spreadsheet, select the cell where you want to paste the clipboard contents. Choose the Edit -> Paste menu item or press CTRL + V. Note that the paste operation overwrites any existing data in the cells.

Clearing Data

Use the Edit -> Clear -> Selected command or press the DELETE key to delete data from selected cells. Note that the Clear command does not delete the cells, just the data.

To clear all cells in the spreadsheet, choose the Edit -> Clear -> All menu item or press the Clear All toolbar button .

Deleting Rows And Columns

Use the Delete command to delete entire rows or columns from the spreadsheet. First, select the rows or columns that you want to delete by clicking on a row or column label and dragging the mouse pointer. Then choose the Edit -> Delete menu item or press the Delete toolbar button to delete the selected rows or columns.

Note that the Delete command is different from the DELETE key or Clear command, which removes the data but leaves the cells empty. When rows or columns are deleted, the adjacent rows or columns are shifted to fill in the gap.

Adding Rows And Columns

Select one or more rows or columns and use the Edit -> Insert command to insert entire rows or columns into a spreadsheet. The selected rows or columns will be shifted down (for rows) or to the right (for columns) and new blank rows or columns are inserted.