Unanswered

Hiding Columns in Excel

(0) Share

Report

Posted on by Community Power Pla...

I am trying to hide excel columns in one of my files. There is no explicit function to do so, so instead I have 're-sized column' to 0.0001. However, it only accepts integer values (so the smallest is 1), meaning this method will not work.

One other (failed) method was to select the entire column and use keystrokes, but to the best of my knowledge there is no way to select and entire column.

Does anyone know how to hide columns?

Categories:

Power Automate Desktop

I have the same question (0)

All responses (4)

Answers (0)

ThomasFonn 273 on at

Like (0)

Report

This may not be very helpful, but I got 3 ideas:

1. A combination with select column and send-key-actions in Power Automate could work.
2. Run a macro with your selected range
Range(Target).EntireColumn.Hidden = TRUE
3. Run VB-script from Power Automate with similar code as in the Macro (however, I'm not proficient in VB-script, so I can't help you at all with that)

Was this reply helpful? Yes No
Kaif_Siddique 2,108 Super User 2024 Season 1 on at

Like (0)

Report
Hi @Anonymous ,

Try to record excel action to hide the specific column.

Here is a sample flow:
Launch Excel
Left click on column B (i.e. select entire B column)
Right click
Select Hide

The recorded steps are similar below action:

Hope this will help you.

If I have answered your question, please mark my post as Solved.
If you like my response, please give it a Thumbs Up.

Regards
Kaif

Was this reply helpful? Yes No
MichaelAnnis 5,727 Moderator on at

Like (0)

Report

I don't recommend selecting rows via UI unless this has improved. The last time (about a year ago), I tried to select columns using UI clicks, it took forever.

Instead:

Select cell

Send keys {Control}({Space}) 'this will select the column

Send keys {Control}(0) 'this will hide the column

Good luck!

Was this reply helpful? Yes No
lgehk 2 on at

Like (0)

Report

Send keys {LControlKey}({D0}) 'this will hide the column

Was this reply helpful? Yes No