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

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Format Excel range int...
Power Automate
Answered

Format Excel range into table and auto adjust colum widths

(0) ShareShare
ReportReport
Posted on by WebPortal 2,297

I'm trying to format an Excel Range into a table with auto width columns.

 

With the Excel instance running, can anyone advise a solution?

 

SendKeys:

  • Ctrl+T+ENTER -> for converting the range to table
  • Then click on the upper-left square of the cells and double click between column A and B  -> for auto adjusting the columns width

Or run a macro:

  • How do I send the VBA code to the Excel?

Desktop recorder?

 

Can anyone help here?

 

 

Categories:
Power Automate Desktop
I have the same question (0)
  • fraenK Profile Picture
    fraenK 2,125 on at

    Why not using an empty preformatted Excel file as a template and add your content?

  • WebPortal Profile Picture
    WebPortal 2,297 on at

    Interesting...

     

    You mean before the whole thing begins, we have already a template and just fill it in?

  • Verified answer
    fraenK Profile Picture
    fraenK 2,125 on at

    Yes, if you need to use PDA. Otherwise, using cloud flows would be a better option for handling Excel data

  • Dreadedgiraffe Profile Picture
    Dreadedgiraffe 20 on at

    Addendum to this, if ive got a cloud flow that creates a new worksheet within an excel file once a week to store timesheet data, is there a way that i can set the coplumn widths for a newly created table within the same flow? I cantg use a VBA script in excel because until ther flow runs, the worksheet doesnt exist and therefore doesnt have a name to reference?

  • Dreadedgiraffe Profile Picture
    Dreadedgiraffe 20 on at

    Apologies, forgot to mention this is a cloud flow, not a desktop flow.

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

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 594

#2
Valantis Profile Picture

Valantis 328

#3
David_MA Profile Picture

David_MA 281 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Share your ideas and struggles with building Power Automate flows!
Survey: Power Automate mobile app
How to Ask for Help with Your Power Automate Workflow
Flows are not visible for users who sign in with their personal accounts
Start and wait for an approval action
Restore a deleted flow
List of actions cheat sheet for Power Automate Desktop
Question for everyone : How are you using Create Text GPT in AI Builder?
Welcome to the Power Automate forum!

Product updates

Microsoft Power Platform Community release plans