web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : AOkTtaKYKoQcgR42bGIPJ/
Power Platform Community / Forums / Power Automate - Power Automate Desktop / How to delete all cont...
Power Automate - Power Automate Desktop
Unanswered

How to delete all contents in an excel file in PAD?

Like (0) ShareShare
ReportReport
Posted on 2 May 2022 05:57:33 by yscx523194 14

Is it possible to delete all rows in an excel file in PAD?

 

Thanks in advance!

I have the same question (0)
  • VJR Profile Picture
    VJR 7,635 on 02 May 2022 at 15:33:19
    Re: How to delete all contents in an excel file in PAD?

    Another option is to use "Get first free row/column".

    Then use "Delete rows" action along with the first free row variable. 

  • VJR Profile Picture
    VJR 7,635 on 02 May 2022 at 11:44:33
    Re: How to delete all contents in an excel file in PAD?

    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.

     

     

  • MichaelAnnis Profile Picture
    MichaelAnnis 5,721 Moderator on 02 May 2022 at 06:51:31
    Re: How to delete all contents in an excel file in PAD?

    Send keys {Control}(a)

    Send Keys {Control}({Minus}())

     

    good luck!

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.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Tom Macfarlan – Community Spotlight

We are honored to recognize Tom Macfarlan as our Community Spotlight for October…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 707 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 499 Moderator

#3
chiaraalina Profile Picture

chiaraalina 312

Last 30 days Overall leaderboard

Featured topics

Flows are not visible for users who sign in with their personal accounts
List of actions cheat sheet for Power Automate Desktop

Product updates

Microsoft Power Platform Community release plans