The Clear Worksheet instruction makes it easy for the user to clear out an entire sheet.
Step-by-step guide
1. Create a data step and upload an Excel workbook.
2. Add a Manipulate Data action step.
3. Add a Clear worksheet instruction.
4. Link the workbook and then select the worksheet to be cleared.
Tips and Tricks
This instruction is mainly used to clear old data from a worksheet.
Comments
0 comments
Please sign in to leave a comment.