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.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Haque 589
Valantis 328
David_MA 284 Super User 2026 Season 1
