Clear Cell
This article provides information on the following topics:
Note: The Actions Quick Reference provides a complete list of actions that you can print for easy reference.
What is the Clear Cell Action?
The Clear Cell Action clears one or more cells in an Excel workbook.
Creating a Clear Cell Action
Drag and drop the Selector
onto the Targets 
list in the target workbook to display the available target options. Continue
to drag the Selector to the Cell
option, expanding the available Cell
Options 
.
Choose the desired cell option:
- Current Cell - Performs the action to the active cell in the workbook
- Exact Cell - Performs the action to a cell specified by the user
- Cell Range - Performs the action to a defined range of cells
- Named Range - Performs the action
to a named range within the workbook
Note: An Exact Cell can also be accessed by targeting it directly. For more information about modifying a target cell, read the Understanding Excel Targets section of the Understanding Targets article.
If this is the first time the workbook was targeted, Nintex RPA will attempt to create a workbook connection automatically. (For more information about Microsoft Excel workbook connections, read the Excel Connections article.)
A preview of the target
cell 
is displayed along with a button that
allows you to modify the cell
to target 
, per the Cell
Options (above).
Select the Clear
Cell Action 
from the Actions
list.
Select the Rules
to change the Connection for this Action. Both
the Timing 
and
Error 
settings
for this action may be configured to fine tune the how the Action will
run.
Note: For more information about Timing and Error settings, read the Action Builder article.
Select what should be cleared 
in the target cells. The following options are
available and at least one must be selected. More than one can be
selected as well.
-
Content - clears the data from the cell(s)
-
Formatting - clears any formatting (such as Bold, Italic, and fontsize) present in any of the cell(s)
-
Comments - clears any comments that are attached to the cell(s)
Optionally add Notes
to the Action to document any special instructions
or functionality. When the Run Switch
is set to Run, the action
will be executed after clicking OK.
Note: The run switch is set to Run by default. To create or modify this action without executing it, click the slider to change the option to Don't Run. For more information, see Action Builder.
Click the OK
button 
to
save the Action.