Summary

Deletes selected rows or parts of rows from the data table.

Configuration

Input settings of existing table

Want to learn more?

Examples

Example: Delete rows

Situation

Rows 1-8, 10, and 12 should be deleted from the following table:

Operation setting


Please note:

  • You can define independent sets of rows, e.g., 1-50, 500-520 ... rows 1 to 50, rows 500 to 520 are deleted.
  • You can define the last rows, e.g., B1-B50, B500-B520 ... deletes the last 50 rows and rows 500 to 520 counted from the end of the table.
  • You can mix both definitions, e.g., 2-B2 ... deletes everything except the first and last row.

Result

TIS Project

-


Troubleshooting

Problem

Frequent cause

Solution

The wrong rows have been deleted.

Typing errors...

Check spelling

How do I find the data set causing the error?


a) Search for a certain term.

b) If this is not possible, try binary search:

  • delete the first half of the data sets (rows)
  • if the error is still there, it must be in the second half
  • if not, the error must be in the first half, and so on.

How do I delete the last data sets?


Elegant work-around:

Related topics