Clear Cells
Clear formats and/or data from the designated cells.
Options
-
Workbook(dropdown): a list of workbooks available to the account. Workbook is another word for your Excel files.
-
Worksheet(dropdown): a list of worksheets available in the selected workbook. Worksheet is the individual spreadsheet within them, displayed as tabs in Excel files.
-
Apply to (dropdown): select what should be cleared from the cells.
-
All - clear formats and content.
-
Formats - clear formats only.
-
Contents - clear contents only.
-
Input Fields
The cell reference cells are used to construct a grid of cells to apply the clear action.
-
Cells
-
Cell Reference Begin(text): a value representing a cell (e.g. A2) in the top left corner of the grid to be cleared.
-
Cell Reference End(text): a value representing a cell (e.g. D4) in the bottom right corner of the grid to be cleared.
-
Output Fields
- Response