Notifications
Announcements
Is it possible to delete all rows in an excel file in PAD?
Thanks in advance!
Send keys {Control}(a)
Send Keys {Control}({Minus}())
good luck!
I have added a varied list of Excel Features here.
You can use No. 9 CLEAR CONTENTS
or No. 10 CLEAR
depending on your requirements
You can calculate the last row and column that contains data and then pass a dynamic range to clear the cells.
Another option is to use "Get first free row/column".
Then use "Delete rows" action along with the first free row variable.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
In our never-ending quest to improve we are simplifying the forum hierarchy…
We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Michael E. Gernaey 501 Super User 2025 Season 2
Tomac 323 Moderator
abm abm 237 Most Valuable Professional