When processing EXCEL documents, it is sometimes necessary to delete several rows and/or columns. For example: open a document, delete unnecessary information and save it to another document, possibly in a different format (e.g. CSV). The principle of deleting rows and columns is simple:
•You need to activate the desired page of the document
•Select the desired cell
•And delete the whole row and/or the whole column for this cell.
Worksheet
Specify the name or the number of a document worksheet. The ordinal number begins from 1.
Cell address to be selected
Cell coordinates on the page. Both addressing methods can be used:
•A1 - That is, the column address is written in letters and the row address is written in numbers. For example: C3, D5, BD15. The next column after Z is column AA, AB, etc.
•R1C1 - After the letter R is the number of a row beginning from 1, after the letter C is the number of a column beginning from 1.
Remove an entire row
Enable this checkbox if you want to delete the row completely.
Remove an entire column
Enable this checkbox if you want to delete the column completely.
Related Topics