Displaying and Editing Data > Editing Tabular Data


Deleting Rows and Columns

You may delete rows from a table when working with irregular-interval time series data and paired data.  To delete a row from a table, select the row and then on the Edit menu, click Delete Rows.

If you are working with regular interval time series data, you will not be able to delete rows; instead, the Delete Rows function will change the data values to missing.  This is the same as selecting Clear from the right-click shortcut menu.

In a paired data table you can delete a column.  To delete a paired data column, select the column and then select the Edit → Delete Column menu option.  The Delete Column message will appear, requiring you to verify you would like to delete the entire column (see below).  Click Yes to finish deleting the column.


Delete Column confirmation window