Deleting a specific row or column


I am wondering if there is a way to delete a specific row. I know you can do it with a filter and a keyword etc, but I would like to just be able to tell it to delete row 2, or delete column 5 etc. I know I could just delete these in teh excel sheet before I uploaded it, but that may mean uploading multiple versions of the same excel sheet with different rows deleted.
Where this could be handy is when you have a column of numbers that are going to be used with two different products. You may have a two rows with the file number that is slightly adjusted, say in the format of 1234-1 and 1234-2, so if you can delete row two in the first filter and row three in the second filter.

You may consider to use " Insert ROW number " then filter " Remove ROW #2 "

1 Like