Delete from Excel

Delete specified cell values from an Excel file.

1. Click Browse and navigate to the Excel file from which you would like to delete cell values.

2. If the selected Excel file is password protected, enter the password.

3. Specify the worksheet and cells from which to delete values, either:

   • by selecting them directly in Excel; or

   • by entering them manually (this method can be particularly useful when you want to use variable values to select cells).

4. Instruct the wizard how to handle any errors encountered.

   Read more about error handling.

5. Enable timeout monitoring.

   Read more about Timeout Monitoring.

Selecting worksheet & cells directly in Excel

1. Click Select in Excel to invoke the Excel selector.

2. The Excel selector will appear with the selected Excel file open behind it.

   

3. Click directly in the Excel file and select the worksheet (tab) and cells you want to delete from.

   • The worksheet name and cell range you have selected will appear in the selector window's Current selection fields.



If the selector window interferes with viewing or selecting the cells you need, simply drag the window to a more convenient location on the screen.

4. When you are satisfied with your selection, click OK .

5. The main Delete from Excel window will appear, with the Worksheet and Range fields populated by your selections.

6. If you want to make modifications to your selections, you can do so either manually or by repeating the Select in Excel process.

Entering worksheet & cells manually

1. Specify the worksheet (tab) in which the cells you want to delete are located.

2. Choose one of three methods for specifying the cells you want to delete:

   1. Range – Designate the range using "standard" Excel format (e.g., the range from Column A Row 1 to Column D Row 8 is designated as A1:D8).

   2. From/To – Designate the starting column and row and the ending column and row, using numbers and/or letters (e.g., cell C5 could be designated as Column 3, Row 5 or Column C, Row 5).

   3. Entire worksheet – The robot will delete data from the whole worksheet.